Skip to content
The title slide and first slides of the Canada Rental Income Tracker template

Canada Rental Income 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

Landlords with one or more properties use this tracker to get ready for the rental form of their Canadian return. The Properties tab sets ownership shares and totals each property. The Rent tab records each payment with tenant, unit and status, including late and partial payments. The Expenses tab files costs under the lines of the rental form with a rental-use share. The Dashboard compares rent and expenses by property and shows a chart by line.

Record rent as it arrives and expenses when the bill is paid. Use the rental-use share for a mixed cost, such as utilities for a property you also use. Keep repairs apart from improvements and ask your accountant about anything that adds lasting value. Co-owners should set each person's share on the Properties tab.

Useful for

  • Prepare the rental form from one tidy list
  • Compare property results when you own more than one
  • Spot late or partial rent early

What's included

  • 5 tabs: Dashboard, Properties, Rent, Expenses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Properties: a table
  • Rent: a table
  • Expenses: 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 Properties 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 are the expense lines chosen?

They follow the headings of the CRA rental form, such as repairs, insurance and property taxes, so you can copy totals across. Check the current form because the layout can change.

What if I co-own a property?

Enter your ownership share on the Properties tab. The sheet multiplies the net income by that share to give your part. Co-owners often keep a shared copy and agree on the figures together.

Does it handle a vacant month?

Add a row with the status Vacant and an amount of zero so the month is on record. The dashboard counts only late and partial payments as problems, and vacancy rows simply keep the history complete.

  • #tax-tracker
  • #canada-rental-income-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…