Showing results for 
Search instead for 
Did you mean: 

Run a report with vendor totals

To get a report on all money paid to a vendor for the year, you can run a Transaction List by Date report. Once the appropriate customizations are made it will reflect all payments made to vendors.

Note: The Expenses by Vendor Summary report only reflects payments coded to expense accounts and not true vendor totals.

To get your vendor totals:

  1. Select Reports from the left menu.
  2. Enter the report name as Transaction List by Date.
  3. Choose Transaction List by Date.
  4. Select a Report period to the year.
  5. For Group By, select Vendor.
  6. Select Customize.
  7. Filter by the following Transaction Types:
    • Bill Payment (Check)
    • Bill Payment (Credit Card)
    • Cash Expense
    • Check
    • Credit Card Expense
    • Credit Card Credit
    • Vendor Credit
  8. (Optional) If you want to report on a particular vendor or group, select the Name ▼ drop-down menu, then select the appropriate vendor(s).
  9. Select Run Report.
  10. Select Save customization, then select Save. Note: You can create a new name for the report.

This will create a report that will reflect all payments to your vendors.

Note: If you need a total for all of your payments, select the Export button, then Export to Excel for the total the column.

Was this helpful?

You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us