Rental suite expense spreadsheet for form T776 (free template)

Rental suite expenses for form T776

Excel file (.xlsx), 28 KB · free, no sign-up

Download
Settings
The suite’s share of the home, and each owner’s share
T776 summary
Gross rent, each T776 expense line, net income at line 9369, and each owner’s share
Expenses
One row per cost, whole house or suite only
Rent
Rent due and received, month by month

Opens in Excel, Apple Numbers and Google Sheets (in Sheets: File, then Import, then Upload). Example amounts are filled in so you can see it working; replace them with your own.

A template that does arithmetic on what you type. Where CRA limits apply, they're the published limits as of Nov 20, 2026. Not advice. Check it against your own records before you act on it.

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.

Common questions

How do I track expenses for a basement suite?

Log each cost with its T776 line and whether it was for the whole house or the suite only. Whole-house costs count at the suite's share of the home, suite-only costs count in full. The free Larch template does the arithmetic.

How do I work out the suite's share of the house?

Divide the suite's floor area by the whole home's, or use the number of rooms, as long as the method is reasonable and you use it consistently. A 650 sq ft suite in a 2,600 sq ft home is 25%.

Can I claim mortgage interest on a rental suite?

The rental share of interest on a mortgage taken to buy or improve the property goes on T776 line 8710. Mortgage principal isn't an expense.

How do two owners report a suite?

Each co-owner files their own T776 with the whole rental's rent and expenses, then reports their own share of the net income (line 9369) at amount 2, by their share of ownership. The template shows each owner's share.

Does the template include capital cost allowance?

No. Claiming CCA on a home with a suite can affect the principal residence exemption when you sell. CRA's guide T4036 explains when it applies.

Changes

  1. Published.

Try Larch free

Make your login in a minute. Free while Larch is in beta. No bank password, now or later.

Sign up Have a login? Sign in to Larch