Savings tracker: printable, template, and spreadsheet
Three savings trackers that work: a printable to colour in, a Google Sheets template with four formulas, and a ledger. How to pick one and keep using it.
A savings tracker has one job: to make progress you can't feel into progress you can see. Week three of saving for anything is the hard week. You have $150 in the account, the goal is $2,400, and nothing in your life looks any different. A tracker is what tells you that you are 6% of the way there and on schedule.
Most people choose a tracker for how it looks. It is better to choose one for what it shows you. This entry covers three kinds of savings tracker (the printable, the spreadsheet, and the ledger), with a worked example of each and the numbers to put on it.
What a savings tracker should show
Whichever format you use, a useful tracker answers four questions at a glance.
- What is the goal? One number, named. "Lisbon, $2,400."
- What is saved? The current balance toward it. "$150."
- What is the percentage? "6%." Percentages move faster than balances feel like they do.
- Am I on pace? The weekly figure needed to hit the date, compared to what you are actually saving.
The fourth question is the one most trackers leave out, and it is the one that matters most. A colouring chart tells you how far you have come. It doesn't tell you whether you will arrive by June.
Savings tracker printable: the colour-in chart
The printable is the most popular kind, and for good reason. Colouring in a square is a small, physical reward, and the chart on the fridge is a reminder you walk past every day.
The common designs:
- The thermometer. A tall tube split into 10 or 20 bands. For a $2,400 goal, each of 20 bands is $120. Colour one in each time you save $120.
- The grid. 100 boxes, each worth 1% of the goal. For $2,400 that is $24 a box. A hundred small wins instead of twenty larger ones.
- The 52-week chart. One row per week with the amount filled in. The classic version runs $1 in week 1 up to $52 in week 52, for a total of $1,378.
- The shape. A house, a plane, a car, split into sections. Same idea as the thermometer, but tied to what you are saving for.
How to make a printable work: write the goal and the date across the top, in ink. Decide the value of each square before you start, and never change it. Put the chart somewhere you look every day, not in a drawer.
The free savings goal charts are four one-page trackers of this kind: 100 boxes each for $5,000, $10,000 and $100,000, plus a blank one for your own number, with the weekly and monthly amounts printed underneath.
The free Manifesting Bank ledger is a 12-page printable with a five-step vision page, transfer pages, and a 52-week tracker (the $1 to $52 version) already laid out.
Where printables fall short: they can't do arithmetic. If you miss three weeks, the chart doesn't tell you what you now need each week to catch up. That is what a spreadsheet is for.
Savings tracker template for Google Sheets or Excel
A spreadsheet takes ten minutes to set up and then does the maths for you. Here is a minimal template that works in Google Sheets or Excel.
| Cell | Label | Example | Formula |
|---|---|---|---|
| B1 | Goal | $2,400 | typed |
| B2 | Target date | 2027-05-12 | typed |
| B3 | Saved so far | $150 | =SUM(B8:B200) |
| B4 | Percent | 6% | =B3/B1 |
| B5 | Weeks left | 30 | =ROUNDUP((B2-TODAY())/7,0) |
| B6 | Needed per week | $75 | =(B1-B3)/B5 |
Rows 8 onward are your deposit log: date in column A, amount in column B. Add a row each time you save. The four formulas update themselves.
B6 is the important cell. It is your pace. If you planned on $75 a week and B6 now reads $91, you have fallen behind, and the tracker tells you so in a number you can act on. You can raise the transfer, move the date, or lower the goal. Any of the three is fine. What matters is that you decide on purpose.
Optional upgrades: a progress bar using conditional formatting on B4; a column for memos ("birthday money", "sold the old bike"); and one tab per goal if you are tracking several. Having several goals is common, and it is the subject of sinking funds.
A savings tracker app or ledger
The third kind of tracker records the deposits for you. Banking apps with savings "pots" or "spaces" do this for real money. Manifesting Bank does it for your intentions: each vision is an account with a goal number, each transfer is a dated entry with a memo, and a standing order adds the weekly figure automatically.
The statement shows the same four things as the spreadsheet: goal, balance, percentage, and the annual run-rate (what your current pace adds up to over a year). The difference is that you don't have to remember to log anything. The standing order posts every Monday whether you open the app or not.
For a longer comparison of savings apps, banking pots, and manifesting banks, see savings goal app.
Which savings tracker should you use?
- You want the habit to feel good: a printable on the fridge. Pair it with an automatic transfer so the colouring is never the only thing keeping you going.
- You want to know if you are on pace: a spreadsheet with the "needed per week" formula.
- You don't want to log anything: a ledger with a standing order.
- You are saving with kids: a printable, always. The kids' 52-week challenge in money saving challenge ideas is built for one.
Many people use two at once: a printable for the visible reminder and a ledger or spreadsheet for the arithmetic. That works well. Just make sure one of them is the source of truth, so the two don't drift apart.
How to keep using a savings tracker past week six
Most trackers are abandoned between weeks four and eight. Three things help:
Update on a fixed day. Sunday evening, five minutes. Don't wait until there is something to report.
Log the small ones. A $12 refund counts. So does $20 of birthday money. Small entries keep the tracker alive in the weeks when nothing big happens.
Read the pace, not just the balance. "On pace" is a reason to keep going. "$16 a week behind" is a reason to change something. Either one is more useful than "only 18%."
Start with the number at the top
Every tracker starts the same way: a goal, a date, and a weekly figure. Decide those three, then pick the format. If you want the arithmetic and the reminders handled for you, open an account, name the vision, attach the number, and set the standing order. Your tracker then fills itself in every Monday.
If you have never set the goal itself, how to set savings goals walks through it in five steps.
Frequently asked questions
What is a savings tracker? A chart, spreadsheet, or app that shows your savings goal, how much you have saved, and how far along you are. The good ones also show whether you are on pace to hit your date.
Is there a free savings tracker printable? Yes. Many are free to print. Manifesting Bank has two: 100-box savings goal charts for $5,000, $10,000 and $100,000, and a ledger with a 52-week tracker alongside vision and transfer pages. Both are free to download.
How do I make a savings tracker in Google Sheets? Enter the goal and target date, sum a deposit log for the saved amount, then add three formulas: percent (saved ÷ goal), weeks left, and needed per week ((goal − saved) ÷ weeks left).
How much is the 52-week savings challenge? $1,378 in total if you save $1 in week one, $2 in week two, and so on up to $52.
Should I track every savings goal separately? Yes. One tracker per goal, each with its own number and date. A single "savings" total hides which goal is behind.
Chairman of the bank, manifesting as many dreams as possible. Builds Manifesting Bank and wires a number to future him most mornings.