Home › Canadian edition
Canadian editionCanadian landlord spreadsheet for T776
Track rent and expenses for up to 10 Canadian rental properties, in CAD, with every line mapped to CRA Form T776. Works in Excel and Google Sheets.
Instant digital download (.xlsx). No macros, no subscription.
What you get
- A dashboard with income, expenses, net income, cash flow, expense ratio and rent owing, plus 3 charts
- A 1,000-row transactions log with property and category dropdowns
- A property summary by T776 line, with net income before adjustments (≈ line 9369)
- A monthly view for all properties or one
- A rent roll with renewal alerts; rent paid and balance owing fill in automatically
- A capital items log for CCA (class noted)
- Setup for the tax year, up to 10 properties and ownership % and personal-use %
- A Start Here guide and clearly labelled sample data you can delete
Categories included
| Category | T776 line |
|---|---|
| Gross rents | 8141 |
| Other income | 8230 |
| Advertising | 8521 |
| Insurance | 8690 |
| Interest and bank charges | 8710 |
| Office expenses | 8810 |
| Professional fees | 8860 |
| Management and administration fees | 8871 |
| Repairs and maintenance | 8960 |
| Salaries, wages and benefits | 9060 |
| Property taxes | 9180 |
| Travel | 9200 |
| Utilities | 9220 |
| Motor vehicle expenses | 9281 |
| Other expenses | 9270 |
Line numbers are for convenience. Rules change, so confirm with your accountant or CRA Guide T4036.
Screenshots
How it works
- Buy on Etsy and download the .xlsx file.
- Open it in Excel, or upload it to Google Drive and choose File → Save as Google Sheets.
- Delete the sample data, add your properties and start logging.
Canadian notes
GST/HST. Long-term residential rents are generally exempt from GST/HST, so most small landlords record expenses including any GST/HST paid. Short-term or commercial rentals can be different, so check CRA guidance or ask your accountant.
CCA. Buildings, appliances and furniture are generally claimed over time as capital cost allowance rather than expensed. The workbook logs capital items with their CCA class (for example Class 1 buildings at 4% or Class 8 appliances at 20%, per CRA Guide T4036) but doesn't calculate CCA.
This is a record-keeping tool, not tax, legal or accounting advice. It was designed with the help of AI tools, then reviewed and tested formula by formula.