MTC Logo MTC Canada's Finance Hub
Menu
Store: templates & planners
Save 71% Excel · Google Sheets
2026 Edition
Excel & Sheets
Instant Access
Tax Templates 2026 Landlord Edition

Canadian Rental Property Income & Expense Tracker (T776)

Manage tenant rent rolls, track deductible expenses by CRA T776 line, split mortgage interest, and maximize net rental profit.

$4.99 $16.99 CAD
Save 71%

One-time purchase · Instant digital download · Lifetime access

Available soon

Leave your email and we'll send you an instant note the day this template is released.

Stripe secure checkout · Visa, MC, Amex, Apple Pay, Google Pay

Your download includes

  • MTC_Canadian_Rental_Property_Tracker_T776_2026.xlsx14 KB
  • Google Sheets Cloud Copy Setup LinkInstant copy
  • Instant file access
  • No monthly subscription
  • Mac, PC & Mobile
  • 100% Private & Offline

Canadian-Specific

Key Features & Capabilities

Designed specifically around Canadian payroll, tax forms, and account structures:

  • Built around CRA Form T776 (Statement of Real Estate Rentals) line-by-line tax categorization
  • Tenant Rent Roll & Lease Ledger tracking monthly rent, deposits, payment methods, and arrears
  • Mortgage Interest Splitter separating deductible mortgage interest (Line 8710) from non-deductible principal
  • Clear Current vs Capital expense differentiation to prevent costly CRA rental audit penalties
  • House hacking / Basement apartment support with dedicated rental percentage calculation for shared utilities
  • Instant Annual T776 Summary ready to paste into TurboTax, Wealthsimple Tax, or hand to your accountant

Complete Toolkit

What's Inside (9 Components)

Everything you receive immediately upon download:

  • 1 × Canadian Rental Property Tracker Workbook (.xlsx)
  • 1 × Google Sheets Cloud Copy Setup Link
  • Landlord Portfolio Dashboard with Gross Rents, NOI, and Cap Rate
  • Tenant Rent Roll and Security Deposit Tracking Sheet
  • Monthly Rental Income & Payment Status Log
  • CRA Form T776 Categorized Operating Expense Log
  • 12-Month Mortgage Interest vs Principal Splitter
  • Annual CRA Form T776 Tax Filing Summary Sheet
  • Canadian Landlord Tax Deductions and CRA Audit Prevention Guide

Detailed Walkthrough

Maximize Canadian Rental Deductions and Protect Yourself Against CRA Audits

Rental real estate is one of the CRA's top audit focus areas in Canada. Landlords frequently trigger audits by improperly deducting capital improvements as current expenses, miscalculating business-use percentages, or failing to properly separate mortgage interest from mortgage principal.

The MTC Canadian Rental Property Income & Expense Tracker is specifically architected around CRA Form T776 (Statement of Real Estate Rentals), providing an audit-proof system to manage tenant rent, track every deductible dollar, and maximize your net cash flow.

🏢 Complete Landlord Dashboard & Rent Roll

Maintain total operational command of your rental portfolio:

  • Tenant Rent Roll: Keep track of tenant contact details, lease term dates, monthly agreed rent, security/last month rent deposits held, and payment statuses.
  • Income & Fee Ledger: Log gross rents, garage/parking fees, storage rentals, coin laundry, and late fees by property or unit.
  • Key Metrics: Real-time calculations of Net Operating Income (NOI), Capitalization Rate (Cap Rate), and annual cash flow after mortgage debt service.

📐 Line-by-Line CRA Form T776 Expense Mapping

Categorize expenses directly to official CRA lines to ensure nothing is missed at tax time:

  • Line 8521: Tenant advertising on Kijiji, Facebook Marketplace, and rental portals.
  • Line 8690: Landlord property, liability, and rental income protection insurance.
  • Line 8710: Deductible mortgage interest, loan charges, and bank fees.
  • Line 8860: Real estate legal fees, lease drafting, paralegals, and bookkeeping.
  • Line 8960: Maintenance and current repairs (painting, minor plumbing, furnace servicing).
  • Line 9180 & 9220: Municipal property taxes, hydro, heating gas, and water.

📉 Mortgage Interest vs. Principal Splitter

Under Canadian tax law, only the interest portion of your mortgage payment is a tax-deductible expense; principal repayment is equity. Claiming the full payment is one of the most common landlord tax mistakes. This built-in splitter separates every monthly payment into deductible interest and non-deductible principal automatically.

🏘️ House Hacking & Basement Suites

Renting out a basement suite, duplex, or condo unit? The template calculates your deductible square footage percentage, allowing you to legally deduct the exact allowable portion of shared property taxes, home insurance, natural gas, and water without risking your primary residence tax exemption.

Target Audience

Who This Template Is For

Canadian landlords and real estate investors with single or multi-unit properties
House hackers renting out a basement suite, laneway home, or rooms in their primary residence
Condo investors renting out residential units in Ontario, BC, Alberta, or other provinces
Property owners preparing their annual CRA Form T776 return who want to save on accountant bookkeeping fees

Frequently asked questions

Why is separating mortgage interest from principal so important for Canadian landlords?

Under CRA rules, only the interest portion of your mortgage payment is a deductible rental expense (Line 8710). The principal portion pays down your loan and is considered equity, not an expense. Claiming principal as an expense is a major CRA audit red flag. This sheet does the math for you.

Can I use this if I rent out my basement or part of my house?

Yes! The guide explains how to set your rental percentage (e.g. 40% based on square footage), allowing you to deduct the allowable portion of shared municipal property taxes, home insurance, heat, electricity, and water.

What is the difference between Current and Capital expenses in this tracker?

Current expenses restore a property to its original condition (painting, minor plumbing repairs) and are 100% deductible in the year you pay them. Capital expenses improve the property beyond its original state (a brand new roof, an addition) and must be depreciated over years. The template includes clear guidance to categorize each properly.

You Might Also Like

Other curated spreadsheets for Canadian finances

View all templates →