The real problem with spreadsheets
Every Canadian landlord starts with a spreadsheet. It works fine for the first few months. Then life gets busy. A receipt gets lost. A bill gets paid and forgotten. By March you are reconstructing a year of expenses from bank statements and memory.
The spreadsheet was never the problem. The habit was.
Tracking rental expenses in Canada requires consistency above everything else. One missed receipt in November can mean a missed deduction in April.
What you actually need to track
The CRA expects you to report rental expenses by category on your T776. Your tracking system needs to match those categories from day one.
- Advertising: Any cost to find tenants. Kijiji listings, rental platform fees, signage. Keep the receipt and note which property it was for.
- Insurance: Your annual landlord or property insurance premium. If you pay monthly, track each payment separately.
- Interest: The interest portion of your mortgage payments only, not the principal. Your lender provides an annual statement breaking this down.
- Maintenance and repairs: Every plumber, electrician, handyman, and hardware store visit. Photograph receipts immediately.
- Management fees: If you use a property manager, their fees are fully deductible. Get an annual summary from them.
- Motor vehicle: Driving to your rental property for repairs or inspections. Log the date, purpose, and kilometres.
- Office expenses: Printer paper, postage, software subscriptions used for managing your rental.
- Legal and accounting: Lawyer fees for lease agreements, accountant fees for filing.
- Property taxes: Your municipal property tax bill. Track each payment as it is made throughout the year.
- Utilities: Heat, hydro, water. Only deductible if you pay them, not your tenant.
- Other expenses: Locksmith, cleaning between tenants, landscaping, pest control.
The habit that actually works
Every time you pay for something related to your rental property, photograph the receipt and log it the same day. Note the amount, the category, and which property it was for. That is the entire system. The consistency is the hard part, not the tracking itself.
Capital expenses vs. current expenses
Capital expenses
Must be depreciated over time (CCA):
- New roof
- Furnace replacement
- Major renovation
- New appliances
Current expenses
Fully deductible this year:
- Fixing a broken window
- Repainting a unit
- Replacing a faucet
When in doubt, ask your accountant.
How to organize everything for your accountant
Your accountant needs your expenses organized by category, by property, and by tax year. The ideal handoff is a clean summary showing total income per property, total expenses broken down by T776 category, and any capital expenses noted separately.
Stop reconstructing expenses every April
Akre tracks every expense in real time, organized by T776 category. Ready to hand to your accountant or file yourself.
Try Akre freeFAQ
Do I need to keep paper receipts?
The CRA accepts digital records. A clear photo of a receipt is sufficient. The key is that it shows the date, amount, vendor, and what was purchased.
What if I use part of my home as a rental?
You can only deduct the portion of expenses that relate to the rental space. If you rent out 40% of your home, you can deduct 40% of shared expenses like utilities and insurance.
How far back can the CRA audit my rental expenses?
Generally three to four years. Keep records for at least six years to be safe.
What if I forget to track something?
Bank and credit card statements can help reconstruct expenses in a pinch. But the only real solution is tracking in real time going forward.