Free T776 rental income template for Canadian landlords

Your spreadsheet doesn't match the tax form. Ours does.

The 19-Door Ledger is the bookkeeping template we run our own Edmonton portfolio on. Every category is a CRA Form T776 line, so April becomes a transcription job instead of a lost weekend.

Get the CRA-ready ledger

The exact income & expense tracker we use across our own 19 doors — free. You'll also join our list for occasional product updates, which you can unsubscribe from any time.

The April problem

Your 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, plus a separate rule for anything with a lasting benefit. So you spend a weekend re-sorting twelve months of receipts into boxes you should have used from day one.

This template skips the re-sorting. Every category in it is already a T776 line.

What is inside

Eight tabs, one job each

Income Log · Expense Log

Dropdowns locked to the fifteen T776 lines

You pick a category. You never invent one. Nothing to translate at year end.

T776 Summary

Every CRA line total, per unit and combined

Updates as you type. Read it in June and find the door with three furnace calls.

Capital Additions

A new roof stays out of your repairs line

A register with the expected class, kept separately, surviving until you sell.

Deposits Held

Deposits tracked as the liability they are

Per tenant, with interest and anything applied, and a balance matching your trust account.

Year-End Checklist

The twelve step December close we run ourselves

Two hours in the last week of December replaces the April weekend. Next year’s dates included.

Start Here

Set up in five minutes

Four rules keeping the file clean, and a worked example row on every tab to copy.

Who built it

LW

Liliana & Wilson

LuxOasis Living, Edmonton AB

We built a 19-property portfolio in Edmonton while working full time, and got tired of stitching together spreadsheets, email threads and software never designed for a Canadian tenancy.

This is the bookkeeping structure underneath all of it. We used this file for years before we wrote a line of software.

19

doors in our own portfolio

98.6%

of our leases renewed

$1.92M

of our rental income tracked

Straight about the limits

What this file is not

Not built past five doors

The structure holds. The manual entry, receipt filing and deposit tracking around it stop being worth the time. Door six is where most landlords move to software. We know, because door six is where we did.

Not a trial

The file is free and yours to keep. No expiry, no locked tabs, no upgrade prompt inside it.

Not tax advice

General information for Canadian landlords. Rules differ by province and change. Confirm your own position with your accountant before you file.

Before you download

Questions worth answering first

What is Form T776?

Form T776, Statement of Real Estate Rentals, is the CRA schedule where Canadian landlords report rental income and expenses with their tax return. Every category in the ledger matches a T776 line.

Is it Excel or Google Sheets?

Both. You get an .xlsx file plus a link to make your own Google Sheets copy. Formulas, dropdowns and the summary tab work in either.

Does it work outside Alberta?

Yes. Form T776 is federal, so the bookkeeping structure is the same across Canada. Deposit rules differ by province, and the deposit tab notes where.

Do I need accounting knowledge?

No. You pick a category from a dropdown and type an amount. The Start Here tab covers the four rules keeping it clean, including splitting mortgage interest from principal.

Is this a trial of your software?

No. The file is free and yours to keep whether or not you buy anything from us. Share it with the landlord down the street if you like.

What happens to my email address?

We email you the file, then occasional guidance for Canadian landlords where you tick the box. We never sell or rent your address. Unsubscribe from any email in one click.

Start the year with books already in the right shape

Twenty minutes tonight logging last month tells you whether the structure fits how you operate.

Get the CRA-ready ledger

The exact income & expense tracker we use across our own 19 doors — free. You'll also join our list for occasional product updates, which you can unsubscribe from any time.