Emergency Fund Spreadsheet That Fits Your Real Month

Hey folks, it's Ren here.

The dishwasher died on a Wednesday. No drama. It just stopped halfway through a cycle, made one apologetic noise, and would not come back on. I stood there with a wet plate in my hand and did the maths in my head while the kettle boiled.

About eight hundred dollars for a replacement. About two weeks for the new one to arrive. About three weeks of handwashing in the meantime.

What it did not become, because of the small fund sitting quietly in a separate account, was a financial event. It was an inconvenience.

Worth saying, because most of life's actual emergencies are not actual emergencies. They are inconveniences with a price tag. A real emergency fund is built around the second category, not the first.

That distinction is the whole point of a good emergency fund spreadsheet: a number that fits your real month, with usage and replenishment tracked on the same page.

"Do not save what is left after spending; spend what is left after saving." — Warren Buffett

🧾 Why the three-to-six-months rule is the wrong starting number

Almost every emergency fund article opens with the same line. Save three to six months of income. It is repeated so often it sounds like a law. It is not. It is a rough rule of thumb that was useful in the 1990s and is now the wrong starting number for most people who hear it.

Two problems. The first is income. Your emergency fund does not need to replace income; it needs to cover essential outgoings. A household earning ten thousand a month but spending three thousand on essentials does not need a thirty thousand fund. It needs a nine to eighteen thousand fund, depending on the other levers.

The second is the levers. Job stability, household earner redundancy, and how long your industry takes to rehire all change the number meaningfully.

Please do not be hard on yourself if the standard rule made the target feel impossible. The target was usually wrong.

What actually moves the number:

• Monthly essential outgoings (housing, utilities, food, insurance, minimum debt). Not lifestyle.
• Job stability tier. A public-service salary, a contractor, and a small-business owner have very different exposure.
• Earner redundancy. One-income household carries the whole risk; a two-income household carries half each.
• Industry rehire time. Average weeks to a new role in your field. Not the optimistic version.

💰 What an emergency fund spreadsheet actually needs to show

Four numbers, on one page, all visible at once.

The target (calculated from real expenses, not income). The current balance. The usage log, showing every dollar pulled out and what it was for. The replenishment plan, showing how the fund refills after a draw.

The usage log is the bit most articles leave out. People build the fund up over a year, then a real expense lands, and the spreadsheet goes back to looking like a balance graph with a dip in it. The dip is the most useful data on the page. It is the story of what actually happened and how long the refill took.

🛠️ How to set up an emergency fund spreadsheet

About thirty minutes in Google Sheets or Excel. Five columns plus a small target panel.

1. Essential monthly outgoings. Add them up. Housing, utilities, food, insurance, minimum debt repayments. Lifestyle goes in a different bucket.
2. Months of cover target. Three months if you have two earners and stable work. Six months if you have one earner or unstable work. Nine months if you are self-employed, single-income, or in a slow-to-rehire industry. Target = essential outgoings × months.
3. Balance and last updated. One row for the current fund balance and the date you last checked it. Updated monthly is plenty.
4. Usage log. One row per draw. Date, amount, what it was for, balance after. Even small draws count. The log is the diagnostic.
5. Replenishment plan. After a draw, the monthly amount you will redirect from regular savings until the fund is back to target. Set it the same week as the draw or it does not happen.

If running the numbers manually is the bit that stops you starting, our free savings calculator will do the target maths in a couple of clicks.

⚠️ Mistakes to sidestep

• Pegging the target to income. Fix it: peg it to essential outgoings. The two numbers can be three times different and the income version usually overshoots into discouragement.
• Hiding usage as "miscellaneous spending". Fix it: a real draw goes in the usage log, dated. The log is what tells you whether the fund actually does its job.
• Not setting the replenishment plan the same week as the draw. Fix it: set it the same day. Otherwise the fund never returns to target and the next draw lands lower.
• Treating the fund as flexible savings. Fix it: separate account, separate purpose. Mixing it with "saving up for something" kills both jobs.

If you want the full plan the fund sits inside, the savings planner guide walks through the broader savings architecture.

🎯 Your action steps this week

• Add up your essential monthly outgoings. Be honest about essential.
• Pick the months-of-cover number based on your earner and stability situation.
• Multiply to get the target. That number is yours, not the rule of thumb's.
• Open a sheet with the five columns above and set the target panel.
• If you have already drawn from your fund this year, also run the sinking fund tracker spreadsheet guide, since most non-emergency big expenses belong there instead.

💬 Common situations

If you have just started and the target feels impossible

Aim for a one-month buffer first. Just one. The leap from zero to one is by far the most psychologically valuable, because it changes what an unexpected bill feels like. Anything above one month is a continuation of the same monthly habit. The first month is the lift, the rest is compounding.

If you have a partner and you both earn

Your earner redundancy halves the risk, but only if both incomes can independently cover essential outgoings. If one income alone falls short, you are effectively a one-earner household for risk purposes. Run the target on the lower income covering essentials, not on the combined number.

If you are self-employed or your income is irregular

Push the target out to nine months and tag each month as either a good or lean month in the log. Lean months are when the fund earns its keep; good months are when replenishment happens. The pattern matters more than the rolling average.

The dishwasher arrived eleven days later. The fund went down, then back up over the next three months. The thing it bought was not the dishwasher. It was the calm to make a decision while a wet plate dripped on the floor.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.