Home › Templates › Emergency fund tracker
Emergency Fund Tracker
A free emergency fund tracker for Excel and Google Sheets: list your essential monthly expenses, pick how many months to cover (3 to 12), log every deposit and withdrawal, and the sheet shows your target, progress, months of coverage, months to goal and a projected goal date.
Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no bank connection, no add-on. Amounts work in any currency.
| Date | Type | Amount | Note | Balance after | Months covered | % of target |
|---|---|---|---|---|---|---|
| 15 Jan 2026 | Deposit | +$450.00 | Transfer on payday | $2,850.00 | 1.06 | 17.7% |
| 15 Feb 2026 | Deposit | +$450.00 | Transfer on payday | $3,300.00 | 1.23 | 20.5% |
| 15 Mar 2026 | Deposit | +$450.00 | Transfer on payday | $3,750.00 | 1.40 | 23.3% |
| 31 Mar 2026 | Interest | +$18.20 | Q1 interest | $3,768.20 | 1.41 | 23.4% |
| 15 Apr 2026 | Deposit | +$450.00 | Transfer on payday | $4,218.20 | 1.57 | 26.2% |
| 15 May 2026 | Deposit | +$450.00 | Transfer on payday | $4,668.20 | 1.74 | 29.0% |
| 28 May 2026 | Withdrawal | −$640.00 | Car repair | $4,028.20 | 1.50 | 25.1% |
| 15 Jun 2026 | Deposit | +$450.00 | Transfer on payday | $4,478.20 | 1.67 | 27.8% |
| 30 Jun 2026 | Interest | +$22.75 | Q2 interest | $4,500.95 | 1.68 | 28.0% |
| 15 Jul 2026 | Deposit | +$450.00 | Transfer on payday | $4,950.95 | 1.85 | 30.8% |
| 20 Jul 2026 | Deposit | +$1,200.00 | Part of a tax refund | $6,150.95 | 2.30 | 38.3% |
| 15 Aug 2026 | Deposit | +$450.00 | Transfer on payday | $6,600.95 | 2.46 | 41.1% |
| 15 Sep 2026 | Deposit | +$450.00 | Transfer on payday | $7,050.95 | 2.63 | 43.8% |
| 30 Sep 2026 | Interest | +$31.40 | Q3 interest | $7,082.35 | 2.64 | 44.0% |
| 15 Oct 2026 | Deposit | +$450.00 | Transfer on payday | $7,532.35 | 2.81 | 46.8% |
Budget or emergency fund? The budget spreadsheet plans a whole year of income, spending and saving, and shows one emergency fund balance per month. This tracker does one job in more depth: it sets the target from an itemised list of essentials, logs each deposit, withdrawal and interest payment, and works out when you reach the goal, with or without interest. Use the budget to find the monthly amount; use this file to follow the fund.
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, colour key, the formulas in plain words, limits, disclaimer |
| Tracker | Months to cover (dropdown, 3–12), balance on a start date, planned monthly contribution, optional APY, optional deadline in months; 11 essential expense lines | Target, current balance, gap, progress % and a text progress bar, months covered, months to goal (NPER with yield, and simple division), projected goal date, monthly saving needed for your deadline, totals of deposits, withdrawals and interest, milestones (1, 3, 6 months and your target), a 60-month projection, a thermometer column and a line chart |
| Log | One row per movement: date, type (Deposit, Withdrawal or Interest), a positive amount and a note. 500 rows. | Signed amount, running balance, months covered and % of target after each row |
| Example / Example Log | Already filled | A fictional household: 15 log rows from January to October 2026, including one withdrawal |
How to use it
- On Tracker, list your essential monthly costs in section 2: housing, utilities, groceries, transportation, insurance, minimum debt payments, phone and internet, childcare, medical. Leave out costs you could pause.
- Pick the number of months to cover in B4. The target appears at once: months × total essentials.
- Type what the fund holds today and today's date as the start balance and start date, then your planned monthly contribution. If the account pays interest, type its APY; otherwise leave it blank.
- On Log, add one row for every deposit, withdrawal and interest payment, oldest first. Type the amount as a positive number and choose the type from the list. Withdrawals turn red.
- Read section 3 on Tracker: current balance, progress, months covered, months to goal and the projected goal date. The milestone table shows when you pass 1, 3 and 6 months of essentials.
- Optional: type a deadline in months in B9 to see the monthly saving needed to reach the target in that time.
- Update your essentials list after a move, a new job or a new child. The target, progress and dates update by themselves.
What official guides say about emergency savings
- The CFPB's essential guide to building an emergency fund says: "The amount you need to have in an emergency savings fund depends on your situation." It suggests you "Think about the most common kind of unexpected expenses you’ve had in the past and how much they cost." That is why the number of months is your input, not a fixed rule.
- On where to keep it, the same guide says: "You want to make sure this fund is safe, accessible, and in a place where you’re not tempted to spend it on non-emergencies." And after you use it: "If you spend down what’s in your emergency savings, just work to build it up again." The Log tab keeps those withdrawals and refills visible.
- Consumer.gov (FTC), Making a Budget: "Saving money can help you during an emergency, or if you need to pay for something bigger, like a car or trip." It adds: "You can even make savings one of the expenses you include in your budget." The planned monthly contribution on Tracker is that budget line.
- The Federal Reserve's Economic Well-Being of U.S. Households in 2025 (May 2026) calls savings that cover three months of expenses after losing a main income "One common measure of financial resiliency". It reports: "In 2025, 55 percent of adults said they had set aside money for three months of expenses in an emergency savings or “rainy day” fund—unchanged from 2024 but down from a high of 59 percent in 2021."
These figures are context, not a target for you. The sheet accepts any number of months from 3 to 12.
The formulas, explained
Exact formulas from the Tracker tab. Inputs: B4 months, B5 start balance, B6 start date, B7 monthly contribution, B8 APY, B9 deadline in months; B24 total essentials.
| Field | Formula |
|---|---|
| Target (B27) | =N(B4)*B24 |
| Current balance (B28) | =N(B5)+SUM(Log!$E$7:$E$506) |
| Progress (B30) | =IF(B27=0,"",MIN(1,MAX(0,B28/B27))) |
| Months covered (B32) | =IF(B24=0,"",B28/B24) |
| As-of date (B33) | =IF(AND(N(B6)=0,COUNT(Log!$A$7:$A$506)=0),"",MAX(N(B6),MAX(Log!$A$7:$A$506))) |
| Monthly rate from APY (B34) | =IF(N(B8)<=0,0,(1+B8)^(1/12)-1) |
| Months to goal, with yield (B35) | =IF(B27=0,"",IF(B28>=B27,0,IF(B34=0,IF(N(B7)>0,(B27-B28)/B7,"Not reachable"),IFERROR(NPER(B34,-N(B7),-B28,B27),"Not reachable")))) |
| Months to goal, no yield (B36) | =IF(B27=0,"",IF(B28>=B27,0,IF(N(B7)>0,(B27-B28)/B7,"Not reachable"))) |
| Projected goal date (B37) | =IF(B27=0,"",IF(B35=0,"Reached",IF(ISNUMBER(B35),IF(B33="","Add a start date",EDATE(B33,ROUNDUP(B35,0))),"Raise the contribution"))) |
| Monthly saving for a deadline (B38) | =IF(OR(N(B9)<=0,B27=0),"",IF(B28>=B27,0,IF(B34=0,(B27-B28)/B9,MAX(0,-PMT(B34,B9,-B28,B27))))) |
| Log: signed amount (E7) | =IF(C7="","",IF(B7="Withdrawal",-ABS(C7),ABS(C7))) |
| Log: balance after (F7) | =IF(C7="","",N(Tracker!$B$5)+SUM($E$7:E7)) |
| Log: months covered (G7) | =IF(OR(F7="",N(Tracker!$B$24)=0),"",F7/Tracker!$B$24) |
| Thermometer, conditional format on F4:F23 | AND(ISNUMBER($B$30),$B$30>0,$B$30>=(23-ROW())/20) |
NPER answers "how many monthly deposits until the balance, growing at the monthly rate, reaches the target?" It assumes the deposit lands at each month end. When the APY is blank or 0, NPER is skipped and the sheet uses plain division, so a 0% account still gets an answer. If the contribution is 0 and there is no interest, the sheet says "Not reachable" instead of an error. The APY is turned into a monthly rate with (1+APY)^(1/12)−1, so 12 months of compounding equal the APY.
Worked example from the sample data
The target
| Essential expense (fictional) | Monthly |
|---|---|
| Rent or mortgage | $1,250.00 |
| Utilities (power, water, heating) | $170.00 |
| Groceries | $480.00 |
| Transportation (fuel, transit, car payment) | $240.00 |
| Insurance (health, car, home, renters) | $190.00 |
| Minimum debt payments | $120.00 |
| Phone and internet | $95.00 |
| Childcare | – |
| Medical and prescriptions | $55.00 |
| Other essential 1 | $80.00 |
| Other essential 2 | – |
| Total essentials | $2,680.00 |
Six months × $2,680.00 = $16,080.00.
Balance and coverage
Start $2,400.00 + deposits $5,700.00 + interest $72.35 − withdrawals $640.00 = $7,532.35. That is 46.8% of the target and $7,532.35 ÷ $2,680.00 = 2.81 months of essentials. The car repair on 28 May cut coverage from 1.74 to 1.50 months; the Log shows the dip and the refill after it.
Months to goal and goal date
Gap: $16,080.00 − $7,532.35 = $8,547.65. Without interest: $8,547.65 ÷ $450 = 18.99 months. With a 3% APY the monthly rate is (1.03)^(1/12) − 1 = 0.2466%, and NPER(rate, −450, −7532.35, 16080) = 17.87 months. Rounded up to 18 months from the as-of date (15 Oct 2026), the projected goal date is 15 Apr 2028. The projection reaches $16,145.89 that month, after $15,657.28 the month before.
To hit the target in 24 months instead, the sheet's PMT line shows $327.58 a month would be enough at the same APY.
Milestones
| Milestone | Amount | Months to reach | Projected date |
|---|---|---|---|
| 1 month of essentials | $2,680.00 | 0 (reached) | Reached |
| 3 months of essentials | $8,040.00 | 1.1 | Dec 2026 |
| 6 months of essentials | $16,080.00 | 17.9 | Apr 2028 |
The household is past one month of essentials and is projected to pass three months in two contributions. Projections assume the same deposit every month and no further withdrawals.
Common mistakes
- Using total spending instead of essentials. The target is meant to cover costs you must pay. Including every want makes the goal bigger than it needs to be.
- Typing withdrawals as negative numbers. Type a positive amount and choose "Withdrawal"; the sheet sets the sign.
- Forgetting the start balance. If the fund already holds money, put it in B5 with a start date, then log only movements after that date.
- Treating the projected date as a promise. It assumes a fixed contribution, a fixed APY and no withdrawals. Re-read it after each change.
- Typing the APY as 3 instead of 3%. The cell expects a percentage; the sheet rejects values above 20%.
- Never updating essentials. Rent and insurance change. An old list makes the coverage figure look better than it is.
FAQ
How much should be in an emergency fund?
There is no single number. The CFPB says the amount you need "depends on your situation" and suggests thinking about "the most common kind of unexpected expenses you’ve had in the past and how much they cost". A common way to set a goal is a number of months of essential expenses; the Federal Reserve's household survey uses three months as its measure. This tracker lets you pick 3 to 12 months and multiplies that by your essential monthly costs.
How do you calculate how long it will take to build an emergency fund?
Without interest, divide the gap (target minus what you have) by what you add each month. With interest, use NPER: =NPER(monthly rate, -monthly contribution, -current balance, target). In the example, the gap is $8,547.65 and the contribution is $450, so simple division gives 19.0 months; with a 3% APY, NPER gives 17.9 months, rounded up to 18.
What expenses count toward an emergency fund target?
Only costs you would still have to pay if your income stopped: housing, utilities, groceries, transportation, insurance, minimum debt payments, phone and internet, childcare and medical costs. Leave out spending you could pause, such as dining out or travel. A smaller, honest essentials list gives a smaller target that is still realistic.
Where should you keep an emergency fund?
The CFPB says you want the fund to be "safe, accessible, and in a place where you’re not tempted to spend it on non-emergencies", and lists a bank or credit union account, a prepaid card or cash as options, noting that cash can be stolen, lost or destroyed. If your account pays interest, type its APY into the tracker.
How many Americans have three months of emergency savings?
In the Federal Reserve's Economic Well-Being of U.S. Households in 2025 report (May 2026), 55 percent of adults said they had set aside money for three months of expenses in an emergency savings or "rainy day" fund, unchanged from 2024 and down from 59 percent in 2021.
Can I use this emergency fund tracker in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Drive and open it with Google Sheets. The formulas use functions that exist in Excel 2016+, Google Sheets and LibreOffice (NPER, PMT, EDATE, SUMIFS, REPT), and the progress column uses plain conditional formatting.
Related tools and templates
- Budget spreadsheetFind the monthly amount to save
- Net worth trackerAssets minus debts over time
- Compound interest spreadsheetHow a balance grows with interest
- Compound interest calculatorQuick growth estimate online
- FIRE calculator spreadsheetLong-term savings goal
- Net worth percentile calculatorCompare your net worth
- All templatesFree spreadsheets
Educational template only, not financial advice. The tracker does not account for taxes on interest, inflation or changing rates. Example data is fictional: the household, expenses, deposits, withdrawal, interest and the 3% APY are made up. CFPB, Consumer.gov and Federal Reserve material was retrieved on 29 October 2026.