Budgeting

Goal progress review: ahead, on track or behind (with a formula)

Check if your savings goal is ahead, on track or behind with one formula: target times elapsed months over total months, against what you have saved.

Editorial illustration for Goal progress review: ahead, on track or behind (with a formula)

To review a savings goal, work out what you should have saved by now and compare it with what you actually have. Expected to date = target × months elapsed ÷ total months. If your saved amount is above that figure you are ahead, near it you are on track, and below it you are behind. The method assumes you save at an even pace, which is a fair default for most goals.

How do you calculate where you should be?

Say your goal is ₹60,000 over 12 months and five months have passed. A straight line gives ₹60,000 × 5 ÷ 12 = ₹25,000 expected by now. If you have ₹28,000, you are ₹3,000 ahead. If you have ₹21,000, you are ₹4,000 behind. That is the whole method; the rest is deciding what to do about the answer.

What does it look like for three different goals?

Here are three hypothetical goals, all measured at the same point in time.

GoalTarget and periodMonths elapsedExpected to dateSavedStatus
Holiday fund₹60,000 over 12 months5₹25,000₹28,000Ahead by ₹3,000
Bike down payment₹1,20,000 over 18 months9₹60,000₹60,000On track
Emergency cushion₹2,40,000 over 24 months10₹1,00,000₹70,000Behind by ₹30,000

Checks: ₹1,20,000 × 9 ÷ 18 = ₹60,000. ₹2,40,000 × 10 ÷ 24 = ₹1,00,000, so the third goal is ₹30,000 short, which is 30% of what it should be at this point. That is more serious than the ₹3,000 lead on the first goal, even though both numbers look small in a table.

How do you set it up in Excel or Google Sheets?

Put the target in B1, the start date in B2, the end date in B3, the amount saved so far in B4 and today's date in B5 (or use TODAY()). Then use these formulas, which work in both Excel and Google Sheets:

  • Months elapsed: =DATEDIF(B2, B5, "m")
  • Total months: =DATEDIF(B2, B3, "m")
  • Expected to date: =B1*DATEDIF(B2, B5, "m")/DATEDIF(B2, B3, "m")
  • Gap: =B4-B1*DATEDIF(B2, B5, "m")/DATEDIF(B2, B3, "m")
  • Status: =IF(B4>=expected*1.05, "Ahead", IF(B4>=expected*0.95, "On track", "Behind")), where expected is the cell holding the expected-to-date figure

DATEDIF works in both programs, although Excel does not show it in its function suggestions, so you have to type it in full. The 5% band in the status formula is my own rule of thumb, not a standard: it stops you from calling yourself behind because of a ₹500 difference. Change it to suit the size of the goal.

What should you do if you are ahead, on track or behind?

  • Ahead: do not raise the target automatically. Check whether the lead came from a one-off, such as a bonus or a refund. If it did, keep your normal monthly contribution and enjoy the buffer.
  • On track: change nothing, and look again next month.
  • Behind: find the cause first. A single missed month calls for a catch-up; a monthly contribution that is simply too small needs a new number, a new date, or a smaller target.

For the emergency cushion above, the ₹30,000 gap spread across the 14 remaining months is about ₹2,143 a month on top of the usual contribution. If that is not realistic, moving the end date is a better answer than quietly giving up.

Is a sheet enough, or do you want more?

A sheet is enough for one to three goals, provided you update it monthly. When a sheet stops being enough, for example because you track several goals alongside bills and budgets, SpendixAI Pro includes savings goals, budgets and bills in one personal workspace. It is still worth doing the sum above once by hand so you understand the number on any screen.

A monthly goal check

  1. Update the saved amount from your actual account balance.
  2. Recalculate expected-to-date for the month just ended.
  3. Mark the status and write one line on why.
  4. Adjust the contribution, the date or the target only if you have been behind two months in a row.
SPENDIXAI JOURNAL

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

Explore your reports