Onetribe is a consulting firm specialising in management reporting, controlling, and finance function transformation for mid-market companies in Central Europe. Variance analysis is the structured process of comparing planned and actual financial results, decomposing the differences into their root causes, and deciding what to do about them. It is not just “plan vs. actuals ” — it is the answer to “why” and “what next.”
The concept is universally taught. Every CIMA syllabus and IMA Statement on Management Accounting covers it. Yet in practice, variance analysis at mid-market level is overwhelmingly broken. AFP (Association for Financial Professionals) surveys consistently show that mid-market FP&A functions rate variance analysis as one of their most time-consuming processes but among the lowest in perceived value. The report gets produced — the analysis does not. This article closes that gap.
Why Budget-vs-Actual Comparison Alone Is Not Enough
Leadership receives a report: “Revenue is £150,000 below plan.” What should they do? The answer depends entirely on the cause:
- If volume dropped (fewer units sold), the problem sits in sales or demand
- If price dropped (same units, lower prices), the problem sits in pricing policy or competitive pressure
- If the mix shifted (more low-margin, fewer high-margin products), the problem sits in sales structure
Each cause demands a different response. The total variance on its own provides zero navigation for decision-making.
IMA (Institute of Management Accountants) research identifies that fewer than 25% of mid-sized companies perform systematic variance decomposition beyond the total-level comparison. Price, volume, and mix variances — the building blocks of meaningful analysis — are taught in every management accounting qualification but practised in a minority of businesses.
Three Types of Variances Every Finance Team Must Distinguish
1. Price Variance
What it measures: The difference between planned and actual price, holding volume constant.
Formula: (Actual price − Planned price) × Actual volume
Example: Planned selling price for Product A was £50/unit. Actual average price was £47/unit. 10,000 units sold. Price variance = (47 − 50) × 10,000 = −£30,000.
What to do: Investigate whether the price drop was intentional (discounts, promotions) or forced (competitive pressure, pricing errors).
2. Volume Variance
What it measures: The difference between planned and actual volume, holding price constant.
Formula: (Actual volume − Planned volume) × Planned price
Example: Plan was 12,000 units, actual was 10,000 units. Planned price £50/unit. Volume variance = (10,000 − 12,000) × 50 = −£100,000.
What to do: Analyse whether the volume shortfall is a demand problem, a production issue, a logistics bottleneck, or seasonality.
3. Mix Variance
What it measures: The shift in sales structure — more low-margin or fewer high-margin products (or vice versa).
Why it matters: A company can hit its revenue and unit targets yet see profit decline if the mix shifts towards lower-margin products. Mix variance is what McKinsey calls the “hidden margin killer” — the structural shift that total-level reporting does not reveal.
The Onetribe Variance Drill-Down — Five Steps From Number to Decision
At Onetribe, we use a structured five-step process to turn variance reports into decision tools:
Step 1: Detect — Compare Plan vs. Actual at the Top Level
Revenue, contribution margin , fixed costs, operating profit. Where are the largest variances? Focus on the top three to five by absolute value — not every line item deserves attention.
Step 2: Decompose — Split Into Price, Volume, and Mix
For each material variance, break it down into its components. This is the step that most mid-market companies skip — and the reason they cannot tell leadership what to do about a variance.
Step 3: Diagnose — Identify the Root Cause
A variance is a symptom, not a cause. A price variance of −£30,000 could result from: an unplanned discount by a sales rep, a competitor price cut, an error in the pricing system, or a currency shift on imported goods. Without diagnosis, the response will be wrong.
Deloitte frames the challenge: finance organisations built for annual budgets and quarterly reporting cannot deliver the continuous, forward-looking insight that management needs. The investigation step is where that insight lives.
Step 4: Decide — Classify and Assign
Distinguish between one-off and systematic variances. A one-off supplier outage requires a note in the report. A systematic margin decline — month after month — requires either a plan revision or a strategy change.
Every material variance should end with one of three outcomes:
- Action — a specific measure with an owner and a deadline
- Monitor — not yet critical, but track the trend
- No action — one-off, explainable, no impact on future periods
Step 5: Document — Create the Audit Trail
Record the variance, the cause, the decision, and the owner. Without documentation, the same variance gets “discovered” and debated every month. The documentation also builds an institutional knowledge base that survives personnel changes.
Materiality Thresholds — Not Every Variance Deserves Attention
If the controller analyses every variance equally, they spend the month explaining £500 differences while a £200,000 trend goes unnoticed. Materiality thresholds determine which variances escalate to leadership and which are handled operationally.
| Level | Threshold | Who Handles It |
|---|---|---|
| Operational | > 1% of the line item or > £5,000 | Controller / finance manager |
| Management | > 3% or > £20,000 | Leadership team / monthly review |
| Strategic | > 10% or > £100,000 | Board / owner-manager |
Thresholds must be calibrated to company size. For a £5M-revenue company, £20,000 is material. For a £50M company, it is not. The point is not the specific number — it is having a defined, agreed-upon rule that focuses attention where it matters.
Common Variance Analysis Mistakes
1. Reporting Without Decomposition
“Revenue is £150K below plan” is not analysis. It is observation. Without a breakdown into price, volume, and mix components, leadership cannot decide what to do.
2. A Bad Plan Makes Variances Meaningless
If the budget was built politically — every department added a buffer, leadership cut 10% across the board — then variances reflect planning quality, not business performance. EY highlights that organisations relying on annual budgets as their primary variance benchmark are structurally unable to produce meaningful analysis because the baseline itself is irrelevant.
3. Every Variance Gets the Same Explanation
“Timing differences” and “one-off” are the two most overused phrases in variance commentary. If every variance is explained away, leadership stops reading the report. The AFP survey confirms: variance reports consistently rank among the lowest-perceived-value outputs of FP&A functions.
4. Variances Without Owners
If nobody is accountable for a variance, nobody resolves it. Every material variance needs an owner — a person who explains the cause and proposes the response.
5. Reports Without Action
A beautifully formatted report with dozens of variances and zero conclusions. BCG research finding that only 48% of cost-saving targets are achieved suggests that variance analysis — the mechanism by which target achievement is monitored — fails systematically at converting insight into action.
Static Budget vs. Flexible Budget — Why It Matters
Most mid-market companies compare actuals against a static annual budget. The problem: if volume changes, every variance is contaminated by the volume effect. A department that spent £10,000 more than budget looks overspent — but if volume was 20% higher than planned, they may actually have been efficient.
A flexible budget adjusts the plan to actual activity levels, isolating the true performance variances:
| Metric | Static Budget | Flexible Budget (at actual volume) | Actual | Static Variance | Flexible Variance |
|---|---|---|---|---|---|
| Revenue | £1,000,000 | £1,100,000 | £1,050,000 | +£50,000 | −£50,000 |
| Variable costs | £600,000 | £660,000 | £680,000 | −£80,000 | −£20,000 |
The static budget says revenue is £50K ahead and costs are £80K over. The flexible budget reveals the truth: revenue is actually £50K below what it should have been at the achieved volume, and costs are only £20K over. Two completely different stories — two completely different management responses.
Frequently Asked Questions
How do I analyse budget-vs-actual variances step by step? Follow the five-step Onetribe Variance Drill-Down: (1) Detect — compare plan vs. actual at the top level and identify the three to five largest variances. (2) Decompose — split each into price, volume, and mix components. (3) Diagnose — identify the root cause. (4) Decide — classify as one-off or systematic, assign an owner and action. (5) Document — record the cause, decision, and owner.
How do I distinguish between price and volume variances? Price variance measures the impact of price change at actual volume: (Actual price − Planned price) × Actual volume. Volume variance measures the impact of volume change at planned price: (Actual volume − Planned volume) × Planned price. The sum of price, volume, and mix variances should equal the total variance.
Do I need specialist software for variance analysis? Not at the start. A structured Excel template — with plan, actuals, variance, decomposition by component, and commentary — is sufficient for most mid-market companies. What matters more than the tool is the discipline: doing the analysis consistently, documenting causes and decisions. When the number of products, cost centres, or reporting dimensions exceeds Excel’s practical limits, consider reporting automation .
Is it better to hire a controller or outsource the analysis? It depends on volume. A full-time controller (£40–60K/year in the UK) makes sense when there is enough work to fill the role. An outsourced or fractional controlling model is more cost-effective for companies that need the methodology and structure but do not have a full-time workload. The ideal is often external setup followed by internal handover after six to twelve months.
Where This Fits in Our Expertise
Variance analysis is at the core of the Performance Analysis pillar at Onetribe. It connects planning (the budget, the forecast ) to decision-making — enabling leadership to see not just what happened, but why, and what to do next. Without it, the monthly report is an observation. With it, the report becomes a steering tool.
Further Reading
- Profitability Analysis Fundamentals — the profitability data that variance analysis investigates
- Management Reporting Framework — the reporting structure in which variances are communicated
- KPI Framework for Financial Reporting — the metrics against which variances are measured
- Building Effective Management Reports — how to present variances so leadership acts
- Financial Data Governance — data quality that variance analysis depends on
- Performance Analysis — Our Expertise — how we approach performance analysis
- Glossary: Variance Analysis | Plan vs. Actuals | Contribution Margin | Budget | Forecast
Sources
- IMA — Institute of Management Accountants — fewer than 25% of mid-sized companies perform systematic variance decomposition
- AFP — Association for Financial Professionals — variance analysis ranks among lowest-perceived-value FP&A outputs; 60%+ of time on data gathering
- McKinsey — FP&A Transformation — 60–75% of FP&A time spent on data gathering and report production
- Deloitte CFO Signals — improving quality and speed of financial analysis among top CFO priorities
- EY — Planning and Forecasting Gap — annual budgets as primary benchmark produce structurally meaningless variances
- KPMG — FP&A Operating Model — variance quality reflects upstream data and planning quality
- BCG — Cost Management 2025 — only 48% of cost-saving targets achieved on average
- CIMA — Management Accounting Practice — management accounting practice gaps at mid-market
- Horvath — CxO Priorities 2025 — controlling transformation priorities
Martin Duben is CEO of Onetribe — a consulting firm specialising in management reporting, controlling, and finance function transformation for mid-market companies in Central Europe. With over 15 years of experience, he helps CFOs and business owners build information systems that support decision-making. Contact: onetribe.team .