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
- 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.
- Under Account Documents, select Account statements.
- 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.
- Selecting a statement downloads the PDF straight to your device.
- 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.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
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.