What Is Variance Analysis?
Variance analysis is the practice of comparing actual results to a reference point, a budget, a forecast, or a prior period, and explaining the differences. The variance is the gap; the analysis is understanding why it exists and what it means. When revenue comes in below budget or costs run above plan, variance analysis is how finance moves from noticing the gap to explaining it and deciding what to do.
It is one of the most common and valuable activities in financial planning and analysis. Numbers on their own say what happened; variance analysis says how it compares to expectation, which is what turns reporting into insight a leader can act on.
How to Calculate Variance
A variance is the difference between an actual result and its reference point, usually a budget or forecast. It is often expressed both as an absolute amount and as a percentage of the reference.
Variance = Actual – Budget
Variance % = (Actual – Budget) / Budget
Worked example, revenue against budget:
- Actual revenue: $900,000
- Budgeted revenue: $1,000,000
- Variance: 900,000 – 1,000,000 = -$100,000
- Variance %: -100,000 / 1,000,000 = -10%
Whether a variance is favorable or unfavorable depends on the line. A revenue figure below budget is unfavorable; a cost figure below budget is favorable. The math is the same; the interpretation flips.
Variance Analysis in Power BI (DAX)
In Power BI, variance is the difference between an actuals measure and a budget measure, with a percentage version alongside. Replace the measure names with the ones in your model:
Budget Variance = [Actual] - [Budget]
Budget Variance % = DIVIDE ( [Actual] - [Budget], [Budget] )The same pattern compares actuals to a forecast or a prior period by swapping the second measure.
Common Types of Variance
The most familiar comparison is budget versus actual: how did results compare to the plan. Closely related is forecast versus actual, comparing to the most recent expectation rather than the original budget. Period-over-period variance compares to a prior period, last quarter or last year. Each answers a different question, against plan, against expectation, against history, and together they give a rounded view of performance.
A variance can be favorable or unfavorable, and the sign alone is not the point. A favorable cost variance might reflect underspending that will hurt later; an unfavorable revenue variance might be timing. The value is in the explanation, not the number.
Why Variance Analysis Matters
Variance analysis is how organizations hold themselves accountable to a plan and learn from the gaps. It surfaces problems early, a cost trending over budget shows up before year-end, and it informs the next forecast, because understanding why a variance happened improves the next estimate. It also drives the management conversation: the monthly review is largely a discussion of variances and what they mean.
Done well, it closes the loop between planning and results. This is core FP&A work, and it depends on actuals and plan data sitting together in a form that makes the comparison easy.
The Data Behind Good Variance Analysis
The practical difficulty is that actuals and budgets often live in different places, actuals in the ERP, budgets in spreadsheets or a planning tool, structured differently. Comparing them means reconciling the two to a common structure, by account, department, and period, before any analysis can happen. Much of the effort in variance reporting is this alignment, not the math.
A foundation that brings actuals and plan data together on a common model removes that friction. With both aligned, variance analysis becomes fast and routine: leaders see budget, forecast, actual, and the variances between them in one place, broken down however they need. The comparison stops being a monthly assembly job and becomes a standing view.
Frequently Asked Questions
What is variance analysis?
It is the practice of comparing actual results to a budget, forecast, or prior period and explaining the differences. The variance is the gap between actual and reference; the analysis is understanding why it occurred and what it means for the business.
How do you calculate a variance?
Subtract the reference from the actual: Variance = Actual – Budget. Express it as a percentage by dividing that difference by the budget. A revenue actual of $900K against a $1M budget is a -$100K, or -10%, variance.
What are the main types of variance?
Budget versus actual compares results to the plan; forecast versus actual compares to the latest expectation; and period-over-period compares to a prior period such as last quarter or year. Variances can be favorable or unfavorable, though the explanation matters more than the sign.
Why is variance analysis difficult to produce?
Because actuals and budgets often live in different systems with different structures, the ERP versus spreadsheets or a planning tool. Comparing them requires reconciling both to a common structure by account, department, and period first. A foundation that aligns actuals and plan removes most of that effort.
Variance Analysis and QuickLaunch’s Approach
QuickLaunch Analytics brings actuals and plan data together on a common model, so variance analysis, budget, forecast, and prior-period comparisons, becomes a standing view rather than a monthly assembly job. Finance sees the variances and can break them down by account, department, and period in one place, on a foundation refined across 250+ enterprise implementations.
