This free spreadsheet keeps the year’s records for a rented suite in your own home, laid out for CRA’s form T776. You log each cost and the rent, set the suite’s share of the house once, and it totals every T776 expense line and gives each owner’s share of the net income.
It’s an Excel file that also opens in Google Sheets and Apple Numbers. There’s no sign-up. For a one-off split, the suite expense split calculator works in your browser.
What’s in the template
- Settings. The suite’s floor area and the home’s, which give the suite’s share, and each owner’s share of the property.
- Expenses. One row per cost: the date, who you paid, the T776 line, whole house or suite only, and the amount. The rental part works itself out.
- Rent. Rent due and received for each month of the tax year.
- T776 summary. Gross rent, each expense line, total expenses and line 9369, net income before adjustments, for the whole rental. Then each owner’s share of line 9369.
The T776 lines it uses
8521 advertising, 8690 insurance, 8710 interest and bank charges, 8810 office expenses, 8860 professional fees, 8871 management and administration fees, 8960 repairs and maintenance, 9060 salaries, wages and benefits, 9180 property taxes, 9200 travel, 9220 utilities, 9281 motor vehicle expenses and 9270 other expenses. Line numbers are from CRA’s form T776; check the year’s form before you file.
A worked example
Alex and Sam own their home 50/50 and rent a 650 sq ft suite in their 2,600 sq ft house: 650 ÷ 2,600 = 25%. The suite brought in $1,600 a month for 11 months.
| T776 line | Paid in the year | On the form |
|---|---|---|
| 8141 Gross rents, $1,600 × 11 | $17,600 | |
| 8690 Insurance, whole house | $2,400 | 25% = $600 |
| 8960 Repairs, suite only | $380 | $380 |
| 9180 Property taxes, whole house | $4,800 | 25% = $1,200 |
| Total expenses (amount 1) | $2,180 | |
| 9369 Net income before adjustments | $17,600 − $2,180 = $15,420 |
Each owns half, so Alex and Sam each report $15,420 × 50% = $7,710 at amount 2 of their own T776.
Figures on this page are examples.
Keep the receipts
The template is a record, not proof. CRA asks you to keep records, such as receipts and the lease, generally for six years from the end of the tax year they relate to. The Expenses sheet has a column to mark that you’ve kept each one.
When there are two owners
Each co-owner files their own T776 with the whole rental’s rent and expenses, and reports their own share of line 9369 at amount 2, by their share of ownership. The summary sheet works out each owner’s share. Our guide to form T776 walks through the rest of the form.
Larch keeps the suite on its own page through the tax year: rent in, costs split, receipts filed.