Account schedules and financial reports in Business Central

Business Central ships with a row-and-column reporting engine for financial statements that long predates Power BI. It's old-fashioned, fast, and good enough that many companies never need an external BI tool for monthly management accounts.

Account schedules and Financial Reports

The original feature is called Account Schedules. Microsoft is gradually rebranding it to Financial Reports, with a refreshed UI on top of the same engine. Both names refer to the same underlying capability: define a list of rows pointing to GL accounts or dimensions, define a list of columns covering periods, comparisons, or calculations, and the system renders a structured report.

Row definitions

A row definition lists report lines. Each line references one or more GL accounts (by number, by range, or by category), or another row by totalling formula, with formatting (bold, italic, indent) and optional drill-down. Rows can be hidden when zero, bold when negative, or constrained to a single dimension value. This is how you build a P&L: revenue lines, gross profit subtotal, operating expense rollups, EBITDA, depreciation, financial expenses, net profit.

Column definitions

A column definition lists report columns. Each column is a period (current, prior, year-to-date, budget), a comparison (variance, variance %), or a formula across other columns. Columns can be dimension-filtered, so you can split a single account across departments side by side.

Combining them

You attach a column definition to a row definition to get a runnable report. The same row definition (e.g. "Standard P&L") can be combined with several column definitions ("Month vs Budget", "Month vs Last Year", "Year-to-date vs Plan").

Dimensions and consolidations

Account schedules respect dimensions throughout, which is how single-row, multi-cost-centre reports work without duplicate accounts.

Excel and Power BI

Reports can be scheduled to email as PDF or Excel, opened in Excel for ad-hoc editing, or exported to Power BI for distribution. Excel integration is two-way for some report types.

Limits

Account schedules are tabular; they don't do charts, parameter prompts beyond date and dimensions, or row-level conditional formatting beyond signed values. For sophisticated visualisation you use Power BI. For solid month-end P&L and balance sheet, Account Schedules earn their keep.