Built-in finance reports in Business Central

2025-06-30

Business Central includes several built-in reports, tracing functions, and tools to help auditors or controllers who are responsible for reporting to the finance department.

Explore finance reports with Report Explorer

To get an overview of the reports that are available for finance, choose All Reports on your Home page. This action opens the Role Explorer, which is filtered to the features in the Report & Analysis option. Under the Finance heading, choose Explore.

Example of reports on the finance role center

To learn more, go to Finding pages and reports with the role explorer.

Core finance reports

Tip

If you have a production environment for Business Central online, you can click on a report ID in the following table to open the report in the product. If you want to stay on this page, hold down CTRL before you click. In most browsers, the report opens in a new browser tab.

The following table describes some key financial reports. The reports are designed to help different roles in finance departments make informed decisions that optimize their operations.

To...	Open in Business Central (CTRL+select)	Learn more	ID
Use the report when setting up or reviewing your company’s account structure, verifying posting groups, or preparing for financial reports and audits.	Chart of Accounts	About Chart of Accounts	1
Use during preparation for an audit or when tracing G/L entries by posting dates or users to verify financial transaction integrity.	G/L Register	About G/L Register	3
Audit and reconcile general ledger balances at the end of a period by viewing the net change, opening balance, each transaction in the period, and the closing balance grouped by G/L account.	Detail Trial Balance	About Detail Trial Balance	4
Reconcile subledger balances for accounts receivable (AR) and accounts payable (AP) with their respective general ledger (G/L) control accounts. This report is especially useful during financial close or when investigating discrepancies between subledger and ledger data.	Receivables-Payables	About Receivables-Payables	5
Use Excel to view a snapshot of your chart of accounts at a given point to check the debit and credit net change and closing balance.	Trial Balance Excel	About Trial Balance Excel	4405
To check the debit and credit net change and closing balance compared to the same period in the previous calendar year, view a snapshot of your chart of accounts at a given point.	Trial Balance/Previous Year	About Trial Balance/Previous Year	7
Use Excel to view a snapshot of your chart of accounts at a given point to check the debit and credit net change and closing balance compared to the budget.	Trial Balance/Budget Excel	About Trial Balance/Budget Excel	4406
To check the debit and credit net change and closing balance compared to the budget, view a snapshot of your chart of accounts at a given point.	Trial Balance/Budget	About Trial Balance/Budget (legacy)	9
Check end of financial year figures, excluding closing entries, and compare this year and the previous year.	Closing Trial Balance	About Closing Trial Balance	10
Get a detailed breakdown of your closing balances over 12 accounting periods for each general ledger account.	Trial Balance by Period	About Trial Balance by Period	38
Review opening and closing balances for each general ledger account within a selected fiscal year. The report supports reconciliation and trend analysis across fiscal periods. To verify that balances are correctly carried forward, use this report during fiscal year-end close.	Fiscal Year Balance	About Fiscal Year Balance	36
To identify trends and variances, compare account balances side-by-side across two fiscal years. Filter by dimension or account range for more targeted insights. Use this report to analyze year-over-year financial performance and highlight account-level changes.	Balance Comp. - Prev. Year	About Balance Comp. - Prev. Year	37
Monitor and reconcile foreign currency transactions, particularly during revaluation periods or when reviewing the impact of exchange rate fluctuations.	Foreign Currency Balance	About Foreign Currency Balance	503
Run a report defined in the Financial Reporting feature.	Run Financial Report	About Financial Report	25
Analyze your general ledger with dimension totals by building groups of dimensions for combinations of dimension values, and calculate a general ledger balance total for each segment.	Dimensions - Total	About Dimensions - Total	27
Analyze your general ledger with dimension detail by building groups of dimensions for combinations of dimension values, and view a breakdown of general ledger entries for each segment.	Dimensions - Detail	About Dimensions - Detail	28
Validate whether value entries such as inventory or cost postings are correctly posted to the general ledger. Helps ensure posting integrity and supports accurate financial reporting.	Dimension Check Value Posting	About Dimension Check Value Posting	30
Understand the transactions for control G/L accounts, and highlight any discrepancies between G/L and customer/vendor ledgers.	Reconcile Cust. and Vend. Accs	About Reconcile Cust. and Vend. Accs	33

Deferral reports

Tip

The following table describes financial reports for the deferrals feature.

To...	Open in Business Central (CTRL+select)	Learn more	ID
Review and reconcile deferred revenue and expense entries by analyzing their impact on general ledger balances over time. Get transparency into how deferrals affect G/L accounts across posting periods, helping ensure accurate financial reporting.	G/L Deferral Summary	About G/L Deferral Summary	1700
Analyze how sales-related revenue is deferred across accounting periods and ensure it aligns with revenue recognition policies. Use the report to reconcile deferred revenue balances and validate recognition timing. Ideal for finance teams reviewing sales deferrals and compliance with accounting standards.	Sales Deferral Summary	About Sales Deferral Summary	1701
Review and reconcile deferred purchasing expenses by viewing deferral schedules and amounts across periods. Ensure expenses are allocated to the correct financial periods for accrual accuracy. Use during period-end close to validate purchasing deferral balances.	Purchasing Deferral Summary	About Purchasing Deferral Summary	1702

VAT reports

Tip

The following table describes financial reports that deal with tax/VAT.

