Budget Variance Analysis: Formula, Examples, and How to Read a Budget vs Actual Report
Calculate budget variance in dollars and percent, classify favorable vs unfavorable correctly, and learn to read a budget vs actual report the right way.
A Budget Number Alone Doesn't Tell You Whether Spending Is a Problem
A department that spent $93,000 against a $90,000 budget looks the same on paper as one that spent $9,300 against a $9,000 budget — both are 3.3% over. Only one of those is worth a conversation. Budget variance analysis is the discipline of turning "actual doesn't match plan" into a specific, sized, and directional answer: how far off, in which direction, and whether it's large enough to matter.
The calculation itself is simple arithmetic. What makes it useful is reading the dollar variance and the percentage variance together, telling favorable apart from unfavorable correctly depending on whether the line is revenue or expense, and deciding in advance how much variance actually warrants a response.
How Budget Variance Analysis Works
The model turns a budget and an actual figure into a sized, directional answer.
Set the budget baseline
Fix the planned amount for the period — a month, a quarter, or a year — before spending begins.
Record the actual
Log the real amount for the same period and the same category.
Calculate variance $ and %
Find the dollar gap and express it as a percentage of the budget.
Classify and decide
Mark it favorable or unfavorable based on whether it's a revenue or expense line, then decide if it crosses your threshold for action.
Skipping step four is the most common mistake — a variance percentage without a threshold is just a number, not a decision.
Quick Answer
- Budget variance in dollars equals actual minus budget; variance in percent equals that dollar variance divided by budget, times 100.
- For expense lines, actual below budget is favorable; for revenue lines, actual below budget is unfavorable — the direction flips depending on what's being measured.
- Utilization rate (actual divided by budget) is the same information expressed as a single running percentage, commonly used for department-level status flags.
- Read dollar and percentage variance together — a small budget can post a large percentage swing on a trivial dollar amount.
- Set a utilization threshold for "on track," "watch," and "over budget" in advance so review is consistent rather than reactive.
- Budget variance analysis identifies where to look — it doesn't explain why, on its own; that still requires a conversation with whoever owns the number.
What Budget Variance Measures
Variance analysis compares a budgeted, planned, or standard amount against what actually happened, for both costs and revenues. It's a standard tool of budgetary control in management accounting — not a specialized technique reserved for large companies with a finance department, but the same basic comparison scaled down to a single department's monthly expense line.
Swipe sideways to compare columns.
| Input | Meaning | Examples | Common misreading risk |
|---|---|---|---|
| Budget (planned) amount | The target set before the period began | Monthly department budget, annual revenue target | Treating a stale, unrevised budget as still valid |
| Actual amount | What really happened in the same period | Logged expenses, recorded revenue | Comparing a partial-month actual to a full-month budget |
| Variance $ | The dollar gap between actual and budget | Actual − Budget | Reading it without the percentage for scale |
| Variance % | The dollar gap as a share of budget | Variance $ ÷ Budget × 100 | Reading it without the dollar amount for materiality |
| Utilization % | Actual as a share of budget, running total | Actual ÷ Budget × 100 | Confusing a cumulative utilization rate with a single month's variance |
Budget Variance and Utilization Formulas
Favorable and Unfavorable Work in Opposite Directions
This is the detail most budget vs actual reports get wrong by treating every positive variance the same way. On an expense budget, coming in under plan is favorable — the business spent less than expected. On a revenue budget, coming in under plan is unfavorable — the business earned less than expected. The formula for variance is identical in both cases; only the interpretation flips.
A profit variance then follows from both: budgeted profit minus actual profit tells you whether the combined effect of revenue and expense variance left the business ahead of or behind its plan for the period, even when the individual department flags look mixed.
Worked Example: Reading a Department's Budget vs Actual
Consider two lines from the same monthly report. A Marketing expense line was budgeted at $18,000 and actual spending came in at $19,850. A Sales revenue line was budgeted at $50,000 and actual revenue came in at $46,200.
Swipe sideways to compare columns.
| Line | Budget | Actual | Variance $ | Variance % | Classification |
|---|---|---|---|---|---|
| Marketing (expense) | $18,000 | $19,850 | +$1,850 | +10.3% | Unfavorable — spent more than planned |
| Sales (revenue) | $50,000 | $46,200 | −$3,800 | −7.6% | Unfavorable — earned less than planned |
Both lines are unfavorable, but for opposite reasons and at different dollar sizes. The Sales shortfall is more than double the Marketing overrun in dollar terms, even though its percentage variance is smaller — which is exactly why reading percent alone, without the dollar figure next to it, understates which line actually needs attention first.
Check the Margin Behind a Revenue ShortfallCalculate gross, operating, and net margin to see how a revenue miss actually affects profit, not just top-line variance.Department Variance Snapshot
Annual Variance by Department
A single-month view can hide a pattern. Reviewing variance across departments at the same point in the year shows where spending discipline is actually breaking down.
Sales & Marketing
$211,200 budget vs $214,330 actual — over budget
Operations
$264,200 budget vs $269,424 actual — over budget
Finance & Admin
$85,900 budget vs $84,842 actual — under budget, watch
People & HR
$378,600 budget vs $379,377 actual — over budget
Technology
$90,500 budget vs $93,957 actual — over budget
Facilities
$98,400 budget vs $98,096 actual — under budget, watch
Technology shows the largest percentage overrun; Operations shows the largest dollar overrun — the two rankings don't have to agree, and both are worth checking.
How to Build a Reliable Budget vs Actual Report
- Fix the budget for the period before it starts, and don't quietly revise it mid-period without noting the change.
- Compare actual and budget from the same time window — a partial month against a full-month budget will always look artificially favorable on an expense line.
- Calculate variance for every line individually before rolling up to a department or company total; a rollup can hide two offsetting variances inside it.
- Report both variance in dollars and variance in percent side by side, never one without the other.
- Apply favorable/unfavorable logic separately for revenue and expense lines, not one blanket rule.
- Add a cumulative, year-to-date column alongside the single-period column — a single bad month can look worse (or better) than the annual trend actually is.
- Flag lines against a pre-agreed threshold rather than a subjective read of "does this look like a lot."
- Revisit and update the report on the same cadence every time — monthly is standard for most operating budgets.
Set Utilization Thresholds Before You Need Them
Utilization rate — actual divided by budget, expressed as a running percentage — is the simplest way to build a consistent status flag across every department, without re-deciding what counts as "a lot" every single month. A common three-tier structure: below roughly 95% utilization is "on track" (or "watch" if it's a revenue line running behind), 95–100% is "on track," and anything meaningfully above 100% is "over budget."
The exact cutoffs should match your own tolerance for risk and the size of the budget in question — a department with a large, mostly-fixed cost base (like payroll) may reasonably sit very close to 100% every month, while a discretionary line (like advertising) might warrant a flag at a lower threshold because it's easier to pull back if needed.
Why Percentage Variance Can Mislead on Small Budgets
This is why a well-built budget vs actual report shows variance in both units at once, rather than sorting by percentage alone. Sorting by dollar variance surfaces the lines that actually move the company's total profit; sorting by percentage surfaces lines that are furthest off their own plan, regardless of size. Neither view alone tells the whole story.
Common Budget Variance Mistakes
- Comparing an in-progress month's actual to a full month's budget and reading it as under budget.
- Applying the same favorable/unfavorable color logic to revenue and expense lines.
- Reporting percentage variance without the underlying dollar amount, or vice versa.
- Rolling multiple line items into one department total before checking whether offsetting variances are canceling each other out.
- Never revisiting the utilization threshold as the business grows, so an old percentage cutoff stops matching current budget sizes.
- Treating a single unfavorable month as a trend without checking the year-to-date column.
- Changing the budget baseline mid-period without documenting it, so future variance comparisons are measured against a moving target.
- Skipping the "why" conversation — variance analysis identifies the size and direction of a gap, not its cause.
Assumptions and Limitations
The formulas here cover single-line and department-level variance. They do not cover more advanced variance decomposition — such as splitting a materials cost variance into a price component and a usage component — which is typically relevant to manufacturing cost accounting rather than a small business's operating budget.
Sources to Verify or Cite
- Corporate Finance Institute, Variance Analysis Template: https://corporatefinanceinstitute.com/learn/resources/financial-modeling/variance-analysis-template
- Corporate Finance Institute, Variance Formula Template: https://corporatefinanceinstitute.com/resources/financial-modeling/variance-formula-template
- U.S. Small Business Administration, Manage Your Finances: https://www.sba.gov/counseling/manage-your-business/#manage-your-finances
Related DTC Resources
Check Profit Margin Behind the VarianceCompare profit as a share of revenue before and after a variance to see whether it actually moved the bottom line.Test the Break-Even Point on a New LineCalculate the sales volume a line item needs before deciding whether an unfavorable variance is worth correcting or absorbing.Budget Variance FAQs
What is budget variance?
It's the difference between a budgeted or planned amount and the actual amount for the same period and category, expressed in dollars, as a percentage, or both.
What's the difference between variance in dollars and variance in percent?
Dollar variance shows the actual size of the gap; percentage variance shows that gap relative to the budget. A small dollar gap can be a large percentage on a small budget, and a small percentage can be a large dollar gap on a large budget — read both together.
Is a positive variance always good news?
No. On an expense line, a positive variance (actual above budget) is unfavorable. On a revenue line, a positive variance (actual above budget) is favorable. The direction of "good" flips depending on what's being measured.
What is utilization rate, and how is it different from variance?
Utilization rate is actual divided by budget, expressed as a running percentage — it's a status snapshot. Variance is the specific dollar and percentage gap for a given period. Many dashboards use utilization for a quick flag and variance for the underlying detail.
How do I decide if a variance is worth investigating?
Set a threshold in advance — for example, anything over 100% utilization on an expense line, or more than 5% under plan on a revenue line — so review is consistent rather than a case-by-case judgment call.
Can a department show a favorable total variance while individual line items are unfavorable?
Yes. Rolling several line items into one department total can hide offsetting variances — one cost center running under budget can mask another running well over. Check individual lines before trusting a rollup.
How often should a budget vs actual report be updated?
Monthly is standard for most operating budgets, with a year-to-date column reviewed at the same time so a single unusual month doesn't get mistaken for a trend.
Does variance analysis explain why spending was off?
No. It identifies the size and direction of the gap. Explaining the cause requires a conversation with whoever owns that budget line, informed by the variance data.
Should the budget be revised mid-year if actuals consistently miss it?
That's a judgment call specific to the business, but any revision should be documented and dated so future variance comparisons are measured against a clear, known baseline rather than a moving target.
Is this budget variance analysis financial advice?
No. It's an educational explanation of the underlying formulas and how to read the results. For decisions with real financial consequences, involve a qualified accountant or financial advisor.
Related Reading
Budget variance analysis is the math behind the Budget vs Actual sheet in a department-based budget workbook. See Business Budget Workbook Guide: Turn Department Spending Into a Repeatable Monthly Process for how to structure that workbook by department and cost center, or go straight to the Business Budget Planner Template to start tracking it.
Final Summary
Budget variance analysis takes a gap between plan and actual and makes it specific: sized in dollars, sized in percent, and classified as favorable or unfavorable in the correct direction for the type of line being measured. Read both units together, set your utilization thresholds before a department drifts over them, and remember that the calculation tells you where to look, not why it happened. That's a small amount of arithmetic in exchange for catching a problem while there's still a month left to fix it, instead of finding it at year-end.
Written by
Do The Calculation Team
Do The Calculation Editorial Board
The Do The Calculation Editorial Board is comprised of software engineers, finance analysts, and technical contributors focused on building clean, accurate, and easy-to-use calculator tools.
Reviewed & Verified By
Dr. Marcus Sterling, PhD
Tax Policy & Economic Advisor
Specialist in progressive taxation systems, corporate finance, and business depreciation cycles. Dr. Sterling ensures our tax, salary, depreciation, and corporate margin calculators match current IRS and global regulatory guidelines.