Budget vs Actual Variance Analysis: A Practical Guide

A budget vs actual variance analysis compares what you planned to earn and spend with what actually happened, line by line, and explains the difference. Many Indian SMBs prepare an annual budget in March, file it away, and look at it again the following March. The budget only earns its keep when it is compared with actuals every month, the significant variances are explained, and someone decides what to do about them. This guide covers how to structure a budget vs actual report, calculate variances correctly, split them into price, volume and mix effects, use cost centres to assign responsibility, and run a monthly review that leads to decisions rather than excuses.

What budget vs actual analysis is for

• Early warning: a 6 percent overrun on power costs in May is easier to fix than a full-year surprise.
• Accountability: each department head owns their numbers.
• Better forecasting: understanding why last year's assumptions failed improves next year's budget.
• Lender and investor communication: banks reviewing CMA projections and investors reviewing plans expect explanations of deviations.

Structuring the budget vs actual report

A useful monthly report has these columns for each line of the P&L (and key balance sheet items such as receivables and inventory):

Line	Budget (month)	Actual (month)	Variance	Variance %	Budget (YTD)	Actual (YTD)	Variance (YTD)	Full-year forecast
Revenue

Two design choices matter:

• Phase the budget monthly using seasonality, not by dividing the annual figure by twelve. A Diwali-heavy business that budgets one-twelfth of sales in October will show meaningless variances.
• Mark favourable and adverse consistently. Higher revenue is favourable; higher cost is adverse. Avoid relying on signs alone, which confuse readers.

Worked example: a monthly P&L variance report

Suppose a hypothetical Nashik packaging manufacturer reviews October:

₹ lakh	Budget	Actual	Variance	Fav / Adv
Revenue	180.0	171.0	9.0	Adverse
Material cost	99.0	98.3	0.7	Favourable
Power and fuel	12.6	13.9	1.3	Adverse
Wages	18.0	18.4	0.4	Adverse
Freight outward	5.4	6.2	0.8	Adverse
Other overheads	14.0	13.1	0.9	Favourable
EBITDA	31.0	21.1	9.9	Adverse

On the surface, material cost looks favourable. But revenue was 5 percent below budget, so material cost should have fallen too. That is why a static comparison is not enough.

Static vs flexible budgets

A static budget compares actuals with the original plan. A flexible budget restates variable costs for the actual level of activity, which isolates efficiency from volume.

In the example, material is budgeted at 55 percent of revenue. At actual revenue of ₹171 lakh, the flexed material budget is ₹94.05 lakh. Actual material was ₹98.3 lakh, so against the flexed budget the variance is ₹4.25 lakh adverse, not ₹0.7 lakh favourable. The real story is a material cost problem hidden by lower sales.

₹ lakh	Static budget	Flexed budget	Actual	Volume effect	Spending or efficiency variance
Revenue	180.0	171.0	171.0	9.0 Adv	0
Material (55%)	99.0	94.05	98.3	4.95 Fav	4.25 Adv
Power (7% variable)	12.6	11.97	13.9	0.63 Fav	1.93 Adv
Freight (3%)	5.4	5.13	6.2	0.27 Fav	1.07 Adv

Splitting sales variance: price, volume and mix

A revenue shortfall can come from selling fewer units, selling at lower prices, or selling a different mix of products. Separating them points to different actions.

• Sales price variance = (Actual price minus Budget price) x Actual quantity.
• Sales volume variance = (Actual quantity minus Budget quantity) x Budget price (or budget margin, for profit analysis).

Example

Budget: 6,00,000 cartons at ₹30 = ₹180 lakh. Actual: 5,85,000 cartons at ₹29.23 = ₹171 lakh.

• Price variance = (29.23 minus 30) x 5,85,000 = about ₹4.5 lakh adverse.
• Volume variance = (5,85,000 minus 6,00,000) x 30 = ₹4.5 lakh adverse.

Half the shortfall is lower prices (perhaps discounts to win orders), half is lower volume. When there are multiple products with different margins, a mix variance shows whether the business sold more of its low-margin products than planned, even if total units matched.

Cost variances: price and usage

For materials, split the spending variance into:

• Material price variance = (Actual price minus Standard price) x Actual quantity purchased or used.
• Material usage variance = (Actual quantity used minus Standard quantity for actual output) x Standard price.

Suppose kraft paper was budgeted at ₹42 per kg and 0.36 kg per carton. For 5,85,000 cartons, standard usage is 2,10,600 kg. Actual usage was 2,16,000 kg at ₹42.50 per kg.

