Budget Variance Analysis

Accounts Receivable Dictionary

What is budget variance analysis?

Budget variance analysis is the process of comparing actual financial results against budgeted figures to measure the gap, called the variance, and understand why it happened. It is run line by line across revenue and costs, turning a vague sense that results were off into a specific, explainable number. The point is not the gap itself but the reason behind it.

It is one of the most practical tools in finance because it closes the loop between planning and reality. A budget is a forecast; variance analysis is the scorecard that tells you how good that forecast was and where the business is drifting from plan, early enough to act. Without it, a budget is just a document filed in January and forgotten. With it, every month becomes a chance to catch a problem while it is still small and to make the next forecast sharper than the last.

Key takeaways

Actual minus budget.The variance is the difference between what you planned and what actually happened, by line item.

Favourable or unfavourable.A variance helps profit (favourable) or hurts it (unfavourable). Direction depends on whether it is revenue or cost.

The why is the value.The number flags the issue; the explanation behind it drives the decision.

How to calculate a budget variance

A budget variance is actual minus budget for any line, and the percentage variance is that difference divided by the budgeted amount. The absolute number tells you the size of the miss in money; the percentage tells you how material it is relative to plan. Enter your figures to see both, along with whether the result is favourable or unfavourable.

Your figures

$
$

Defaults show revenue coming in 5,000 under budget. General information, not financial advice.

Budget$50,000
Actual$45,000
Variance percentage10.0%
Variance-$5,000Unfavourable

Two short examples make the direction clear. If you budgeted 50,000 in sales and earned 45,000, that is a 5,000 unfavourable revenue variance: you brought in less than planned. If you budgeted 20,000 for wages and spent 18,000, that is a 2,000 favourable cost variance: you spent less than planned. The arithmetic is identical; what flips is whether less is good or bad.

The percentage is what tells you whether to care. A 5,000 variance on a 50,000 budget is 10%, which is material and worth investigating. The same 5,000 variance on a 5 million budget is 0.1%, which is noise. Always read the variance and the percentage together: the dollar figure sizes the impact on cash and profit, while the percentage tells you how far results have drifted from the plan in proportional terms. Reporting both is what separates a useful variance report from a wall of numbers.

Favourable vs unfavourable variances

A favourable variance improves profit compared with the budget, and an unfavourable variance reduces it. The trap is assuming a higher actual is always good. It depends on the line. For revenue, actual above budget is favourable. For costs, actual above budget is unfavourable. So the same direction of movement means opposite things depending on which side of the profit equation you are on.

Just as important: favourable is not automatically good news. Sales above budget might come from unplanned discounting that crushed margin, and costs below budget might mean you underspent on something that mattered, like collections effort or marketing. This is why every meaningful variance gets a reason attached, not just a label. A margin analysis is often the next step when a revenue variance looks favourable but profit has not moved with it.

Types of budget variance

Variances are usually grouped by where they sit in the accounts, which makes them faster to investigate. Separating price from volume is especially powerful, because a cost overrun caused by a supplier raising prices needs a very different response from one caused by simply using more.

Revenue or sales varianceThe gap between budgeted and actual income, the first place most teams look.

Cost or expense varianceThe gap on spending lines, where actual above budget is unfavourable.

Price varianceYou paid a different rate than planned, often pointing back to procurement.

Volume or quantity varianceYou used a different amount than planned, pointing back to operations.

A quick illustration shows why the split matters. You budgeted 10,000 units of materials at 2 each, or 20,000, but actually bought 11,000 units at 2.10, or 23,100. The 3,100 overrun is not one problem but two. Roughly 1,000 of it is volume (the extra 1,000 units) and roughly 1,100 is price (the 0.10 increase across the units). Knowing the split tells you whether to talk to procurement about the rate or to operations about usage. A single 3,100 figure would hide that entirely.

The variance that matters most for AR

For accounts receivable teams, the variances that bite hardest are usually on the collections side: actual cash collected versus the amount the budget assumed would be in by now. A shortfall there is an early warning that DSO is stretching or that bad debt is rising, well before it shows up elsewhere. A price variance on a cost line means renegotiating with a supplier; a collections variance means tightening terms or chasing harder. Lumping them into a single number tells you something is wrong but not what to do about it.

Why budget variance analysis matters for accounts receivable

For AR, the most revealing variance is between forecast collections and actual cash received, because it exposes problems that a profit-focused budget can hide. A business can hit its revenue budget on paper while badly missing its cash budget, simply because customers are paying slowly. Variance analysis is what surfaces that gap.

When collections come in under budget, the analysis points you straight at the cause: terms that are too loose, reminders going out too late, or a few large overdue accounts dragging the total. Tracking it against live accounts receivable reporting turns a monthly surprise into a running signal, and watching days sales outstanding alongside it tells you whether a collections variance is a one-off or a trend. Feeding actuals back into a rolling forecast then keeps the next period's budget honest.

Common budget variance analysis mistakes

The biggest mistake is stopping at the number: a variance with no explanation is just trivia. The value is entirely in the reason and the action it prompts. The traps below are the ones that most often turn a variance review into busywork rather than insight.

Traps to avoid

Chasing every tiny varianceSet a materiality threshold by dollar or percentage and investigate only what clears it.

Comparing against a stale budgetA budget never updated for known changes guarantees large but meaningless variances.

Treating every favourable variance as a winCheck how it arose: discounting or underspend can flatter the number while hurting the business.

Mistaking timing for performanceA cost booked a month early shows unfavourable now and favourable later, with nothing actually wrong.

The discipline that fixes all of these is the same: investigate the material variances, explain the cause, and feed what you learn back into the next forecast. Done that way, budget variance analysis stops being a monthly autopsy and becomes a steering signal.

Frequently asked questions
What is budget variance analysis?
Budget variance analysis is the process of comparing actual financial results against budgeted figures to measure the gap, called the variance, and understand why it happened. It is done line by line across revenue and costs so a business can see where it is drifting from plan and act on it.
What is the budget variance formula?
Budget variance equals actual minus budget for any line. The percentage variance equals that difference divided by the budgeted amount, multiplied by 100. For example, a budget of 50,000 and an actual of 45,000 gives a variance of minus 5,000, or 10%.
What is the difference between a favourable and unfavourable variance?
A favourable variance improves profit versus budget, and an unfavourable variance reduces it. For revenue, an actual above budget is favourable. For costs, an actual above budget is unfavourable. The same direction of movement means opposite things depending on whether the line is income or expense.
How often should you do budget variance analysis?
Most businesses run budget variance analysis monthly, after the books are closed, and review larger variances quarterly. Cash and collections variances are often watched more frequently, even weekly, because they affect liquidity sooner than profit-based lines.
How does budget variance analysis relate to accounts receivable?
The key AR variance compares forecast collections with actual cash received. A shortfall signals slowing payments, loose terms or rising bad debt, often before it appears elsewhere. Watching it alongside days sales outstanding shows whether the gap is a one-off or a trend.
Keep reading

Are you making these
5 invoicing mistakes?

Don't let these critical mistakes hurt your
collections - See how to fix them, today!