Home › Templates › Savings goal tracker

Savings Goal Tracker Spreadsheet

A free savings goal tracker spreadsheet for Excel and Google Sheets: set up to 12 bigger goals (a house down payment, a car, a wedding, school, travel) with a target, a date and the APY of the account that holds the money. Log each deposit, and the sheet shows % complete, the monthly amount needed with and without interest, your projected finish date at your real pace and whether each goal is on track.

Download Excel template (.xlsx) 95 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 1 Nov 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no bank connection: you type the numbers yourself.

Preview: the Example Goals tab (fictional data), as of 1 Nov 2026. APYs are example assumptions, not quoted rates. Saved = starting balance + deposits − withdrawals + logged interest.
$54,873.80saved of $128,500.00 in targets (42.7%)
$3,414.79a month needed with interest ($3,659.40 without)
$3,132.48current average monthly pace, all goals
1 · 2 · 3reached · on track · behind
GoalPriorityTargetTarget dateAPYSaved% completeMonths leftMonthly needed, no interestMonthly needed, with interestAverage paceProjected finishStatus
House down paymentHigh$60,000.0030 Jun 20304.00%$21,456.4535.8%43$896.36$765.97$901.111 Jan 2030On track
WeddingHigh$25,000.0018 Sep 20274.00%$13,405.9053.6%10$1,159.41$1,098.54$894.491 Dec 2027Behind
Car replacementMedium$18,000.0031 Mar 20283.50%$6,579.8536.6%16$713.76$679.63$334.481 Jun 2029Behind
Grad school tuitionMedium$15,000.0015 Aug 20280.00%$5,000.0033.3%21$476.19$476.19$300.371 Sep 2029Behind
Japan tripLow$7,500.001 Apr 20273.75%$5,431.6072.4%5$413.68$394.46$645.141 Mar 2027On track
Home office upgradeLow$3,000.0015 Dec 20260.00%$3,000.00100.0%1$0.00$0.00$56.89ReachedReached
Total$128,500.00$54,873.8042.7%$3,659.40$3,414.79$3,132.48
Example Dashboard: % complete for the six fictional goals as of 1 Nov 2026. House down payment 35.8% (On track); Wedding 53.6% (Behind); Car replacement 36.6% (Behind); Grad school tuition 33.3% (Behind); Japan trip 72.4% (On track); Home office upgrade 100.0% (Reached).0%25%50%75%100%House down payment35.8% · On trackWedding53.6% · BehindCar replacement36.6% · BehindGrad school tuition33.3% · BehindJapan trip72.4% · On trackHome office upgrade100.0% · ReachedReachedOn trackBehind

Chart: % complete from the same tab. In the workbook, % complete is drawn with data bars, and the Dashboard adds a stacked bar chart (saved vs remaining) and a column chart of the monthly amount needed with and without interest.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, the maths in plain words, colour key, limits, disclaimer
GoalsUp to 12 goals: name, priority (High, Medium, Low), target amount, target date, starting balance, start date, APY; an as-of date (optional)Net deposits and interest from the log, saved to date, % complete (data bars), remaining, months left, monthly rate, monthly needed with and without interest, average monthly pace, months to goal (NPER), projected finish, status, extra needed per month, projected balance on the target date; totals; a duplicate-name check
LogDate, goal (dropdown), type (Deposit, Withdrawal or Interest), amount, note; 500 rowsTotals by type and a check on every row (unknown goal, missing type, amount or date)
DashboardTwo cells for the what-if: a goal and a monthly amountTotals, overall % complete, monthly needed, pace, next target date, status counts, a goal table with data bars and text bars, two native charts, and the what-if block (new finish date, months sooner or later, balance on the target date)
Example Goals, Example Log, Example DashboardAlready filledSix fictional goals and 57 log rows, so you can see every formula working

This file is built for bigger goals that take a year or more and sit in an account that pays interest. For irregular bills you pay every few months, the sinking funds tracker is simpler: no interest, a 12-month plan. For a cushion against costs you cannot plan, use the emergency fund tracker, which sets its target from your essential expenses.

