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

RESP Contribution Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

An RESP has two moving parts: your own deposits and a government grant that depends on them. Beneficiaries stores each child with a lifetime limit, a grant rate and a yearly grant maximum, all typed in from CRA or provider figures, and shows contributed, room left, grant earned and grant still to receive. Contributions logs each deposit in Canadian dollars with who paid it.

Grants needs one row per child and year. It totals what you contributed that year, works out the grant at your rate up to the yearly maximum, and compares it with the grant your provider paid. In the sample, a 2026 deposit year for each child has earned $980 in grants that has not been received. Carry-forward room is not modeled, so add it by hand if you use it.

Useful for

  • Catch a grant that was earned but never paid
  • See how much lifetime room is left for each child
  • Record deposits from parents and grandparents separately

What's included

  • 4 tabs: Beneficiaries, Contributions, Grants, How to use
  • Beneficiaries: a table with 3 summary figures
  • Contributions: a table
  • Grants: a table with 3 summary figures
  • 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 Beneficiaries 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 track RESP contributions?

Record each deposit with the date and the child, then total them by year. Compare each year with the grant your provider shows to confirm the match was paid.

How much grant money do I get on RESP contributions?

The government sets a grant rate and a yearly maximum, and both can change. Look up the current figures with the CRA and type them in, as the sheet does not build them in.

What is the RESP lifetime contribution limit?

It is a cap on total deposits per beneficiary set by federal rules. Type the CRA figure into Beneficiaries and the remaining room appears beside each child.

  • #investment-tracker
  • #resp-contribution-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…