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.

Download Excel template (.xlsx) 86 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 29 Oct 2026

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.

Preview: the Example and Example Log tabs for a fictional household with $2,680.00 of essential monthly costs, a 6-month target, $450 a month and a 3% APY (an example assumption, not a quoted rate). All amounts are made up.
$16,080.00target (6 months × $2,680.00)
$7,532.35current balance on 15 Oct 2026
2.81months of essentials covered
17.9months to goal (with 3% APY)
Apr 2028projected goal date
$8,547.65gap to target

Progress to target: 46.8%

Example tab: fund balance from $2,400.00 on 2 Jan 2026 to $7,532.35 on 15 Oct 2026 (solid), then the projection with $450 a month at 3% APY (dashed) crossing the $16,080.00 target in Apr 2028$0$5,000$10,000$15,000$20,000Jan 2026Jul 2026Jan 2027Jul 2027Jan 2028Target $16,080 (6 × $2,680)−$640 car repairApr 2028: $16,146Solid: logged balance. Dashed blue: projection. Dashed gold: target. All fictional.
DateTypeAmountNoteBalance afterMonths covered% of target
15 Jan 2026Deposit+$450.00Transfer on payday$2,850.001.0617.7%
15 Feb 2026Deposit+$450.00Transfer on payday$3,300.001.2320.5%
15 Mar 2026Deposit+$450.00Transfer on payday$3,750.001.4023.3%
31 Mar 2026Interest+$18.20Q1 interest$3,768.201.4123.4%
15 Apr 2026Deposit+$450.00Transfer on payday$4,218.201.5726.2%
15 May 2026Deposit+$450.00Transfer on payday$4,668.201.7429.0%
28 May 2026Withdrawal−$640.00Car repair$4,028.201.5025.1%
15 Jun 2026Deposit+$450.00Transfer on payday$4,478.201.6727.8%
30 Jun 2026Interest+$22.75Q2 interest$4,500.951.6828.0%
15 Jul 2026Deposit+$450.00Transfer on payday$4,950.951.8530.8%
20 Jul 2026Deposit+$1,200.00Part of a tax refund$6,150.952.3038.3%
15 Aug 2026Deposit+$450.00Transfer on payday$6,600.952.4641.1%
15 Sep 2026Deposit+$450.00Transfer on payday$7,050.952.6343.8%
30 Sep 2026Interest+$31.40Q3 interest$7,082.352.6444.0%
15 Oct 2026Deposit+$450.00Transfer on payday$7,532.352.8146.8%

Start balance $2,400.00 on 2 Jan 2026. The chart and table are drawn from the recalculated workbook. In the file, a column of cells fills like a thermometer as the balance grows, and a native Excel line chart shows the projection against the target.

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

TabWhat you typeWhat it calculates
Start hereNothingSteps, colour key, the formulas in plain words, limits, disclaimer
TrackerMonths to cover (dropdown, 3–12), balance on a start date, planned monthly contribution, optional APY, optional deadline in months; 11 essential expense linesTarget, 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
LogOne 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 LogAlready filledA fictional household: 15 log rows from January to October 2026, including one withdrawal

How to use it

  1. 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.
  2. Pick the number of months to cover in B4. The target appears at once: months × total essentials.
  3. 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.
  4. 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.
  5. 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.
  6. Optional: type a deadline in months in B9 to see the monthly saving needed to reach the target in that time.
  7. 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

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.

FieldFormula
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:F23AND(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

MilestoneAmountMonths to reachProjected date
1 month of essentials$2,680.000 (reached)Reached
3 months of essentials$8,040.001.1Dec 2026
6 months of essentials$16,080.0017.9Apr 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

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

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.