One rental property is manageable with a spreadsheet and a shoebox of receipts. Two properties is still okay. Three properties and things start to get complicated. By the time you're managing five or more units, a disorganized tracking system doesn't just cause headaches — it costs you money at tax time and creates real risk if the CRA comes knocking.
This guide covers exactly how to track Canadian rental properties properly, what information you need to keep, and how to build a system that scales.
What You Actually Need to Track as a Canadian Landlord
Before choosing a tracking method, get clear on what CRA requires you to document. For Form T776, you need to be able to report:
Per property: Gross rental income collected. Each deductible expense category — advertising, insurance, interest, maintenance, management fees, motor vehicle, office, professional fees, property taxes, salaries, travel, utilities. Capital cost allowance if claiming. Net rental income or loss.
Per tenant: Rent amounts and payment dates. Security deposits received and returned. Lease start and end dates.
General records: All receipts for deductible expenses. Mileage log if claiming motor vehicle expenses. Bank statements showing rental income deposits.
CRA recommends keeping these records for at least six years from the end of the tax year they relate to.
The Tracking Methods: A Realistic Comparison
Spreadsheet
The default for most small landlords. Works reasonably well for 1–2 properties, degrades quickly beyond that.
What works: Free. Flexible — you can set it up however you want. Familiar for most people.
What breaks down: No automatic rent entry generation — you manually add each payment. Categorizing expenses for T776 requires you to know the categories and apply them consistently. Multiple properties means multiple tabs or files that are easy to lose track of. No receipt storage — you still need a separate system for that. Easy to make formula errors that throw off your totals.
Time cost: High. Most landlords spend 6–12 hours at tax time reconstructing records from a spreadsheet.
Accounting Software (QuickBooks, Wave, FreshBooks)
General accounting tools that some landlords try to adapt for rental properties.
What works: More robust than a spreadsheet. Cloud-based with receipt capture (QuickBooks). Can track income and expenses.
What breaks down: Not built for rental properties — no rent ledger, no tenant tracking. No T776 mapping — you still need to manually categorize everything for CRA. No Canadian mortgage math. Wave and FreshBooks have no rental-specific features at all. QuickBooks is $30–$90+ CAD/month for features you mostly won't use.
Time cost: Medium. Better than a spreadsheet but still requires significant manual T776 work.
Dedicated Rental Property Tracker
Software built specifically for landlords, with rent ledgers, tenant tracking, and tax reporting built in.
What works: Rent entries auto-generated each period. Expenses pre-categorized for T776. Per-property reports at year-end. Receipt storage attached to each transaction. Mortgage interest calculated correctly.
What breaks down: Most dedicated tools are built for the US market — AppFolio, Buildium, Rentec Direct. The few Canadian-specific tools are either too basic or too expensive.
Time cost: Low. With the right tool, tax time is a 30-minute report export.
How to Structure Your Tracking System
Whether you use software or a spreadsheet, your system should be organized around four layers:
Layer 1 — Property. Each property gets its own record: address, purchase date, ownership percentage if co-owned, province for applicable tenancy law reference.
Layer 2 — Units. Each unit within a property: unit number or description, current tenant, monthly rent amount, lease dates.
Layer 3 — Transactions. Every rent payment in, every expense out — tagged to a property, a unit (for income), and a T776 category (for expenses).
Layer 4 — Documents. Leases, receipts, inspection reports — attached to the relevant property, unit, or transaction.
This four-layer structure means that at any point in the year, you can pull up any property and see exactly where things stand. At year-end, generating a T776 report is just filtering by property and year.
The Expenses Canadian Landlords Most Commonly Miss
Mortgage interest. Many landlords track their total mortgage payment but don't separate the interest portion. Only interest is deductible — and the split changes every month as your balance decreases.
Home office. If you manage your properties from a home office, a portion of your home expenses may be deductible. Most landlords don't claim this.
Mileage. Every trip to a property counts. At CRA's per-kilometre rate, this adds up quickly over a year. But you need a log — undocumented mileage doesn't fly.
Bank charges. Monthly account fees on a dedicated rental bank account are deductible on Line 8710. Many landlords miss this entirely.
Insurance premiums. Landlord insurance, liability insurance, and title insurance are all deductible. Many landlords only track one of the three.
Professional development. Books, courses, and seminars related to property management and investing may be deductible as office or professional expenses.
Building a System That Survives Tax Season
The single biggest mistake Canadian landlords make is treating their rental records as a once-a-year project. Rebuilding twelve months of records in February is painful, error-prone, and expensive if you're paying an accountant by the hour.
The better approach: log transactions as they happen. Set a recurring 15-minute calendar block each week to enter that week's payments and expenses. By December 31, your records are complete and tax time is just a report export.
Try Estate Ledger free for 60 days. Rent ledger, T776 expense categories, Canadian mortgage tracking, and per-property year-end reports — all in one place. No credit card required. $39 CAD/month after your trial.
Estate Ledger is Canadian-made software for Canadian landlords. We're not tax advisors — always confirm your deductions with a CPA familiar with CRA rental income rules.