Landlord bookkeeping in Canada: spreadsheet, software or accountant?
Wilson ยท 6 min read ยท
Most landlords ask which tool to use. The better question is which job needs doing. Keeping rental books is three separate jobs, and the spreadsheet, the software and the accountant are each good at a different one.
The three jobs
Every set of rental books has to do all three, whoever does them.
- Record: capture each payment and expense when it happens, against the right unit and the right category.
- Reconcile: match what you recorded to the bank, mortgage and card statements, so missing items show up before April.
- File: turn the year into Form T776, make the repair versus capital decisions, and claim capital cost allowance if you choose to.
A spreadsheet
A spreadsheet is the right starting point for one to three doors. It costs nothing, you see every number, and it forces you to learn the categories. If that is where you are, our free 19-Door Ledger at luxoasisos.com/ledger is the template we run our own books on.
It starts to fail in predictable places. Entries get skipped in busy months. A formula gets overwritten. Receipts live somewhere else. Only one person can really use it, and the per-unit view gets harder with every door you add. A spreadsheet records well and reconciles only as well as your discipline.
Bookkeeping software
Software earns its cost when volume grows or more than one person touches the books. It handles the recording and some of the reconciling, keeps receipts attached to entries, and does not break when you copy a row.
The thing to check is whether it is built around rental property. A general-purpose accounting tool works, but you will build the categories yourself, and they need to line up with the T776 lines and stay separate per unit. A landlord-specific tool does that mapping for you.
An accountant
An accountant is the best answer to the filing job and the worst answer to the recording job. They are expensive for data entry, and they can only work with what you hand them.
Bring one in for anything with real consequences: the repair versus capital line, capital cost allowance, whether to hold the properties personally, jointly or in a corporation, and any letter from the CRA. For everything else, give them clean books and the filing becomes quick.
How to decide
Start from your situation rather than the tool.
- One to three doors, simple ownership: a good spreadsheet, a monthly reconciliation, and an accountant at filing time.
- Four to ten doors, or more than one person entering data: software that tracks per unit and keeps receipts attached, with the accountant at year-end.
- More than ten doors, several owners or a corporation: software every month, and an accountant involved during the year rather than after it.
Five questions to test any option
Ask these of a spreadsheet template, a software product or a bookkeeper.
- Can it show income and expenses per unit?
- Does every category map to a line on Form T776?
- Can a receipt or invoice be attached to each entry?
- Can your accountant read the export without re-keying it?
- Can you take your data with you if you leave?
We built LuxOasisOS to run our own portfolio. Income and expenses are tracked per unit in the T776 structure, and the year-end export goes straight to the accountant. If you are on a spreadsheet and it works, keep it. The point is the books, not the tool.
Put it into practice
Keep your rentals and your books in one place.
Start with the free 19-Door Ledger, or see how LuxOasisOS runs viewings, applications, maintenance and CRA-ready bookkeeping for a flat monthly price.
Keep reading
The landlord chart of accounts built around Form T776
Most landlord spreadsheets use categories the CRA form doesn't recognize. Here's a chart of accounts mapped line by line to Form T776, tracked per unit.
Liliana ยท 6 min read
The CRA bookkeeping checklist every Canadian landlord needs
What to track month-to-month so tax season is a formality, not a scramble โ the exact structure we use for our own 19 doors.
Liliana ยท 6 min read
The landlord year-end close: a December checklist
A December checklist for Canadian landlords โ twelve steps to finish the books, catch the deductions with deadlines, and make filing a transcription job.
Liliana ยท 6 min read
General information for Canadian landlords, not tax or accounting advice. Your situation may call for a different approach. Check with an accountant who works with rental property.
Back to the Journal