Savings Goal Tracker for Excel and Google Sheets: Monthly Targets, Progress Bars and Behind-Schedule Alerts

A savings goal tracker is a spreadsheet that lists each goal (emergency fund, vacation, car down payment…), how much you need, how much you have and the date you want it by; formulas then work out how much to set aside each month, show a progress bar, and flag any goal that has fallen behind schedule. Turning a vague “save more” into one specific monthly transfer is what makes saving automatic instead of whatever is left at the end of the month.

This guide sits in Debt Payoff & Savings. If you are still carrying high-interest balances, run it alongside the debt snowball spreadsheet.

Tracker layout

The Deposits sheet logs every transfer with a date, the goal name and the amount. Summing deposits instead of overwriting a balance keeps the history you need for the progress chart.

Why PMT gets “saved” as positive and “target” as negative

PMT follows cash-flow sign conventions: money you have and money you want to end up with sit on opposite sides. Written as PMT(rate,months,C2,-B2), the result comes back positive and reads directly as “deposit this much per month.” Flip the signs and Excel returns a negative number that MAX(0,…) would turn into zero.

Progress bar and status flag

• Text progress bar: =REPT("█",ROUND(H2*10,0))&REPT("░",10-ROUND(H2*10,0)), or apply Conditional Formatting → Data Bars to column H.
• Expected progress if you put the start date in K2: =MIN(1,(TODAY()-K2)/(D2-K2))
• Status: =IF(H2>=1,"Funded",IF(H2>=L2,"On track","Behind")), where L2 holds the expected progress.

Worked example: three goals, set up on November 6, 2026

The 4% annual rate is an assumption used only to show the calculation; savings account yields vary by bank and change over time.

The plan needs roughly $1,220–$1,260 a month. Interest trims about $40 off that over these short horizons; the deposits do the heavy lifting. If the total does not fit your budget, you have three levers: push a date out (the car to mid-2028), shrink a target (a shorter trip), or run goals in sequence and finish the emergency fund first.

How much should go to savings?

Start from your budget, not from the goals. Under the 50/30/20 budget, 20% of take-home pay covers savings and extra debt payments; that 20% is the pool this tracker divides between goals. Record the monthly transfers as a fixed line in your monthly budget template so they are paid first, before discretionary spending.

A common order of priorities

1. Starter cushion for small surprises so they don’t land on a credit card.
2. High-interest debt such as credit cards.
3. Full emergency fund, often expressed as several months of essential expenses depending on how stable your income is.
4. Dated goals: car, tuition, moving, a wedding.
5. Long-term goals: retirement, a home down payment.

Where to keep each goal

Add a “Account” column so you know where each dollar sits. Many people keep the emergency fund in a separate savings account so it is easy to reach but not mixed with spending money. Deposits at FDIC-insured banks are insured up to $250,000 per depositor, per insured bank, for each ownership category; check that the institution you use is covered, and compare current rates and withdrawal terms before you fill in the assumed rate in J1.

Optional: a 52-week savings challenge column

If a fixed monthly amount feels hard to start, the classic 52-week challenge saves $1 in week 1, $2 in week 2 and so on up to $52. The total is =SUM(SEQUENCE(52)), which equals $1,378 — enough to seed a starter cushion. Log each week’s deposit against a goal named “52-week challenge” and the tracker counts it automatically.

Actual vs plan chart

Build a small table of the running balance by month for each goal (SUMIFS with month-start and month-end dates) and chart two lines: actual, and the straight planned line from today’s balance to the target on the target date. The gap between the lines shows at a glance whether you are ahead or behind.

Common mistakes

• Goals without a date — no date, no monthly number.
• Too many goals at once — the combined monthly total becomes impossible and the tracker gets abandoned.
• Overwriting the balance instead of logging deposits — you lose the history.
• Optimistic interest assumptions — use a cautious rate or the no-interest column.
• Accidentally typing over formulas — lock them with the steps in how to protect formulas in Excel.

FAQ

DATEDIF doesn’t appear when I type it. Does it work?

Yes. DATEDIF is an undocumented Excel function: it does not autocomplete, but it calculates correctly. Google Sheets supports it too.

What if my income is irregular?

Base the monthly amount on your average take-home pay over the last six months and deposit extra in strong months to cover lighter ones.

Do I need a separate bank account per goal?

No. Separate rows in the tracker are enough. Some banks let you create sub-accounts or “buckets,” which can make it harder to dip into one goal for another, but that is a preference rather than a requirement.

Does this work in Google Sheets?

Yes. SUMIFS, PMT, DATEDIF, REPT, SEQUENCE and conditional formatting all work the same way.

Next step: write down three goals with an amount and a date, enter them in the tracker, and set up an automatic transfer for the amount in column F. More templates live in Personal Finance & Budgeting.