Canadian Rental Property Tracker: T776 Income & Expense Spreadsheet with CCA (2026)

- Income and expense ledgers for up to 3 properties

- Expense categories mapped to Form T776 lines (8521–9281); capital items kept out of expenses

- T776 summary by property and in total: gross rents (8141), other income (8230), personal-use portion (9949), your co-ownership share, CCA (9936) and net income (9946)

- CCA worksheet (Class 1 4%, Class 8 20%, half-year rule) that caps CCA so it can't create or increase a rental loss. An override covers enhanced first-year CCA for property acquired from 2025 (RIIP, Bill C-15); confirm eligibility with the CRA or a preparer

- Not modelled: short-term rental lines 9365–9367. Line 8299 goes to return line 12599 as the whole-property amount

- CRA source links and plain-language CCA notes

- Built and tested in Excel/LibreOffice, using only functions that also exist in Google Sheets. To open it in Google Sheets: upload the .xlsx to Google Drive, then Open with → Google Sheets. It hasn't been tested in a live Google Sheets account. Formula-cell protection applies in Excel only (there's no password: Review → Unprotect Sheet).

Instant download: .xlsx, README and test cases.

Estimate, not tax advice. Not affiliated with or endorsed by the CRA.

Licence: In addition to Payhip's standard licence, you may use this template for your own records, personal or commercial; don't resell or share the file.