FHSA Savings Tracker Excel - Free Template

1. Open the FHSA Contributions sheet and enter each deposit or withdrawal on its own row. Use the date, contributor name, institution, and transaction type exactly as they occurred.
2. Check the Opening Room, New Room Added, and Available Contribution Room columns before you add a new contribution. This helps you stay within your room and avoid a correction later.
3. Enter the contribution amount and, if needed, a withdrawal amount on the same line. If you have multiple transactions in a month, record each one separately so the balance stays clear.
4. Adjust the Growth Rate field when your expected return changes. The template uses that rate to estimate investment growth and show a more realistic closing balance.
5. Review the FHSA Dashboard after each update. Use it to confirm your latest balance, room usage, and overall progress toward your home-saving target.
6. Read the Instructions sheet if you need a reminder on how the layout works. Keep your workbook saved by tax year or by account holder if you are tracking more than one FHSA.

This spreadsheet is for the person who wants to keep an FHSA accurate without opening a full accounting system. A first-time homebuyer can use it after each paycheque deposit, while a couple can keep separate lines for two accounts and compare balances before a house hunt starts.

Where it fits in real life

A salaried employee might add $300 every two weeks, then check the dashboard at month-end to see whether the account is on pace for a $16,000 target. A self-employed person can use the same file to record a $2,000 lump-sum contribution after a strong quarter and keep the paper trail in one place.

Why the sheet is laid out this way

The FHSA Contributions sheet matches the way people actually save: one line per transaction, one balance after another, no hidden logic to guess through. The FHSA Dashboard is there for the quick answer when you want to know, in ten seconds, how much room you have left and how much your account is worth today.

The FHSA is a registered savings plan, so your record-keeping should be specific, not casual. In 2026, the annual contribution limit is $8,000 and the lifetime limit is $40,000, so a tracker like this helps you spot when a $5,000 deposit still leaves room or when two deposits have already used most of the annual cap.

The numbers you need to watch

If you put in $8,000 in January and another $1,000 in March, you are over the annual limit by $1,000 before you even look at investment growth. That is the kind of mistake this sheet prevents, because it shows opening room, new room added, and available room on the same row.

How this relates to CRA records

You do not need a heavy system for an FHSA, but you do need clean support for your deposits and withdrawals. Keep the workbook with your tax files for at least the CRA’s six-year retention window so you can answer questions about timing, amounts, and any deduction you claimed.

Those same files become part of your annual support package, and a balance sheet template can keep the year-end figures organized alongside the FHSA records you retain for CRA review.

The most common error is recording the contribution date loosely and then losing track of which tax year the deposit belongs to. If you make a $4,000 deposit on 2026-12-30 but only enter it in January, your year-end numbers can look fine on paper while your deduction claim and contribution room no longer line up.

Small mistakes that turn into real costs

Another mistake is treating growth like a guess and never updating the rate. If a $10,000 balance grows at 5.0% instead of 2.0%, the estimated year-end value differs by about $300 after one year, which is enough to distort your saving target if you are planning a home purchase.

Why withdrawal lines matter

People also forget to record withdrawals separately, then wonder why the balance in the bank and the balance in the sheet do not match. If you withdraw $3,500 for a down payment-related transfer and leave it out, the tracker can overstate your available funds by exactly that amount until you fix the row.

That same record-keeping becomes even more important when the withdrawal is meant to be offset later, because an RRSP room tracker keeps the contribution and withdrawal side of the plan aligned.

The easiest way to keep this file alive is to update it on the same day you move money into the FHSA. For most people, that means one set date each month, or the same day you review your paycheque and savings transfers.

Simple habits that keep it current

• Update the sheet right after each contribution, not at month-end when receipts are already mixed together.
• Copy last month’s growth rate if your investment mix has not changed, then revisit it after a quarter-end statement.
• Use the dashboard first, then the ledger, so you can spot errors faster than scrolling through every row.
• Save one workbook per account holder if two people are saving separately; that keeps room totals from being crossed.

Once you have enough transactions that the balance no longer explains itself, you have outgrown a simple tracker and should move to a more complete portfolio or tax system. Until then, this file is enough for a clean, practical FHSA routine.