Can I run a report in QBO sorted by GL code as well as customer? I run deposits and reimbursable expenses out of 1175 and will invoice the leftover portion at end.

Let me guide you run the report sorted by GL code and customer in QuickBooks Online, @jhouck-edclancas.

We can generate the Transaction Detail by Account report, then customize this to show the information you want in the data. 

Here's how:

1. Log in to your QuickBooks Online account.
2. Go to the Reports menu.
3. In the Find report by name field, search and select Transaction Detail by Account report.
   
   
4. Click the Customize button.
   
   
5. Choose the Report period. 
6. Under Rows/Column, choose Vendor in the Group by dropdown menu.
7. Click the Change columns link, then put a checkmark on the Customer box. 
8. Once done, click Run report. 
   
   

For more information on how to add filters to your report, feel free to open this resource: Customize reports in QuickBooks Online.

Also, you can memorize your report to save it with its current customization settings.

Keep in touch if you need more help accessing and managing reports in QuickBooks. I'll be glad to assist you always. Have a nice day.

Hi, @jhouck-edclancas.

Hope you’re doing great. I wanted to see how everything is going about running the report sorted by GL code and customer concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

This report worked great for my needs.  Is it possible for it to total at the end so I can tie it into my GL balance.  I did the math and it works- it would just be nice for Quickbooks to do that math.  Thank you!  

Thank you for following up, jhouck-edclancas.

It's a good idea that to get the total by pulling up that report.

Currently, we don't have that option to show the total for all accounts on that report. But you can export it to an excel file to easily get the total amount.

Like this:

1. Open the report you want to export to excel.
2. At the top of the report, click the Export icon.
3. Select Export to Excel.
4. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

I've also included this article that you can also use as a reference in customizing reports in QuickBooks Online.

Please don't hesitate to click the reply button below for follow-up questions about reports. I'm always here to help. Have a great day!