Skip to main content
December 8, 2023
Question

Filter Payment Report to Vendors

  • December 8, 2023
  • 1 reply
  • 0 views

I created a transaction report that shows bill payments to a specific vendor. Is there a way to further filter that report so it shows only payments to the vendor for a specific job? The report currently shows all payments to the vendor within the date range.Thanks!

1 reply

December 8, 2023

It's good to see you here, @Phil51. Let me guide you through filtering a transaction report in QuickBooks Desktop (QBDT) to find payments made to a specific vendor for a particular job.

 

Follow these steps to view a breakdown of vendor expenses totaled by the job to personalize the transaction report you've generated.

 

  1. Select Custom Reports from the Reports menu, then click Transaction Detail.
  2. In the Display tab:
    1. Choose the appropriate date range.
    2. Have a check mark beside Source Name to add it to your columns in the Columns section, and click the check mark beside Name to remove it from the list.
    3. Click the Total By drop-down arrow and select Customer.
  3. In the Filters, from the Filter list, select Transaction Type.
  4.  Select Check and Bills payments as the Transaction type.
  5. Hit OK to show the report. 

 

Once done, you may visit this article as your reference in customizing vendor reports in QBDT. 

 

On the other hand, I'll leave this link for future guidance on how to pay bills online within QBDT: Pay bills online from QuickBooks Desktop

 

For more questions about customizing your vendor reports in QBDT, notify us below. Have a good one!