Home / Guides / Budget against actual variances explained

Budget against actual variances explained

A variance is the difference between what the business did in a month and what the budget said it would do. Each month you set the actual figure for every line of the profit and loss account next to its budget, work out the difference in pounds and as a percentage, and explain the differences large enough to change the year's profit.

Setting out the comparison

Use the same layout every month, with one row for each line of the profit and loss account and these columns:

  • Budget for the month, taken from the annual budget and left unchanged during the year
  • Actual for the month, from the management accounts once the month is closed
  • Variance in pounds, actual less budget
  • Variance as a percentage of the budget figure
  • Year to date, the same three figures added up from the first month of the year

The month shows what has just happened. The year to date shows whether it is a pattern. A month of low sales after three good months may leave the year on budget, and a small overspend repeated every month adds up to a large one by the year end.

If you have not yet set a budget, the guide on how to set an annual budget goes through it in six steps.

Favourable and adverse variances

A favourable variance improves profit against the budget. Sales above budget and costs below budget are favourable. An adverse variance reduces profit: sales below budget, or costs above it. Mark each one F or A, or show adverse figures in brackets, so the direction is clear without having to think about whether the line is income or a cost.

A favourable cost variance needs checking before you take it as good news. A supplier invoice that has not been posted, a pay rise that starts later than planned or a repair put off until next month will all show as a saving this month and an overspend later. A close that includes accruals for bills not yet received removes most of these. The month-end close checklist covers accruals.

Price and volume

A sales variance has two causes: you sold a different quantity from the budget, or you sold at a different price. Splitting the two tells you what to do next. A volume shortfall points at enquiries, quotes and capacity. A price shortfall points at discounts, the mix of customers and the prices on your quotes.

Sales variance split into volume and price

Budget: 400 units at £50£20,000
Actual: 360 units at £55£19,800
Volume variance: 40 fewer units at the budget price of £50−£2,000 A
Price variance: £5 more on each of the 360 units sold+£1,800 F
Total sales variance−£200 A

An example on invented round numbers.

The total looks small, and it hides two large movements in opposite directions. The price rise held the sales figure up while 10% fewer units were sold. The guide on what a price rise does to profit shows how to test whether a rise like that leaves you better off.

The same split works for direct costs. A materials variance is either a usage variance (more or less material per job than budgeted) or a price variance (a different cost per unit from the supplier). Labour splits the same way into hours worked and the rate paid.

A worked month

Take a business that budgeted £80,000 of sales in the month at a 45% gross margin, with £25,000 of overheads and £11,000 of net profit. Its actual sales were £76,000 at a 43% margin, and overheads came to £26,100, leaving £6,580 of profit. The £4,420 shortfall breaks down into three parts.

Where the month's profit went

Budgeted net profit£11,000
Sales £4,000 below budget, at the budgeted 45% margin−£1,800
Margin of 43% against 45%, on £76,000 of sales−£1,520
Overheads £1,100 above budget−£1,100
Actual net profit£6,580

An example on invented round numbers.

Each part has its own question. For the sales, whether the shortfall is volume or price, and whether next month's orders are already lower. For the margin, which jobs, products or customers came in below 45%, and whether material prices or extra hours caused it. For the overheads, which line moved, and whether it was a one-off or will repeat. The guide to gross margin covers how to find the line of work pulling the margin down.

Which variances to act on

Agree a threshold before the year starts, so the review goes straight to the lines that matter. A common rule is to explain any variance over a set sum, such as £1,000, or over 10% of the budget line, and to leave smaller ones alone unless they repeat. Then sort each one into one of four kinds:

  • Timing: the cost or sale has moved to another month and the year is unaffected. Note it and check it reverses.
  • One-off: a repair, a lost order or a single large sale. Note the cause and leave the forecast as it is.
  • Continuing: a supplier price rise, a lost customer or a new hire. Update the forecast for the rest of the year and decide what to do about it.
  • Error: a cost posted to the wrong line or the wrong month. Correct it in the accounts before the figures go to anyone else.

Continuing variances are the ones that change the year. A 2% fall in margin on £900,000 of annual sales costs £18,000 of profit over the year, and it is far easier to deal with in month three than in month eleven.

A flexed budget

When sales are well above or below budget, every variable cost moves with them, and a straight comparison shows large cost variances that only reflect the change in volume. A flexed budget restates the budget at the actual level of sales. Variable costs are recalculated at the budgeted percentage of actual sales, and fixed costs stay at their original budget.

In the worked month above, a flexed budget at £76,000 of sales would allow £41,800 of direct costs at 55%. Actual direct costs were £43,320, so the true cost overspend was £1,520, the same figure as the margin variance. Without the flex, direct costs look £680 under budget, which reads as a saving when the business spent more on each pound of sales than it planned to.

The balance sheet and cash

