Skip to content
The title slide and first slides of the TFSA Contribution Tracker template

TFSA Contribution Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

People with a TFSA at more than one institution use this sheet to get a full view. The Transactions tab holds each deposit, withdrawal and direct transfer. The Accounts tab shows every account with its balance and net money in. The Room tab adds new room, unused room and last year's withdrawals, then subtracts deposits. The Dashboard charts room against use and shows activity by account.

Take new and unused room from your CRA My Account instead of guessing, and update it after each January. Mark direct transfers with the Transfer type so they are not counted as deposits. Review the Years over room figure on the Dashboard; any count above zero is a prompt to look at that year and ask a tax professional what to do.

Useful for

  • Count room across several TFSA accounts
  • See when a withdrawal can be put back
  • Keep deposits and transfers apart

What's included

  • 5 tabs: Dashboard, Transactions, Accounts, Room, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Transactions: a table
  • Accounts: a table
  • Room: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Transactions tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why are withdrawals added back to the next year?

A withdrawal does not restore room right away. The room returns on January 1 of the following year. The Room tab uses the prior year withdrawals for that reason, so you can plan a re-deposit.

Where do I find my TFSA room?

Your CRA My Account lists your room for the year. Enter it in the Room tab as new room and unused room. This sheet does not contain the yearly figure because it changes and depends on your history.

Is a transfer between banks a deposit?

Not when it is a direct transfer between TFSAs. Use the Transfer in and Transfer out types so the Room tab ignores them. A withdrawal followed by a new deposit is different and counts against room.

  • #tax-tracker
  • #tfsa-contribution-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…