To...	Open in Business Central (CTRL+select)	Learn more	ID
Reconcile VAT amounts in the general ledger with posted VAT entries. The report helps ensure accuracy when you file taxes. Use filters such as posting date and VAT period to validate that reported VAT aligns with transaction-level data. The alignment helps you be compliant and ready for audits.	G/L - VAT Reconciliation	About G/L - VAT Reconciliation	11
Calculate and report VAT that's due or refundable during tax filing by summarizing input and output VAT based on how you set up your custom VAT statement. Select the relevant statement and period to generate accurate, structured tax reports.	VAT Statement	About VAT Statement	12
Review and validate individual VAT transactions from posted sales, purchases, and journals for tax audits and accurate VAT reporting. Use filters such as posting date or VAT group to review specific entries and investigate discrepancies.	VAT Register	About VAT Register	13
Generate a declaration of intra-EU sales to VAT-registered customers for submission to the VIES system, ensuring compliance with EU tax regulations. Validate customer VAT numbers and country codes before running the report to avoid errors. Use this report when submitting required intra-EU sales data to tax authorities.	VAT- VIES Declaration Tax Auth	About VAT- VIES Declaration Tax Auth	19
Calculate and post VAT that's payable or refundable at the end of a filing period by generating a journal based on posted entries. This report helps streamline tax settlement and compliance work.	Calc. and Post VAT Settlement	About Calc. and Post VAT Settlement	20
Identify posted transactions where VAT was expected but not applied. The report helps ensure that your VAT setup is accurate, which prevents reporting errors before you file tax returns.	VAT Exceptions	About VAT Exceptions	31
Verify the validity of VAT registration numbers for customers and vendors by cross-checking them against the EU VIES system. Use this report regularly, and especially before you submit EU sales reports, to ensure compliance with cross-border VAT regulations and avoid reporting errors.	VAT Registration No. Check	About VAT Registration No. Check	32
Reconcile VAT entries with general ledger accounts before you file taxes by comparing VAT calculated on documents with posted VAT amounts. Use the report to ensure accuracy and alignment of VAT data during tax preparation.	VAT Reconciliation Report	About VAT Reconciliation Report	743
Review all posted VAT transactions grouped by document date in a register-style format. The report can help you with tax audits, reconciliations, and historical analysis across sales and purchase documents.	Day Book VAT Entry	About Day Book VAT Entry	2500

Consolidation and intercompany reports

Tip

The following table describes some key financial reports when using consolidation companies and/or the intercompany (IC) feature.

To...	Open in Business Central (CTRL+select)	Learn more	ID
Use Excel to view a snapshot of your consolidated chart of accounts at a given point to check the debit and credit net change and closing balance.	Consolidated Trial Balance Excel	About Consolidated Trial Balance Excel	4410
Review combined financial results across multiple companies under a parent organization. Summarize general ledger account balances from several legal entities into one unified trial balance. Use this report to support high-level financial analysis and ensure alignment across entities.	Consolidated Trial Balance Consolidated Trial Balance (NA localization)	About Consolidated Trial Balance	17 10007 (NA localization)
Analyze consolidated financial data across multiple companies with a four-column layout showing local balances, converted values, eliminations, and totals. Use this report to compare and review financial performance side-by-side across business units.	Consolidated Trial Balance (4) Consolidated Trial Balance (4) (NA localization)	About Consolidated Trial Balance (4)	18 10008 (NA localization)
Remove internal transactions between companies during financial consolidation to avoid duplicate revenues and expenses. Run this report after posting all intercompany transactions to ensure accurate and compliant group-level financial statements. Use it to streamline consolidation and maintain the integrity of financial reporting.	G/L Consolidation Eliminations	About G/L Consolidation Eliminations	16
To ensure accurate financial consolidation and transparency, review and reconcile intercompany sales, purchase, and journal entries between internal entities.	Intercompany Transactions	About Intercompany Transactions	512

Cost accounting reports

Tip

The following table describes financial reports for cost accounting.

To...	Open in Business Central (CTRL+select)	Learn more	ID
Analyze cost activity over specific periods, such as months or quarters, by reviewing posted cost entries grouped by reporting intervals. Use it to monitor cost trends and evaluate periodic spending patterns.	Cost Acctg. Stmt. per Period	About Cost Acctg. Stmt. per Period	1123
Break down total costs by category, such as labor, materials, and overhead, to analyze how each cost type contributes to overall expenses. Use the report for detailed cost tracking and filtering by period or cost center.	Cost Types Details	About Cost Types Details	1125
Get a summarized view of total costs across dimensions like departments or cost centers. Use this report to review cost totals, apply filters for period, cost type, or object, and support operational decision-making with a high-level overview of posted cost data.	Cost Acctg. Statement	About Cost Acctg. Statement	1126
Compare actual costs to budgeted values to identify variances and improve forecasting. Select the relevant period and budget version to analyze where costs exceeded or fell below expectations.	Cost Acctg. Analysis	About Cost Acctg. Analysis	1127
Review and validate posted cost entries by listing journalized transactions with amounts, dates, and dimensions. Use this report to trace cost postings and ensure accuracy in cost accounting.	Cost Acctg. Journal	About Cost Acctg. Journal	1128
Evaluate how costs are allocated across cost centers, cost objects, or dimensions using defined allocation rules. Use this report to understand cost distribution and support cost control efforts.	Cost Allocations	About Cost Allocations	1129
Compare actual costs against budgeted amounts by cost center to identify variances and improve budgeting accuracy. Use this report during planning cycles to monitor cost performance and highlight gaps between projections and actuals.	Cost Acctg. Statement/Budget	About Cost Acctg. Statement/Budget	1133
Analyze balances for cost accounts and budgets to support financial planning and control. Use filters like fiscal year, cost type, or budget version to tailor insights and ensure accuracy.	Cost Acctg. Balance/Budget	About Cost Acctg. Balance/Budget	1138

Accounts Receivable Reports
Accounts Payable Reports
Fixed Assets Reports
Ad hoc analysis on finance data
Power BI finance app
Financial analytics

Find free e-learning modules for Business Central here

Share via