Profit is only part of the review. Compare the bank balance at the month end with the cash flow forecast, and look at the balance sheet lines that hold cash:

  • Debtors: the amount customers owe against the forecast, and debtor days against your target
  • Stock and work in progress: whether more cash is tied up than planned
  • Creditors: whether suppliers are being paid later than agreed to make the bank balance look better
  • VAT, PAYE and Corporation Tax: the amounts owed, set against the money put aside for them

A month can be on budget for profit and well behind on cash, if customers paid late or stock was bought early. The debtor days calculator works out how much cash late payment is holding back.

Writing up the review

For each variance you act on, write one line: what caused it, what you will do, who will do it and by when. Check the list at the start of the next month's review. The budget stays fixed for the year so the comparison stays fair, and the forecast is updated each month with what you now expect. The management accounts page shows what goes into each month's pack.

Business Pulse

Business Pulse sets your budget for the year, produces management accounts against it and goes through the variances with you in a review meeting. It costs £375 + VAT a month with quarterly reviews, or £499 + VAT a month with monthly reviews, on top of your accounts fee.

Questions

What is a budget variance?

A budget variance is the difference between the actual figure for a line of the profit and loss account and the figure in the budget for the same period. It is shown in pounds and as a percentage of the budget. A variance that improves profit, such as higher sales or lower costs, is favourable. One that reduces profit is adverse. Variances are checked each month when the management accounts are produced. Set the month and the year to date side by side, so a one-off can be told apart from a pattern. In an example month with £80,000 of budgeted sales and £11,000 of budgeted profit, actual profit of £6,580 gives an adverse variance of £4,420, which splits into lower sales, a lower margin and higher overheads. The management accounts page shows what goes into each month's pack.

What is the difference between a favourable and an adverse variance?

A favourable variance leaves profit higher than the budget, and an adverse variance leaves it lower. Sales above budget and costs below budget are favourable. Sales below budget and costs above budget are adverse. A favourable cost variance can be a timing difference, such as a bill that has not yet been posted, so check it before treating it as a saving. Mark each one F or A, or show adverse figures in brackets, so the direction is clear on every line. A supplier invoice that has not been posted, a pay rise that starts later than planned or a repair put off until next month will all show as a saving this month and an overspend later. Posting accruals for bills not yet received at the month end removes most of these, and the month-end close checklist covers how.

How do you calculate a sales price variance and a volume variance?

The volume variance is the difference between actual and budgeted units, multiplied by the budgeted price. The price variance is the difference between the actual and budgeted price, multiplied by the actual units sold. Added together they equal the total sales variance. Selling 360 units at £55 against a budget of 400 at £50 gives a £2,000 adverse volume variance and a £1,800 favourable price variance. In that example the total sales variance is only £200 adverse, and it hides two large movements in opposite directions: the price rise held sales up while 10% fewer units were sold. A volume shortfall points at enquiries, quotes and capacity, and a price shortfall points at discounts, customer mix and the prices on your quotes. Direct costs split the same way, into usage and price for materials, and hours and rate for labour.

Which variances should a small business investigate?

Investigate any variance above a threshold you set before the year starts, such as £1,000 or 10% of the budget line, and any smaller variance that repeats for several months. Sort each one into timing, one-off, continuing or error. Continuing variances, such as a supplier price rise or a lost customer, need the forecast updating and a decision on what to do. Continuing variances are the ones that change the year: a 2% fall in margin on £900,000 of annual sales costs £18,000 of profit over the year. For each variance you act on, write one line saying what caused it, what you will do, who will do it and by when, and check the list at the start of the next month's review.

Should you change the budget during the year?

Keep the budget fixed for the year and update the forecast each month with what you now expect for the rest of the year. The budget is the plan you are measured against, so changing it removes the comparison. If sales move a long way from the plan, a flexed budget restates costs at the actual sales level for a fairer comparison. In the worked example, sales of £76,000 against a budget of £80,000 flex the direct cost allowance to £41,800 at 55%. Actual direct costs of £43,320 then show a true overspend of £1,520, where the unflexed comparison shows a £680 saving. Business Pulse sets the budget, reports against it and reviews the variances with you, for £375 + VAT a month with quarterly reviews or £499 + VAT a month with monthly reviews, on top of your accounts fee.

Sample monthly board pack

Six pages for one month at an invented catering wholesaler with 18 staff, prepared the way the finance team prepares one for a client.

  1. 1Summary
  2. 2Profit and loss
  3. 3Balance sheet
  4. 4Cash
  5. 5Customers and suppliers
  6. 6Commentary

Get the sample pack

Six pages, PDF.

More guides

Management accounts explained

The contents of a monthly management pack, and how to read it.

KPIs to check every month in a small business

The KPIs an owner-managed business checks each month, how to set targets, leading and lagging measures, and a worked monthly KPI sheet.

Sample board pack

A six-page monthly board pack to download.

Gross margin explained

What gross margin is, how it differs from mark-up, how to calculate it, what moves it and why to check it monthly, with a worked example of the confusion.

Working capital explained

What working capital is, how to calculate it from a balance sheet, the working capital cycle in days, why growth uses cash, and a worked example.

