QuickBooks HelpQuickBooksHelpIntuit

Run a report with supplier totals in QuickBooks

by Intuit•2• Updated 1 month ago

Learn how to view all payments made to your suppliers using the Expenses by Supplier Summary report in QuickBooks Online. This report helps you track supplier payments and gain insights into your business expenses.

Note: This report only includes payments coded to expense accounts, not total supplier balances.


Run the Expenses by Supplier Summary report

Follow these steps to run a report with supplier totals:

  1. Follow this link to complete the steps in product Open this link in a new window
  2. From the Type report name here â–Ľ dropdown, select Expenses by Supplier Summary.
  3. From the Report period â–Ľ dropdown, select a date range.
  4. To run a report for a specific period, select Custom and enter start and end dates.
  5. From the Display columns by â–Ľ dropdown, select Suppliers.
  6. In the Accounting method field, select Cash or Accrual:
    • Cash: Shows only payments made to suppliers.
    • Accrual: Includes open invoices and bills.
  7. Select Run report.

Edit and save your report

  1. Select the Edit pencil icon to change the report name.
  2. Select Save customisation to:
    • Enter a custom report name.
    • Add the report to a group for easy tracking.
    • Choose your sharing preferences.

Export a copy of your report

If you need a copy of the report:

  1. Select the Export Image Alt Text icon.
  2. Choose Export to Excel or Export to PDF. If exporting to PDF, you may need to select Save as PDF to download a copy automatically.
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start