Why might a heading and a column both say Withdrawals?

One is a section title and one is the column. The column is the header sitting above the numbers. Section titles are not exported as rows.

Is 11/12/2026 November or December?

On CIBC Canada it is 11 December.

Will overdraft interest be included?

If it was charged as a dated withdrawal, yes. A sentence explaining the rate is not a row.

Can I convert several accounts in one PDF?

Only if you are willing to split the sheet afterward. A PDF that stacks two accounts will produce one table. It is cleaner to download one account at a time.

Banks · Canada

Convert CIBC statements to Excel

CIBC personal chequing PDFs typically show Withdrawals, Deposits, and Balance with day/month/year dates. Descriptions for pre-authorized payments include the originator, sometimes continued on the next line. The smart-account or fee summary above the table is not a substitute for the rows.

A text-based CIBC PDF is read in your browser. The file is not uploaded. If the columns on your copy differ from the notes below, change the mapping in the preview before you download.

Convert a CIBC PDF

How this statement is usually printed

A withdrawal column entry is money out. Do not also apply a minus unless the PDF printed one. Doing both would flip the row.

Heading text Withdrawals on its own line, above the table, is not the same thing as the column. The column header is the one aligned with the numbers.
Page numbers and 'continued' lines are not transactions.
CIBC credit cards and lines of credit are separate PDFs.
A dividend or interest credit is a deposit, not income you should delete.

Typical columns: Date, Description, Withdrawals, Deposits, Balance. Date order: day/month/year. Currency on the statement: CAD.

Steps

1. Download the chequing statement
In CIBC online banking, open the account and save the e-statement PDF.
2. Set DMY
Canadian dates are day/month/year.
3. Map Withdrawals and Deposits
Withdrawals are debits. Deposits are credits. Leave the numbers positive inside those columns.
4. Export
If the closing balance matches, download XLSX or CSV.

Questions about CIBC PDFs

Loading the guide…

Banks · Canada

Convert CIBC statements to Excel

A text-based CIBC PDF is read in your browser. The file is not uploaded. If the columns on your copy differ from the notes below, change the mapping in the preview before you download.

Convert a CIBC PDF

How this statement is usually printed

A withdrawal column entry is money out. Do not also apply a minus unless the PDF printed one. Doing both would flip the row.

Heading text Withdrawals on its own line, above the table, is not the same thing as the column. The column header is the one aligned with the numbers.
Page numbers and 'continued' lines are not transactions.
CIBC credit cards and lines of credit are separate PDFs.
A dividend or interest credit is a deposit, not income you should delete.

Typical columns: Date, Description, Withdrawals, Deposits, Balance. Date order: day/month/year. Currency on the statement: CAD.

Steps

1. Download the chequing statement
In CIBC online banking, open the account and save the e-statement PDF.
2. Set DMY
Canadian dates are day/month/year.
3. Map Withdrawals and Deposits
Withdrawals are debits. Deposits are credits. Leave the numbers positive inside those columns.
4. Export
If the closing balance matches, download XLSX or CSV.

Convert CIBC statements to Excel

How this statement is usually printed

Steps

1. Download the chequing statement

2. Set DMY

3. Map Withdrawals and Deposits

4. Export

Questions about CIBC PDFs

Related

Convert CIBC statements to Excel

How this statement is usually printed

Steps

1. Download the chequing statement

2. Set DMY

3. Map Withdrawals and Deposits

4. Export

Questions about CIBC PDFs

Related