Personal finance template
Savings Goal Tracker Template
Set a goal and a deadline. The sheet shows your progress and how much to save each month to get there.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Goal | Target | Saved | Months left | Progress | Per month |
| 2 | Emergency fund | 60,000 | 22,000 | 10 | =C2/B2 | =(B2-C2)/D2 |
| 3 | Holiday | 25,000 | 8,000 | 6 | =C3/B3 | =(B3-C3)/D3 |
| 4 | Total | =SUM(B2:B3) | =SUM(C2:C3) | =C4/B4 | =SUM(F2:F3) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =C2/B2
How far you've come towards the goal.
F2 =(B2-C2)/D2
Remaining amount spread over the months left.
Make it yours by asking
Try a request like this in Tabstra:
"Create a savings goal tracker with goal amount, saved so far, months left, progress and monthly amount needed"