Introduction

Most savings plans fail for the same boring reason: the goal is vague. “Save more money” has no target, no deadline, and no monthly number, so there is nothing to check and nothing to miss. A spreadsheet fixes all three problems at once. It turns a wish into a target amount, a deadline, and a monthly contribution — and then it shows you, every month, whether you are on track.
You do not need a budgeting app, a paid template, or advanced spreadsheet skills. A free Google Sheet (or Excel, if you prefer it) and about twenty minutes of setup are enough. This guide walks through the whole process: choosing goals that are specific enough to track, turning each goal into a monthly amount with one simple formula, building the sheet step by step, handling several goals at once, and adjusting the plan when life changes. Every money example in this article is hypothetical, in US dollars, and clearly labelled as such.

Start with goals that can be measured

Before you open a spreadsheet, write down each savings goal in a form that can be measured. A useful savings goal has four parts:

• Specific: What exactly are you saving for? “A used car” is specific. “The future” is not.
• Measurable: How much money, in dollars, does it need? If you do not know the amount yet, research a realistic figure first and write down your source — a car listing, a contractor’s quote, a travel estimate.
• Time-bound: By when? A month and year, not “someday.” A deadline is what turns a target into a monthly amount.
• Realistic: Can your current income actually support the monthly amount the goal requires? If the arithmetic says no, the goal needs a smaller target, a later deadline, or both — and it is far better to discover that now than six months in.
  A common framework for this is SMART goals — Specific, Measurable, Achievable, Relevant, Time-bound — which is widely used in financial education. You do not need to memorize the acronym; you need its discipline. A goal that fails any of the four tests above is a wish, not a plan, and a spreadsheet cannot track a wish.
  Sort your goals into three buckets, because they behave differently:
• Short-term (under a year): a holiday, a new laptop, car insurance paid annually, holiday gifts. These have fixed deadlines and fixed amounts.
• Medium-term (one to five years): a car down payment, a home down payment fund, a wedding. These are large enough that the monthly amount matters a great deal.
• Long-term or open-ended (no fixed deadline): an emergency fund, a general safety cushion. These have a target amount but no hard deadline, so you set a monthly amount you can sustain instead of working backward from a date. Our guide to building an emergency fund explains how to size that particular target.

The one formula that runs the whole plan

Every savings goal in your spreadsheet is governed by a single piece of arithmetic:
Monthly amount = (Target amount − Amount already saved) ÷ Months remaining
That is the entire calculation. The amount still needed, divided by the time left to save it. Everything else in the spreadsheet — progress bars, totals, status flags — is built on top of this formula.
Here is a worked hypothetical example, clearly labelled hypothetical. Suppose you want to save $2,400 for a holiday, you already have $600 saved, and the trip is 8 months away:

• Amount still needed: $2,400 − $600 = $1,800
• Months remaining: 8
• Monthly amount: $1,800 ÷ 8 = $225 per month
  Check the arithmetic backward: $225 × 8 months = $1,800, plus the $600 already saved = $2,400. The plan adds up exactly. That backward check — multiply the monthly amount by the months remaining, add what is already saved, and confirm it equals the target — is a habit worth keeping for every goal you enter.
  If the monthly amount is more than you can afford, you have three honest options, and only three: lower the target, extend the deadline, or find more room in your monthly budget. What you cannot do is keep the same target and deadline while saving less each month and still expect to arrive on time. The spreadsheet’s job is to make that trade-off visible instead of letting it stay vague.

Build the spreadsheet, step by step

Open a new Google Sheet (or a blank Excel workbook) and name it something you will recognize, such as “Savings Goals 2026.” You will build three tabs: a goals dashboard, a contribution log, and a monthly review. Twenty minutes of setup now saves hours of confusion later.

Step 1: Create the goals dashboard

Name the first tab “Savings Goals.” This is the sheet you will look at most often — one row per goal, with the numbers that matter. Set up these columns:

Column	What goes in it
A — Goal	The name, e.g. “Holiday fund”
B — Target	The total amount needed, e.g. $2,400
C — Deadline	The target date, e.g. 2027-07-01
D — Already saved	The amount saved so far, e.g. $600
E — Months remaining	Calculated from today’s date and the deadline
F — Monthly needed	Calculated from the formula above
G — Progress	Percentage of the target already saved
H — Status	On track, Behind, or Complete
Now add the formulas. Assuming your first goal is in row 2, with the target in B2, the deadline in C2, and the amount already saved in D2:

• Months remaining (E2): =MAX(1, DATEDIF(TODAY(), C2, "M")) — this counts the whole months between today and the deadline, and the MAX(1, …) part prevents a divide-by-zero error when the deadline is this month.
• Monthly needed (F2): =(B2-D2)/E2 — the core formula: amount still needed divided by months remaining.
• Progress (G2): =IF(B2=0, 0, D2/B2) — the share of the target already saved, formatted as a percentage. The IF guard prevents an error if the target is ever zero.
• Status (H2): =IF(D2>=B2, "Complete", IF(F2<=0, "Complete", "In progress")) — a simple flag you can refine later.
  Format columns B, D, and F as currency and column G as a percentage. Then add a totals row at the bottom: =SUM(F2:F10) in the Monthly needed column tells you the single most important number in the whole plan — the total amount you need to set aside each month across all goals. If that total is more than your budget allows, you know immediately, before the month begins.
  For an open-ended goal with no deadline, such as an emergency fund, the formula above does not apply — there is no date to count months from. Instead, enter a manual monthly amount you can sustain in column F, and leave the deadline blank with a note. The goal still belongs on the dashboard so its progress stays visible.

