AuthorErin ArchivesCategories |
Back to Blog
I then went to the “Pay Bills” window and selected the bill representing the refund amount. I then made a deposit using the vendor’s name in the “Received From” column and used the accounts payable account in the “From Account” column. Since it was for a job (I post everything to a job) I created a “Bill Credit”, posted it to an expense account, not an item because it is an Overhead Job. However, I can’t seem to get a transaction report that shows the correct amount paid.My problem seems to be occurring from a refund I received. The amount is correct in job cost and on the 1099.You can run them and Customize them to ignore Thresholds, and for All Vendors, not 1099-Misc only."My problem seems to be occurring from a refund I received. Just one example is the Reports menu > Vendor Reports, the 1099 reports. The only way it shows is if I include credits which is not correct.Does anyone have any suggestions on how to create a report that I need?"I know that report does not exist with the information I mentioned above."Of course it does, and it a number of perspectives. So, if I create a transaction report with all the different types of payments, this will not show on the report. The vendor account now shows the credit, but not under payments.Once you enter the refund, it offsets the credit balance. The vendor account now shows the credit"It should not show a credit balance, though. Then I applied the credit by selecting “Set Credits”. Needing two names (vendor and Job) = needing AP credit."I then went to the “Pay Bills” window and selected the bill representing the refund amount. You don't want one Huge Value listed as "no Item" because that doesn't tell you anything about these costs, when you run Job-based reports, such as Job Profit Summary, Detail or P&L by Job."I then made a deposit using the vendor’s name in the “Received From” column and used the accounts payable account in the “From Account” column."Yes, this is how you link the Refund to the credit if you didn't need job tracking, you could use Deposit directly with no name at all. Your "overhead" if that still has a Job Name, you should always be using items because that is what the Job Reports are showing.Example: Reports menu > Banking reports, Check Detail. That's why you have to be very careful about the Perspective of the report you start with. You see it here, as well.Transactions are not the Job data the Details are the job data. Run Unbilled Costs by Job, change the Billable filter to Any. For instance, Job Profitability Detail for that one job name = the vendor credit will be a negative entry.
The one does not bring the other to the party. Transaction Listing reports are Activity, not Balance Perspectives."If I add Bill Credit to my report, it includes the Bill Payment Credit Card amount"How would this be true? You just described two different transactions. The only way it shows is if I include credits which is not correct."Yes, Credits will reduce the amounts you paid, and that is proper.Remember that using the 1099-Misc reports will not include CC amounts, because you don't report these payment types for purposes of 1099-Misc reporting.So, for instance: Job Cost Detail by Vendor and Job, or by Job and Vendor, shows Everything you asked."I have a Bill, a Credit, and a Bill Payment Credit Card for one bill."For what is Paid, that needs to be a Cash Basis report. Otherwise, banking reports with Vendor Name (which is Source Name) doesn't show Job (target) names from the Details, because Banking reports are the Check perspective neither the expense or items tab details perspective."with all the different types of payments, this will not show on the report. Radio app for mac redditSpending Type is Expense, and perhaps your own Assets such as Fixed Assets or Inventory improvements or Work in Process assets.Hi there, you for joining the QuickBooks Community. AP is Fund Balances, not Spending Type. In other words, you mixed the Payment Amount as Method, with the Expense as Reason."as well as the Credit which is not correct."Make sure you are not reporting AP. Cash basis = paid or not, or partial amounts, such as partially paid by applying a previous vendor credit. You would include only the Bill, on Cash Basis = the expense incurred, not How it got paid. Bill Payment is AP payment from Checking not Expense details. Quickbooks 2016 Vendor Transaction Report Free To ReachOn the Contact Us page, click a topic.5. They can initiate a screen sharing session to get this resolved quickly.4. From the Filters tab, search for Paid Status.Also, if you wish to add more details, I recommend checking this article: Customize reports in QuickBooks Desktop.I've added some screenshots for your reference.For additional help, feel free to reach out to our Phone Support. From the Display tab, select Num on the COLUMNS section. At the top left, click the Customize Report button. Select Vendors & Payables, then select Transaction List by Vendor. I'll be happy to help you out.
0 Comments
Read More
Leave a Reply. |