Skip to main content
L
lmoody
May 7, 2020
Question

Vendor Payments by Job Report

  • May 7, 2020
  • 2 replies
  • 0 views

I use QuickBooks Desktop Contractor's Edition. I need a report that shows vendor payments totaled by customer job for specific period of time.  I've tried many types of reports and can't seem to pull in both vendor and customer job information.  Does anyone know a way to pull this report?

 

Thanks.

 

Lisa

 

2 replies

katherinejoyceO
katherinejoyceO
May 7, 2020

Welcome to the Community, @lmoody. I've got you the steps on how to run the report that you need.

 

Let's pull up the Vendor Expenses by Customer: Job report and set the date to show the details on that specific period. Here's how: 

 

  1. Go to the Reports menu. 
  2. Select Custom Reports, then Transaction Detail.
  3. In the Display tab:
    1. Set the appropriate date range.
    2. In the Columns section, put a checkmark beside Source Name to add it to your columns and uncheck the Name to remove it from the list.
    3. Select the Total By drop-down arrow, then select Customer.
  4. Go to the Filters tab, then select Transaction Type from the Filter List.
  5. Select the transaction type associated with the vendor purchases such as bills, then click OK to display the report.

 

To learn more about how to get reports based on your business needs, check out this article: Customize vendor reports. It also contains links to different topics that cover basic information about customizing reports in QuickBooks Desktop.

 

Feel free to message again should you have more concerns about anything else. We're always delighted to assist. 

 

 

 

Mark the post that answers your question by clicking on "Accept as solution".

L
lmoodyAuthor
May 7, 2020

Thanks for your response, however, this doesn't give me the information that I want.  This just shows me invoices by project but can't pull in paid status or paid date.

 

We are a contractor and I track vendor payments by customer projects for cash flow purposes.  I may have the same vendor working on multiple projects.  I am looking for a report will show me which vendor invoices were paid for each customer's jobs within a specific time period. 

 

For example:

Paid Dates: 04.01.20 - 04.30.20

Customer Job A

   Vendor 1 - Ref Num 5653  - Amount $100 - Paid 04.03.20 - Check # 1050

   Vendor 2 - Ref Num 75161 - Amount $500 - Paid 04.03.20 - Check #1051

Customer Job B

   Vendor 2 - Ref Num 5657 - Amount $250 - Paid 04.08.20 - Check #1056

   Vendor 3 - Ref Num 12457 - Amount $600 - Paid 04.10.20 - Check #1064

Ect....

 

Thanks.

    M
    Mark_R
    May 7, 2020

    Thanks for getting back to us and giving some examples, @lmoody.

     

    At this time, there isn't an option to run and customize a report based on your example given. However, you can customize the Transaction Detail report and have a closer result.

     

    Here's how:

     

    1. Run the Transaction Detail report.
    2. Click the Customize button in the report.
    3. In the Modify Report window, go to the Display tab and customize the date range from 04/01/2020 to 04/30/2020.
    4. In the Columns section, put checkmarks only to these following:
    • Type
    • Num
    • Amount
    • Paid
    • Paid Date

         5. Select Customer from the Total by drop-down.

         6. Click OK.

     

    Once done, the report will show you which invoices were paid for each job. However, the Paid Date column will not show any data, but you can consider opening the transaction on at a time to check when it was paid.

     

    Just in case you want to memorize this report, feel free to check out this article for the detailed steps and information: Create, access, and modify memorized reports.

     

    Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. Have a good day and keep safe.

    J
    JGENT
    April 6, 2023

    So I am guessing this still has not been addressed I am having the same issue. Need a report total invoiced and paid to vendor per job (ie Sub Customer) and cannot get it no matter what I try. 

      Terms & ConditionsAccessibility statement