Step 2: Add progress bars you can read at a glance

Numbers are precise; bars are motivating. In Google Sheets, add a progress bar next to the percentage with the SPARKLINE function. In a new column, enter:
=SPARKLINE(G2, {"charttype","bar"; "max",1; "color1","green"})
This draws a small in-cell bar showing how far along the goal is. Alternatively, use conditional formatting on the Progress column: color the cell green when progress is above 80%, yellow between 50% and 80%, and red below 50%. Either method gives you the same thing — a dashboard you can understand in five seconds without reading a single number.

Step 3: Create the contribution log

Name the second tab “Contributions.” This is where you record every deposit, one row per deposit:

Column	What goes in it
A — Date	The date of the deposit
B — Goal	The goal name, matching the dashboard exactly
C — Amount	The amount deposited
D — Notes	Optional: where the money came from, e.g. “payday transfer”
Log deposits on the day you make them, or set a weekly reminder to batch them in. The discipline that matters is not daily logging — it is never letting a month pass without the log matching reality. A contribution log with gaps is worse than no log, because it tells you a story you believe but that is not true.
If you want the dashboard’s “Already saved” column to update automatically from this log, replace the manual figure in column D with a SUMIFS formula:
=SUMIFS(Contributions!C:C, Contributions!B:B, A2)
This adds up every deposit in the log whose goal name matches the goal in row 2. It requires the goal names to match exactly between the two tabs — a trailing space is enough to break it — so copy and paste the names rather than retyping them. In Excel, the same formula works with the tab name adjusted to your workbook.

Step 4: Create the monthly review tab

Name the third tab “Monthly Review.” This is a simple table with one row per month:

Month	Planned total	Actually saved	Difference	Notes
2026-11	$450	$450	$0
2026-12	$450	$300	−$150	Holiday spending
The “Planned total” comes from the dashboard’s SUM formula. The “Actually saved” figure comes from adding up the contribution log for that month. The difference column is the honest part: it shows, without judgment, whether the plan survived contact with the month. Review this tab on the first weekend of each month, and make it a five-minute habit rather than an annual reckoning.

Handling multiple goals at once

Most people have more than one savings goal, and the spreadsheet’s real value shows when goals compete for the same dollars. Three rules keep multiple goals manageable:
Rule 1: Rank your goals. Not all goals are equal. An emergency fund protects you against the unexpected; a holiday is enjoyable but postponable. Write a priority number (1, 2, 3) next to each goal on the dashboard. When money is tight, the ranking tells you which goal gets funded first and which one waits. Without a ranking, the loudest goal wins, which is rarely the most important one.
Rule 2: Check the total before adding a goal. Every new goal adds a monthly amount to the dashboard total. Before adding one, look at the SUM at the bottom and ask whether the new total still fits your budget. If it does not, something else must give: a smaller target, a later deadline, or a lower priority goal paused until another one finishes.
Rule 3: Use one account per goal, or one account with a clear ledger. Some people open a separate savings account for each goal; others keep one savings account and use the spreadsheet as the ledger that divides it. Either approach works, as long as the spreadsheet and the real money agree. If you keep one account, reconcile the two monthly: the sum of the “Already saved” column should equal the balance of the savings account (plus or minus any interest, which you can log as a contribution with a note). If the numbers disagree, find out why before the gap grows.
A worked hypothetical example with three goals shows how this fits together:

Goal	Target	Already saved	Months left	Monthly needed
Emergency fund	$3,000	$1,200	(open-ended)	$150 (manual)
Holiday	$2,400	$600	8	$225
New laptop	$1,200	$0	6	$200
Total monthly needed: $150 + $225 + $200 = $575. Check it against your budget: if you can set aside $575 a month, all three goals proceed. If you can set aside only $400, the arithmetic forces a choice — extend the laptop deadline from 6 months to 9 months ($1,200 ÷ 9 = $133.33, rounded to $134), pause the holiday, or reduce a target. The spreadsheet does not make the choice for you. It makes the choice unavoidable, which is the point.

Adjusting the plan after setbacks

