With QuickBooks Online, you can export your reports to Excel and take advantage of the built-in features of the spreadsheet-editing software. By doing so, you can get the totals you need without manually doing the calculations. For this specific situation, I suggest doing as follows:
- Select Reports from the left menu
- Scroll down to the Expenses and suppliers section
- Select Transaction List by Supplier
- Customize the report to show the transactions you need for each supplier, if needed.
- Once done, select the Export icon (see attached screenshot)
- Select Export to Excel
- Select Open with Microsoft Excel
- Find the Amount column and execute an AutoSum for each supplier
To know more about customizing reports, check this community article.
Let me know if you have any other questions.
.png){kind=link}
