Canadian Rental Property Spreadsheet, CRA T776 Landlord Income & Expense Tracker, Rent Roll, CAD, Excel and Google Sheets, 10 Properties

Rental bookkeeping made for CANADIAN landlords – every income and expense line organized by CRA Form T776, in CAD, in one spreadsheet that works in Microsoft Excel AND Google Sheets.

For small landlords with 1–10 properties: duplexes, condos, basement suites and houses.

★ WHAT YOU GET
• Automatic DASHBOARD – total income, expenses, net income, cash flow, expense ratio and rent owing, plus 3 charts
• TRANSACTIONS log – 1,000 rows; pick property & category from dropdowns
• PROPERTY SUMMARY by T776 line – Gross rents (8141), Other income (8230), Advertising (8521), Insurance (8690), Interest & bank charges (8710), Office (8810), Professional fees (8860), Management & admin (8871), Repairs & maintenance (8960), Salaries (9060), Property taxes (9180), Travel (9200), Utilities (9220), Motor vehicle (9281), Other (9270) – with a net-income-before-adjustments total (≈ line 9369) per property
• Personal-use % and ownership % per property (estimates shown separately)
• MONTHLY view – all properties or one via dropdown
• RENT ROLL – tenants, lease dates, deposits, renewal alerts; rent paid by month, expected-to-date and balance owing fill in AUTOMATICALLY from your transactions
• CAPITAL ITEMS – log buildings, appliances and improvements (with CCA class) to hand to your accountant
• START HERE guide incl. plain-language notes on GST/HST and CCA

★ HOW IT WORKS
1. Download the .xlsx instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Delete the SAMPLE data, add your properties and start logging.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros)
• Amounts in CAD; tested formula-by-formula

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
Record-keeping tool only – not tax, legal or accounting advice. Line numbers follow CRA Form T776 / Guide T4036 for convenience; the workbook does not calculate CCA or file anything. Please confirm your reporting with a qualified tax professional or the CRA.

Personal-use licence: for your own properties. Please don't resell or share the file. Digital items can't be returned – but if anything doesn't work, message me and I'll fix it.