Budget vs Actual Variance Analysis: Formulas, Example Report and Commentary

Budget vs actual variance analysis compares what you planned with what happened, line by line, and explains the difference. The variance is actual minus budget. It is favourable when it raises profit (more revenue or less cost than planned) and unfavourable when it lowers profit. The useful part is not the number but the explanation: price, volume, mix, timing or a real overspend.

This guide gives the formulas, a materiality rule for deciding which variances to investigate, a worked example for a services company with a price, mix and volume breakdown, a monthly report layout, a commentary template and a note on rolling forecasts. The last part shows how Ledgeriano produces the report from posted entries. For the wider toolkit (master budgets, break-even, segment reporting) see the management accounting guide.

#At a glance

#What is budget vs actual variance analysis?

Budget vs actual (often shortened to BvA) is a report that places the budget and the actual result for the same period side by side, shows the difference in currency and as a percentage, and labels each difference favourable or unfavourable. Variance analysis is the work that follows: splitting each material difference into its causes and deciding what to do.

Definition: A budget variance is the difference between an actual result and the budgeted amount for the same line and period. It is favourable when it increases profit and unfavourable when it reduces profit.

The report is only as good as its inputs. The budget must be set by month (not as an annual total divided by twelve when the business is seasonal), on the same accounts and cost centers as the books, and the actuals must come from a closed period.

#How do you calculate a budget variance?

Three formulas cover nearly every report:

Some teams prefer to show every favourable variance as a positive number, whatever the line. That reads well on revenue and cost lines alike, but it breaks the simple rule "actual minus budget". Pick one convention, state it at the top of the report and keep it.

#Is a favourable variance always good?

No. A favourable variance only means profit is higher than planned on that line. Lower maintenance spending can mean a machine was not serviced; lower marketing spending can mean a campaign slipped to next month and the cost will arrive later. Every material variance, favourable or not, needs an explanation.

#Static budget vs flexible budget

A static budget is fixed at the planned activity level. A flexible budget keeps fixed costs as planned and recalculates variable costs for the activity actually achieved. Comparing actual with the flexible budget separates two questions that a static report mixes together:

• Activity (volume) variance = flexible budget - static budget. Did we do more or less work than planned?
• Spending (flexible budget) variance = actual - flexible budget. Given the work we did, did we spend more or less than we should have?

A flexible budget needs cost behaviour. Classify each expense account as fixed, variable or mixed before you rely on it; the break-even analysis guide explains the same split from the profit side.

#Worked example: an engineering services firm

A 30-person engineering consultancy bills two grades of staff by the hour. Amounts are in USD. This is the March budget and the March result, after the books were closed.

Revenue drivers

Budget vs actual for March

At first glance March went to plan: profit beat budget by 550. The detail says otherwise.

#Step 1: apply a materiality rule

Investigating every line wastes time. A common rule is to investigate a variance when it exceeds both a percentage of budget and a fixed amount. Here the firm uses 5% and 2,000:

Revenue is the exception that proves the rule: a small total variance can hide large offsetting ones. Revenue lines deserve a driver breakdown every month.

#Step 2: split the revenue variance into price, mix and volume

For a business that sells hours, units or contracts at different prices, the revenue variance has three parts:

The firm billed 200 more hours than planned (worth 21,250), and its rates held up (550). But the work shifted from senior engineers to technicians, and that mix shift cost 15,750. Senior engineers lost 150 billable hours: were they on unbilled proposals, training, or doing technician work?

#Step 3: flex the variable costs

Subcontractors are budgeted at 10.00 per technician hour and travel at 5.00 per billable hour. Flexing for actual activity:

Of the 7,500 subcontractor overrun, 3,500 is explained by the extra technician hours. The other 4,000 is real overspending, worth a question about rates or about work outsourced that staff could have done. Travel, which looked slightly favourable on the static report, is in fact 1,900 better than it should have been for the work done.

#Step 4: classify fixed cost variances as timing or permanent

