Savings Tracker Template
Track multiple savings goals with target, saved-so-far, remaining dollars, and percent complete — all computed by formulas as you update deposits.
Preview
The workbook ships with the example values below plus blank rows — every total is a live formula.
| Goal | Target | Saved | Remaining | Progress |
|---|---|---|---|---|
| Emergency fund (3 mo) | $9,000.00 | $6,400.00 | $2,600.00 | 71.1% |
| Vacation | $3,500.00 | $1,850.00 | $1,650.00 | 52.9% |
| New laptop | $2,000.00 | $2,000.00 | $0.00 | 100.0% |
| House down payment | $60,000.00 | $21,300.00 | $38,700.00 | 35.5% |
| Car replacement | $12,000.00 | $3,000.00 | $9,000.00 | 25.0% |
| Totals | $86,500.00 | $34,550.00 | $51,950.00 | 39.9% |
How to use it
- List each goal with its target amount and what you have saved so far.
- Remaining (=Target − Saved) and Progress (=Saved ÷ Target) update automatically.
- Update the Saved column whenever you make a deposit — progress percentages move instantly.
- Keep the emergency fund as its own row so it never gets spent on a vacation by accident.
Related online calculators
Free for personal use. The file contains no macros — just data, formatting, and standard spreadsheet formulas that work in Excel, Google Sheets, and LibreOffice.