Budgeting

Favourable or adverse variance: which sign means trouble?

For spending lines a positive variance is adverse, for savings and income it is favourable. See six categories and when under budget signals a missed goal.

Editorial illustration for Favourable or adverse variance: which sign means trouble?

Whether a variance is good or bad depends on the kind of line. For a spending line, spending more than budget is adverse and spending less is favourable. For a savings or income line it is the reverse: more than planned is favourable and less is adverse. The sign alone, plus or minus, does not tell you which one you are looking at.

What is a variance, and why does the sign confuse people?

Variance is the gap between what you planned and what happened. If you calculate it as actual minus budget, an expense that ran over shows as a positive number, which looks like good news but is not. A savings transfer that fell short shows as a negative number, which looks like a reduction in spending but is really a shortfall. The words favourable and adverse remove that confusion: favourable means the result helped your plan, adverse means it hurt it.

Conventions differ between textbooks and tools, so write down your own at the top of your sheet. Here it is: variance equals actual minus budget, and favourable or adverse is decided by the type of line.

Which sign is trouble for which line?

Line typeActual above budgetActual below budget
Spending (groceries, rent, travel)AdverseFavourable, usually
Savings transfersFavourableAdverse
Income (salary, freelance)FavourableAdverse
Planned one-off spendingAdverseCheck whether it is just delayed

How does it work on six real-looking lines?

Say these are one month's figures, with made-up numbers.

CategoryTypeBudgetActualVariance (actual minus budget)Reading
GroceriesSpend₹12,000₹13,500+₹1,500Adverse
Dining outSpend₹5,000₹3,200-₹1,800Favourable
ElectricitySpend₹2,400₹2,900+₹500Adverse
Online course feeSpend₹2,500₹0-₹2,500Under budget, but check
Savings transferSavings₹15,000₹9,000-₹6,000Adverse
Freelance incomeIncome₹8,000₹9,500+₹1,500Favourable

Dining out under by ₹1,800 is a genuine saving. The course fee under by ₹2,500 is not necessarily a saving: if the course is still planned, the money is just late. And the savings transfer short by ₹6,000 is the most serious line on the sheet, even though it has the largest negative number and a minus sign that looks like it reduces spending.

When does under budget signal a missed goal?

  • A savings or investment transfer that did not happen.
  • A bill that was not paid, so it will land next month.
  • A planned purchase you delayed, such as insurance, servicing or a course.
  • A health or maintenance cost you postponed, which may cost more later.
  • A budget that was set too high, which is a planning issue, not a saving.

In these cases the favourable reading is misleading. Ask what the money was supposed to achieve, and whether it was achieved.

How do you set this up in a sheet?

Put the category in column A, the type (Spend, Savings or Income) in B, budget in C, actual in D. In E calculate the variance: =D2-C2. In F put the reading: =IF(E2=0,"On budget",IF(B2="Spend",IF(E2>0,"Adverse","Favourable"),IF(E2<0,"Adverse","Favourable"))). This works in Excel and Google Sheets. The type column is what lets one formula handle all three kinds of line.

What about timing differences?

Some variances are only about timing. An annual premium budgeted at ₹2,000 a month and paid in June shows a big adverse variance in June and favourable ones in the other months. In such cases a year-to-date view is fairer than the single month. Mark these lines so that they are not read as a failure.

Where does a tracker help?

Budgets are part of SpendixAI Pro, alongside bills and savings goals, so you can set category budgets and compare them with what your imported transactions show. For savings lines, check that a transfer is recorded as a transfer or saving, not as spending, otherwise the sign will mislead you.

A short checklist

  • Decide the sign convention and write it on the sheet.
  • Label each line as Spend, Savings or Income.
  • Read adverse and favourable, not plus and minus.
  • For any favourable underspend, ask whether the goal behind it was met.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports