![QuickBooks Help](https://uxfabric.intuitcdn.net/web-app/sh-exp-sbg-app-experience/sbg_ohh_icon.19f2ae89.png)
Run a report with supplier totals
by Intuit• Updated 1 month ago
To get a report on all money paid to a supplier for the year, you can run a Transaction List by Date report. Once the appropriate customisations are made it will reflect all payments made to suppliers.
Note: The Expenses by Supplier Summary report only reflects payments coded to expense accounts and not true supplier totals.
To get your supplier totals:
- Go to Reports (Take me there).
- Enter the report name as Transaction List by Date.
- Choose Transaction List by Date.
- Select a Report period to the year.
- For Group By, select Supplier.
- Select Customise.
- Filter by the following Transaction Types:
- Bill Payment (Cheque)
- Bill Payment (Credit Card)
- Cash/Other Expense
- Cheque Expense
- Credit Card Expense
- Credit Card Credit
- Supplier Credit
- (Optional) If you want to report on a particular supplier or group, select the Name ▼ dropdown menu, then select the appropriate supplier(s).
- Select Run Report.
- Select Save customisation, 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 suppliers.
Note: If you need a total for all of your payments, select the Export button, then Export to Excel for the total the column.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- How to view and edit supplier transactions in QuickBooks Onlineby QuickBooks•9•Updated 4 weeks ago
- Set up low stock alerts in QuickBooks Onlineby QuickBooks•52•Updated April 15, 2024
- How can I track Profit and Loss by Customer?by QuickBooks•9•Updated September 25, 2023
- Manage outstanding balances for customers and suppliers in QuickBooks Onlineby QuickBooks•38•Updated 4 weeks ago
- How to add a preferred supplier and create a purchase order using that preferred supplier in QuickBooks Onlineby QuickBooks•6•Updated January 08, 2024