Budget vs. Actual Analysis

This happens for predictable reasons. Variances are not investigated systematically—large and small variances receive equal attention. Root causes are not identified—'we were over budget' does not explain why. No threshold framework exists—what variance size warrants investigation? Volume, rate, and mix effects are not separated—so the driver of change remains unclear.

According to Planful's FP&A survey, 61% of finance leaders say variance analysis is their most time-consuming FP&A activity, yet only 34% say their organizations consistently act on variance insights. The gap between analysis and action is where value is lost.

Effective variance analysis requires a systematic framework: what to investigate, how to investigate, and what investigation reveals about future performance.

Primary Investigation Thresholds: Materiality threshold—this variance is material if it exceeds 10% of budget or $5,000, whichever is smaller. Controllability threshold—this variance matters more if the driver is within management control. Trend threshold—any variance that persists for 2+ consecutive months warrants investigation regardless of size.

Secondary Investigation Factors: Strategic significance—even small variances in strategically important areas may warrant attention. Cash impact—variances affecting cash position may need investigation even if small. Unusual items—any variance from an unusual or non-recurring item deserves examination.

Investigation Priority Matrix:
High Priority: Large variance + controllable + persistent
Medium Priority: Large variance but uncontrollable, or moderate variance + controllable
Low Priority: Small variance + uncontrollable + one-time

This framework prevents both analysis paralysis (investigating everything) and blind spots (missing important signals).

Volume Effect: The difference caused by selling more or fewer units than budgeted. If you sold 100 units at $50 budgeted price but 90 units at $50 actual, revenue variance is $500 unfavorable, entirely volume-driven.

Rate Effect: The difference caused by prices or costs being higher or lower than budgeted. If you sold 100 units at $50 budgeted price but 100 units at $52 actual, revenue variance is $200 favorable, entirely rate-driven.

Mix Effect: The difference caused by changing the combination of products, services, or customer segments. If you sold the same total units but shifted from higher-margin to lower-margin products, margin percentage declines even with stable per-unit economics. Mix effects are common in multi-product businesses and often overlooked.

Calculation example for revenue: Budget: 100 units x $100 = $10,000 | Actual: 110 units x $95 = $10,450. Total variance: $450 favorable. Volume effect: 10 additional units x $100 budgeted price = $1,000 favorable. Rate effect: 110 units x ($95 - $100) = $550 unfavorable. Mix effect requires additional analysis if product mix changed.

For expense variances: Volume effect reflects actual activity vs. planned activity. Rate effect reflects price/cost changes. Spending variance reflects whether actual spending followed the plan.

Step 1: Gather Context
Before analyzing numbers, gather operational context. What happened in the period? Did sales launch a new product? Did operations change capacity? Did the market shift? Understanding what actually happened enables meaningful analysis.

Step 2: Classify the Variance Type
Determine whether the variance is timing, volume, rate, or mix. This classification determines the appropriate response. Timing variances self-correct; rate variances require operational response; volume variances require capacity planning.

Step 3: Drill to Root Cause
Move beyond surface-level explanation. 'Marketing spent more than budget' is not an analysis. 'Marketing spent more on digital advertising because CPC increased 30% following competitor activity, exceeding our budget assumption of 10% increase' is analysis.

Step 4: Assess Implications
What does this variance imply for future periods? Is this an isolated event or a structural change? Should we update our forecasts? Should we change our processes?

Step 5: Document and Communicate
Keep a log of variance explanations and actions taken. Over time, this builds organizational learning about where planning assumptions break down.

For Revenue Variances: Investigate pipeline health when revenue is below plan. Are deals slipping? Is competition increasing? Is pricing pressure emerging? Update forecasts to reflect actual pipeline conversion rates.

For Payroll Variances: When payroll is over budget, determine if headcount additions were planned or reactive. If reactive, assess whether the additional hiring creates sustainable value or adds to fixed cost base.

For Operating Expense Variances: When expenses exceed budget, distinguish between strategic investment (we decided to spend more for expected return) and execution variance (we spent more without planned benefit). Each requires different management response.

For Gross Margin Variances: When margin is below plan, separate material cost changes from pricing changes from mix changes. Each has different strategic implications.

The key question for each variance: does this variance indicate we should change our plans, change our behavior, or simply update our forecasting assumptions? The answer determines the appropriate response.

Monthly Review Cadence: Schedule variance analysis review within 10 business days of month-end. The faster the review, the more actionable the insights. Waiting until Day 20 makes investigation feel academic rather than operational.

Department Owner Accountability: Each variance category should have a department owner responsible for investigation. Finance facilitates and consolidates, but department leaders own the business explanations.

Pattern Recognition: Track variances over time to identify systematic issues. If marketing is consistently 10% over budget for campaigns, either the budget assumption is wrong or marketing planning needs improvement.

Forecast Integration: Variance insights should feed back into forecasting. If utilities consistently run 8% under budget, next year's budget should reflect that. Continuous improvement in forecasting comes from learning from variance patterns.

Board Reporting: Boards should see variance analysis that is material and actionable, not comprehensive line-item comparison. Focus on the 3-5 variances that most require board attention or decision.