Try ERPNext Buy Support Partners Foundation Foundation Members

Exporting Financial Statement to Excel

When an accounting statement report like Trial Balance which contains collapsible rows is exported, the amounts for the individual child rows are summed in the parent row which makes it difficult to sum the rows when working with the exported sheet.

Please is there any advice on exporting such reports to excel to work with?

Trial Balance:

Screenshot%20from%202019-07-04%2021-31-41

Exported report:

63000 is the sum of the values in the individual rows but its easy to erroneously sum it with 12000,1000,1000,2000… when doing =sum(c2:c81)

Screenshot%20from%202019-07-04%2021-57-57

1 Like

Is there a way to get a “flat view” of the report instead of the default hierarchical view, such that only non-group accounts are shown in the report?