Skip to content
The title slide and first slides of the Canada Childcare Expense Tracker template

Canada Childcare Expense 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

Parents paying for daycare, camps or a caregiver use this tracker to build the childcare expense deduction. The Payments tab logs each payment with the child, provider, type of care and receipt status. The Children tab holds each child with a limit you enter and shows what is paid and what remains. The Providers tab lists each provider and whether their tax ID is on a receipt. The Dashboard charts paid against limit per child and spending by type of care.

Ask for a receipt each time you pay and note the provider's tax ID the first time. A caregiver paid privately may not give a receipt automatically, so ask early. Look at the Providers tab each month for red rows. Limits and rules differ for each child and each type of care, so confirm them with the CRA and ask an accountant which spouse should claim.

Useful for

  • Total childcare payments for each child
  • Check every provider receipt before filing
  • Decide which parent claims the deduction

What's included

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

Where do I find the limit for each child?

The CRA publishes the limits and the conditions, which depend on the age of the child and on the type of care. Type the amount into the Children tab. No limit is built in, because it can change.

What should a childcare receipt show?

Ask for the provider's name, the dates, the amount paid and their tax ID. The Providers tab has an ID column, so an empty cell shows which provider still owes you that detail.

Which parent claims the expense?

Often the lower income spouse claims, with some exceptions set by the CRA. Fill the Claimed by column on the Children tab and review your case with a tax professional.

  • #tax-tracker
  • #canada-childcare-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…