Skip to main content
December 10, 2018
Question

Report of all payments made to vendors in QuickBooks Desktop

  • December 10, 2018
  • 2 replies
  • 0 views

Software used:  QuickBooks Premier Plus Contractor Edition 2019-Desktop

 

Needed:  A report showing all payments made to vendors with type of payment, check number, etc.

 

We are a General Contractor.  I need a report showing all payments made to a vendor by job.  I know that report does not exist with the information I mentioned above.  I can get around that by putting the job number in the memo field of the bill, credit card charge, etc.  I need one report that shows all the payments for insurance audits also.

 

I have not been able to create this report with accurate information.  The amount is correct in job cost and on the 1099.  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.  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.  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.  I then went to the “Pay Bills” window and selected the bill representing the refund amount.  Then I applied the credit by selecting “Set Credits”.  The vendor account now shows the credit, but not under payments.  So, if I create a transaction report with all the different types of payments, this will not show on the report.  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?

 

Your help in greatly appreciated.

2 replies

qbteachmt
December 10, 2018

"I know that report does not exist with the information I mentioned above."

 

Of course it does, and it a number of perspectives. Just one example is the Reports menu > Vendor Reports, the 1099 reports. 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.  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."

 

What matters here is that the Job Reporting relies on Items. Your "overhead" if that still has a Job Name, you should always be using items because that is what the Job Reports are showing. 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. 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.  Then I applied the credit by selecting “Set Credits”.  The vendor account now shows the credit"

 

It should not show a credit balance, though. Once you enter the refund, it offsets the credit balance. Then, you Applied them, that status is no longer Open, but the math won't change because you linked them.

 

"but not under payments."

 

Underpayments? Credits show, the same as Bill Charges, from the Job Tracking that you did. That's why you do them. For instance, Job Profitability Detail for that one job name = the vendor credit will be a negative entry. Run Unbilled Costs by Job, change the Billable filter to Any. You see it here, as well.

 

"So, if I create a transaction report"

Transactions are not the Job data; the Details are the job data. That's why you have to be very careful about the Perspective of the report you start with. Example: Reports menu > Banking reports, Check Detail. Make sure to filter on Payee name = Vendors, to see job details here. 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.  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.

Zappa-CatAuthor
December 10, 2018

Thanks for trying to help.  I need a vendor report that lists all the payments and types  to the vendor.  The closest one I have found is creating a report from the Transaction List by Vendor.  I filter for Check, Credit Card, CCard Credit, Bill Payment, and Bill CCard.  That works fines on everything except for the Refund I received.  Since that is a credit, it does not show up on the payment list to decrease it.  That is a problem.

 

The 1099 report will not work for me because it does not include credit card payments.  I need a report that shows all payments regardless of type.

 

Thanks again for trying.

qbteachmt
December 10, 2018

"That works fines on everything except for the Refund I received.  Since that is a credit, it does not show up on the payment list to decrease it.  That is a problem."

 

You missed selecting that Transaction Type "Bill Credit." You didn't get them All.

qbteachmt
December 10, 2018

Let's go back to my previous answer for this:

"We are a General Contractor.  I need a report showing all payments made to a vendor by job."

 

Reports menu > your Contractor Reports, you have Job Cost by Vendor And Job Detail; run it for Cash Basis. Done.

Zappa-CatAuthor
December 10, 2018

Thanks for trying to help.  This was my original question.  I should not have mentioned the job in the same post.  

 

Software used:  QuickBooks Premier Plus Contractor Edition 2019-Desktop

 

Needed:  A report showing all payments made to vendors with type of payment, check number, etc.

 

For our insurance audits every year, I need a simple report that shows all the money we have paid to subcontractors.  We are charged for money paid to every subcontractor even though we have a certificate of insurance from them.  This would include any refunds by check.   I can't seem to get that all in one report.  The other software I used has such a report.  It was easy.  I am sure we are not the only contractor trying to do this.

 

Thanks again for all your help.  I think this is just something I will not be able to do.

 

March 18, 2019

I just discovered a similar flaw.  I believe that older versions of QuickBooks allowed you to run a transaction detail report by vendor, and it included payments & refunds.  It's changed.  QB Pro 2017 only allows you to run reports for payments TO the vendor.  I don't use bills, invoices, etc.; only the checkbook.  If I include a refund from a vendor on a deposit slip, the amount WILL NOT appear on that transaction report.  The only way to "hunt" for the credits is to look at the expense category and sort by Vendor.  It will appear there.  I believe this to be a flaw in QB.