Savings Tracker Google Sheets — Watch Every Goal Fill Up

Having money sitting in a savings account and knowing whether you are actually on track are two different things. Most people who save do so by moving whatever is left at the end of the month — which means some months they save and some months they do not, and they have no clear picture of when any specific goal will be reached.

A savings tracker changes that. Instead of one vague savings balance, you have named goals with targets, monthly contributions, and a running count of how many months remain. Saving becomes intentional rather than accidental. You know exactly where you stand on each goal every time you open the sheet.

This guide walks through how to build a savings tracker in Google Sheets that handles multiple goals at once, shows you progress visually, and takes five minutes a month to update.

Why separate goals beat one savings pot

When savings is a single number, every purchase is competing against everything you are saving for at once. You cannot tell whether spending £200 on car repairs puts your holiday at risk, delays your emergency fund, or has no real impact at all.

Separate goals give each target its own lane. You can see immediately which goal takes the hit, decide whether to rebalance contributions, and keep the others moving forward. It also makes saving more motivating — watching a specific goal tick toward 100% is more engaging than watching a number grow with no obvious meaning.

Here is what a multi-goal savings tracker looks like in practice:

At a glance you can see the holiday is the closest goal, the car replacement is the longest-range one, and the emergency fund sits in the middle. That picture is impossible to see when everything is pooled together.

Setting up the tracker in Google Sheets

Open a blank Google Sheet. Each row is one savings goal. Use one tab per tracker — you do not need separate sheets for each goal.

Column A — Goal name. Name each goal clearly: "Holiday — Greece 2026," "Emergency fund," "New boiler." Be specific enough that you remember what you are saving for.

Column B — Target amount. The total you need. Enter it as a plain number. Do not format it as currency until all the formulas are in place — it is easier to build without the formatting getting in the way.

Column C — Saved so far. The current balance for this specific goal. Update this number once a month. This is the only column you will need to edit after the initial setup.

Column D — Monthly contribution. How much you plan to add each month. This drives the months-remaining calculation.

Column E — Months remaining. Formula: =(B2-C2)/D2. This tells you how many months until the goal is reached at the current contribution rate. Wrap it in ROUNDUP() if you want a whole number: =ROUNDUP((B2-C2)/D2,0). If saved-so-far already exceeds the target, this will return zero or a negative — add an IF to cap it: =IF(C2>=B2,"Done",ROUNDUP((B2-C2)/D2,0)).

Column F — Percentage complete. Formula: =C2/B2. Format this column as a percentage. This is the number that drives the progress bar in the next step.

That is the full data structure. Six columns, one row per goal, and only one column to update each month.

Adding a progress bar with conditional formatting

A row of percentages is useful. A row of visual progress bars is more immediately readable — especially if you share the sheet with a partner or family member who does not want to interpret numbers.

Google Sheets does not have a native progress bar chart type, but you can simulate one using conditional formatting on the percentage column.

Select the percentage cells in column F. Go to Format → Conditional formatting. Set the format rule to "Color scale." Set the minimum colour to white or light grey and the maximum colour to green. The cell background will now fill with green proportional to the percentage — cells near 0% stay pale, cells near 100% turn solid green.

For a more pronounced bar effect: add a second column (G) that uses REPT("█", ROUNDDOWN(F2*20,0)). This repeats a block character up to 20 times based on the percentage, creating a simple text-based bar. It is low-tech but visible at a glance in any browser or phone.

Either approach works. The colour scale is cleaner; the block character bar is more explicit. Use whichever reads better for how you use the sheet.

Deciding how much to put toward each goal

The tracker shows you the consequences of your current contributions — months remaining per goal. But it does not decide how much to allocate. That decision belongs in your budget.

The right way to treat savings is as a fixed expense in your family budget, not as whatever is left after spending. Set the contribution amount for each goal before you plan anything else in the month. Then distribute what remains across everyday spending.

If the contributions you want would exceed what is available, the tracker helps you make trade-offs visibly. Reduce the car replacement contribution and the months-remaining number changes immediately. You can see the cost of each decision rather than guessing.

If you are also using a bill tracker to manage regular outgoings, run both alongside the budget. Bills tell you what is committed; the savings tracker tells you whether what is left is being allocated with intention.

The monthly update habit

The tracker is a five-minute task on the first of the month. That is all it takes to keep it accurate and useful.

Open the sheet. Go to the "Saved so far" column (column C). For each goal, update the number to the current balance in that savings pot. Do not calculate the change — just enter the current total. The formulas handle the rest.

Check months remaining. Did any goal move closer or further than expected? A goal that is moving slower than the formula predicted usually means a contribution was missed or the balance was used for something else. Note it and decide whether to catch up next month or accept the delay.

Check for completed goals. If a goal shows "Done," move the contribution amount to another goal or back into the budget. Do not let the freed-up money disappear into general spending by default — make a deliberate decision about where it goes next.

That is the entire monthly process. The value is in the regularity, not the complexity.

When to adjust goals vs contributions

Two things can change in the tracker: the target amount, or the monthly contribution. Knowing which to adjust in different situations keeps the system honest.

Adjust the contribution when your income changes, you add a new goal that needs funding, or you want to accelerate a goal that is close to completion. Contribution changes affect the timeline but not the ambition.

Adjust the target when the goal itself changes — the holiday costs more than expected, the car you were looking at is now a different price, the home improvement scope has expanded. Changing the target is fine as long as you do it deliberately, not just to make the percentage look better.

Remove a goal entirely when it is no longer relevant. A holiday you are not taking, a purchase you have decided against — delete the row and redistribute the contribution. Keeping irrelevant goals in the tracker clutters the view and makes the useful numbers harder to see.

Pair the tracker with a broader home management system if you want savings goals sitting alongside household planning, maintenance schedules, and family finance in one place.