Financial Reports and Analytics in Business Central

Financial reporting in Business Central gives financial and business professionals the power to create, maintain, deploy, and view financial statements. Goes beyond traditional reporting constraints to help you efficiently design various types of reports. Business Central includes several reports, tracing functions, and tools to 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 key financial reports.

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 or 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. Use this report at the close of an accounting period or fiscal year. 8A-8B Net Amt. of Your Obligations (9)
Detailed Trial Balance Shows a detailed trial balance for selected general ledger accounts. You can define which accounts are included in the report by setting filters. Use this report at the close of an accounting period or fiscal year. 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. Use this report at the close of an accounting period or fiscal year. The previous year means the same period one calendar year earlier. 7
Financial Report Financial reports can be used to display general ledger accounts in a different way than in the chart of accounts. For example, financial reports can be used to report 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 to report on consolidated financial data from multiple companies. Learn more at 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. Learn more at Set Up Company Consolidation. Use this 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

Find free e-learning modules for Business Central here