Skip to content
The title slide and first slides of the Canada Charitable Donation Tracker template

Canada Charitable Donation Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Donors who give to several charities use this tracker to get the donation credit ready on their return. The Receipts tab lists each gift with the receipt number, any benefit received, the eligible amount and who will claim it. The Charities tab groups giving by cause with registration numbers. The Carry tab compares eligible gifts with what was claimed each year and shows the use-by year. The Dashboard charts giving by cause and by year.

Ask for an official receipt when you give and enter its number right away. Subtract the value of any ticket, meal or gift you received, since only the eligible part counts. Mark receipts that are pending or missing and chase them before you file. Enter what you claimed each year on the Carry tab to see what is left, and ask an accountant how spouses should split claims.

Useful for

  • Collect official receipts before filing
  • Carry unclaimed gifts to a later year
  • Compare giving by cause and by year

What's included

  • 5 tabs: Dashboard, Receipts, Charities, Carry, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Receipts: a table
  • Charities: a table
  • Carry: 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 Receipts 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

What counts as an eligible gift amount?

It is the gift minus the value of anything you received in return. The Receipts tab does the subtraction for you. The charity's official receipt normally states the eligible amount, so match your row to it.

Can I claim donations in a later year?

Unclaimed gifts can often be carried forward for a limited number of years under the CRA rules. Enter that number on the Carry tab and the sheet shows the last year each gift can be used.

Do the sample registration numbers mean anything?

No. They are placeholders in the format charities use. Replace each one with the registration number printed on your receipt, and check the charity is registered on the CRA list.

  • #tax-tracker
  • #canada-charitable-donation-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…