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

Canada Medical 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

Families use this tracker to gather medical receipts before filing. The Expenses tab lists each bill with who it was for, the type, the amount paid and any amount paid back. The Family tab totals each person. The Claim tab compares counted costs with a threshold built from your net income and two CRA figures that you type in, then shows an estimated claim. The Dashboard charts costs by person and by type.

Add a bill right after you pay it and save the receipt in a folder with the same date. Fill in the paid-back column when the insurer pays, so only your net cost counts. Choose the claim period with your tax professional, mark which bills fall in it and decide who will claim. The estimate is only a guide and the final claim is worked out on your return.

Useful for

  • Gather medical receipts for each family member
  • Choose which spouse should claim the costs
  • Compare totals with the threshold before filing

What's included

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

Which expenses are eligible?

The CRA publishes lists of eligible medical expenses and the rules for the claim period. This tracker records costs and lets you mark each one, but it does not decide eligibility. Check the CRA list or ask a tax professional.

Why are there two CRA figures on the Claim tab?

The claim usually starts after a threshold that depends on a share of net income and a fixed amount, and the lower one applies. Both are set by the CRA and change by year, so you type them in.

Who should claim the expenses?

Either spouse or common-law partner can often claim for the family, and the best choice depends on both returns. Fill in the Claim tab for each person and ask a tax professional which result you prefer.

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

Also in Finance

All finance templates
Get this template

Preparing your template…