Most landlord spreadsheets fail at exactly one point in the year, and it is April.

The books look fine in June. They look fine in October. Then you open Form T776, and none of your column headers match the form. You have a column called "fixes." The CRA has a line called Repairs and maintenance and a separate rule for anything with a lasting benefit. You have a column called "condo stuff." The CRA wants condo fees split from special assessments. So you spend a weekend re-sorting twelve months of receipts into boxes you should have used from day one.

The fix takes an hour. Build your chart of accounts around the tax form instead of around your own habits.

Why the CRA form is your category list

Form T776, Statement of Real Estate Rentals, is the schedule every Canadian landlord attaches to their T1. It has two income lines and thirteen expense lines. Those fifteen lines are the only shape the CRA sees.

Any bookkeeping category outside those fifteen lines creates work later. Any category inside them disappears at filing time, because the number flows straight through.

So the design rule is simple. Every account in your ledger maps to one T776 line, or it is a balance sheet item and never touches the form at all.

The income side

Line 8141, Gross rents. Total rent charged for the year, before deductions of any kind. Charge it when it is due, not when it lands in your account. A tenant who pays December late still owes December rent for the December year.

• Base rent by unit
• Parking and storage rent
• Rent adjustments and abatements

Line 8230, Other income. Everything else the property earns. Laundry coin, pet fees, late fees, key replacement, forfeited deposits applied to unpaid rent or damage, and lease-break payments.

The one people miss: a security deposit is not income when you collect it. It is a liability. It becomes income only in the year you apply it to unpaid rent or damage.

The thirteen expense lines

Copy these exactly. The numbers are the CRA line numbers.

• 8521 Advertising — listing fees, rental site subscriptions, photography, signage, tenant finder's fees.
• 8690 Insurance — landlord policy premiums for the current year only. A three-year prepaid policy gets split across three years.
• 8710 Interest and bank charges — mortgage interest, line of credit interest on borrowed funds used for the property, bank fees on the rental account, and interest paid to tenants on deposits where your province requires it. Mortgage principal is not here — that's a balance sheet item.
• 8810 Office expenses — small consumables like stamps, paper, printer ink. A desk or a laptop is a capital item, not an office expense.
• 8860 Professional fees — accounting, bookkeeping, tax prep for the rental, legal fees for drafting leases or chasing rent, and tribunal filing fees. Legal fees to buy the property belong in the cost of the building, not here.
• 8871 Management and administration fees — property manager fees, leasing commissions, and rent collection agent fees. Software subscriptions used to run the portfolio sit comfortably here.
• 8960 Repairs and maintenance — labour and materials to keep the property in the condition it was already in. Your own labour is worth nothing to the CRA, so no entry for your Saturday.
• 9060 Salaries, wages and benefits — only for actual employees, with the employer CPP and EI portions. A contractor invoice belongs in Repairs.
• 9180 Property taxes — municipal taxes for the period the property was rented.
• 9200 Travel — trips to collect rent, supervise repairs, or manage the property. Meals and lodging are excluded.
• 9220 Utilities — heat, power, water and internet where the lease puts them on you.
• 9281 Motor vehicle expenses — tight conditions apply, and they differ depending on whether you own one property or several. Track kilometres all year regardless, because reconstructing a log in April is impossible.
• 9270 Other expenses — condo fees, landscaping, snow removal, pest control, lease cancellation payments.

Four accounts to add outside the form

These never appear on T776, and leaving them out of your ledger is what breaks the reconciliation.

• Mortgage principal — splits off the payment each month. Only interest is deductible. A single "mortgage payment" line is the most common bookkeeping error in small portfolios.
• Security deposits held — a liability account per tenant. Money you hold, not money you earned.
• Capital additions — new roof, new furnace, new appliances, an added bathroom. These go into a capital cost allowance class, not into Repairs — our capital cost allowance guide covers how the classes work.
• Owner contributions and draws — money you put in and money you take out. Neither is income or expense.

Track per unit, not per portfolio

Portfolio-level books answer one question: what did I make. Unit-level books answer the questions you need answered.

Which door is quietly losing money. Which furnace has taken four repair calls in eighteen months. What the real cap rate is on the duplex you keep meaning to sell. Whether the basement suite justifies the utility split.

Unit-level books also matter at disposition. When you sell one property out of five, you need its cost base, its capital additions and its capital cost allowance history isolated. Pulling it out of a blended ledger years later is a paid project for your accountant.

Three rules keeping the ledger clean

• One bank account per portfolio, minimum — never run rental money through your personal chequing. The CRA reviews mixed accounts more closely, and you'll spend hours proving which coffee was a property trip.
• Enter the transaction in the week it happens — receipts photographed at month end are receipts already lost. A ledger updated weekly takes minutes. A ledger updated in April takes a weekend.
• Attach the document to the entry — six years of records is the CRA requirement, counted from the end of the tax year the records relate to. For anything touching the cost of the building, keep it six years past the year you sell.

What good looks like on December 31

Your books are finished when you print a per-unit income and expense summary, and every number on it lands on a T776 line without further sorting. Gross rents. Thirteen expenses. A capital additions list for the depreciation schedule. A deposit liability balance matching what's in trust.

At this point your accountant is transcribing, not investigating. The bill drops accordingly.

LuxOasisOS builds this structure for you. Every unit gets its own ledger, categories are already mapped to the T776 lines, and the year-end export comes out CRA-ready. We built it because we run 19 doors and got tired of the April weekend.