Spreadsheets

Emergency fund tracker sheet showing months of expenses covered

An emergency fund tracker sheet that averages your essential monthly spend, divides your balance by it to show months of cover, with a target and top-up plan.

Editorial illustration for Emergency fund tracker sheet showing months of expenses covered

To see how many months of expenses your emergency fund covers, divide the balance by your average monthly essential spending. The sheet pulls that average from an expenses tab, divides the fund by it, and shows months of cover next to a target you choose. A top-up cell then tells you how long closing the gap will take.

What goes on the expenses tab?

Start with a tab named Expenses. Add one row per expense from the last few months, taken from your bank and card statements.

ColumnHeadingNotes
ADateDate of the expense
BCategoryRent, groceries, EMI, fuel, dining out
CAmount (₹)Amount spent
DEssential?Yes or No

Essential means spending you could not drop quickly if income stopped: rent or home loan EMI, groceries, utilities, insurance premiums, school fees, transport to work, minimum repayments. What counts is a personal call, so decide your list once and keep it fixed.

How do I calculate average monthly essential spend?

On a Summary tab, use these cells.

  • Essential total: =SUMIFS(Expenses!$C$2:$C$1000, Expenses!$D$2:$D$1000, "Yes")

Number of months covered, in B2: =(YEAR(MAX(Expenses!$A$2:$A$1000))-YEAR(MIN(Expenses!$A$2:$A$1000)))*12+MONTH(MAX(Expenses!$A$2:$A$1000))-MONTH(MIN(Expenses!$A$2:$A$1000))+1

Average monthly essential spend in B3: =B1/B2, where B1 holds the essential total. Use at least three months and, if you can, six so that one odd month does not distort the figure.

What does the calculation look like?

Say your essential spend over six months was ₹38,000, ₹41,000, ₹39,500, ₹42,500, ₹40,000 and ₹39,000. The total is ₹2,40,000, so the average is 2,40,000 / 6 = ₹40,000. If your emergency fund balance is ₹1,60,000, months of cover is 1,60,000 / 40,000 = 4.0 months. These amounts are made up.

CellLabelFormulaExample result
B3Average essential spend=B1/B2₹40,000
B4Emergency fund balancetyped in₹1,60,000
B5Months of cover=B4/B34.0
B6Target monthstyped in6
B7Target amount=B6*B3₹2,40,000
B8Gap=MAX(0,B7-B4)₹80,000

How do I build a top-up plan?

Enter the amount you can put aside each month in B9. Months to reach the target is =IF(B9<=0, "Set a monthly amount", ROUNDUP(B8/B9, 0)). With a gap of ₹80,000 and ₹8,000 a month, that is 10 months. Change B9 to see how the time changes. Choose the target months yourself, by thinking about how stable your income is and how many people depend on it; this sheet does not recommend a number.

What should count as the fund balance?

  • Money kept aside only for emergencies, in a place you can reach quickly
  • Not money earmarked for a holiday, a wedding or a down payment
  • Not an investment whose value moves; if you include one, note it and decide how to treat that risk

Update the balance on the same date every month and keep a small log of withdrawals with the reason.

How do I handle yearly bills?

Insurance premiums or school fees paid once a year should be spread over twelve months or the average will look low in most months and jump in one. Add a line to the essential total for each: yearly amount divided by 12. A premium of ₹24,000 a year adds ₹2,000 to the monthly essential figure. Add it to B1 once, rather than letting it appear in a single month of the expenses tab.

Where can an app help?

Filling the expenses tab by hand is the slow part. SpendixAI can import your statements and let you review the rows, with categories you can report on, and a report can be downloaded as CSV to paste into this sheet. You then only mark each category as essential or not.

Monthly routine

  1. Add the month's expenses and mark essentials
  2. Update the fund balance
  3. Read months of cover against your target
  4. Adjust the top-up amount if needed
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports