Emergency Fund & Sinking Funds Tracker
Size your emergency fund from your real essentials, then plan savings for known costs like car repairs, gifts and vacations.
MTC_Emergency_Fund_Sinking_Funds_Tracker_2026.xlsx· 16 KB
Opens in Excel, Apple Numbers and Google Sheets (File, then Import).
- One-click download
- Free, no subscription
- Mac, PC & Mobile
- 100% Private & Offline
Canadian-Specific
Key Features & Capabilities
Designed specifically around Canadian payroll, tax forms, and account structures:
- Emergency fund goal built from your essential monthly costs × 3 to 12 months
- See how many months until you reach it at your current savings rate
- Sinking funds: what to set aside each month for each future cost
- Progress bar per fund, fed by a simple deposit log
- Dropdowns keep fund names consistent
Complete Toolkit
What's Inside (4 Components)
Everything you receive immediately upon download:
- How to use guide
- Emergency Fund calculator
- Sinking Funds (20 goals)
- Deposits log (200 rows)
Detailed Walkthrough
Stop being surprised by bills you knew were coming
An emergency fund covers the unexpected. Sinking funds cover the expected: car repairs, holiday gifts, insurance renewals, vacations. This free tracker plans both, so neither one drains the other.
How big should your emergency fund be?
Most planners suggest 3 to 6 months of essential costs: housing, utilities, groceries, transportation, insurance and minimum debt payments. The tracker adds them up, multiplies by the months you choose, and shows how long it takes at your monthly contribution.
Sinking funds
List each future cost with its amount and due date. The sheet works out the monthly amount to set aside and tracks progress as you log deposits.
Where to keep the money: a high-interest savings account or cash in a TFSA keeps it safe and easy to reach. Compare current rates on our free savings and GIC rate pages.
Target Audience
Who This Template Is For
Frequently asked questions
How much should I have in an emergency fund in Canada?
A common target is 3 to 6 months of essential expenses. Choose more if your income is irregular or you are the only earner.
What is a sinking fund?
Money you set aside a little at a time for a cost you know is coming, like car maintenance or holiday gifts, so it doesn't hit one paycheque.
Does it work in Google Sheets and on a Mac?
Yes. It is an Excel workbook (.xlsx) that opens in Excel for Windows and Mac, Apple Numbers, and Google Sheets (upload it to Drive, then open with Google Sheets). Formulas recalculate as you type.
You Might Also Like
Other curated spreadsheets for Canadian finances
Free
Excel · Google Sheets
Budgeting & Debt
Canadian Personal Budget & Net Worth Dashboard (50/30/20)
Master your monthly cash flow, crush debt with snowball/avalanche, and track your growing net worth in Canadian dollars.
Free
Excel · Google Sheets
Budgeting & Debt
Bi-Weekly Paycheque Budget Planner
Budget by paycheque, not by month: assign each bill to the pay that covers it, and plan the two extra paycheques you get each year.
Free
Excel · Google Sheets
Budgeting & Debt
Debt Snowball & Avalanche Payoff Planner
Enter up to six debts, pick snowball or avalanche, and see your debt-free date, total interest and a month-by-month payoff schedule.