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.