Now the hidden Currency Column is no longer printed and the data rows are vertically aligned with their respective monthly headings. I guess this also fixes other query and script based reports like trial balance.
Great! Thanks for posting the fix. The most major issue for us though is the fact that Group accounts are not highlighted in any way! How do you make sense of any financial reports (in Excel) without being able to tell the Groups from the Ledgers???
A simpler way is to Add Column to the Report (Balance Sheet, Profit Loss, etc.)
Menu > Add Column:
Add Column (Dialog)
From Document Type: Account
Field: Is Group
Insert After: Account
→ Click Submit (Click once only even if the Dialog box does not close immediately.)
You will see that the non-group Accounts (entries) will be unchecked while the Group Accounts (ledger accounts) will be checked.
Unfortunately, while Print shows the added column, the exported Excel does not show the added Is Group column. So, I guess I have to do another round of bug hunting.
Thanks a lot for this! It however seems the solution involves changing the core code? Would have preferred to avoid that but at least this provides an option for emergency use