• Software licences, 2,400 U. An annual renewal fell in March instead of April. Timing: no change to the full-year forecast.
• Marketing, 5,500 F. A trade show booth was postponed to May. Timing: the cost will come later; the favourable variance is not a saving.
• Salaries, 2,000 U. Overtime during a deadline week. Below the threshold; note it and watch the trend.

#How should a monthly budget vs actual report be laid out?

A report that managers read has the same shape every month. One layout that works:

Put subtotals (gross profit, operating profit, net profit) in bold, show the materiality rule in the header, and keep the commentary next to the numbers rather than in a separate document.

#A commentary template for each material variance

Good commentary answers five questions in two or three sentences:

1. What happened? "Subcontractor costs were 7,500 (37.5%) over budget."
2. Why? "3,500 came from 350 extra technician hours; 4,000 from a higher day rate on the Harbour Road project."
3. Timing or permanent? "Permanent for this project."
4. What are we doing? "Rates renegotiated from April; the project manager to approve any new subcontract."
5. Effect on the forecast? "Full-year subcontractor forecast raised by 9,000."

Avoid commentary that restates the number ("costs were higher than budget") or blames the budget ("the budget was unrealistic") without saying what changes.

#Budgets, forecasts and rolling forecasts

A budget is a target set before the year and usually approved; it should not be changed every month, or variances lose their meaning. A forecast is the current best estimate of where the year will land. Many teams keep both: the approved budget for measuring performance and a reforecast (for example "3 + 9": three months of actuals plus nine months of updated estimates) for planning cash and hiring.

A rolling forecast always looks the same distance ahead, typically 12 months or the next four quarters, adding a new month as each one closes. It suits businesses whose plans change faster than an annual cycle. It does not replace the variance discipline: you still compare each closed month with what you expected and explain the differences.

#Common budget vs actual mistakes

1. Spreading an annual budget evenly in a seasonal business, which produces large "variances" that are only seasonality.
2. Comparing with a static budget only, so volume hides spending problems.
3. Treating timing differences as savings. A postponed cost is not a saved cost.
4. Investigating everything. Without a threshold, the important variances get the same attention as the trivial ones.
5. Using actuals from an open period. Late invoices and accruals change the picture; run the report after the close.
6. Budgeting on different accounts from the books. If the budget uses a "general overheads" line that the ledger does not have, actuals cannot be matched.
7. Rewriting the budget mid-year. Keep the approved budget and track changes in a forecast.

#How Ledgeriano does budget vs actual

Ledgeriano's budgeting reads actual figures straight from your posted journal entries, so there is no export and no copy and paste. It is available to every business, in the dashboard and through the accounting API.

• Budgets. Each budget belongs to a fiscal year and holds monthly amounts by account, cost center and project. Months follow the business's own fiscal year, whichever month it starts in.
• Building the numbers. Spread an annual total evenly or by a seasonality profile, copy a previous year's actuals month by month with a growth percentage, copy another budget with a percentage change, or duplicate a budget into another scenario or year.
• Scenarios and approval. Budgets carry a scenario (base, optimistic, pessimistic or your own name). A budget moves from draft to approved, which locks its lines, and one approved budget per fiscal year is the default. A reforecast can sit next to the approved budget as another scenario.
• Budget vs actual report. Lines are grouped into income statement sections (revenue, cost of sales, operating expenses, other income and expenses, tax) with section totals, operating profit and net profit. Each line shows budget, actual, variance, variance % and a favourable or unfavourable flag. View it by account, cost center, project or as a monthly matrix, and filter by cost center, project or account type. Actuals are posted movements, excluding closing entries.
• Flexible budget. The activity measure is revenue or, when the inventory module is on, units sold. Each line is flexed using the account's cost behaviour (fixed, variable, or mixed with a variable percentage), and the report shows the static budget, the sales-volume variance, the flexible budget, the spending variance and actual, with contribution margin lines. A firm that sells hours, like the example above, would flex on revenue.
• Access. Viewing management reports and managing budgets are separate permissions, so a department head can read the variance report without editing the budget.

The management accounting guide shows the master budget and the other analyses, and the features page has the overview.