Landlords have a special tax-season problem: the numbers the CRA wants are scattered across mortgage statements, insurance bills, repair receipts, and one BMO account that holds it all together. When you convert BMO statement PDF to Excel, your rental activity becomes one searchable ledger — rent in, expenses out, transfers flagged — instead of twelve PDFs nobody can analyze. This guide shows BMO customers how to build a rental-property workbook from their statements: downloading the right files, converting them in a batch, categorizing the expenses the CRA actually allows, and reconciling the final numbers before your T1 goes in.
Why rental income reporting lives or dies on transaction detail
Rental income is reported on form T776, and the CRA allows a specific set of deductions: mortgage interest (not principal), property taxes, insurance, maintenance and repairs, utilities you pay, advertising, and professional fees. Every one of those is a line item hiding in your BMO transactions. The difference between a good year and a bad year on T776 is rarely the rent — it is whether you captured every deductible expense. PDFs make this nearly impossible: they cannot be filtered, sorted, or summed, so small deductible charges get missed and big ones get misremembered. A spreadsheet with a Category column makes the T776 nearly self-assembling. Our PDF-to-Excel conversion guide covers the general technique this workflow builds on.
Step 1: Download your BMO statements for the tax year
- Sign in to BMO online banking and open the chequing account your rental income and expenses flow through.
- Under Statements & Documents, download each month of the tax year as a PDF.
- If you hold a separate BMO account for the property, download that too — dedicated property accounts make the workbook dramatically simpler.
- Grab the annual mortgage interest statement (the T5/interest summary BMO issues) alongside the monthly PDFs; interest is your biggest deduction and it needs its own verification.
- Name files clearly: bmo-rental-2026-01.pdf keeps the batch in calendar order.
Have the PDF password ready if your BMO statements are password protected — conversion handles it directly. More BMO specifics live on our BMO bank page.
Step 2: Convert the PDFs into one Excel ledger
Upload each BMO PDF to Convert Statement in your browser — no software to install — and download the Excel file. Work in a single batch session: convert all twelve months, then merge every month's rows under the first month's header into one continuous table. Three checks make the merge trustworthy: the row count should roughly match a year of rental activity, dates should run January to December with no gaps, and the closing balance of the merged sheet must equal the closing balance on the December PDF. The free tier covers most monthly statements; unusually busy months are worth converting individually. If your bookkeeper imports into accounting software, keep a CSV copy too — the CSV format guide explains what QuickBooks and Xero expect.
Step 3: Categorize expenses the way the CRA allows them
Add a Category column and tag every row using deduction-friendly labels:
- Rent received: every tenant payment. Note the unit and month in a Notes column — the CRA wants to see the income stream clearly.
- Mortgage interest: tag only the interest portion of each payment. The principal is not deductible, so split payments into Interest and Principal columns and verify the annual interest total against BMO's interest statement.
- Property tax, insurance, utilities: direct T776 lines — tag them individually.
- Repairs vs. capital: this is the distinction auditors care about. A $300 plumbing fix is a current expense; a $30,000 new roof is capital and goes into the CCA schedule instead. Tag repairs separately from improvements and flag anything ambiguous for your accountant.
- Owner transfers: money you move in or out of the account is neither income nor expense — tag it Transfer so it never pollutes the T776 totals.
A pivot table of Category by Month now gives you every T776 line. If you manage the property yourself, this same sheet is your annual performance report: net cash flow per month, expense ratios, and the vacancy months that hurt.
Step 4: Reconcile to the T1 before you file
Final pass before the return. Verify the workbook's opening and closing balances against the January and December PDFs. Confirm no transfer rows are sitting in income or expense categories. Cross-check the mortgage-interest total against BMO's annual interest figure — the two must match exactly. Scan for duplicate rows from overlapping statement periods, the classic merged-sheet bug our reconciliation guide warns about. Then send the workbook through your accountant's secure portal, never plain email — a year of banking data deserves the handling our data-security best practices describe.
Frequently asked questions
Can I deduct the full mortgage payment?
No — only the interest portion is deductible; principal repayment is not. Split each payment into interest and principal columns, and verify the yearly interest total against BMO's interest statement before filing.
What if I own the property personally but the rent goes through a joint BMO account?
Add an Owner/Notes column and tag every row to the correct person or property. For next year, a dedicated property account eliminates this entirely — it is the highest-value change a landlord can make.
Do I need to keep the original BMO PDFs?
Yes. Keep them as source documents alongside the workbook — the CRA can request supporting documents, and the Excel file is your working copy, not the evidence.
How do I handle a month where I bought furniture for the unit?
Furniture and appliances for a rental are usually capital (CCA) rather than current expenses. Tag them Capital in the workbook and let your accountant place them on the CCA schedule — do not bury them in repairs.
Your rental books are only as good as their detail. Convert your BMO statements to Excel free today, categorize once, and file your T776 from a pivot table — or check pricing when a full year of busy statements goes beyond the free tier.