Fiscal Year Balance (report)

The Fiscal Year Balance report shows the fiscal-year opening balance, debit and credit movements before and within a selected period, and balances at the period end for each general ledger (G/L) account. Closing balances are separated into balance sheet and income statement columns.

Enter Starting Date and Ending Date for the period. The starting date must be an accounting period start. You can filter by account and global dimensions, select an Indentation Level and Rounding Factor, and turn on Show Totals.

Use cases

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.

Tip

Here are some tips on how to use the report:

  • Run this report during fiscal year-end close to confirm that balances are carried forward accurately.
  • Use filters to isolate specific account types or fiscal years for targeted analysis.

Finance teams can use this report to:

  • Verify that each G/L account has the correct opening and closing balances during fiscal year-end close.
  • Reconcile account movements across fiscal years.
  • Analyze trends in financial position over time for strategic planning.

Try the report

Try the report here: Fiscal Year Balance

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview

Find free e-learning modules for Business Central here