A1:G13fxCOUNTIF IF IFERROR MIN ROUNDUP SUM
Savings Goal Tracker — the first rows of the actual spreadsheet
Savings Goal Tracker
The opening rows of the file you get — sample data included, not a mock-up.

Finance template

Savings Goal Tracker

Progress bars per goal, with months remaining worked out from your monthly contribution.

$7one payment, yours to keep
  • ✓Instant download
  • ✓Every later version free
  • ✓Commercial use
  • ✓No signup, no watermark
22
live formulas, each one recalculated and checked
7
columns: Goal, Target, Saved so far, Monthly, % complete, Months left, Status
4
figures worked out for you

A saver with a deposit, wedding or trip in mind — usually looking for this when a target exists but no plan to reach it by a date.

Need more than one? All 11 Finance templates for $39 — $176 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 22 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Savings Goal Tracker template

Saving is easier when you can see how close you are. This Excel savings goal tracker lists each goal with its target, what you have saved so far and what you put aside each month, then works out the percentage complete and how many months are left.

The overall view shows how much is still to save, your progress across every goal, how many goals you have reached and how long clearing them all will take.

Good for

  • →Saving towards several goals at once, such as a deposit and a holiday
  • →Checking whether a monthly amount will get you there in time
  • →Building an emergency fund alongside other savings

What it works out for you

Overall

  • →Still to save
  • →Overall progress
  • →Goals reached
  • →Months to clear all

What is inside the Savings Goal Tracker template

The table has 7 columns. Calculated columns fill themselves in; the rest are yours to type over.

  • →Goal
  • →Target
  • →Saved so far
  • →Monthly
  • →% complete
  • →Months left
  • →Status

How to use the Savings Goal Tracker in Excel

Set a target and what you put aside each month. Percentage complete, months left and the finish date follow automatically.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

COUNTIFIFIFERRORMINROUNDUPSUM

Questions about the Savings Goal Tracker

How are months left calculated?

The amount still to save is divided by your monthly contribution and rounded up to whole months. It does not include any interest earned.

What happens when I reach a goal?

It shows 100% complete, its status updates and it counts towards goals reached in the summary.

Can I change the monthly amount?

Yes. Change any monthly figure and the months left for that goal update straight away.

What you get with the Savings Goal Tracker

  • ✓22 formulas, every one recalculated and checked
  • ✓Opens with sample rows already filled in
  • ✓Excel, Google Sheets and LibreOffice Calc
  • ✓Set up to print on one page wide
  • ✓Commercial use, no attribution needed
  • ✓Every later version included free

Get the Savings Goal Tracker for $7

One payment. The file downloads straight away, and every later version of it is yours at no extra cost.

Buying a few? All 11 Finance templates for $39, or all 66 for $99.

More finance templates

See all Finance →