Variance analysis isn't about explaining every number. It's about finding the few that change a decision.
Compare each line's actual with budget for the month and year to date, in amount and percentage. Explain only variances above a set threshold, for example a percentage and a minimum amount together. For each one, say what caused it, whether it is timing or permanent, and what it means for the forecast. Review the commentary before it goes to management.
Without a threshold, teams either explain everything or nothing. Use two conditions together: a percentage and a minimum amount. A large percentage on a tiny line doesn't matter; a small percentage on revenue might. Agree the threshold with management once and apply it every month.
One row per account or cost centre, with actual and budget for the month and year to date. Then:
Variance: =C2-D2 (actual minus budget)
Variance %: =IFERROR(E2/ABS(D2),0)
Explain?
=AND(ABS(E2)>=MinAmount,ABS(F2)>=MinPct)
Name the threshold cells MinAmount and MinPct. Filter for TRUE. Remember that a favourable variance on costs is negative and on revenue positive; add a column that labels each one favourable or adverse by account type.
Each explanation answers three questions:
Compare: "Marketing over budget due to timing" against "Marketing over budget by the cost of the trade show, budgeted for next month; full year unchanged." The second one needs no follow-up question.
Many large variances are accounting errors, not business events: a missed accrual, a cost posted to the wrong cost centre, a prepayment expensed in full. Before writing commentary, ask whether the actual is right. A manual journal review and a complete accruals routine remove most of these.
A monthly variance that reverses next month is timing. A year-to-date variance that keeps growing is a trend. Show both, and update the forecast when a variance is permanent, so the budget comparison stays meaningful for the rest of the year.
Management rarely needs every line. Lead with a short summary: the total result against budget, the three to five variances that matter, and what changes in the forecast. Put the detailed table behind it for anyone who wants to look. Use the same layout every month, so readers learn where to find things and spot changes quickly.
The method is the same in both countries. Some US teams call it "budget-to-actual" or "BvA"; UK teams often say "variance analysis" or "management accounts commentary".
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
As short as it can be while still answering what happened, whether it is timing or permanent, and what it means for the forecast. One or two sentences per variance is usually enough.
Only those above an agreed threshold that combines a percentage and a minimum amount. Explaining everything hides the important ones.
A timing variance reverses in a later month, such as a cost incurred earlier than budgeted. A permanent variance changes the full-year result.
Many teams show both. The budget shows performance against the plan; the forecast shows whether the latest view is still on track.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.