How to use it

  1. Write down each goal. Give it a target amount and a date. The CFPB's goal-setting worksheet in its Your Money, Your Goals toolkit puts it this way: "Think about how long it will realistically take you to reach your goal. Then, make an action plan and stick to it."
  2. Open Goals. In the yellow cells type the name, priority, target, target date, what the goal already has (starting balance), the date of that balance (start date) and the APY of the account holding it. Leave APY blank for cash or a 0% account. E4 says OK when every name is unique.
  3. Open Log. Add a row each time money moves: Deposit when you add money, Withdrawal when you take some out, Interest when the bank pays interest. Amounts are always positive. Column F flags rows that need a fix.
  4. Read the grey columns on Goals: the monthly amount needed (column P with interest, O without), your average pace (Q), the projected finish (S) and the status (T). Column U shows how much more per month a goal behind schedule needs.
  5. Open Dashboard for totals, status counts and charts. In the what-if block pick a goal in E12 and type a monthly amount in E13: the sheet shows the new finish date and the balance you would have on the target date.
  6. Re-check monthly. When your bank changes the rate, type the new APY; when a goal is done, keep the row (it shows Reached) or clear it to free the slot.

Leave Goals!B4 blank and the sheet uses today's date. Type a date there to see the numbers as of that day.

Why interest changes the monthly amount

