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

RRSP Contribution Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Canadians who save into an RRSP, a spousal plan or a group plan use this tracker to keep deposits in one list. The Contributions tab records the date, plan, amount, return year and slip status. The Room tab holds the deduction limit from your notice of assessment for each year and works out what is used and what is left. The Dashboard shows a plan breakdown and a chart of room against deposits.

Type the limit exactly as it appears on your latest notice, because it changes with income, pension adjustments and past use. Mark the return year as you deposit, not at filing time, so deposits made right after New Year land on the right return. Chase any row marked Missing before you file, and read the Check column for a warning if a year looks over its limit.

Useful for

  • Match deposits to the notice of assessment room
  • Separate own, spousal and group plan deposits
  • Find missing contribution slips before April

What's included

  • 4 tabs: Dashboard, Contributions, Room, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Contributions: 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 Contributions 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

How do I find my RRSP deduction limit?

It is printed on your notice of assessment and shown in your CRA My Account. Type that figure into the Room tab for the year. The sheet does not hold a fixed limit because the number differs for each person and each year.

Which return does a deposit belong on?

Deposits made early in the new year can usually be deducted on the previous year, as the CRA sets out. Check the deadline on the CRA site, then choose the return year in the Contributions tab.

Does this sheet file anything with the CRA?

No. It is a working record to share with your tax professional. You still enter deductions on your return and keep the slips in case the CRA asks.

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

Also in Finance

All finance templates
Get this template

Preparing your template…