Variance Analysis
Prepare the comparison
Confirm entity, account hierarchy, period, currency, unit, actual/budget/forecast versions, sign convention, and materiality. Validate that compared datasets use consistent scope and mappings.
Calculate absolute variance = actual - comparison and percentage variance using a documented denominator. Treat zero or sign-changing denominators explicitly rather than presenting misleading percentages.
Decompose drivers
- Price/volume: volume effect = (actual volume - baseline volume) x baseline price; price effect = (actual price - baseline price) x actual volume.
- Mix/rate: quantify shifts among products, customers, channels, regions, grades, or contract types.
- Headcount: separate headcount, compensation rate, mix, hiring timing, attrition, bonus, and benefit effects.
- Spend: separate fixed, volume-driven, discretionary, contractual, one-time, foreign-exchange, and timing effects.
The starting value plus all signed drivers must equal the ending value. Show any residual as an unresolved item, not “other” without explanation.
Narrative
For each material variance state:
- amount, percentage, favorable/unfavorable status, comparison, and period;
- quantified primary and offsetting drivers;
- the business cause and evidence;
- whether the effect is timing, one-time, structural, or uncertain;
- outlook, action, owner, and forecast implication.
Avoid circular statements such as “revenue increased because revenue was higher.” Distinguish proven cause from plausible hypothesis.
Waterfall and output
Limit a waterfall to a decision-useful set of drivers, verify it reconciles, and accompany it with a driver table. Rank follow-up by absolute impact, unexpected direction, recurrence, trend, controllability, and materiality. State all data limitations and required review.
1---2name: variance-analysis3description: Decompose actual, budget, forecast, and prior-period financial variances into quantified drivers and management commentary. Use for price-volume-mix, rate, headcount, spend, margin, and waterfall analysis.4---56# Variance Analysis78## Prepare the comparison910Confirm entity, account hierarchy, period, currency, unit, actual/budget/forecast versions, sign convention, and materiality. Validate that compared datasets use consistent scope and mappings.1112Calculate absolute variance = actual - comparison and percentage variance using a documented denominator. Treat zero or sign-changing denominators explicitly rather than presenting misleading percentages.1314## Decompose drivers1516- Price/volume: volume effect = (actual volume - baseline volume) x baseline price; price effect = (actual price - baseline price) x actual volume.17- Mix/rate: quantify shifts among products, customers, channels, regions, grades, or contract types.18- Headcount: separate headcount, compensation rate, mix, hiring timing, attrition, bonus, and benefit effects.19- Spend: separate fixed, volume-driven, discretionary, contractual, one-time, foreign-exchange, and timing effects.2021The starting value plus all signed drivers must equal the ending value. Show any residual as an unresolved item, not “other” without explanation.2223## Narrative2425For each material variance state:26271. amount, percentage, favorable/unfavorable status, comparison, and period;282. quantified primary and offsetting drivers;293. the business cause and evidence;304. whether the effect is timing, one-time, structural, or uncertain;315. outlook, action, owner, and forecast implication.3233Avoid circular statements such as “revenue increased because revenue was higher.” Distinguish proven cause from plausible hypothesis.3435## Waterfall and output3637Limit a waterfall to a decision-useful set of drivers, verify it reconciles, and accompany it with a driver table. Rank follow-up by absolute impact, unexpected direction, recurrence, trend, controllability, and materiality. State all data limitations and required review.
rongxinzy