CIBC Bank Statement to Excel: Accounts and Credit Cards

TL;DR To get a CIBC statement into Excel, use the PDF eStatement for each period you need, convert it so every transaction is one row with a single signed amount, and confirm that the opening balance plus all transactions equals the closing balance. Chequing and savings statements work like any bank account, while CIBC credit card statements run "backwards": purchases increase what you owe and payments reduce it, so flip signs deliberately. If transaction dates on the statement don't include a year, add it from the statement period, taking care with statements that cross December and January. Once each statement reconciles, the data is ready for bookkeeping, GST/HST, a tax return, or an import into QuickBooks, Xero or Wave.

CIBC is one of Canada's largest banks, and plenty of individuals, sole proprietors and small corporations run their finances through a CIBC chequing account and a CIBC credit card. The online banking downloads are handy for recent activity, but they don't always go back far enough, and accountants, lenders and the Canada Revenue Agency tend to think in terms of statements. Sooner or later you'll want those statements in a spreadsheet.

This guide covers what's on a CIBC statement, whether to start from a download or a PDF, how to convert and check the data, the specific quirks of credit card statements and dates, a worked example, and how to move the result into accounting software. CIBC's online banking changes over time, so we describe the options generally rather than giving click-by-click menu paths.

What's on a CIBC statement

Whether it's a chequing account, a savings account or a credit card, a statement is a record of one account over one period. You can expect to find:

• Account information: the account holder, and the account or card number (usually partly masked).
• The statement period: a start and end date.
• Opening and closing balances. For a bank account, the balance at the start and end of the period. For a credit card, the previous balance and the new balance.
• The transaction list: a date, a description, and an amount, often split into withdrawals and deposits (or charges and credits), sometimes with a running balance.
• For credit cards: a payment due date, a minimum payment, credit limit information, and interest and fee lines.

Statements may be available in English or French. The logic is identical, but column headings and month abbreviations differ, which matters if you're writing formulas that look for text such as "Jan" or "janv."

Start with a download or a PDF?

CIBC online banking generally lets you download recent transactions in spreadsheet-friendly formats and view eStatements as PDFs. Check what your account currently offers.

Transaction downloads (CSV and similar) open in Excel straight away and are good for quick analysis of recent activity. But they typically cover only a limited window, they may not include opening and closing balances, and they may show pending or recent items that haven't settled.

PDF eStatements are the official record. They show a fixed period, the opening and closing balances, and look exactly like what a lender or accountant expects. For older periods, they may be the only thing you have.

Use this rule of thumb:

• For bookkeeping or tax for completed periods, work from statements, so every month has a fixed opening and closing figure to reconcile against.
• For documents you need to submit, send the PDFs and keep the spreadsheet as your working file.
• For a quick look at last month's spending, a download is fine.

Converting a CIBC PDF to rows

There are three common routes:

1. Copy and paste from a PDF viewer into Excel. Fine for a few lines; unreliable for full statements because columns merge and descriptions wrap onto separate rows.
2. Power Query in Excel for Windows can pull tables from a PDF. Results depend on how the PDF was built. Our Power Query bank statement guide explains how to clean up what it produces.
3. A dedicated converter. SheetStatement converts bank and credit card statement PDFs into one row per transaction, produces a signed amount, and checks opening and closing balances before export. The free plan includes 3 pages a month; paid plans are Starter ($9), Pro ($19) and Business ($39) per month.

Aim for this structure:

If the statement has separate Withdrawals and Deposits columns, combine them into one signed Amount: =Deposits-Withdrawals, treating blanks as zero. Our guide to separating debit and credit columns covers both directions. Name files with the account and period, for example cibc-chequing-2026-04.pdf and cibc-visa-2026-04.pdf, and put the file name in the Source file column.

Step 1: reconcile each statement

For a chequing or savings account:

=ROUND(Opening + SUM(Amount) - Closing, 2)

The result must be zero. If it isn't, look at the size of the difference:

• Equals one transaction: a row went missing, often at a page break or after a subtotal line.
• Equals twice a transaction: a sign is flipped.
• Equals a subtotal on the statement: a "total withdrawals" or "balance forward" line was imported as if it were a transaction.

With a running balance column, check row by row (balance in column D, amount in column C, starting on row 3):

=ROUND(D2 + C3 - D3, 2)

