Guide · Report

How to Build a Budget vs Actual Report

The variance columns are the easy part. The value of a budget versus actual report is the commentary that explains why the numbers moved and what to do about it.

Report
Revenue variance
Quarter to date • vs budget
Budgeted revenue1,000,000
Actual revenue900,000
Variance (adverse)(100,000)
Variance %-10%

What a budget versus actual report is

A budget versus actual report compares what you planned against what happened, line by line, and quantifies the gap between the two. That gap is the variance. It answers three questions in order: what did we expect, what did we get, and how far apart were they. A good one answers a fourth, which is the whole point: why. Done well, it is a control and accountability tool, not a scorecard, telling you where the business is diverging from plan early enough to do something about it.

What to include

Five columns do most of the work.

Budget. The figure you committed to for the period, from the approved budget.
Actual. The figure from your accounting system for the same period, on the same chart of accounts.
Variance (currency). Actual minus budget, in your reporting currency.
Variance (percent). The same gap as a percentage of budget, so a small line and a large line can be compared on the same footing.
Commentary. One or two sentences on each material line, explaining the variance.

Show the period and the year to date side by side. A line can be on budget for the month and well off for the year, or the reverse, and only both columns together tell the truth.

Budget vs actual
Quarter to date
Account Budget Actual Var $ Var %
Revenue750,000762,000+12,000+1.6%
Marketing232,000274,000(42,000)+18%
Commentary. Marketing 18% over for the quarter, a $42k adverse variance, driven by bringing the Q3 campaign forward. Timing, not overrun.

The commentary column is the one the board reads first.

Report

How to build one, step by step

1
Pull the actuals
For the period from your accounting system, on the same chart of accounts as the budget.
2
Line them up
Against the budget for the same period, so every budget line has its actual beside it.
3
Calculate the variance
In both currency and percent for each line.
4
Flag the material variances
Set a threshold, a percentage, a currency amount, or both, so attention goes to what matters, not every rounding difference.
5
Write the commentary
On the flagged lines only. The lines within threshold need no explanation.

How to write the variance commentary

The part that separates a report the board reads from one it skims.

1
What changed
The line and the size of the gap.
2
Why it changed
The operational cause, not a restatement of the number.
3
What it means
The impact on the full-year position or on cash.
4
What you are doing about it
The action, if any is needed.
Worked commentary

"Marketing spend was 18% over budget for the quarter, a $42k adverse variance, driven by bringing the Q3 campaign forward to catch the trade-show window. This is timing, not overrun; full-year marketing remains on budget. No action required."

"Costs went up" is not commentary. It is the absence of commentary with a full stop on the end.
The two habits that matter most

Name the operational cause rather than the accounting movement, and separate a timing difference from a permanent one. A board reacts very differently to "we will spend this later" than to "this is the new run rate."

Report

What your board actually wants

Common mistakes
×
Explaining every line instead of only the material ones
×
No materiality threshold, so the signal drowns in noise
×
Commentary that restates the number instead of explaining the cause
×
No distinction between timing and permanent variances
×
No action, so the board is left to ask "so what?"
Key takeaway

The board is not testing whether your numbers are right. It is testing whether you understand why they moved. The commentary is the test, not the table.

Report

A faster way

By hand

Building this by hand every cycle, pulling actuals, lining them up, calculating variances, chasing the causes, is the repetitive part of the reporting cycle.

With Planir

Planir generates the budget versus actual from your live accounting data, flags the material variances against a threshold you set, and drafts the commentary explaining what changed and why. You review the reasoning, adjust where your business context dictates, and approve. The structure stays the same every cycle, so your board can compare like for like.

Common questions

What is a budget vs actual report?
+
A budget versus actual report compares planned figures against actual results for a period, line by line, and quantifies the variance between them, with commentary explaining the material differences.
What is a good variance threshold?
+
There is no universal figure. Many teams flag variances above 5 to 10 percent of the budget line, or above a set currency amount, whichever is more useful for that account. The aim is to focus attention on what is material to your business.
What is the difference between a favourable and an adverse variance?
+
A favourable variance improves the result, such as revenue above budget or a cost below it. An adverse variance worsens it. Favourable is not always good and adverse is not always bad, which is exactly why the commentary matters.
How often should you run a budget vs actual report?
+
Usually monthly, aligned to the reporting cycle, with a year-to-date view alongside the period so timing differences are visible.

Explore other use cases

Planir is built for the planning and reporting cycles that funded, governed, and multi-entity businesses actually run.

Board governance

Board reporting

The financial foundation of every board pack, with variance analysis by dimension and forward projections your board can interrogate.

See board reporting
Investor obligations

Investor reporting

The financial section of every monthly and quarterly investor update, generated from your live data.

See investor reporting
Planning & forecasting

Budgeting and planning

Driver-based 3-way budgets and forecasts built from your live data, with every assumption documented and reviewable.

See budgeting and planning

See your budget vs actual build itself

Connect your accounting data and Planir generates the budget versus actual, flags the material variances, and drafts the commentary, ready for you to review.

Book a Demo Talk to Sales