Template
Emergency Fund Tracker
An emergency fund is the buffer that keeps a job loss or medical bill from turning into credit card debt. This tracker first sizes your target — typically three to six months of essential expenses — from your actual monthly outgoings, then tracks every contribution until you get there. It shows your current months-of-cover, the gap remaining, and a realistic date to reach a fully funded buffer. Built for Indian households, it keeps the goal concrete instead of a vague "I should save more" and stops you from investing before your foundation is in place.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The tracker calculates how large your emergency fund should be by taking your essential monthly expenses — rent, EMIs, groceries, utilities, insurance, school fees — and multiplying by the number of months of cover you choose, usually three for stable salaried jobs and six or more for variable income or single-earner homes. It then logs each contribution to your fund, shows the running balance, and converts that balance into "months of cover" so you always know how protected you are. A progress line and a projected completion date keep the goal visible until the fund is full and you can confidently move surplus into investments.
Who it’s for
- Anyone who has never separated emergency savings from spending money.
- Single-income families who need a deeper buffer against one salary stopping.
- Freelancers and business owners with lumpy income who must self-insure against dry months.
- New investors who keep being told to "build an emergency fund first" and want a concrete target.
Fields included
How to use it
- List your essential monthly expenses — rent, EMIs, groceries, utilities, insurance, fees — and exclude discretionary spends.
- Choose your cover: three months for a stable salary, six or more for single-income or variable-income households.
- Let the sheet compute your target fund — essential expenses times months of cover.
- Enter your current emergency savings to see how many months of cover you already have.
- Set a monthly contribution and log it each month; the balance and months-of-cover update automatically.
- Keep the fund in a separate liquid account — a sweep-in FD or liquid fund — not your spending account.
- When the fund hits 100%, stop topping it up and redirect that contribution to long-term investments.
Preview
| Month | Contribution (₹) | Balance (₹) | Cover |
|---|---|---|---|
| Start | — | 60,000 | 1.3 mo |
| Month 3 | 20,000 | 1,20,000 | 2.7 mo |
| Month 6 | 20,000 | 1,80,000 | 4.0 mo |
| Month 11 | 20,000 | 2,70,000 | 6.0 mo |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Priya’s essential expenses come to ₹45,000 a month. As a single earner she chooses six months of cover, setting a target of ₹2,70,000. She already has ₹60,000 parked, giving her 1.3 months of cover — the tracker shows she is 22% of the way there. She commits ₹20,000 a month into a separate liquid fund. Over roughly eleven months the balance climbs to the full ₹2,70,000, the months-of-cover line reaches 6.0, and the tracker marks the fund complete. Priya then redirects that ₹20,000 monthly into her equity SIPs with her foundation secure.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)