What management accounts cost and include

Management accounts from £375 a month quarterly or £499 monthly + VAT: what a monthly set contains, what the owner provides and when it should arrive.

Management accounts for a construction company

Management accounts for builders and contractors: work in progress, retentions, CIS deductions, the VAT reverse charge and margin by contract.

Setting up monthly management reports in Xero

How to set up monthly management reports in Xero: the ledger work first, then the Management Report pack, budget variance, tracking and commentary.

The 13-week cash flow forecast

How to build a 13-week cash flow forecast, update it every Monday and act on it, with payroll, PAYE, VAT and Corporation Tax in the right weeks.

Month-end close for a small business

How to close the books by working day 10: the reconciliations, accruals and prepayments, the review, and what the management accounts should show.

Debtor control and getting paid faster

Payment terms, invoicing, a chase sequence by day, debtor days, and statutory late payment interest and compensation at the rates on GOV.UK today.

The monthly KPI pack and board pack

The 8 to 12 numbers an owner-managed business should see every month, how to read them, and what a monthly board pack contains, with a worked example.

13-week cash flow forecast template

A free Excel template for the next 13 weeks of receipts, payments and bank balance.

Cash flow forecasting

How to build a 12-month forecast and keep it up to date.

How to read a cash flow forecast

What each line means and where a tight month shows up.

Why a profitable business runs out of cash

Profit is counted when you invoice and cash moves when you are paid. Where the difference goes, how much cash you need, and ways to release it.

How to reduce debtor days

How to work out debtor days, the steps that bring them down, from payment terms to a weekly chasing routine, and the cash a lower figure releases.

Charging interest on late payments

Statutory interest at 8% above base rate, the fixed sums of £40, £70 and £100, when the late payment law applies, how to claim and how to word your terms.

Setting aside money for VAT, PAYE and Corporation Tax

When VAT, PAYE and Corporation Tax are due, how to work out what to move to a tax account each month, and a worked example for a limited company.

CIS deductions and a builder's cash flow

How CIS deductions of 20%, 30% or nothing reduce what a subcontractor banks on each invoice, HMRC deadlines, and gross payment status.

Outsourced credit control and how it works

What an outsourced credit controller does each week, how it runs in your Xero, what it costs against employing one, and the cash it releases.

Cash flow forecasting in Xero

What Xero's short-term cash flow projection shows, what it leaves out, and how to keep a 13-week or 12-month forecast alongside Xero.

How to price for profit

What a price change does to profit, worked through.

Turnover up, profit down

Why sales can rise while profit falls, and where to look.

How to set an annual budget for your business

Six steps to next year's budget, a month-by-month worked example, seasonality, wage rises from April 2026, and reforecasting during the year.

Break-even point explained

How to work out break-even in sales and in units from fixed costs, variable costs and contribution margin, with a worked example and the margin of safety.

What a price rise does to profit

How a small price rise flows straight to profit, how many customers you could lose and still be better off, and how much more you must sell after a discount.

Job costing for small businesses

How to cost each job with materials, labour at a loaded hourly rate, subcontractors and overheads, compare quoted with actual, and value work in progress.

What does a part-time finance director do?

What a part-time or fractional finance director does, the first three months, how it differs from a financial controller, and what one costs.

Finance manager or financial controller?

What a finance manager does, what a financial controller adds, the month-end close, deadlines, how to choose, and what each costs to employ or outsource.

Month-end close checklist

The steps to close the books within five working days: bank, ledgers, accruals, prepayments, payroll, VAT, stock, fixed assets and a final review.

In-house or outsourced bookkeeper?

What employing a bookkeeper costs once National Insurance, pension and holiday cover are added, what an outsourced service covers, and how to switch.

How to run a monthly board meeting

Who attends a board meeting in an owner-managed company, what goes in the board pack, a standard agenda, the decisions and actions log, and the minutes.

Replacing a bookkeeper who has left

Keeping payroll, VAT and the books running when your bookkeeper goes.

The cost of employing a financial controller

What a finance manager, financial controller and finance director cost to employ in 2026 to 2027, with National Insurance and pension, against Buzz fees.

How much a part-time finance director costs

A part-time finance director from Buzz costs £2,000 + VAT a month with the finance team included, against £128,508.40 a year to employ one.

Fractional CFO, part-time FD or interim FD

What a fractional CFO, a part-time finance director, an outsourced CFO and an interim FD each are, and how to choose one for your business.

What a bank wants to see in a business plan

What a lender reads in a business plan: the amount and purpose, ability to repay, forecasts, assumptions, security, guarantees and the people running it.

Talk to us

Tell us about the business and what is taking up your week, or book 30 minutes with Peter. He will come back within 48 hours with the level that fits and a fixed monthly fee.

Book a call

Or call

07476 989568

Accreditations and partners

AAT Licensed Accountant
ICPA
FreeAgent Partner
Equity & General
All In Place
Xero Gold Partner
Swoop
The Gap
Institute of Advisors