CIBC Statement to Excel Converter

Cross-border businesses are common CIBC customers, and the USD account is where the mistakes happen: a converted figure typed into a CAD column, or two currencies summed into one total. FlowParse keeps each amount in the currency the statement prints and proves the USD statement against its own USD balances.

Conversion to CAD, where your books need it, belongs in the accounting system with the rate it uses — not in the bank data.

For a T2, a review engagement or a lender's annual review, Smart Merge takes up to 100 CIBC PDFs — both currencies, several accounts — and builds one workbook in date order with the account and source on every row, chaining each statement's closing balance to the next opening balance per account.

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

Canadian bookkeepers mostly work in QuickBooks Online, Xero or Sage 50. FlowParse exports a QBO file QuickBooks imports as bank transactions, a CSV for Xero's or Sage's import, and an Excel file for review first. A USD account goes to the USD bank account in the ledger.

Because the full description is kept — e-Transfer sender, pre-authorized debit payee, cheque number — each line can be matched and categorized after import.

An eStatement downloaded from My Documents or the CMO Welcome Page carries real text and converts exactly. Older paper statements can be scanned and converted through OCR; scan them flat, one statement per file.

Upload each statement as one file so the proof can run from opening to closing balance. Download the full seven years before closing an account or moving banks.

Withdrawals and deposits are unsigned columns; pasted into one list they all become positive. A USD statement typed into a CAD sheet silently mixes currencies. FlowParse signs by column and keeps the currency.

Long descriptions — an e-Transfer with a message, a U.S. card purchase with conversion details — wrap over two lines and become two rows when copied. FlowParse keeps one transaction per row, and the balance proof confirms nothing was split or dropped.

A consultancy invoices U.S. clients into a CIBC USD account and pays its Canadian costs from a CIBC CAD account. At year end the accountant needs both accounts' twelve eStatements. The figures here are an illustration, not a real company's.

Uploaded together, the 24 statements become one workbook with the account and currency on every row, each statement proved in its own currency and each account's chain complete. The USD file goes to the USD bank account in QuickBooks, the CAD file to the CAD one, and the transfers between them are visible on both sides instead of looking like income.

Coverage: every month for every account, each closing balance equal to the next opening balance. Currency: USD rows in USD, CAD rows in CAD. Reconciled: every statement proved before its totals are used.

And keep the PDFs — the CRA generally expects records to be kept for six years from the end of the tax year they relate to, and the converted file is a working copy.

Chequing, savings and business account eStatements, in CAD and USD, list transactions between two balances and convert the same way. Credit card eStatements convert as purchases and payments against the previous and new balance.

Tax slips, investment summaries and confirmations of a single transfer summarise or document one event. Keep them; convert the statements.

Canadian business accounts still clear cheques, pay suppliers by pre-authorized debit, and run payroll through the bank. On a CIBC statement, each of these appears with its own description, and they are the lines a bookkeeper matches most carefully: a cheque against the cheque register, a pre-authorized debit against the supplier's invoice, a payroll run against the payroll journal.

FlowParse keeps the description of each line whole, including cheque numbers and payee names, so the matching can happen after import exactly as it would against the paper statement — but by filter and formula rather than by eye.

For a business moving its banking to or from CIBC, the converted statements also make the switch-over month easy to check: the last statement at one bank and the first at the other sit in one workbook, and the transfer between them is visible on both sides.

CIBC's business page notes that turning off paper statements avoids paper statement fees. Before you switch, it is worth checking which months exist only on paper: older statements from before eStatements were enabled will not appear in My Documents.

Scan those paper statements once, convert them alongside the eStatements, and the whole history — paper years and electronic years — ends up in one proved workbook rather than in two filing systems.

The same applies to a business that kept paper for one account and switched another to eStatements early: convert both, merge them, and the account column keeps them apart. For an accountant taking over the file, that single workbook replaces a box of paper and a folder of downloads, and every statement in it has been proved against its own balances — which is the question an incoming accountant asks first. When a review engagement or a lender's annual review comes round, the same workbook answers the completeness question again in seconds.