Budget vs Actual Variance Analysis: A Practical Method for UK SMEs
A variance report that lists every line over or under budget is noise. A useful one explains the handful of differences that matter, why they happened, and whether they will reverse.
Most SME variance reports fail in one of two ways: they show nothing but the numbers, or they explain every pound. Neither helps a director decide what to do differently next month.
Start with materiality
Decide in advance which variances get commentary. A dual threshold — a percentage and an absolute amount — keeps attention on what moves profit and cash.
Split revenue variances properly
| Component | Question it answers | Typical action |
|---|---|---|
| Volume | Did we sell more or fewer units / hours? | Pipeline, capacity, sales activity |
| Price | Did we achieve the planned rate? | Discounting discipline, price reviews |
| Mix | Did we sell a different blend of products or clients? | Focus on higher-margin lines |
Classify every material variance
- Timing — will reverse; note the expected period.
- Permanent — will not reverse; update the forecast.
- Error or misposting — fix in the ledger, not in the commentary.
- Budget error — the plan was unrealistic; say so and reforecast.
A monthly routine
- Close the month with proper accruals so variances are real, not cut-off noise.
- Run the report month and year to date against budget and latest forecast.
- Filter to material lines only.
- Ask the budget holder for the reason before writing anything.
- Write commentary as cause, impact and action — in that order.
- Roll permanent variances into the rolling forecast.
Writing commentary the board reads
Weak: "Revenue was £42k below budget." Strong: "Revenue was £42k below budget because two retainer clients started in October rather than September — a timing variance expected to reverse next quarter. No change to the full-year forecast." The second version answers the only question the board has: does this change anything?
Doing this in MouCFO
MouCFO compares actuals to budget each month, highlights material variances and drafts account-level commentary that your team can enrich with operational context before it goes in the board pack.
Frequently asked questions
What is a sensible materiality threshold for variance commentary?
A common approach for SMEs is to comment on any line that differs from budget by more than a set percentage and a set absolute amount — both conditions, so small lines with large percentage swings do not dominate the report. The right figures depend on the size of the business.
What is the difference between a timing and a permanent variance?
A timing variance reverses in a later period — for example, a marketing campaign that slipped from March to April. A permanent variance does not — for example, a lost customer or a supplier price rise. The board should care far more about permanent variances.
Should we reforecast when variances get large?
Yes. Keep the original budget as the fixed reference, but maintain a rolling forecast so decisions are made against the most likely outcome rather than an outdated plan.