QB Online: How can I create a report that groups by by vendor then also shows a grand total at the bottom of the report?

I see you want to create a report that groups by vendor and also shows a total at the bottom of the report in QuickBooks Online. I'm here to help you sort things out so you to proceed with ease.

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. However, it's important to note that the Expenses by Vendor Summary report only shows payments coded to expense accounts and not the true vendor totals. If you need the total for all your payments, simply select the Export button and then Export to Excel for the total in the column. 

Here's how to export reports from QuickBooks Online to Excel:

1. Go to Reports.
2. Search for and select the report you want to export.
3. At the top of the report, select the Export icon. Then select Export to Excel.
4. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

Note: If you’re missing data when you open the report in Excel, the file's in protected view. In Excel, you’ll need to select Enable Editing to view the full report.

Furthermore, if you need data that isn’t found in basic reports. You can create custom reports to get the data that matters to you most.

If there's anything else you need to accomplish for your report that groups by vendor, please let me know by leaving a comment below. I'd be more than happy to work with you.

Thank you for your help. 

Good morning, @Kaylamariem33. 

I'm glad my colleague was able to help you out. 

If you have any other questions, don't hesitate to ask. We're only a post away if you need us. Take care!