General information only — not financial advice. If money stress or debt is hard to manage, free help is available via the National Debt Helpline on 1800 007 007.
An emergency fund is money for things you did not plan: a car repair, a jumped power bill, reduced hours. It is not Christmas, a holiday, or a new phone. Those are goals. An emergency is something that would otherwise land on a credit card.
In Australia a lot of people are paid weekly or fortnightly, while big bills still arrive in lumps. A small spreadsheet can turn "I should save more" into a starter buffer, then a months-of-essentials target, with payday amounts you can actually transfer. It takes about ten minutes to build in Google Sheets or Excel.
The sheet layout
Labels in column A, values in column B:
| Cell | Label | Example |
|---|---|---|
| B1 | Essentials per fortnight (AUD) | 1800 |
| B2 | Pay cycle | FORTNIGHT (or WEEK) |
| B3 | Starter buffer target | 1000 |
| B4 | Months of essentials goal | 3 |
| B5 | Payday transfer you can stick to | 60 |
| B6 | Amount already saved | 0 |
Essentials means rent or mortgage, groceries, utilities, phone and internet, transport, insurance, minimum debt repayments, and unavoidable childcare or school costs if they apply — not takeaway and streaming extras.
Core formulas
Convert essentials to a monthly figure (useful for the "months of essentials" target):
B8 Essentials per month =IF(B2="WEEK",B1*52/12,B1*26/12) B9 Deep target (AUD) =B8*B4 B10 Still needed (starter) =MAX(0,B3-B6) B11 Still needed (deep) =MAX(0,B9-B6) Using the example inputs: essentials ≈ A$3,900/month, deep target ≈ A$11,700. That number looks huge from zero. Hitting a starter buffer of A$500–A$1,000 first is the point of the model — behaviour changes when the next surprise does not automatically go on credit.
Payday math (the useful bit)
How many paydays until each target at your planned transfer:
B13 Paydays to starter =IF(B5<=0,"",CEILING(B10/B5,1)) B14 Paydays to deep =IF(B5<=0,"",CEILING(B11/B5,1)) Or flip it: given a deadline in paydays, what transfer do you need?
B16 Paydays available (starter) 20 B17 Required transfer (starter) =IF(B16<=0,"",B10/B16) B18 Paydays available (deep) 78 B19 Required transfer (deep) =IF(B18<=0,"",B11/B18) Worked examples (same as the longer guide's pay-cycle maths):
- Starter A$1,000 ÷ 20 fortnights = A$50 a fortnight
- Or A$1,000 ÷ 10 fortnights = A$100 a fortnight if you can stretch
- Even A$20 a week is A$1,040 in a year
The amount matters less than that it leaves every payday before the account feels spendable. If A$60 does not fit this fortnight, drop to A$20 rather than pausing.
Weekly vs fortnightly
If you are paid weekly, keep B1 as essentials per week and set B2 to WEEK so B8 annualises correctly (*52/12). If you are paid fortnightly, enter essentials per fortnight and use *26/12. Do not mix a fortnightly essentials figure with a weekly transfer without converting — either keep everything on one cycle or add:
B20 Weekly equivalent of B5 =IF(B2="WEEK",B5,B5/2) B21 Fortnightly equivalent =IF(B2="WEEK",B5*2,B5) Irregular income
Casual, commission and side-hustle pay vary. Size B1 from a cautious recent fortnight (or week), not a lucky one, so the deep target is not built on a peak month. Recalculate B8–B11 when hours change.
Two rules next to the numbers
Add a short notes area on the same sheet:
- What counts as an emergency — car or appliance repair, urgent medical gap, short work gap, unexpected bond. Not planned Christmas or annual insurance (those are sinking funds: for example rego ÷ 26 beside the emergency fund).
- How you refill — after a withdrawal, keep B5 running until B6 is back to the last target before growing further.
Park the money in a separate account nicknamed Buffer or Emergency, with a recurring payday transfer and same-day or next-day access. Locking it into something hard to unwind can backfire when the car dies on a Tuesday.
The one-line version
Deep target = (essentials per pay × pays per year / 12) × months Payday transfer = still_needed / paydays_available Recalculate when rent, hours or dependants change. A quarterly glance is enough: Is the starter intact? Is the transfer still leaving every payday? Do essentials still look right?
Want the longer walkthrough (or the planner)?
I wrote the full Australian guide here: How to Build an Emergency Fund in Australia (Starter Buffer to 3 Months of Essentials).
If you want the tracker already built — any pay frequency rolled into one monthly view, essential vs flexible costs, and an emergency-fund target in months of essentials — the Single Income Family Budget Planner is Excel and Google Sheets in AUD. It is a budgeting tool, not financial advice. (Disclosure: I write these guides and sell the template.)
Not financial advice. Figures are examples only.


