QuickBooks HelpQuickBooksHelpIntuit

Run a report with vendor totals

SOLVEDby QuickBooks245Updated January 25, 2024

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. Go to Reports (Take me there).
  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 ▼ dropdown 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
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online LedgerQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this