Budgeting, forecasting, and variance analysis

Direct answer

The budget records the approved plan; the forecast updates the expected outcome; variance analysis compares each with actual results. Keep the versions separate so a revised forecast does not erase the original target.

Why this question comes up

If the budget is overwritten, a favorable actual-to-forecast result can hide a missed original target. Save each version with its date and compare the same period and scope.

When weekly receipt and payment timing drives the decision, move from the annual plan to a 13-week cash forecast.

Records to gather

• The approved budget with its version, date, and approver
• Actuals for the same period on the same accounting basis
• Any reforecast, with what changed and why
• Chart-of-accounts mapping if budget and actuals use different structures
• Documented materiality thresholds for investigation

Review workflow

1. Set a review threshold. Choose a dollar amount, percentage, or both before reviewing results; still investigate unusual small items when warranted.
2. Match the basis. Compare the same period, entities, currency, accounting basis, and account mapping. Record any mapping change before interpreting the variance.
3. Separate price and volume where data allows. Lower units sold and lower selling prices call for different responses; do not invent the split from ledger totals alone.
4. Check timing. A late invoice or collection may move a result between periods. Distinguish that from a lasting change, and update the cash forecast if timing matters.
5. Find the driver. Trace a material difference to transactions, headcount, units, rates, or another documented cause. An account total alone does not explain it.
6. Record follow-up. For differences requiring action, name an owner and a review date.

What a useful answer should include

• Budget, latest forecast, actual, and their differences for the same scope; percent only when the comparison baseline is nonzero
• The materiality threshold, stated up front
• Price/volume decomposition when unit and price data are available
• Timing versus changed-outlook classification for material items
• The transactions or drivers behind each material variance
• An owner and follow-up date for items requiring action

Common failure modes

• Explaining every line. Without a threshold, review time goes to trivia and the material items get the same weight as noise.
• Comparing incomparable structures. A reorganised chart of accounts produces large variances that mean nothing.
• Claiming a price/volume split without operating data. Ledger totals alone do not identify the cause.
• Treating a timing difference as permanent. Check the next period and cash effect before changing the plan.
• Explanations that restate the number. “Marketing was over budget because we spent more on marketing” is common and useless.