QuickBooks GL Ledger - without blank rows?

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.

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 . . .