Canadian Imperial Bank of Commerce ยท Canada

CIBC Statement to Excel, CSV & QuickBooks | AI Bank Statement

CIBC keeps up to 7 years of eStatements, in English or French. Its transaction download reaches back 13 months and skips the last few business days. Here's how to get each, and how to turn CIBC PDF statements into Excel, CSV, QuickBooks or Xero data.

Last reviewed 14 October 2026

At a glance

Official statement format
PDF eStatements in Online Banking and the CIBC Mobile Banking app
Statements online
Up to 7 years (bank accounts and credit cards)
Transaction download
CSV, QuickBooks, Quicken, Simply Accounting or MYOB; up to the last 13 months, one account at a time
Statement language
English or French, depending on your language preference
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

How to download a CIBC eStatement

In Online Banking

  1. On the Online Banking homepage, select My Documents.
  2. Under Account Documents, select Account statements and choose the account.
  3. Pick a statement by date, and it downloads as a PDF.

In the CIBC Mobile Banking app

  1. Tap More, then My documents.
  2. Select Account statements and choose the account.
  3. Select the statement you want to view.

CIBC eStatements carry the same information as mailed statements: an account summary with opening balance, total withdrawals, total deposits and closing balance, then transaction details in withdrawals, deposits and balance columns. They come in English or French, depending on your language preference.

For deposit accounts, last month's eStatement appears on the second or third business day of the month.

CIBC's transaction download

In Online Banking, Download Transactions exports one account at a time as a spreadsheet (CSV) or for QuickBooks, Quicken, Simply Accounting or MYOB. You can choose transactions since your last download, a date range, or everything from the last 13 months.

Where it falls short

  • 13 months maximum. For older periods, the eStatements are the record.
  • Recent days are missing. The current day and the previous two business days aren't included.
  • There's a download limit. If a period has too many transactions, CIBC asks you to choose a shorter date range.
  • It's not the statement. Lenders, accountants and auditors usually want the statement period with its balances.

Statement copies from CIBC cost $5 each for most personal accounts, or $10 for a credit card statement copy, so the PDFs you can already download are the cheaper source.

Converting a CIBC PDF statement

  1. Upload one or more CIBC eStatements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. Download one transaction per row, with date, description, withdrawals, deposits and balance in separate columns.

Amounts stay in dollars, and dates are written out consistently, so check that your accounting software's import date setting matches.

Getting CIBC data into QuickBooks or Xero

  • QuickBooks: choose the 3- or 4-column CSV and upload it from file. QuickBooks Online Canada takes up to 1,000 lines per upload and requires the file to be in English.
  • Xero: choose Xero CSV and import it as a bank statement for the matching account.

CIBC business clients can connect SmartBanking to QuickBooks Online or Xero for $5 a month each. For periods before the feed, convert the statements and import them. CIBC credit card eStatements convert with the credit card statement converter.

Choose your output format

Frequently asked questions

How far back can I get CIBC eStatements?

CIBC says you can view up to 7 years of credit card and bank account eStatements online and on mobile. For statements older than 2008, CIBC can mail them for a fee.

Can I download CIBC transactions to Excel?

Yes, as a spreadsheet (CSV) or for QuickBooks, Quicken and other software, using Download Transactions in Online Banking. It covers up to the last 13 months, one account at a time, and doesn't include the current day or the previous two business days.

Why are recent transactions missing from my CIBC download?

CIBC says transactions for the current day and the previous two business days aren't included in a download. They'll appear in a later download, or on your next statement.

Are CIBC eStatements accepted for tax purposes?

CIBC says electronic statements are accepted by the Canada Revenue Agency for tax purposes. Keep copies past 7 years by saving the PDFs yourself.

Can I import a converted CIBC statement into QuickBooks or Xero?

Yes. Choose QuickBooks 3- or 4-column CSV or Xero CSV as the output. CIBC business clients can also pay for a SmartBanking feed to QuickBooks Online or Xero ($5 a month each), which covers transactions from when it's connected.

Is it safe to upload a CIBC statement?

Statements show your account and transit numbers and transaction history. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Stop retyping statements by hand

Upload a PDF and download clean Excel, CSV, Xero or QuickBooks data in about 30 seconds.