Report this item to Etsy

Emergency Fund Tracker Spreadsheet for Excel, Emergency Savings Calculator, Months of Expenses Covered, Rainy Day Fund Planner

Price:$7.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Digital download
  • Digital file type(s): 1 ZIP

How big should your emergency fund be - and how safe are you right now? This emergency fund tracker works out your target from your essential expenses, tracks every deposit and withdrawal, and shows how many months of expenses you could cover today and when you will be fully funded.

WHY YOU WILL LIKE IT
- Know your real target, based on your own essential expenses.
- See how many months of expenses your fund covers right now.
- Celebrate milestones: starter goal, 1, 3 and 6 months.
- Know the month you will be fully funded at your planned contribution.
- Used the fund? Log it - the refill plan updates automatically.

FEATURES
- Target calculator: up to 15 essential expenses x months of cover
- Suggested months of cover from 6 yes/no risk questions, or choose your own
- Fund log for up to 300 deposits, withdrawals and interest payments with a running balance
- Months of expenses covered with red / amber / green status
- Months to target and projected full month at your monthly contribution
- 5 milestones with the date you reached them
- 3 automatic charts: month-end balance vs target, progress to target, essential expenses
- Any currency label, blank template plus a filled-in sample, printable layouts

EXAMPLE (fictional sample data)
In the sample, essential expenses of 3,215.00 a month and 6 months of cover give a target of 19,290.00. The fund holds 8,058.30 - about 2.51 months of expenses - and at 400.00 a month it is full in 29 months.

WHAT'S INCLUDED
- Emergency-Fund-Tracker.xlsx - blank template
- Emergency-Fund-Tracker-SAMPLE.xlsx - the same workbook filled with fictional example data
- User-Guide.pdf - getting started, how the numbers work, Google Sheets steps and limitations
- Essential-Expenses-Starter.csv - a starter list of essential expenses
- README.txt - quick start

HOW TO USE
1. Download the ZIP after purchase and unzip it.
2. Open Emergency-Fund-Tracker.xlsx in Excel (or upload it to Google Drive and save as Google Sheets).
3. Fill in the Target sheet, then your starting balance and monthly contribution on Settings, then log deposits as you make them.

COMPATIBILITY
- Microsoft Excel (desktop): tested in Microsoft 365 for Windows. Uses features available since Excel 2013.
- Google Sheets: built only with formulas that Google Sheets also supports; upload the .xlsx to Google Drive and choose File > Save as Google Sheets. Live Google Sheets testing is pending - see the note in the guide.
- Not tested in Apple Numbers, LibreOffice or Excel for Mac.

PLEASE NOTE
This is a digital download - no physical product will be shipped. Please read the description and compatibility notes before purchasing. The suggested months of cover are a rule of thumb; this template is a planning tool and does not provide financial advice. Sample data is fictional.

FAQ
How many months should I save?
Many people aim for 3-6 months of essential expenses. The sheet suggests a number from 6 simple questions (3 + 1 per "Yes", up to 9), and you can type your own. It is a rule of thumb, not advice.

What counts as an essential expense?
What you must pay to get by: housing, utilities, groceries, insurance, transport, minimum debt payments, childcare and medical costs.

What if I use the fund?
Log the withdrawal. The balance, months covered and refill plan update automatically.

Does it connect to my bank?
No. You type your deposits and withdrawals; nothing is connected or uploaded.

Does it work with my currency?
Yes. Type your symbol or code on Settings; amounts are plain numbers in one currency.

Will I receive a physical item?
No. This is an instant digital download.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 25, 2026