From the finance director's chair
Budget vs forecast vs actual: how to read a variance report
Three numbers, one row, and a column of red. Here's how to read a variance report without panicking, and how to explain yours.
- Budget: the plan agreed before the year started. Forecast: the latest estimate of how the year will end. Actual: what really happened.
- A variance is the gap between actual and budget (or forecast). Favorable helps profit; unfavorable hurts it.
- Split big variances into price and volume. It turns "we missed" into "here's why".
Three numbers, three jobs
The budget is the approved plan, the closest thing to a promise. It's usually set once, usually before the year starts, and it's what targets and bonuses are often tied to.
The forecast is the weather report. It's updated during the year (how often depends on the company; quarterly is common) with everything you now know. If the budget said 1,000 units and you now expect 900, the forecast says 900.
Actuals are the receipts: what was really sold, spent and earned.
Reading the variance column
A variance is simply actual minus budget. Finance labels it favorable (F) if it helps profit and unfavorable (U) if it hurts. Careful: higher revenue is favorable, but higher costs are unfavorable, even though both are "up". Some reports use + and − or colors instead, so check the legend before you react.
Not every variance deserves a meeting. Most companies set a threshold, for example anything over 5% or over a fixed amount (each company picks its own). Spend your energy on the big ones.
Quick math: one "good" number hiding two stories
Budget: 1,000 units at $50 = $50,000. Actual: 1,100 units at $46 = $50,600. Revenue is $600 above budget. Nice, right?
Split it: selling 100 extra units at the budget price added $5,000 (volume variance). Selling all 1,100 units $4 cheaper cost $4,400 (price variance). The headline is +$600. The real story is "we bought volume with discounts", and if those discounts came out of margin, profit may be down. See the true cost of a discount.
How to explain your variance
- State it plainly: "We're $4,400 under budget on price."
- Give the driver: price, volume, mix, timing or a one-off.
- Say whether it's permanent or timing (will it reverse next month?).
- Say what you're doing about it, and what it does to the forecast.
Why it matters to you
Your monthly review is basically a variance conversation. Managers who arrive with the split already done ("volume +$5,000, price −$4,400, here's the plan") spend five minutes on it. Managers who don't spend thirty.
I'm rarely worried by a variance someone can explain. I'm worried by a forecast that hasn't moved in three months while the actuals have.
"What's my variance threshold, and do you report me against budget or the latest forecast?"