Comerze › Blogs › Finance Careers

Budget vs Forecast: How Variance Analysis Works

A budget is a plan. A forecast is the latest view. The gap between actuals and either one is a question to answer.

By Comerze DeskUpdated 18 November4 min read

Reviewed by Comerze Desk

Budget and forecast

  • Budget: set once, used to judge performance against the plan
  • Forecast: revised regularly, used to decide what to do next

A worked variance table

A company budgeted sales of Rs 50,00,000 and material cost of Rs 30,00,000 for the month. The actuals were Rs 46,00,000 and Rs 29,00,000.

LineBudget (Rs)Actual (Rs)Variance (Rs)Type
Sales50,00,00046,00,000(4,00,000)Adverse
Material cost30,00,00029,00,0001,00,000Favourable

Lower sales are adverse. Lower material cost looks favourable, but part of it is simply the result of selling less. A useful note separates the effect of volume from the effect of price.

What a good variance note contains

  1. The numberState the variance and whether it is favourable or adverse.
  2. The causeVolume, price, mix or timing.
  3. The impactWhat it means for the year, not only the month.
  4. The actionWho will do what.

Common mistakes

  • Reporting the variance without explaining it
  • Treating every favourable variance as good news
  • Comparing different definitions of a line item
  • Ignoring timing differences that will reverse next month
Pro tipAsk the owner of the line

The person who runs the activity usually knows the real reason faster than the ledger does.

FAQs

What is a rolling forecast?

A forecast that always looks a fixed number of months ahead and is extended as each month closes.

Is a favourable variance always good?

No. A lower cost can mean lower activity or a quality compromise.

Which tool is used?

Most teams use spreadsheets, and larger firms use planning software connected to the accounting system.

Keep reading

Tools & courses for CA studentsMarketplace