# 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.

---

- **Canonical URL:** https://dothecalculation.com/blog/business/budget-variance-analysis
- **Category:** Business
- **Author:** Do The Calculation Team
- **Published:** 2026-08-03
- **Reading time:** 15 min read
- **Publisher:** Do The Calculation (https://dothecalculation.com)
- **Methodology:** https://dothecalculation.com/methodology

---

## 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.

_[Figure: How Budget Variance Analysis Works — The model turns a budget and an actual figure into a sized, directional answer.]_

## 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.

**Inputs used in a basic budget vs actual comparison**
| 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

**Core budget variance formulas**

```
Variance $ = Actual - Budget
Variance % = (Actual - Budget) / Budget x 100
Utilization % = Actual / Budget x 100
Margin of safety on an expense budget = Budget - Actual
```
- Use budget and actual figures from the same period and the same category.
- A positive Variance $ on an expense line means actual spending exceeded plan.
- A positive Variance $ on a revenue line means actual revenue exceeded plan.
- Utilization above 100% on an expense line means the budget has already been fully spent, or exceeded, for that period.

## 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.

> **Direction Warning** — Don't apply one color rule to an entire report. A red "over budget" flag makes sense for an expense line that ran hot — it does not make sense applied to a revenue line that beat its target. Build the status logic separately for revenue rows and expense rows.

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.

**Two variance calculations from the same report**
| 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.

Tool: [Check the Margin Behind a Revenue Shortfall](https://dothecalculation.com/calculators/profit-margin-calculator) — Calculate gross, operating, and net margin to see how a revenue miss actually affects profit, not just top-line variance.

## Department Variance Snapshot

_[Figure: 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.]_

## 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

> **Percentage Trap Warning** — A cost center budgeted at $200 for the month that spends $260 posts a 30% unfavorable variance — a number that would trigger an alarm on a six-figure department budget. In dollar terms, it's $60. Always check the dollar variance before reacting to a percentage on a small line item; the reverse is just as true for a large line with a small percentage but a large dollar gap.

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

> **Editorial Trust Note** — This guide is an educational explanation of budget variance mechanics, not accounting, tax, legal, or investment advice. Variance analysis identifies where actual results diverge from plan; it does not on its own diagnose the cause, verify that transactions were recorded correctly, or account for financing, non-cash items, or one-time events. For financial statements, tax filings, or a lender or investor presentation, reconcile the analysis against your actual accounting records and involve a qualified professional.

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

Tool: [Check Profit Margin Behind the Variance](https://dothecalculation.com/calculators/profit-margin-calculator) — Compare profit as a share of revenue before and after a variance to see whether it actually moved the bottom line.

Tool: [Test the Break-Even Point on a New Line](https://dothecalculation.com/calculators/break-even-calculator) — Calculate 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](/blog/templates/business-budget-workbook-guide) for how to structure that workbook by department and cost center, or go straight to the [Business Budget Planner Template](/excel-templates/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.

---

_Source: [Do The Calculation](https://dothecalculation.com/blog/business/budget-variance-analysis). Quote freely with attribution and a link to this page._