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.

Part of the Google Sheets expense tracking guide — all templates and guides in one place.

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 vacation 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 vacation 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 color to white or light grey and the maximum color 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 color 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. If you are not yet tracking day-to-day spending, a Google Sheets expense tracker alongside this savings tracker gives you the full picture — what you are spending and what you are building toward. 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 vacation 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 vacation 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.

Savings tracker spreadsheet vs a dedicated app

Dedicated savings apps exist, but a Google Sheets savings tracker spreadsheet has a few advantages that are hard to replicate in an app. It is free with no subscription. You own the data and can export or share it however you like. You can customise every column, formula, and visual to match how you actually think about your goals rather than how the app designers think you should. And it works on any device that can open a browser.

The downside is that it requires manual updates — apps can pull live balances from linked bank accounts. If automation is important to you, an app may suit better. But for most people who want clarity without complexity, a spreadsheet is enough. The five-minute monthly update is a feature, not a bug: it forces you to look at each goal deliberately rather than letting a dashboard update passively in the background.

A savings tracker spreadsheet also integrates naturally with your other financial tracking. If you already use Google Sheets for a budget or expense tracker, you can link sheets so the savings total feeds directly into your monthly budget without re-entering numbers.

Emergency fund tracker in Google Sheets

An emergency fund is the most important savings goal to track separately because it has a specific target (typically three to six months of expenses) and a specific function — it does not get spent on anything else. Mixing it with other goals in a single account makes it too easy to raid for non-emergencies.

In the savings tracker, give the emergency fund its own row. Set the target as a specific number — if your monthly expenses are $3,000 and you want three months of cover, the target is $9,000. Track it like any other goal. When it is complete, the contribution amount gets reallocated to the next priority.

One useful addition for an emergency fund row: a note column showing what the target represents. "3 months expenses at $3,000/mo" next to the $9,000 target is more motivating than a number alone, and it tells a partner or family member what the goal is without explanation.

Once the emergency fund hits its target, do not delete the row — keep it at 100% and check it monthly. If you draw on it after an emergency, the percentage drops below 100% and you can track the replenishment like any other goal.