Built-in finance reports in Business Central

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 moreID
Use the report when you set up or review your company’s account structure, verify posting groups, or prepare for financial reports and audits.Chart of AccountsAbout Chart of Accounts1
Use the report to prepare for an audit or trace G/L entries by register number, document reference, and posting date.G/L RegisterAbout G/L Register3
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 BalanceAbout Detail Trial Balance4
Compare customer receivables and vendor payables by due-date period in local currency. Use the net change and cumulative net balance to identify potential cash shortfalls. The report doesn't reconcile these balances with general ledger control accounts.Receivables-PayablesAbout Receivables-Payables5
Use the report when a controller or accountant needs to reconcile deferred revenue or expense balances on G/L accounts as of a specific date and review how much has been recognized versus how much remains to be deferred.Deferral Summary - G/LAbout Deferral Summary - G/L1700
Use the report when finance teams need to reconcile deferred sales revenue balances and review how deferral amounts are recognized across accounting periods.Deferral Summary - SalesAbout Deferral Summary - Sales1701
Use the report when a controller or accounts payable clerk needs to reconcile deferred expense balances for vendors as of a specific date, producing a breakdown of recognized and remaining deferred amounts by document and period.Deferral Summary - PurchasingAbout Deferral Summary - Purchasing1702
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 ExcelAbout Trial Balance Excel4405
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 YearAbout Trial Balance/Previous Year7
Use Excel to view a snapshot of your chart of accounts at a given point to check the net change and closing balance compared to the budget.Trial Balance/Budget ExcelAbout Trial Balance/Budget Excel4406
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/BudgetAbout Trial Balance/Budget (legacy)9
Check end of financial year figures, excluding closing entries, and compare this year and the previous year.Closing Trial BalanceAbout Closing Trial Balance10
Get a detailed breakdown of your net changes over up to 12 accounting periods for each general ledger account.Trial Balance by PeriodAbout Trial Balance by Period38
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 BalanceAbout Fiscal Year Balance36
To identify trends and variances, compare account balances side-by-side across two date ranges. 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. YearAbout Balance Comp. - Prev. Year37
Monitor and reconcile foreign currency balances, particularly during revaluation periods or when reviewing the impact of exchange rate fluctuations.Foreign Currency BalanceAbout Foreign Currency Balance503
Run a report defined in the Financial Reporting feature.Run Financial ReportAbout Financial Report25
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 - TotalAbout Dimensions - Total27
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 - DetailAbout Dimensions - Detail28
Find conflicts between default dimension value posting rules before posting documents. Review conflicting mandatory, same-code, and no-code requirements during setup or when troubleshooting dimension-related posting errors.Dimension Check Value PostingAbout Dimension Check Value Posting30
Understand the transactions for control G/L accounts, and highlight any discrepancies between G/L and customer/vendor ledgers.Reconcile Cust. and Vend. AccsAbout Reconcile Cust. and Vend. Accs33
Get an overview of your financials across assets, liabilities, and equity.Balance SheetAbout Balance Sheet151
Get an income statement that shows your income, cost of goods sold (COGS), gross profit, expenses, and net income.Income StatementAbout Income Statement154
Get a Statement of Cashflows showing an overview of operating activities, investing activities, and financing activities gathered in a single cash flow report.Statement of CashflowsAbout Statement of Cashflows155
Get an overview of retained earnings from the start of the period you specify in the report filter, net income, and distributions to shareholders.Retained Earnings StatementAbout Retained Earnings Statement156
Review the audit trail of G/L registers and their entries, including reversed transactions, to verify posting activity and support compliance with accounting standards.Audit TrailAbout Audit Trail330
Get a daily transaction overview for customer postings, similar in intent to a sales day book or a chronological audit-style listing of customer postings.Day Book Customer Ledger EntryAbout Day Book Customer Ledger Entry2501
Get a daily transaction overview for vendor postings, similar in intent to a vendor day book or a chronological audit-style listing of vendor postings.Day Book Vendor Ledger EntryAbout Day Book Vendor Ledger Entry2502

Deferral 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 financial reports for the deferrals feature.

To...Open in Business Central (CTRL+select)Learn moreID
Use the report when a controller or accountant needs to reconcile deferred revenue or expense balances on G/L accounts as of a specific date and review how much has been recognized versus how much remains to be deferred.G/L Deferral SummaryAbout G/L Deferral Summary1700
Use the report when finance teams need to reconcile deferred sales revenue balances and review how deferral amounts are recognized across accounting periods.Sales Deferral SummaryAbout Sales Deferral Summary1701
Use the report when a controller or accounts payable clerk needs to reconcile deferred expense balances for vendors as of a specific date, producing a breakdown of recognized and remaining deferred amounts by document and period.Purchasing Deferral SummaryAbout Purchasing Deferral Summary1702

