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 customizations 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:
- Choose Reports from the menu on the left
- In the "Go to reports" field, enter Transaction List by Date.
- Choose Transaction List by Date.
- Set Report period to the correct year.
- For Group By select Vendor/Supplier
- Click Customize.
- In the filters, and select the following Transaction Types:
- Bill Payment (Check/Cheque)
- Bill Payment (Credit Card)
- Cash Expense
- Check/Cheque
- Credit Card Expense
- Credit Card Credit
- Vendor/Supplier Credit
- (Optional) If you want to report on a particular supplier or group click the drop-down menu next to Name and select the appropriate supplier(s).
- Click Run 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, click the Excel button at the top left of the report page to export your report, then total the column.
3495