The first non-zero row shows exactly where the data stops matching. For more on this, see our guide to finding reconciliation discrepancies.

Step 2: get the signs right on credit card statements

Credit card statements confuse spreadsheets because the "balance" is money you owe.

On a CIBC credit card statement, a purchase increases the balance owing and a payment reduces it. If you treat the statement on its own terms:

=ROUND(PreviousBalance + SUM(Charges) - SUM(Credits) - NewBalance, 2)

For bookkeeping, you usually want the opposite view: purchases are spending (negative) and payments are transfers from your chequing account (positive on the card). Choose one convention and stick to it. The approach that causes least trouble is:

• Purchases, fees and interest: negative.
• Payments and refunds: positive.
• Balance check: -PreviousBalance + SUM(Amount) = -NewBalance, which is the same test written as a liability.

Two lines need special attention:

• Payments to the card also appear on your chequing statement. In your combined spending view, tag both sides as Transfer – Card payment so the money isn't counted as spending twice.
• Interest and fees are real costs. Keep them as their own category.

Our credit card reconciliation guide goes further on matching card statements to receipts and bookkeeping.

Step 3: fix dates (including the missing year)

Some bank and card statements list transactions with only a month and day, such as APR 03, and leave the year to the statement header. When that's the case, Excel has nothing to go on and will either treat the value as text or quietly assume the current year.

Add the year explicitly from the statement period:

=DATEVALUE(A2 & " " & StatementYear)

DATEVALUE depends on your system's locale and language, so if it fails, build the date from parts with DATE(year, month, day) and a small month lookup table (which also lets you handle French month abbreviations).

The December–January trap. A statement covering 15 December to 14 January has transactions in two calendar years. If you apply one year to every row, half of them will be a year off. A simple rule fixes it: if the transaction month is greater than the statement's end month, use the previous year.

=DATE(IF(Month > EndMonth, EndYear - 1, EndYear), Month, Day)

Transaction date vs posting date. Credit card statements often show both. Pick one and use it consistently. For month-end bookkeeping, the posting date usually lines up better with the statement; for expense claims, the transaction date is usually what matters.

If your dates are already in a mixed or broken state, our guide to fixing bank statement dates in Excel walks through the common cases.

A worked example

A small consulting business has a CIBC chequing account and a CIBC credit card. Here's a simplified April. All figures are invented for illustration.

Chequing statement: opening balance $4,310.00, closing balance $5,092.75.

Sum of amounts: 2,825 − 145.25 − 1,200 + 1,130 − 96 − 1,700 − 31 = 782.75. Opening $4,310.00 + $782.75 = $5,092.75. The chequing statement reconciles.

Credit card statement: previous balance $1,486.40, new balance $1,034.65.

Sum: −54.24 − 118.65 + 1,200 − 462.10 − 98.76 + 22.60 − 37.10 = 451.75. As a liability: −1,486.40 + 451.75 = −1,034.65, which matches the new balance of $1,034.65 owing. The card statement reconciles too.

Removing the double count. The $1,200 card payment appears on both statements. Tag both rows Transfer – Card payment and exclude them from income and expense totals. What's left:

• Income: $2,825 + $1,130 = $3,955.
• Expenses from chequing: $145.25 + $96 + $1,700 + $31 = $1,972.25.
• Expenses on the card: $54.24 + $118.65 + $462.10 + $98.76 + $37.10 − $22.60 refund = $748.25.

Sales tax. If the business is registered for GST/HST, the amounts above include tax on many lines, and the deposits from clients may include tax charged. A bank statement shows totals, not the tax portion, so you'll still need invoices and receipts to work out input tax credits and tax collected. The spreadsheet tells you which receipts to find. This is general information rather than tax advice; check CRA guidance or speak with an accountant.

Moving CIBC data into accounting software

Once each statement reconciles, you can import the transactions.

• QuickBooks Online accepts CSV files with a date, description and amount (or separate debit and credit columns). See our guide to importing bank statements into QuickBooks Online and, for problems, QuickBooks Online CSV import errors.
• Xero has its own CSV template. See the Xero CSV import format guide.
• Wave, popular with Canadian freelancers, also takes CSV. See importing bank statements into Wave.

A few rules apply whatever the software:

