BMO Statement to Excel Converter

BMO can consolidate several bank accounts onto one statement — mailed only to the Canadian address on the account. Some accounts can't be added: BMO InvestorLine accounts, business accounts, passbook accounts and accounts not held in your name.

A consolidated statement puts more than one account on one document. FlowParse keeps the account on every row so the sections stay apart, and where a section prints its own opening and closing balance, that section is checked against them.

A BMO chequing or savings statement gives the account holder, the transit and account number, the period and the opening balance, then the transactions — an Interac e-Transfer, a bill payment, a payroll deposit, a debit purchase, a plan fee — with amounts deducted and added in separate columns and the balance beside them. The closing balance ends it.

FlowParse writes one row per transaction with the date, the full description and one signed amount in CAD, decided by the column, so the amount column sums to the change in balance.

The opening balance plus every signed transaction must equal the closing balance. FlowParse checks that on every BMO statement, and checks each row against the running balance where it is printed. A deposit read as a withdrawal, or a line lost at a page break, fails where it happened.

Statements that pass are marked reconciled; anything else is shown in the preview with the difference.

BMO credit card and line of credit eStatements sit in the same seven-year archive. A card statement lists purchases, payments, interest and fees between the previous and the new balance; a line of credit statement lists advances, payments and interest.

Both convert into rows. Merged with the chequing account that pays them, the payments appear on both sides — the pair a bookkeeper needs to see so the same money isn't counted twice.

For a T1 return with self-employment or rental income, a T2 corporate return or a mortgage application, Smart Merge takes up to 100 BMO PDFs and builds one workbook with every transaction in date order, the account and source file on every row, and a check that each closing balance is the next opening balance.

Statements from RBC, TD Canada Trust, Scotiabank, CIBC or Tangerine can be merged into the same workbook, matched column by column.

Canadian bookkeepers mostly work in QuickBooks Online, Xero or Sage. FlowParse exports a QBO file QuickBooks imports as bank transactions, a CSV for Xero or Sage, and an Excel file for review first.

The description stays whole — the e-Transfer sender, the bill payee — so each line can be matched and coded for GST/HST after import.

Deducted and added amounts are unsigned columns; pasted into one list, they all become positive. A consolidated statement pasted as one block mixes two accounts' transactions with no way to tell them apart. A bill payment with a long payee name wraps over two lines and becomes two rows.

FlowParse signs by column, keeps the account on every row and one transaction per row; the balance proof confirms nothing was split or dropped.

A graphic designer working as a sole proprietor runs their business through a BMO chequing account and a BMO credit card. Their accountant needs the calendar year for the T2125. The figures here are an illustration, not a real business's.

The designer downloads twelve chequing and twelve card eStatements and uploads all 24. FlowParse returns one workbook, each statement proved, both accounts chained. Client payments, software subscriptions and the card repayment — visible on both sides — are filtered in minutes; the CSV goes into QuickBooks and the PDFs stay in the year's folder.

Coverage: each closing balance equal to the next opening balance, per account. Consolidated statements: each account kept apart by the account column. Pairs: card and line of credit payments matched between accounts. Reconciled: every statement proved before its totals are used.

And keep the PDFs. The converted file is a working copy; the statement is the record for the CRA, a lender or a court.

Chequing, savings, credit card, line of credit and business account statements list transactions between two balances and convert the same way. Consolidated statements convert account by account.

Mutual fund statements, InvestorLine statements, tax slips and fee notices are valuations, summaries or single figures. Keep them with the file; convert the bank statements.

BMO's guidance on statements includes two habits worth keeping: avoid opening eStatements on public Wi-Fi, and destroy or shred old paper statements to prevent identity theft. A statement carries your name, address and account number.

FlowParse deletes your uploaded PDF straight after processing. The converted file you download holds the same personal data, so store it as carefully as the statements — in the same folder, under the same protection.

BMO recommends reviewing statements regularly to spot unauthorized charges or errors — a merchant that charged twice, a payment you don't recognise — and reporting anything suspicious immediately.

Converted, that review takes a sort and a filter: sort by amount to see the largest payments, filter by payee to find a duplicate charge, compare the same subscription month to month. With a year of BMO statements in one sheet, a recurring charge that crept up is visible in one column instead of twelve PDFs.