Calculate budget variance in dollars and percentage, and determine whether the variance is favorable or unfavorable for revenue or expense lines.
~5 min read
Budget Variance Formula
Variance = Actual - Budget
Variance % = (Actual - Budget) / |Budget| × 100
Favorable vs Unfavorable
The direction that makes a variance "favorable" depends on the line item type:
| Line Type |
Favorable Condition |
| Revenue |
Actual > Budget (earned more than planned) |
| Expense |
Actual < Budget (spent less than planned) |
Materiality Thresholds
Most organizations set materiality thresholds for variance investigation. Common rules:
- Investigate variances > 5–10% for budget lines over $10k
- Always investigate revenue variances > 10%
- Flag cumulative variances even if individual periods are within tolerance
Types of Budget Variance
- Price variance: The unit price differed from what was budgeted
- Volume variance: Quantity sold or units consumed differed
- Efficiency variance: Labor or material usage per unit differed
- Mix variance: The combination of products/services sold differed from the planned mix
Understanding the source of a variance determines the appropriate corrective action.
Intent Pages
↑ Back to calculator
What Is Budget Variance Analysis?
A plain-English guide to budget variance analysis — what it measures, how to calculate it, and how finance teams use it to catch problems early.
Budget variance analysis is the practice of comparing actual financial results against
a budgeted plan, then investigating the differences. It's one of the most basic — and
most frequently skipped — disciplines in financial management.
The core calculation
Variance = Actual - Budget
Variance % = (Actual - Budget) / |Budget| × 100
A variance on its own is just a number. Analysis means asking why the number exists
and whether it will repeat next period.
Why finance teams run variance analysis every month
Monthly variance review catches problems while they're still cheap to fix. A marketing
line running 40% over budget in month one is a quick conversation; the same overrun
left unchecked for two quarters is a cash crisis. Variance analysis is the early-warning
system that sits between "we made a budget" and "we actually hit it."
Revenue vs expense variances read in opposite directions
A positive expense variance (spent more than planned) is unfavorable. A positive revenue
variance (earned more than planned) is favorable. Mixing these up is the most common
reporting mistake in finance decks — always label variances as favorable/unfavorable,
not just positive/negative, to avoid ambiguity.
Three questions every variance review should answer
- Is this a timing issue or a real gap? A marketing spend that landed in month 2
instead of month 1 isn't a real overrun — it's a timing shift.
- Is this one-time or structural? A single large one-off expense doesn't need a
process fix. A recurring 15% overrun on the same line every month does.
- Does this change the full-year forecast? Material variances should update your
reforecast, not just get logged and forgotten.
Frequently asked questions
How big does a variance need to be before I investigate it?
Most finance teams use a materiality threshold — commonly 5–10% of the budgeted line,
or a fixed dollar amount for smaller lines. Below that, normal noise; above it, dig in.
Should every department review its own variances?
Yes — department owners have the operational context finance doesn't. Finance's job is
to flag the variance and ask the question; the department head explains the cause.
Use the Budget Variance Calculator to compute the
dollar and percentage variance for any line item instantly.
↑ Back to calculator
Favorable vs Unfavorable Variance: Key Differences
How to tell whether a budget variance is favorable or unfavorable, why the direction flips between revenue and expense lines, and common mistakes in labeling.
The same-sized dollar variance can be good news or bad news depending on what kind of
budget line it sits on. Getting the direction wrong is the single most common error in
variance reporting.
The rule
| Line Type |
Actual > Budget |
Actual < Budget |
| Revenue |
Favorable |
Unfavorable |
| Expense |
Unfavorable |
Favorable |
For revenue, more is better — exceeding budget is favorable. For expenses, less is
better — spending under budget is favorable. The label describes the impact on profit,
not the direction of the number.
Why this trips people up
A spreadsheet that simply colors positive variances green and negative variances red
is wrong for expense lines — a "positive" (over-budget) expense variance is bad news,
but a naive color rule would flag it green. Always compute favorable/unfavorable
explicitly based on line type rather than relying on the sign alone.
A worked example
Marketing budgeted $50,000, spent $58,000 → variance = +$8,000 (16% over) →
unfavorable, because it's an expense line running over.
Revenue budgeted $200,000, actual $215,000 → variance = +$15,000 (7.5% over) →
favorable, because it's a revenue line running over.
Both variances are positive numbers. One is good news, one is bad news.
Favorable variances deserve scrutiny too
A large favorable expense variance isn't automatically good — it might mean a project
was delayed (the money will still be spent, just later) or a headcount plan under-hired,
which could hurt output. Investigate large favorable variances with the same rigor as
unfavorable ones.
Frequently asked questions
Does "favorable" always mean good for the business overall?
Not necessarily. Underspending marketing might be favorable on the budget line but
unfavorable for pipeline generation. Always check the downstream effect, not just the
line-item label.
How should favorable/unfavorable be shown in a report?
Most finance teams use a dedicated column or icon (▲/▼ with color) computed from the
rule above, rather than relying on raw variance sign — this avoids the revenue/expense
confusion entirely.
Use the Budget Variance Calculator — it labels
every variance as favorable or unfavorable automatically based on the line type you select.
↑ Back to calculator