Money for a long goal usually sits in a savings account, a money market deposit account or a CD. The bank pays interest on the balance, and later on the interest too. Investor.gov (the SEC's investor education site) defines compound interest as "Interest paid on principal and on accumulated interest." Its Savings Goal Calculator does the same job for one goal: it calculates "how much money you need to contribute each month in order to arrive at a specific savings goal."

Banks quote the rate as an annual percentage yield. The CFPB's Regulation DD (Truth in Savings), § 1030.2 defines it as "a percentage rate reflecting the total amount of interest paid on an account, based on the interest rate and the frequency of compounding for a 365-day period". Because APY already includes compounding, the sheet turns it into a monthly rate with (1+APY)^(1/12)−1, so twelve months at that rate equal the APY. At a 4% APY the monthly rate is 0.3274%.

The effect grows with time. In the example, the house down payment has 43 months left: interest cuts the monthly amount needed from $896.36 to $765.97. The Japan trip has 5 months left, so the saving is only $19.22 a month.

Where the money sits. The FDIC's Understanding Deposit Insurance page says: "FDIC deposit insurance covers $250,000 per depositor, per FDIC-insured bank, for each account ownership category." A large goal such as a house down payment can get close to that limit when it shares a bank and an ownership category with your other deposits. The same page lists stocks, bonds, mutual funds and crypto assets as not covered.

The formulas, explained

Exact formulas from the file (row 8 on Goals, row 6 on Log). On Goals, A is the goal name, C the target, D the target date, E the starting balance, F the start date and G the APY; $B$5 is the date used. The log reads rows 6 to 505.

FieldFormula
Date used (B5)=IF(B4="",TODAY(),B4)
Net deposits from the log (H)=IF(A8="","",SUMIFS('Log'!$D$6:$D$505,'Log'!$B$6:$B$505,A8,'Log'!$C$6:$C$505,"Deposit")-SUMIFS('Log'!$D$6:$D$505,'Log'!$B$6:$B$505,A8,'Log'!$C$6:$C$505,"Withdrawal"))
Interest from the log (I)=IF(A8="","",SUMIFS('Log'!$D$6:$D$505,'Log'!$B$6:$B$505,A8,'Log'!$C$6:$C$505,"Interest"))
Saved to date (J)=IF(A8="","",N(E8)+H8+I8)
% complete (K)=IF(OR(A8="",N(C8)<=0),"",J8/C8)
Remaining (L)=IF(A8="","",MAX(0,N(C8)-J8))
Months left (M)=IF(OR(A8="",D8=""),"",MAX(0,(YEAR(D8)-YEAR($B$5))*12+MONTH(D8)-MONTH($B$5)))
Monthly rate from APY (N)=IF(A8="","",IF(N(G8)<=0,0,(1+G8)^(1/12)-1))
Monthly needed, no interest (O)=IF(M8="","",IF(L8=0,0,L8/MAX(1,M8)))
Monthly needed, with interest (P)=IF(M8="","",IF(L8=0,0,IF(N8=0,O8,MAX(0,-PMT(N8,MAX(1,M8),-J8,C8)))))
Average monthly pace (Q)=IF(OR(A8="",F8=""),"",MAX(0,H8)/MAX(1,($B$5-F8)/30.4375))
Months to goal at pace (R)=IF(OR(A8="",N(C8)<=0),"",IF(L8=0,0,IF(Q8="","Add start date",IF(N8=0,IF(Q8>0,L8/Q8,"Not reachable"),IFERROR(NPER(N8,-Q8,-J8,C8),"Not reachable")))))
Projected finish (S)=IF(R8="","",IF(R8=0,"Reached",IF(ISNUMBER(R8),IF(R8>600,"50+ years",EDATE($B$5,ROUNDUP(R8,0))),R8)))
Status (T)=IF(A8="","",IF(N(C8)<=0,"Add target",IF(J8>=C8,"Reached",IF(D8="","Add target date",IF(D8<$B$5,"Past target date",IF(NOT(ISNUMBER(R8)),IF(R8="Add start date","Add start date","Behind"),IF(R8<=M8+0.0001,"On track","Behind")))))))
Extra needed per month (U)=IF(OR(P8="",Q8=""),"",MAX(0,P8-Q8))
Projected balance at target date (V)=IF(OR(M8="",Q8=""),"",IF(N8=0,J8+Q8*M8,FV(N8,M8,-Q8,-J8)))
Log: row check (F6)=IF(AND(B6="",D6=""),"",IF(COUNTIF('Goals'!$A$8:$A$19,B6)=0,"Goal not found",IF(AND(C6<>"Deposit",C6<>"Withdrawal",C6<>"Interest"),"Pick a type",IF(N(D6)<=0,"Amount?",IF(A6="","Add date","OK")))))
What-if: months with test amount (Dashboard E23)=IF(E14="","",IF(E15>=E16,0,IF(E20=0,IF(N(E13)>0,(E16-E15)/E13,"Not reachable"),IFERROR(NPER(E20,-N(E13),-E15,E16),"Not reachable"))))
What-if: new finish date (E24)=IF(E23="","",IF(E23=0,"Reached",IF(ISNUMBER(E23),IF(E23>600,"50+ years",EDATE($B$2,ROUNDUP(E23,0))),E23)))
What-if: balance on target date (E26)=IF(OR(E14="",E18=""),"",IF(E20=0,E15+N(E13)*E18,FV(E20,E18,-N(E13),-E15)))
Dashboard: text progress bar (G31)=IF(F31="","",REPT("█",ROUND(MIN(1,F31)*20,0))&REPT("░",20-ROUND(MIN(1,F31)*20,0)))

PMT and NPER. Both use the same savings equation: balance × (1+r)n + deposit × ((1+r)n − 1) ÷ r = target, with r the monthly rate and deposits at each month end. PMT solves it for the deposit when n is fixed (months left); NPER solves it for n when the deposit is fixed (your pace or the what-if amount). The minus signs follow Excel's cash-flow convention: money you put in is negative, the target is positive.

Months left counts calendar months from the as-of month up to, but not including, the target month: a goal due 18 Sep 2027, seen on 1 Nov 2026, gets 10 deposits (November to August). Average pace is net deposits ÷ months since the start date, where a month is 30.4375 days. Logged interest counts in the balance but not in the pace, because the projection adds interest from the APY. A goal is On track when the months needed at your pace are no more than the months left.

Worked example from the sample data

The Example tabs hold six made-up goals as of 1 Nov 2026. All balances, deposits, interest payments and APYs are fictional.

Wedding: behind schedule

Target $25,000.00 by 18 Sep 2027. Starting balance $6,000.00 on 1 Mar 2026, plus eight $900.00 deposits ($7,200.00) and $205.90 of logged interest = $13,405.90 (53.6%). Remaining $11,594.10; months left (2027 − 2026) × 12 + 9 − 11 = 10.

House down payment: on track over 3½ years

$12,000.00 + $9,000.00 of deposits (ten $700.00 transfers and a $2,000.00 tax refund) + $456.45 interest = $21,456.45 of $60,000.00. 43 months left. Needed: $896.36 a month without interest, $765.97 with it. Pace $901.11 a month ($9,000.00 over 304 days), so NPER gives 37.37 months and a finish of 1 Jan 2030, six months before the 30 Jun 2030 target. At that pace the balance on the target date would be about $66,228.92.

Car replacement: a withdrawal slows it down

Nine $400.00 deposits minus a $600.00 withdrawal for a brake repair = $3,000.00 net over 273 days, a pace of $334.48 a month. The goal needs $679.63 a month to hit 31 Mar 2028, so it is Behind; at the current pace it would finish 1 Jun 2029.

Grad school: no interest

The APY is 0%, so the monthly amount is the same with and without interest: $10,000.00 ÷ 21 = $476.19. NPER is skipped and the months to goal are plain division: $10,000.00 ÷ $300.37 = 33.3 months.

Japan trip and home office

The Japan trip has $5,431.60 of $7,500.00 and adds $645.14 a month against $394.46 needed, so it is On track to finish 1 Mar 2027. The home office upgrade reached its $3,000.00 target and shows Reached.

The what-if block

On Example Dashboard, the wedding goal is tested at $1,200.00 a month instead of the $894.49 average. NPER(0.003274, −1,200, −13,405.90, 25,000) = 9.20 months, rounded up to 10: new finish 1 Sep 2027, 3 months sooner than at the current pace and before the target date. FV(0.003274, 10, −1,200, −13,405.90) = $26,029.63 on the target date. Verdict: Meets the target date.

What-if for the fictional wedding goal: balance by month at a 4% APY (example assumption).
What-if for the fictional wedding goal: balance month by month from $13,405.90 on 1 Nov 2026 at a 4% APY. At the current average pace of $894.49 a month it reaches $25,000.00 after 12.1 months (1 Dec 2027); at $1,200 a month it gets there after 9.2 months (1 Sep 2027), before the 18 Sep 2027 target date.$10k$15k$20k$25k$30kNov 26Jan 27Mar 27May 27Jul 27Sep 27Nov 27Jan 28Target $25,000Target date (Sep 2027)What-if $1,200/mo: 1 Sep 2027Current pace $894/mo: 1 Dec 2027

Common mistakes

Limits

FAQ

How do I make a savings goal tracker in Excel or Google Sheets?

List each goal with a target amount, a target date and what you have saved. Log every deposit in a second tab with the date, the goal and the amount, and add it up per goal with SUMIFS. Then divide what is left by the months left to get the monthly amount needed. This template has all of that built in for up to 12 goals, plus interest, a projected finish date and a dashboard.

How much should I save each month to reach a savings goal?

Without interest: (target − saved) ÷ months left. In the example, the wedding fund has $13,405.90 of $25,000.00 and 10 months left, so $11,594.10 ÷ 10 = $1,159.41 a month. With a 4% APY the sheet uses −PMT(monthly rate, months, −saved, target) and the amount drops to $1,098.54, because the balance earns interest along the way.

How does interest change how much I need to save?

Interest on the balance does part of the work. Investor.gov defines compound interest as "Interest paid on principal and on accumulated interest." The longer the goal and the bigger the balance, the larger the effect: for the example house down payment (43 months left, 4% APY assumed), the monthly amount needed falls from $896.36 with no interest to $765.97. For a goal a few months away the difference is small.

How do I calculate when I will reach my savings goal?

Use NPER: =NPER(monthly rate, −monthly deposit, −current balance, target) gives the number of monthly deposits needed. With no interest it is simply what is left ÷ monthly deposit. In the example, the wedding fund adds about $894.49 a month on average, so NPER gives 12.1 months and a projected finish of 1 Dec 2027, after the 18 Sep 2027 target date.

Should each savings goal have its own account?

That is a personal choice. Some people keep all goals in one savings account and split it in a spreadsheet; others use separate accounts or labelled savings buckets so each goal can have its own rate. If you use a bank, check that it is FDIC-insured: FDIC deposit insurance covers $250,000 per depositor, per FDIC-insured bank, for each account ownership category. Goals held in the same ownership category at the same bank count toward the same limit.

Can I use this savings tracker template in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use SUMIFS, PMT, NPER, FV, EDATE, INDEX, MATCH and IF, which work in Excel 2016+, Google Sheets and LibreOffice. Google Sheets does not show Excel data bars, so the Dashboard also has a text progress bar that works everywhere.

Related tools and templates

Educational template only, not financial advice. Projections assume a fixed deposit and a fixed APY and ignore taxes and inflation. Example data is fictional: the goals, balances, deposits, interest and APYs are made up to show the formulas and are not quoted rates or a recommendation. CFPB, FDIC and Investor.gov material was retrieved on 1 November 2026.