Template
Financial Goal Tracker
Saving without a goal is easy to abandon; saving toward a named target with a date is far easier to stick with. This tracker lets you list every financial goal — a car, a home down payment, a child’s education, an international trip — with its target amount and deadline, then shows the monthly SIP each one needs. As you contribute, it tracks how far along you are and flags goals that are falling behind. It turns "I should invest more" into a set of specific, fundable monthly commitments you can actually follow.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The tracker holds all your financial goals in one place, each with a target amount, a target date, and the amount you have already saved toward it. For every goal it works out the monthly contribution needed to get there on time, accounting for the years remaining and the growth you expect from where the money is invested. As you log contributions, it updates the saved-so-far figure, shows the percentage complete, and highlights any goal where your current pace will miss the deadline. Short-term goals can be flagged for safer instruments and long-term ones for equity, so each goal is funded in a way that matches its horizon.
Who it’s for
- People with several goals — a car, a house, a child’s education — competing for the same income.
- New investors who want each SIP tied to a concrete purpose rather than a vague total.
- Parents planning ahead for school admissions, higher education, or a wedding.
- Anyone who saves inconsistently and needs a target and a deadline to stay disciplined.
Fields included
How to use it
- List each financial goal — car, home down payment, education, travel — on its own row.
- Enter the target amount in today’s terms and the date you want to reach it.
- Record how much you have already saved toward each goal.
- Let the sheet calculate the monthly SIP each goal needs given its time horizon and expected growth.
- Tag each goal short-term or long-term so you fund it from the right kind of instrument.
- Log contributions monthly and watch the percentage-complete and on-track flags update.
- Rebalance when a goal slips — extend the date, raise the contribution, or trim a lower-priority goal.
Preview
| Goal | Target (₹) | Years | Monthly SIP (₹) |
|---|---|---|---|
| Car | 6,00,000 | 3 | 13,000 |
| Home down payment | 20,00,000 | 6 | 19,000 |
| Child education | 40,00,000 | 14 | 11,000 |
| Total needed | 66,00,000 | — | 43,000 |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Vikram sets three goals. A ₹6L car in 3 years — he has ₹1L saved, so the tracker asks for about ₹13,000 a month in a conservative fund. A ₹20L home down payment in 6 years — ₹3L saved, needing roughly ₹19,000 a month in a hybrid mix. A ₹40L education fund in 14 years — ₹2L saved, needing about ₹11,000 a month in equity given the long horizon. Together that is ₹43,000 a month. His budget allows ₹35,000, so the tracker shows the car goal on track but the others slightly behind. Vikram pushes the car out by six months and redirects the freed cash to the education SIP.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)