Skip to main content
H
HannahChynnah
May 18, 2021
Question

QuickBooks GL Ledger - without blank rows?

  • May 18, 2021
  • 2 replies
  • 0 views

Hello,

 

I need to extract a GL from QuickBooks which has no subtotals included, i.e. I need an Excel report which just has a single row for date, transaction type, amount, account code etc. The way that QuickBooks currently extracts the GL makes the data very hard to manipulate in Excel (ie. I cannot use filters etc.. due to blank value in some rows because of the subtotals). Does anyone know a workaround for this?

Cheers, Hannah

 

 

2 replies

T
Tammy_H
May 18, 2021

Hi Hannah,

 

I can see what you mean. It would be beneficial to have a format that was conducive to downloading in a spreadsheet format. QuickBooks Online gives you the option to customize reports by changing columns and filters. The layout, however, is not part of what can be changed. If you'd like to be able to adjust the formatting, I invite you to provide feedback.

 

You can let our team of program developers know what you'd like to see added into the program by:

  1. Go to the Gear Icon.
  2. Select Feedback.
  3. Fill in the details that you would like them to consider adding, and click Submit feedback.

Input from users like you are essential for the growth of QuickBooks products. If there's anything else that I can help with, please let me know. Take care.

R
Rochelley
May 18, 2021

Hello @HannahChynnah ,

 

It is normal for the G/L to subtotal by each G/L account.  However, if you want just a list of all the transactions on the G/L, then you can create a custom report.

 

There are a number of reports you can start with to create this custom transaction report, but I started with the Trial Balance report.  I drilled down on one account in the Trial Balance which then shows all of the transactions that make up that balance on the TB.  I begin customizing from there, and change the selection of that one account to ALL accounts.  You can customize the report name from here, as well as choose any columns you want to use to filter by in Excel.  When you're done, you should have a G/L listing of transactions  that is not grouped by account.  Save the customization for future use.

 

Hope that helps . . .

Terms & ConditionsAccessibility statement