What Budget vs Actual Analysis Actually Is

Every business plans in numbers and lives in different ones. Budget vs actual analysis is the disciplined comparison of the two: compute the variance on each line, decide which variances matter, find out why they happened, and change something as a result. Without the last two steps, variance reporting is numerology — interesting, decorative, and useless.

The output that matters is not the variance table. It is the short list of decisions the table forces: cut this spend, reprice that product, reforecast revenue, investigate that cost center. If your month-end pack does not produce decisions, the analysis is incomplete no matter how pretty the charts are.

Pair with Financial Statement Analysis, Financial Ratios Cheat Sheet, Cash Flow Forecast Template, and Financial Modeling for Startups.

Why Businesses Bother: Five Payoffs

  1. Early warning. A revenue shortfall spotted in February can be answered with pipeline action; discovered in November, it becomes a missed year.
  2. Accountability with context. Owners explain their lines with causes and actions, replacing blame sessions with problem-solving.
  3. Forecast accuracy that compounds. Each month’s variance post-mortem improves next quarter’s assumptions — the budget gets smarter every cycle instead of being rebuilt from zero annually.
  4. Cash protection. Expense overruns caught monthly never become the year-end surprise that forces emergency cuts or bridge financing.
  5. Board and lender credibility. A management team that explains variances crisply — cause, impact, action — earns the benefit of the doubt when it asks for capital, covenant relief, or patience.

Tie the cadence to Month-End Close: variance commentary is due with the close packet, not two weeks later when memory has faded and the numbers have moved on.

Types of Budget Variances (and Which Deserve Your Time)

Not all variances are equal. Classify before investigating:

Type Meaning Investigate when…
Revenue variance Actual vs budgeted sales Any material shortfall — revenue misses cascade through the whole P&L
Expense variance Actual vs budgeted costs Overruns on controllable lines; persistent small leaks that compound
Volume variance Driven by units sold/delivered It reveals demand problems vs pricing problems — different fixes
Price/rate variance Driven by prices paid or charged Input costs moved (renegotiate) or discounting crept in (retrain sales)
Fixed-cost variance Spending vs budget on costs that should not move with volume Almost always controllable — investigate first, it should rarely surprise
Variable-cost variance Cost per unit vs budget Split into price and efficiency components before acting

The triage rule: investigate material and controllable variances first. A $50,000 forex swing nobody controls gets a one-line note; a $5,000 recurring overrun on a controllable line gets an owner and a deadline.

The Formulas (Five Lines That Run the Whole Exercise)

  • Variance ($) = Actual − Budget. Sign convention matters: define once, document it, never flip mid-year.
  • Variance (%) = Variance ÷ Budget. Percentages let a $2,000 line and a $200,000 line compete fairly for attention.
  • Favorable vs unfavorable: revenue above budget = favorable; revenue below = unfavorable. Costs invert: spending less than budget is favorable, spending more is unfavorable.
  • Flexible-budget variance = Actual − (Budget adjusted for actual volume). Separates “we sold a different amount” from “we spent differently per unit” — the single most clarifying cut in variance analysis.
  • Net operating impact = sum of revenue variances − sum of expense variances. One number that answers “did the month help or hurt the plan.”

Set investigation thresholds in advance (e.g., ±10% and ±$5,000 — both conditions, so neither trivial lines nor rounding errors trigger reviews) and apply them mechanically every month.

Worked Example: Meridian Services, March

A fictional $1.2M ARR services company closes March with this P&L against budget:

Financial metric Budget Actual Variance $ Variance % F/U
Revenue $100,000 $90,000 −$10,000 −10.0% Unfavorable
Operating expenses $60,000 $65,000 +$5,000 +8.3% Unfavorable
Net operating income $40,000 $25,000 −$15,000 −37.5% Unfavorable

Step 1 — Calculate. Revenue missed by $10k (10%); expenses overspent $5k (8.3%); the combined effect is a $15k NOI miss — 37.5% below plan. Note the leverage: a 10% revenue miss plus an 8% cost overrun compounds into a 37.5% profit miss. Small variances combine; that is the entire discipline in one table.

Step 2 — Interpret (ask why twice). Revenue: pipeline review shows two enterprise deals slipped to April (timing, recoverable) plus a 3% discount increase sales applied to close quarter-end deals (structural — margin given away permanently). Expenses: $3,000 is a one-off legal bill for a contract review (non-recurring, no action), but $2,000 is contractor spend covering an unfilled support role now in its third month (structural — either hire or permanently budget the contractor).