VAT 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 financial reports that deal with tax/VAT.

To...Open in Business Central (CTRL+select)Learn moreID
Compare general ledger amounts with VAT entry totals by G/L account, based on your VAT statement setup. G/L totals use posting dates, while VAT entry totals use VAT reporting dates. Investigate differences before you file VAT.G/L - VAT ReconciliationAbout G/L - VAT Reconciliation11
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 StatementAbout VAT Statement12
Review and validate individual VAT entries by G/L register for tax audits and accurate VAT reporting. Use register number filters to review specific entries and investigate discrepancies.VAT RegisterAbout VAT Register13
Review intra-EU sales totals by VAT registration number, with separate amounts for goods, services, and EU three-party trade. Validate VAT numbers and country/region codes before preparing your tax declaration. The report doesn't submit the declaration electronically.VAT- VIES Declaration Tax AuthAbout VAT- VIES Declaration Tax Auth19
Calculate VAT payable or refundable from open VAT entries at the end of a filing period. Review a test report with Post turned off. Turn on Post to transfer the amount to the settlement account and close the settled VAT entries.Calc. and Post VAT SettlementAbout Calc. and Post VAT Settlement20
Review recorded VAT differences that meet a minimum threshold in either direction. Investigate adjustments on existing VAT entries before filing returns. The report doesn't identify transactions with missing VAT entries.VAT ExceptionsAbout VAT Exceptions31
Check VAT registration number formats and find duplicates within customers, vendors, or contacts. Use the report to improve master data before EU sales reporting. The report doesn't validate numbers with VIES.VAT Registration No. CheckAbout VAT Registration No. Check32
Reconcile VAT entries with general ledger accounts before you file taxes by reviewing G/L entries and their linked posted VAT amounts. Use the report to ensure accuracy and alignment of VAT data during tax preparation.VAT Reconciliation ReportAbout VAT Reconciliation Report743
Review posted VAT entries by VAT reporting date and posting type. Use a date range of no more than one year to support tax reviews and reconciliations.Day Book VAT EntryAbout Day Book VAT Entry2500

Consolidation and intercompany 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 when using consolidation companies and/or the intercompany (IC) feature.

To...Open in Business Central (CTRL+select)Learn moreID
Use Excel to view a snapshot of your consolidated chart of accounts at a given point to check the net change and closing balance.Consolidated Trial Balance ExcelAbout Consolidated Trial Balance Excel4410
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 Balance17

10007 (NA localization)
Analyze consolidated financial data for up to four business units in separate columns, with combined amounts, 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)
Preview how unposted elimination entries in a selected general journal batch affect consolidated amounts. Use the report to review eliminations before posting the journal. The report doesn't create or post elimination entries.G/L Consolidation EliminationsAbout G/L Consolidation Eliminations16
To ensure accurate financial consolidation and transparency, review and reconcile the current company's intercompany sales, purchase, and journal entries.Intercompany TransactionsAbout Intercompany Transactions512

Cost accounting 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 financial reports for cost accounting.

To...Open in Business Central (CTRL+select)Learn moreID
Compare cost type balances or net changes for two periods. Review the difference and percentage comparison to identify changes in cost activity.Cost Acctg. Stmt. per PeriodAbout Cost Acctg. Stmt. per Period1123
Review posted entries and running balances by cost type. Filter by date, cost center, or cost object to trace the transactions behind your cost totals.Cost Types DetailsAbout Cost Types Details1125
Get a summarized view of total costs by cost type. Use this report to review cost totals, apply filters for period, cost center, or cost object, and support operational decision-making with a high-level overview of posted cost data.Cost Acctg. StatementAbout Cost Acctg. Statement1126
Compare actual cost amounts across up to seven cost centers or cost objects. Use the date filter to review cost distribution for a selected period.Cost Acctg. AnalysisAbout Cost Acctg. Analysis1127
Check unposted cost journal lines before posting. Include error messages to identify missing information or invalid cost type, cost center, and cost object combinations.Cost Acctg. JournalAbout Cost Acctg. Journal1128
Evaluate how costs are set up to be allocated across cost centers or cost objects using defined allocation rules. Use this report to understand cost distribution and support cost control efforts.Cost AllocationsAbout Cost Allocations1129
Compare actual net changes with budget amounts by cost type. Filter by cost center or cost object to review differences and actual costs as a percentage of budget.Cost Acctg. Statement/BudgetAbout Cost Acctg. Statement/Budget1133
Analyze balances for cost types and budgets to support financial planning and control. Use fiscal-year dates and filters for cost type or budget to tailor insights and ensure accuracy.Cost Acctg. Balance/BudgetAbout Cost Acctg. Balance/Budget1138

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