Variance analysis

What it is

Variance analysis compares actual results with a reference, usually the budget, the latest forecast or the same period last year, and explains the gap. The total variance is broken into drivers so managers can see what changed. Classic drivers are volume (how much was sold or processed), price or rate (at what price), and mix (which products or clients). On the cost side, analysts split variances into headcount, pay rate, timing and one-off items.

A variance is favourable when it improves profit and adverse when it reduces it. Analysts set materiality thresholds, for example 5 percent or EUR 50,000, so only significant variances need written explanation.

Why it matters

Variance analysis turns numbers into decisions. It tells management whether a shortfall is temporary, such as timing of a fee, or structural, such as falling prices. It also tests the quality of budgets and forecasts: large, repeated variances in one line suggest that the plan or the assumptions behind it were wrong.

Worked example

Illustrative numbers. A payments business budgeted 10,000 transactions at an average fee of EUR 5.00, giving EUR 50,000 of fee income. Actual results were 11,000 transactions at EUR 4.60, giving EUR 50,600.

• Volume variance: (11,000 minus 10,000) x EUR 5.00 = EUR 5,000 favourable.
• Price variance: (EUR 4.60 minus EUR 5.00) x 11,000 = EUR 4,400 adverse.
• Total variance: EUR 600 favourable.

The headline looks flat, yet two large effects offset each other. The commentary would explain why prices fell (for example, a large client moving to a cheaper tier) and whether volumes will keep growing.

Who uses it

• FP&A Analysts prepare monthly variance packs against budget and forecast.
• Business Controllers explain variances for their business lines and challenge cost owners.
• Commercial Finance Analysts analyse price, volume and mix of revenue by client and product.
• General Accountants explain balance sheet and expense movements during the close.
• Finance Graduates and Finance Transformation Consultants build and automate variance reports.

Common confusions

• The order of calculation matters. Computing price before volume, or the reverse, changes the split, so a team should fix one convention.
• Favourable is no synonym for good. Lower costs from delayed hiring can be favourable on paper and harmful to the business.
• Variances against budget and against forecast answer different questions: the first measures performance against the plan, the second measures forecast accuracy.
• A flat total can hide large offsetting drivers, so the split is often more useful than the total.