Step 3 — Act. (a) Sales: discount authority tightened above 5% with manager approval logged; slipped deals get weekly close-plan reviews in April. (b) Hiring: decision this week — fill the role or convert the contractor line to a permanent budget item. (c) Reforecast Q2 revenue down $10k with the two slipped deals moved, not wished back. Each action gets an owner and a date, reviewed at the next close — otherwise this exercise was entertainment.

Fixed vs Variable: Split Before You Judge

A cost center 15% over budget means nothing until you know its nature:

  • Fixed costs (rent, salaries, insurance, software seats): investigate any material variance immediately — fixed means predictable, so misses indicate control failures, not volume effects.
  • Variable costs (COGS, commissions, transaction fees): flex the budget first. If revenue ran 10% light, variable costs should run light; judging them against the static budget manufactures false overruns and hides real per-unit deterioration.
  • Step costs (the trap): support headcount, warehouse space — flat across ranges, then jumping. Most “unexplained” variances live here: volume crossed a step threshold nobody budgeted. Name your step points in the budget assumptions so crossings are anticipated, not discovered.

Interpreting and Reporting: The One-Page Variance Memo

Executives and boards need a one-page memo, not the full workbook. Format that forces thinking:

  1. Headline: net variance vs budget with the two or three drivers that explain most of it.
  2. Per material line: budget, actual, variance ($ and %), one-sentence cause, action + owner + date.
  3. Timing vs structural: label each variance — timing differences reverse next month; structural ones compound until fixed. Never let timing items excuse inaction on structural ones.
  4. Reforecast impact: does the full-year outlook change? By how much, and what decision does that force now?

File the memo with the close binder every month — see Month-End Close — so the audit trail shows management actually using the numbers, which is itself evidence of control operation.

Common Mistakes (and Their Fixes)

Mistake Why it hurts Fix
Reporting three weeks late Findings arrive after decisions are made Hard 5-day deadline; commentary with the close, not after
Investigating everything equally Noise drowns the three lines that matter Thresholds: material and controllable first
Static annual budget, never reforecast By Q3 you are measuring against fiction Quarterly rolling reforecast; keep the original for accountability, manage to the latest
Commentary that restates numbers “Revenue was $10k below budget” adds zero information Require cause + action + owner on every flagged line
Blaming volume for rate problems (and vice versa) Wrong fix, repeated monthly Always split flexible-budget variance before assigning cause
No follow-up tracking Same variances recur forever Carry-forward log: every action reviewed next close until closed

Monthly Reporting Template (Copy This Structure)

Header: period, preparer, reviewer, date issued (target: WD+5). Section 1 — Summary table: revenue, COGS, gross profit, opex by department, operating income, cash position — budget, actual, variance $, variance %, prior-month trend arrow. Section 2 — Material variance notes: only lines breaching thresholds, each with cause, timing-vs-structural label, corrective action, owner, due date. Section 3 — Forecast update: revised full-year outlook, key assumption changes, decisions required this month. Section 4 — Carry-forward tracker: prior actions, status (open/closed), overdue items flagged in red with new dates.

Build it once in your reporting tool or a spreadsheet with formulas locked and inputs clearly marked — then protect the template from well-meaning edits. Consistency across months is what makes trends visible; a reinvented pack every month destroys comparability.

FAQ

Should small businesses do variance analysis monthly or quarterly?

Monthly. Quarterly is post-mortem territory — variances discovered after 90 days are history lessons, not management information. Even a five-line flash report beats a perfect quarterly pack.

Static, flexible, or rolling forecast — which budget should I compare against?

All three, each with a job: static for accountability (what did we commit?), flexible for operational diagnosis (how did we perform at actual volume?), rolling reforecast for decisions (where are we heading?). Never let one replace the others.

What is a good variance threshold to investigate?

There is no universal number — set absolute and percentage gates (e.g., ±10% and ±$5,000) so trivial lines don’t trigger reviews while material small-percentage misses on big lines do. Revisit thresholds annually as the business scales.

Next Steps

  1. Lock investigation thresholds and the one-page memo format before next month-end — publish both, and hold preparers to them.
  2. Run the flexible-budget split on your three largest cost centers this close; you will likely find at least one misdiagnosed variance.
  3. Start the carry-forward tracker now: every corrective action gets an owner and a due date, reviewed at each close until closed.