• Import each account into its own bank account in the software. Don't mix chequing and card transactions in one import.
• Use the bookkeeping sign convention for the card: purchases negative, payments positive, unless your software's template asks otherwise.
• Set a cut-over date if a bank feed is also connected, so the same transactions don't come in twice.
• Reconcile in the software afterwards, using the statement closing balances. If the software balance and the statement balance agree at each month end, you're done.

Common problems

A "Balance forward" line imported as a transaction. Delete it from the transaction list; it's already captured in the opening balance.

Amounts in parentheses or with trailing minus signs. Some formats show negatives as (45.00) or 45.00-. Our guide to converting parentheses to negative numbers has formulas for both.

Foreign currency purchases. The card statement shows the Canadian dollar amount charged, sometimes with the foreign amount in the description. Use the CAD figure for reconciliation.

E-transfer descriptions. Interac e-Transfers often include the sender's name or a reference. That's useful for matching invoices; keep the full description rather than trimming it.

Several accounts and months. Convert and reconcile each statement on its own, then combine them with an Account column. Our guide to combining multiple bank statements in Excel shows the safest way to stack files.

Duplicates where statement periods overlap. If you pull statements and downloads that cover the same days, check for duplicate rows before importing. See removing duplicate transactions in Excel.

Using CIBC statements for mortgages and tax

Lenders, landlords and immigration offices usually want official statements, not a spreadsheet you made. Send the PDFs in the format they ask for. Your reconciled spreadsheet is still valuable: it lets you review income patterns, large deposits and recurring payments before someone else asks about them. Our guides to bank statements for a mortgage application and bank statements for tax preparation cover what's typically needed.

For tax, keep the original statements with your records. Canadian record-keeping rules generally require you to keep supporting records for a number of years; check CRA's current guidance for your situation.

Building a monthly summary

Once you have several reconciled months, a summary sheet turns the rows into something you can actually read. Add a Month column with =TEXT(A2,"yyyy-mm") and a Category column, then build a table with months across the top and categories down the side:

=SUMIFS(Amount, Category, $A5, Month, B$4, Type, "<>Transfer*")

The last condition excludes anything tagged as a transfer, which keeps card payments and moves between your own accounts out of the totals. A pivot table does the same job with less typing; our guide to bank statement pivot tables in Excel shows how to set one up.

A few habits make the summary trustworthy:

• Add a check row under each month that compares total net movement on the summary with the net movement on the statements. If they differ, a transaction is uncategorized or tagged twice.
• Keep the chequing account and the card on one summary but with an Account filter, so you can see each separately when you need to.
• Don't edit the summary by hand. If a number looks wrong, fix the category on the transaction row and let the formulas update.

A short checklist

Before you rely on the spreadsheet or import it anywhere:

1. Each statement has its own block of rows with an Account and Source file column.
2. Every chequing and savings statement passes Opening + SUM(Amount) = Closing.
3. Every card statement passes the liability version of the check.
4. Dates are real dates with the correct year, including December–January statements.
5. Card payments are tagged as transfers on both sides.
6. Subtotal and "balance forward" lines have been removed.
7. The original PDFs are saved with clear names.

Convert your CIBC statements

Upload a CIBC chequing, savings or credit card statement PDF to SheetStatement, check the balances, and export to Excel or CSV. The free plan covers 3 pages a month, so you can try it on a real statement first.

FAQ

Can I download CIBC transactions directly into Excel?

CIBC online banking generally offers downloads of recent transactions in spreadsheet-friendly formats. For older periods or official records, convert the PDF eStatements.

Why don't my CIBC statement dates include a year?

Some statements show only the month and day for each transaction, with the year in the statement period. Add the year from the period, and watch statements that span December and January.

How do I reconcile a CIBC credit card statement in Excel?

Record purchases, fees and interest as negative and payments and refunds as positive, then check that minus the previous balance plus the sum of amounts equals minus the new balance.

Will my credit card payment be counted twice?

It will if you combine chequing and card data without tagging it. Mark the payment as a transfer on both statements and exclude it from income and expenses.

Can I use converted statements for GST/HST?

Converted statements help you organize transactions, but they don't show the tax portion. You'll still need invoices and receipts. This is general information, not tax advice.

Do French-language CIBC statements convert the same way?

Yes. The structure is the same; only labels and month names differ, so adjust any formulas that look for month text.

Is it safe to upload CIBC statements?

Read the provider's security and privacy policy first. SheetStatement's approach is described on the security page.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.