Spreadsheets

Savings goal tracker spreadsheet with a progress bar

Build a savings goal tracker in Excel with target, deadline, percentage complete, a text progress bar and the monthly amount each goal needs.

Editorial illustration for Savings goal tracker spreadsheet with a progress bar

A savings goal tracker in Excel needs six columns per goal: name, target, deadline, amount saved, percentage complete and monthly amount needed. A REPT formula draws a progress bar in a cell, so you see at a glance which goal is behind. Here is how to build it, with a laptop, a trip and a rental security deposit as examples.

Which columns should the tracker have?

  • A: Goal
  • B: Target in rupees
  • C: Deadline, as a date
  • D: Saved so far
  • E: Percentage complete
  • F: Progress bar
  • G: Months left
  • H: Monthly amount needed

Put headers in row 1 and goals from row 2. Format B and D as numbers with the thousands separator and C as a date. Format E as a percentage.

What are the formulas?

  • E2, percentage complete: =IF(B2=0, 0, D2/B2)
  • F2, progress bar: =REPT("#", ROUND(MIN(E2,1)*20, 0)) & REPT("-", 20-ROUND(MIN(E2,1)*20, 0))
  • G2, months left, rounded up: =MAX(1, ROUNDUP((C2-TODAY())/30.4, 0))
  • H2, monthly amount needed: =ROUNDUP(MAX(0, B2-D2)/G2, 0)

The bar is 20 characters wide, so each character is five percent. MIN(E2,1) stops it overflowing when a goal is exceeded. Set the F column to a monospaced font such as Consolas so the bars line up. The 30.4 in the months formula is the average number of days in a month, so months left is an estimate.

Can I use a cleaner bar than characters?

Yes. Select E2:E20, choose Home, then Conditional Formatting, then Data Bars, and pick a solid fill. Because the percentage in E is between 0 and 1, the data bar fills up as you save. The REPT bar works in any version and copies cleanly into other apps, which is why many people keep it.

A worked example with pretend numbers

Say today is 1 November 2026 and you have three goals.

GoalTargetDeadlineSavedCompleteMonthsMonthly
Laptop₹60,00031 Mar 2027₹15,00025%5₹9,000
Trip₹35,00031 Jan 2027₹14,00040%3₹7,000
Security deposit₹90,00030 Jun 2027₹9,00010%8₹10,125

Laptop: 150 days to the deadline divided by 30.4 is 4.9, rounded up to 5 months; 45,000 left divided by 5 is ₹9,000. Trip: 91 days gives 3 months; 21,000 / 3 = ₹7,000. Deposit: 241 days gives 8 months; 81,000 / 8 = ₹10,125. All three monthly figures add to ₹26,125.

That total is the real question. If your savings capacity is less than ₹26,125, a goal has to move or shrink. The sheet makes that choice visible in a minute.

If the total looks too heavy, change one input at a time. Push the laptop deadline by two months and watch its monthly figure fall, or reduce the trip target by ₹5,000. The sheet recalculates at once, which makes it a quick way to test a plan before you commit to it.

How do I record what I have saved?

The simplest way is to type the new total into column D each month after you move the money. If you want a history, add a Deposits tab and use =SUMIFS(Deposits!$C$2:$C$500, Deposits!$B$2:$B$500, A2), where column B holds the goal name and C the amount. Pay yourself on salary day so the habit survives a tight month.

Checklist for a new goal

  1. Write the exact target, including any delivery, taxes or deposit that comes on top.
  2. Pick a real deadline date, not a vague month.
  3. Enter what you already have set aside for it, and no more.
  4. Look at the monthly amount and ask if it fits next to rent, EMIs and bills.

If you later want savings goals inside the same place as your imported transactions, SpendixAI Pro has budgets, bills and savings goals, though the formulas above remain a good way to understand the arithmetic.

SPENDIXAI JOURNAL

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

Explore your reports