6
A

Financial Report for Trial Balance

Andrew Thomas on 8/14/2024 10:35:52 AM

We currently have financial reports for Income Statement / Balance Sheet / Cashflow Statement which are the core statutory statements - these are driven by the G/L Account - Account Subcategory as setup to provide the format desired.


It would be really useful to have a Trial Balance Financial report that just does every G/L Account as per the chart of accounts - this would enable custom column analysis to be added as per the other financial reports. Otherwise the only other option is to export to Excel where the data is static and doesn't allow drill through to the entries.

Category: Financial Management
STATUS DETAILS
Completed
Ideas Administrator

Business Central Team (administrator)

You can achieve this by creating a new row definition using the "Insert G/L Accounts.." and select all the accounts
Image

There's no functionality to keep this definition in sync with the CoA, but if you just need a dump of the CoA it's an easy process to delete all lines and insert all G/L accounts again).