Report of Amount by GL account and Vendor

Hi there, @WGG1.

A general ledger report is a comprehensive financial record that provides a detailed summary of all transactions within an organization's accounting system over a specific period. However, this report displays all financial transactions, and generating it with only the vendors and their designated transactions and accounts is unavailable in QuickBooks Online (QBO).

What we can do is generate a Transaction List by Vendor report using the steps below. Please note that we will still need to make some customizations to obtain the details needed. Additionally, the application generates a report for one period at a time. From there, we can export this into an Excel file and sort the dates by month. You can then rearrange the details based on how you want them to look:

1. Go to the Reports menu and search the Transaction List by Vendor Report.
2. Set the Reporting period you want to pull up.
   
3. In the Columns tab, check all the columns you want in your report.
4. Select Transaction Type and Expense to filter your report from the Filter tab.
5. Move to the Group by tab and select Account Name (with sub-account names).
   

    

That's it! Once you have obtained all the information you'll need, we can start exporting this into an Excel file to rearrange the details according to your preference. 

Furthermore, I'll share the following article with you so you can learn how to save the current report customization settings in QBO: Save a customized report in QuickBooks Online.

Aside from that, our QuickBooks Live Expert Assisted can help you manage your reports, streamlining your business needs.

I remain open to any additional questions you may have about managing financial reports or any QuickBooks-related concerns, @WGG1. The Community always has your back. Stay safe!