• Price variance = (42.50 minus 42) x 2,16,000 = ₹1.08 lakh adverse.
• Usage variance = (2,16,000 minus 2,10,600) x 42 = ₹2.27 lakh adverse.

Paper price rose, but higher wastage cost even more. The purchase team cannot fix the usage variance; production must look at trim waste and rejections. Product costing at standard is covered in our guide to product costing in manufacturing.

Using cost centres to assign responsibility

Budgets work when each line has an owner. Tag every expense to a cost centre (production, maintenance, sales, logistics, administration) and every revenue line to a business unit or product line. The cost centre head reviews their own budget vs actual and explains variances. Fininvo's accounting module includes budgets and cost centres, which allows this comparison directly from posted transactions rather than a spreadsheet rebuild each month.

Setting materiality thresholds

Not every variance deserves discussion. Set thresholds so the monthly review focuses on what matters, for example:

• Explain any line with a variance above 5 percent and above ₹1 lakh for the month.
• Explain any YTD variance above 3 percent and above ₹5 lakh.
• Always explain revenue, gross margin, and the top three cost lines.

Running the monthly variance review

1. Close the books by working day 5 to 7, so the review is about last month, not two months ago.
2. Finance prepares the report with flexed budget and variance splits.
3. Each owner writes a one-line explanation and an action for variances above threshold.
4. A 60-minute review meeting with the owner or CEO focuses on actions, not narratives.
5. Update the full-year forecast based on what has been learnt.
6. Track actions to closure the next month.

Building a budget that is worth comparing against

Variance analysis is only as good as the budget. A driver-based budget, built from operational assumptions rather than last year plus 10 percent, makes variances explainable:

1. Sales drivers: volume by product or customer group, price, discounts, and seasonality by month.
2. Material drivers: BOM quantities, expected material prices, scrap rates.
3. Capacity drivers: machine hours and shifts needed for the volume, which determine power, wages and maintenance.
4. People drivers: headcount plan by department with salary revisions and joining dates.
5. Fixed costs: rent, insurance, AMC contracts, listed individually with their timing.
6. Working capital drivers: receivable, inventory and payable days, which turn the P&L budget into a cash budget.

When a variance appears, you can trace it to the driver that moved. A power cost overrun can then be split into more machine hours (volume), a higher tariff (price) or more kWh per hour (efficiency), each owned by a different person.

Beyond the P&L: balance sheet and cash variances

Profit variances get most attention, but cash variances hurt more. Add a short section to the monthly report comparing budgeted and actual:

Item	Budget	Actual	Comment
Receivable days	60	71	Two OEM customers paying late; escalation planned
Inventory days	40	46	Paper bought ahead of expected price increase
Payable days	45	42	MSME suppliers paid within 45 days as required
Capex (YTD, ₹ lakh)	60	38	Corrugator upgrade deferred to Q4

A business can meet its profit budget and still breach its bank limit if receivable and inventory days drift. Reviewing both together keeps the conversation honest.

Common budgeting and variance mistakes

• Annual budget divided by twelve instead of phased by season.
• Only static comparison, hiding efficiency problems behind volume changes.
• Explaining instead of acting: "raw material prices increased" is a description, not a plan.
• Budgets prepared only by finance, so department heads do not own them.
• Accruals missing: expenses not provided for in the month create false favourable variances followed by adverse ones.
• Never revising the forecast, so year-end surprises are inevitable.

Frequently Asked Questions

What is budget vs actual analysis?

It is the comparison of planned income and expenses with actual results for a period, calculating and explaining the differences so that management can take corrective action.

What is a favourable variance?

A variance that improves profit compared with budget: revenue higher than budget, or costs lower than budget. Always check whether a favourable cost variance is simply caused by lower activity.

What is the difference between a budget and a forecast?

The budget is the fixed plan approved at the start of the year. The forecast is an updated estimate of the full-year outcome, revised during the year as results come in.

How often should variance analysis be done?

Monthly for most businesses, with weekly tracking of a few key indicators such as sales, collections and production output.

Can variance analysis be done in Excel?

Yes, but it depends on exporting actuals each month and mapping them to budget lines. Systems that hold budgets and cost centres alongside the ledger reduce this effort and the risk of mapping errors.

How Fininvo Helps

Fininvo ERP keeps budgets, cost centres and the general ledger together, with financial reports and comparative analysis available on demand. Explore accounting, reports and pricing.