Skip to content
stmtai

Convert CIBC statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel files from the PDF.

CIBC eStatement PDFs have no password. Under More on the Online Banking home page there is a Download Transactions option.

Drop your CIBC statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in CAD.

Last updated

How to download a CIBC statement as a PDF

  1. Sign on to CIBC Online Banking and select My Documents on the home page. On older layouts the link is View eStatements in the left sidebar.
  2. Under Account Documents, select Account statements.
  3. Choose the account, then the statement by date. The list shows 13 months by default; change the range to go back as far as 7 years.
  4. Selecting a statement downloads the PDF straight to your device.
  5. In the CIBC Mobile Banking app: More, then My documents, then Account statements, then the account and month.

Then drop the file above; several months of CIBC statements at once come back as one workbook.

Is the CIBC PDF password-protected?

CIBC eStatement PDFs have no password. Open, check the month, upload.

What CIBC statements look like

Date, Description, Withdrawals ($), Deposits ($), Balance ($).

A CIBC chequing statement opens with a summary box giving the opening balance, total withdrawals, total deposits and closing balance, and the transaction table below starts with the opening balance as its first line and ends with the closing balance as its last. Columns are Date, Description, Withdrawals ($), Deposits ($), Balance ($). Point-of-sale rows put RETAIL PURCHASE and a reference number on the first line and the merchant on the second; bill payments carry a tracing number and the payee name, which is handy when a client asks which bill a payment was. Cheques read CHEQUE followed by the number, the service charge shows as a monthly fee line in the Withdrawals column, and a CIBC US Dollar account statement is issued on its own. Personal statements are two to three pages; a Business Operating Account with cheques runs longer.

Why not use CIBC's own export?

Under More on the Online Banking home page there is a Download Transactions option. You pick the account, a time period and a format: CSV, or a financial software choice that produces Quicken QFX or Money OFX. The period is limited to recent history and the file has no balance column, and CIBC eStatements are the only place the opening balance, total withdrawals, total deposits and closing balance are all stated together. For a month or two the export does the job; for a year, or for anything you plan to reconcile, convert the statements.

Where CIBC statements trip up converters

  • Point-of-sale rows include the merchant on a second line; joined into one description.

Which software CIBC customers import into

CIBC customers most often import into QuickBooks Online, Excel.

CIBC questions

The merchant name on my CIBC statement is on a second line under RETAIL PURCHASE. Where does it go?

It is merged into the same description as the row above it, so each purchase is one line reading roughly RETAIL PURCHASE, the reference, then the merchant. Nothing is dropped; the row is just made readable.

Do the opening and closing balance lines in the CIBC table appear as transactions?

No. They are recognised as the period boundaries and used to check the running balance from first row to last. The summary box at the top carries the same figures, and if the table does not tie to them the conversion flags it rather than passing it through silently.

I can only see 13 months of statements. Is the rest gone?

It is still there. The Account statements list shows 13 months by default and has a range control to go back up to 7 years, or as long as you have held the account. Set the range first, then pick the months you need.

How do I convert a CIBC statement PDF to Excel?

Download it from CIBC using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many CIBC statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in Canada

All banks and formats · See a sample result