Most savings trackers have a quiet flaw: the goal never moves. You set a target — say, $30,000 for a house down payment — and the tracker faithfully measures your progress toward a number that means a little less every year. Meanwhile, the interest your savings account earns changes too, sometimes dramatically, and a tracker that ignores it will misjudge your finish date in the other direction.
The fix is a tracker with two moving parts: a goal that rises with inflation, and a projection that reflects the interest rate you’re actually earning. You can build this in a spreadsheet in under an hour. Here’s how.
Start With the Static Version
Before adding the moving parts, get the basics down. Your tracker needs four columns to start:
- Date — one row per month
- Deposits — what you added that month
- Balance — the actual account balance
- Target balance — where you planned to be by that date
Pull the deposit and balance numbers from your bank, or from a budgeting app that syncs your accounts — YNAB, Monarch Money, and Empower Personal Dashboard all show account balances over time, and any of them can feed this spreadsheet. (If you’re still looking for a Mint replacement, note that Mint shut down; Monarch and Empower are the usual migration paths.)
This static version already beats no tracker at all. But it treats your goal as frozen and your money as inert, and neither is true.
Make the Goal Rise With Inflation
Inflation means the same dollar goal buys less over time. If your target is tied to a real-world purchase — a car, a down payment, a year of college — the price of that thing is drifting upward while you save.
The adjustment is one formula. Each year, multiply your remaining goal by (1 + inflation rate):
Adjusted goal = Original goal × (1 + inflation rate)As an illustrative example: a $30,000 goal adjusted for 3% inflation becomes $30,900 after one year, and about $34,778 after five years of the same rate.
Two practical rules keep this honest:
- Use the real number, not a guess. The Bureau of Labor Statistics publishes the Consumer Price Index monthly. Once a year, look up the actual trailing-12-month CPI change and apply that — don’t compound a fixed 2.5% assumption forever.
- Match the index to the purchase if you can. Overall CPI is fine for general goals, but if you’re saving for a house, home prices in your market may move very differently from headline inflation. For big goals, check the price of the actual thing annually.
In the spreadsheet, add an “inflation-adjusted goal” cell that you update each January. Your target-balance column should key off that cell, so the whole plan reshapes automatically.
Project What Interest Will Contribute
The second moving part is the interest rate on your savings. High-yield savings account rates follow the broader rate environment, and they change — an account earning 4%+ one year can drift down toward 3% the next, or vice versa. That difference matters more than it looks over multi-year goals.
Spreadsheets make this easy with the FV (future value) function:
=FV(annual_rate/12, months, -monthly_deposit, -current_balance)This tells you where you’ll land given your current balance, monthly deposit, and rate. Keep the rate in its own cell so that when your bank emails you about an APY change, updating your entire projection is a one-cell edit.
Here’s an illustrative example of why the rate cell matters. Saving $500/month from a $5,000 starting balance for five years:
| Savings APY | Balance after 5 years (example) | Interest earned |
|---|---|---|
| 1.0% | ~$36,000 | ~$1,000 |
| 3.0% | ~$38,200 | ~$3,200 |
| 4.5% | ~$40,000 | ~$5,000 |
(Numbers rounded; actual results depend on compounding schedule and rate changes along the way.) The spread between a low-rate and high-rate account here is roughly $4,000 — which is also a reminder that where you park savings is part of the plan, not a footnote.
Put Both Together: The Real Finish Line
The useful output of the tracker is a single comparison, recalculated monthly:
Projected balance at your target date (from the FV formula, using the current rate) versus the inflation-adjusted goal (updated annually from CPI).
If the projection meets or beats the adjusted goal, you’re genuinely on track. If it falls short, the tracker tells you exactly how much to change: raise the monthly deposit, extend the date, or move the money somewhere earning more. Without the adjustments, you can appear “on track” for years while quietly falling behind in purchasing-power terms.
A worked example, purely illustrative: you’re saving for a $25,000 goal three years out, depositing $650/month at 4% APY. Your projection lands around $27,000 — comfortably ahead. But three years of 3% inflation pushes the goal to about $27,300. Suddenly you’re roughly at break-even, not ahead, and a small deposit bump of $25/month closes the gap. That’s the kind of course correction a static tracker never surfaces.
Set a Maintenance Rhythm
A tracker only works if the inputs stay fresh. A schedule that takes about 15 minutes a month:
- Monthly: enter the new balance and deposits; glance at projection vs. adjusted goal.
- Quarterly: confirm your account’s current APY and update the rate cell.
- Annually: apply the actual CPI figure to the goal; re-examine whether the goal amount itself still matches the real-world price.
If you’d rather not maintain a spreadsheet, you can get partway there with apps. YNAB’s savings targets are excellent for the deposit-discipline side. Monarch Money and Empower Personal Dashboard track balances and net worth across accounts automatically. None of them will inflate your goal for you, though — so even app users benefit from a once-a-year manual check: “is my target still enough to buy the thing?”
The Takeaway
A savings goal is a claim about the future, and the future has two variables a static tracker ignores: what things will cost, and what your money will earn along the way. Building both into your tracker takes one CPI lookup a year and one FV formula — and in exchange, the number on your screen stops flattering you and starts telling the truth.