No savings plan survives a year unchanged. Income changes, expenses spike, a car needs a repair. The spreadsheet is designed for this: when reality changes, you update three numbers and the plan recalculates itself.
If your income drops: Reduce the monthly amounts, starting with the lowest-priority goals, and extend the deadlines on the dashboard. The monthly-needed formula will immediately show the new amounts. Do not simply stop contributing and leave the old numbers in place — a plan that no longer reflects reality stops being useful.
If an unexpected expense eats your savings: Update the “Already saved” figure to the new, lower balance. The monthly-needed amount will rise, and you can decide whether to extend the deadline or accept the higher monthly figure. If the expense came from the emergency fund, that is exactly what the fund was for — replenishing it becomes the top priority.
If you get extra money: A tax refund, a bonus, or a sold item can go straight to the highest-priority goal. Log it in the contribution log like any other deposit, and watch the monthly-needed figure for that goal fall. Resist the temptation to spread a windfall thinly across every goal; concentrating it finishes one goal sooner, which frees its monthly amount for the others.
If a goal’s cost changes: Perhaps the holiday now costs $2,800 instead of $2,400, or the laptop you wanted is on sale for $1,000. Update the target on the dashboard and let the formula do the rest. This is also the moment to check whether the deadline still makes sense.
If a goal is complete: Mark it complete, move its monthly amount to the next goal on your list, and enjoy the visible proof in the progress bar hitting 100%. Then, if you like, archive the row to a “Completed goals” section at the bottom of the dashboard rather than deleting it — a record of finished goals is its own kind of motivation.
In every case, the adjustment rule is the same: change the inputs (target, deadline, or amount saved), let the formulas recalculate, check the new monthly total against your budget, and write a one-line note in the monthly review tab saying what changed and why. Six months later, those notes will tell you the story of your year.

Common mistakes to avoid

• Setting a goal with no deadline and no monthly amount. An open-ended goal without a manual monthly figure is a wish. Give it a number or it will not happen.
• Forgetting money already saved. Starting a goal at zero when you already have money set aside inflates the monthly amount and makes the goal look harder than it is.
• Counting the same dollars twice. If $500 sits in a savings account and you list it under both the emergency fund and the holiday fund, the spreadsheet will lie to you. Every dollar belongs to exactly one goal.
• Ignoring interest. Savings accounts pay interest, which is real money, but the simple formula in this guide does not include it. That is deliberate: ignoring interest makes the plan slightly conservative, which is safer than assuming a return you cannot guarantee. If you want to account for interest, log it as a contribution when it is paid.
• Building a complicated spreadsheet instead of using a simple one. A dashboard, a log, and a monthly review are enough. Adding charts, projections, and five more tabs feels productive but usually means the sheet gets abandoned. Simple and used beats elaborate and ignored.
• Checking the sheet once and never again. A spreadsheet is a tool, not a talisman. The five-minute monthly review is what turns setup into progress.

A setup checklist

• Each goal written with a specific target amount and a deadline (or a manual monthly amount for open-ended goals)
• Dashboard tab created with Target, Deadline, Already saved, Months remaining, Monthly needed, Progress, and Status
• Monthly-needed formula =(Target − Already saved) ÷ Months remaining in place, with the backward check done for each goal
• Total monthly amount (=SUM of the Monthly needed column) compared with your budget
• Progress bars or conditional formatting added
• Contribution log tab created, with goal names matching the dashboard exactly
• Monthly review tab created, with a recurring reminder to review it
• Goals ranked by priority, so a tight month has a clear answer
• A note of the date you set the plan up, so future you knows when the numbers were last true

Frequently asked questions

Should I use Google Sheets or Excel?
Either works. Google Sheets is free, autosaves, and is easy to share or open on a phone; Excel is stronger for offline use and very large files. The formulas in this guide work in both, with only minor syntax differences. Pick the one you will actually open.
What if I cannot afford the monthly amount my goal requires?
Then change the inputs: lower the target, extend the deadline, or pause a lower-priority goal. Saving a smaller amount consistently is better than setting an impossible amount and stopping altogether. The formula will tell you the new monthly figure as soon as you change the target or the date.
How do I track a goal that has no deadline, like an emergency fund?
Set a target amount and a fixed monthly contribution you can sustain, and enter that amount manually instead of using the deadline formula. Review the target once a year: as your expenses change, the right size for an emergency fund changes too.
Do I need a separate bank account for each goal?
No. A separate account per goal makes the money physically divided, which some people find easier, but a single savings account with the spreadsheet as the ledger works just as well — as long as you reconcile the two every month. Our expense tracking guide uses the same Google Sheets approach for spending, so the two sheets can sit side by side.
What if my savings earn interest?
Log interest payments as contributions in the log, with a note saying “interest.” The simple formula in this guide does not project future interest, which keeps the plan conservative and avoids assuming returns that are not guaranteed.

The bottom line

A savings goal spreadsheet is not complicated: one row per goal, one formula — (target minus saved) divided by months remaining — a log of every deposit, and a five-minute monthly review. Set specific goals, check the total monthly amount against your budget, rank your goals so tight months have an answer, and adjust the inputs whenever life changes instead of abandoning the plan. The spreadsheet will not save the money for you. What it will do is tell you, honestly and every month, exactly what “on track” means — and that clarity is what turns a wish into a finished goal.
This article is general education, not financial advice. It explains how to set savings goals using a spreadsheet for informational purposes only and does not provide personalized financial advice. All money examples are hypothetical. Interest rates, account terms, and your personal circumstances vary; verify current details with your bank and consider speaking with a qualified financial professional about your own situation.