BMO Statement to CSV: Past the Two-Month Window

You need BMO transactions in a spreadsheet, and you need them complete. Maybe it is a year of chequing activity for a mortgage broker, a set of business expenses your bookkeeper wants categorised, or the paper trail for a CRA request that landed at an inconvenient moment. BMO will hand you a spreadsheet quite happily — for a narrow slice of recent history.

Everything older than that slice lives in your eStatement archive as PDFs. This post covers both routes, the parts of a BMO statement that defeat generic PDF converters, and how to prove the CSV you end up with actually matches the statement it came from.

Quick answer

Two ways to get BMO transactions into CSV:

1. BMO's own transaction download. Online Banking will export account transactions in several formats, including a spreadsheet-friendly CSV. It is free, it is native, and it covers a documented two months of history.
2. Convert the eStatement PDF. For anything older, for closed accounts, for a statement someone emailed you, or when you need a period that matches your statements exactly, the data exists as a PDF. Upload it to a converter like BankStatementKit, which extracts the transactions and balance-checks the result against the statement's own printed totals.

Rule of thumb: if what you need happened in the last two months, take BMO's download. Anything beyond that goes through the eStatement PDF.

Turn a BMO eStatement into a verified CSV

Option 1: BMO's built-in transaction download

If you have Online Banking access and your date range is recent, start here.

1. Sign in to BMO Online Banking.
2. Go to Accounts and select the account you want.
3. To the right of the Transactions header, select DOWNLOAD.
4. Fill out the form — pick your date range and choose a download format. BMO offers formats for QuickBooks, Quicken and Simply Accounting, the .ofx format, and Comma Separated Value (CSV) for Excel and other spreadsheets.
5. Open the CSV in Excel or Google Sheets.

Where the built-in download stops

The download is genuinely convenient, and it runs out in predictable ways:

• Two months of downloadable history. BMO documents the download as covering two months of account transaction history. That is fine for reconciling last month and useless for a tax year.
• What you can view and what you can export are different numbers. BMO documents roughly two years of viewable transactions for bank accounts — shorter for credit cards and investment accounts — while the download covers two months. Being able to see a transaction on screen does not mean you can export it.
• eStatements outlast both. BMO documents up to 7 years of eStatement archiving for bank accounts and credit cards. Those are PDFs, not spreadsheets. The gap between what you can see and what you can export is the whole problem.
• You need working login access. A closed account, an account held by a business you no longer administer, or a statement a client forwarded you gives you nothing to sign in to.
• The CSV does not match your statement periods. A date-range export and a monthly statement are different objects. If someone has asked you to substantiate a specific statement, the export needs reconciling against it anyway.

All four routes end in the same place: a PDF.

Option 2: Convert the BMO PDF statement to CSV

1. Download the eStatement PDF from BMO Online Banking, or use the one you were sent.
2. Upload it. If the file happens to be password-protected, supply the password at upload — it is unlocked in memory and never written to disk.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance.
4. Check the verification label, then download the CSV.

Convert a BMO statement

Scanned or photographed statements are handled too — those fall back to OCR automatically, though the verification step matters even more when the text came from an image.

Why BMO PDFs trip up generic converters

BMO's Canadian retail layout is airy rather than dense, and that airiness is precisely what naive extraction gets wrong.

The balance column has gaps. BMO does not necessarily reprint a balance figure beside every single transaction line — it appears where the running total is stated, leaving blank space down the column on the rows in between. Converters that use "has a balance" as the test for "is a transaction" will quietly discard real rows. The date and the amount columns have to carry that decision instead.

Descriptions wrap. INTERAC e-Transfer entries, pre-authorized debit merchant strings and point-of-sale descriptions frequently need a second physical line. Read line-by-line, one transfer becomes two rows, the second with no amount attached. Continuation lines have to be folded back into the transaction above them.

Withdrawals and deposits are separate money columns. They must land in Debit and Credit as two distinct fields. Collapse them into one signed column carelessly and a month of withdrawals arrives in your spreadsheet as income — an error that stays invisible until something downstream refuses to balance.

Prove the CSV matches the statement

This is the step almost everyone skips, and the only one that turns a conversion into evidence. A BMO statement gives you at least one independent check, and often two:

1. The printed opening and closing balances. Opening balance, plus every credit, minus every debit, must equal the closing balance the statement prints. If your CSV does not satisfy that to the cent, something was dropped, duplicated or mis-signed — and the size of the gap often tells you which.
2. The balance chain, where BMO prints it. Wherever a running balance appears, each printed figure must equal the previous one minus debits plus credits. Every point the chain holds is a point you know the file is intact up to.

Doing this by hand across twelve statements is an afternoon. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pinpointing the row where the numbers stop reconciling. More detail on the layout specifics is on the BMO statement converter page.

FAQ

The bottom line

If your BMO transactions happened in the last two months and you can sign in, take BMO's own download — it is free and it comes straight from the bank. For everything older, for closed accounts, and for statements that arrived by email, the eStatement PDF is the record, and converting it is the fastest honest route to a spreadsheet. Just insist on a conversion you can check, because gapped balance columns and wrapped INTERAC descriptions are exactly where silent errors hide.