Financial Reports and Analytics in Business Central

Financial reporting in Business Central allows financial and business professionals to create, maintain, deploy, and view financial statements. It moves beyond traditional reporting constraints to help you efficiently design various types of reports. Business Central includes several reports, tracing functions, and tools that help auditors or controllers who are responsible for reporting to the finance department. Financial reporting includes support for dimensions, so account segments or dimensions are immediately available. No other tools or configuration steps are required.

Tip

If you have a (online) Business Central production environment, you can click on a report id below to open the report directly in the product. If you want to stay on this page, consider holding down CTRL before clicking. In most browsers, the report will then open in a new browser tab.

Reports

The following table describes some of the key reports in financial reporting.

Report Description ID
Trial Balance Shows the chart of accounts with balances and net changes. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year. 6
Trial Balance by Period Shows the opening balance by general ledger account, the movements in the selected period of month, quarter, or year, and the resulting closing balance.
Tip: Can be used to display profit and loss (P&L) with a total for each month.
38
Trial Balance/Budget Shows a trial balance in comparison to a budget. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year. 9
Detailed Trial Balance Shows a detail trial balance for selected general ledger accounts. You can use the report at the close of an accounting period or fiscal year. You can define which accounts are included in the report by setting filters. 4
Trial Balance/Previous Year Shows a trial balance in comparison to the previous year's figures. You can choose to see a trial balance for selected dimensions. You can use the report at the close of an accounting period or fiscal year. The previous year means the same period one calendar year earlier. Deferred Company Fund Instalment (7)
Account Schedule Account schedules can be used to display the general ledger accounts in a different way than in the chart of accounts. For example, account schedules can be used for reports on key figures. 25
Consolidated Trial Balance Shows a combined overview of general ledger entries for two or more companies in one consolidated company. Use this report to report on consolidated financial data from multiple companies. For more information, see Set Up Company Consolidation 17
Consolidated Trial Balance (4) Shows a combined overview of general ledger entries for two or more companies in one consolidated company. This version of the report lets you display up to four business units as columns. For more information, see Set Up Company Consolidation. Use this report to report on consolidated financial data from multiple companies. 18

Tasks

The following articles describe some of the key tasks for analysing the state of your business:

See also

Creating Cost Budgets
Report GST to Tax Authorities
Closing Years and Periods
Use Pre-Closing Reports
Preparing Closing Statements
Analysing Financial Statements in Microsoft Excel
Work with Dimensions
Accounts Receivable Reports and Analytics
Accounts Payable Reports and Analytics
Fixed Assets Reports and Analytics
Setting Up Finance
Finance
Local Functionality Overview
Accountant Experiences in Dynamics 365 Business Central