Trial Balance Report Without Group Account OR with filter Is Group

ERPNext Reports
, ,
1

Dear All
I need to get a trial balance report without including the group accounts. Currently we include the group header accounts (which represent the sum of the individual accounts) - and when you export to excel - you have to manually delete the header account rows - so that total at bottom of column actually matches the rows above. Additionally most tax software setup to import Trial Balance xls - require to list only accounts with credit/debit entries.

Is this possible to do today? I think it requires code change to add checkbox that allows to filter group accounts from trial balance report? Appreciate guidance. Thanks.

2

From the menu (…) option Add a column from the Account doctype and the field Is Group. In the “Is Group” search filter enter 0 then it will display only non-group accounts which you can export. However, this does not show the total row at the bottom.