Plan against actual as part of the routine: budgeting in Business Central.
Why a report starts with the chart of accounts
Short answer: a financial report in Business Central is not a separate object with its own data. It is a view onto the chart of accounts. If the chart is structured badly, no amount of report configuration will rescue it.
The classic mistake when moving from an older system is to carry the chart across unchanged, complete with dozens of sub-accounts created purely for analysis. In Business Central analysis lives in dimensions, so a multi-storey chart becomes dead weight — and actively gets in the way when assembling reports.
A quick diagnostic. If your chart contains accounts that differ only by department, project or product line, those are dimensions wearing an account number. Collapsing them is usually the single highest-value change you can make before building reports.
Chart structure: accounts, totals and categories
| Element | Role | What it does for reporting |
|---|---|---|
| G/L account | An ordinary posting account | The source of amounts |
| Total account | Sums a range of accounts | Ready-made subtotals without formulas in the report |
| Account category | Classification: assets, liabilities, income, expense | The basis for standard statements and a fast start |
| Dimensions | Analysis on the transaction: department, project, product line | Lets any row be expanded by any breakdown |
The order matters: sort out categories and total accounts first, build reports second. With categories assigned correctly, a workable profit and loss statement and balance sheet appear almost without configuration, and the remaining work is presentation.
Report rows: where the numbers come from
A financial report row can source its figures in four ways, and the choice decides whether you will be editing reports every time the chart changes.
| Row type | Source of the amount | When to use it |
|---|---|---|
| Account range | A list or range of accounts | Most transparent option for specific line items |
| Total account | A subtotal already held in the chart | When the same subtotal is needed in several reports |
| Formula | Calculated from other report rows | Gross profit, margin, intermediate totals |
| Account category | All accounts in a given category | Resilient to new accounts appearing later |
The last option is the most durable. A row based on a category will automatically pick up an account created six months from now. A row based on a hard-coded list will quietly show an understated figure, and nobody will notice for a while.
Formulas produce derived measures: gross profit as the difference between rows, margin as a percentage of a base. For percentages, set an explicit base row — otherwise comparing two periods calculates each percentage against a different denominator, and the comparison is meaningless.
Columns: periods, comparisons, budget versus actual
If rows decide what the report shows, columns decide for when and against what.
| Column type | What it shows | Typical use |
|---|---|---|
| Net change | Movement during the selected period | Profit and loss |
| Balance at date | Position at period end | Balance sheet |
| Comparison period | Same period last year, or the previous period | Trend analysis |
| Budget | Planned figures | Budget versus actual |
| Calculated | Difference or percentage between columns | Variance reporting |
Here is the trap people fall into most often: a profit and loss statement needs net change, a balance sheet needs balance at date. Swap them and the balance sheet shows movement instead of position — and reconciles with nothing.
Budget-versus-actual only works when the budget is entered in the system using the same dimensions as actual postings. A budget living in an external file with a different breakdown of line items cannot be compared. That is not a system limitation; it is the consequence of two different reference structures.
When built-in reports are enough, and when they are not
Built-in financial reporting covers statutory and management reporting in tabular form: profit and loss, balance sheet, account analysis, turnover by dimension, period comparisons. For finance teams that is usually sufficient.
Power BI earns its place in three situations: when data from several systems has to be combined, when a trend needs visualising rather than tabulating, or when reports must reach management on a schedule without anyone in finance pressing a button.
Outside those cases, a separate analytics project mostly adds a layer that somebody has to maintain.
Why reports fail to reconcile
- A legacy chart carried over with analytical sub-accounts. Reports need editing after every change to the chart.
- Rows built on hard-coded account lists. New accounts never appear, and totals are quietly understated.
- Wrong column type. Net change where balance at date was needed, producing a balance sheet that reconciles with nothing.
- Percentages without a fixed base. Period comparisons return nonsense.
- An open period. A report run yesterday shows different numbers today, because postings kept arriving into a period nobody closed.
The last one is worth its own procedure. Locking posting dates after close is what makes a report reproducible, and reproducibility is what makes finance trust the system.
We build the reporting structure during implementation.
Frequently asked questions
Can we build a P&L and balance sheet without development?
Yes. With account categories assigned correctly, both statements are available almost immediately, and the remaining work is adjusting rows and columns to your preferred presentation.
What is the difference between a total account and a report formula?
A total account holds a subtotal in the chart of accounts itself, so every report can reuse it. A formula calculates from other rows inside one specific report and exists only there.
How do we compare the current period with last year?
Through a comparison period column, which pulls the same period from the previous year or the preceding period, alongside the current figures.
Can actuals be compared with budget?
Yes, provided the budget is entered in Business Central using the same dimensions as actual postings. A budget held in an external file with a different structure cannot be aligned.
Why do report figures change retroactively?
Almost always because the period is still open and postings continue to arrive into it. Locking posting dates after close is what makes a report reproducible.
Do we need Power BI for financial reporting?
Not for standard statements. Power BI is justified when data from several systems must be combined, when trends need visualising, or when reports must be distributed on a schedule automatically.