Scotiabank Statement to Excel: Convert and Check

TL;DR The reliable way to get Scotiabank statements into Excel is to work from the statement PDFs, convert each one so that every transaction is a single row, and then check the result before you use it. Put dates into a real Excel date format, turn debits and credits into one signed Amount column, remove opening balance lines, and confirm that the opening balance plus all transactions equals the closing balance for every statement. Treat each product separately: chequing, savings, credit cards and lines of credit all have slightly different layouts and sign conventions. Once each statement balances, you can stack them, categorize them and import them into accounting software.

Scotiabank (The Bank of Nova Scotia) is one of Canada's big banks, with a large international footprint as well. If you bank there, sooner or later you'll probably need your transactions in a spreadsheet: to prepare business income and expenses for your tax return, to give your accountant a clean year of records, to show a lender your cash flow, to split shared costs with a partner, or just to see where the money went.

This guide focuses on doing that properly. It covers the products you're likely to have, how to approach each, a step-by-step conversion and clean-up, a worked example with a line of credit, and what to do with the result. Online banking menus change and vary between personal and business banking, so we describe them generally instead of listing exact clicks.

Start with the right source file

Before converting anything, decide which file you actually need.

Online banking exports are good for recent activity. They are quick and already in rows. They usually cover a limited window, though, and may not line up exactly with a statement period. They also don't include the official opening and closing balances, which is what you need to prove nothing is missing.

Statement PDFs are the bank's formal record for a period. They include the opening balance, every posted transaction and the closing balance. Accountants, lenders, landlords and government programs generally ask for statements, not exports.

If your goal is anything more than a quick look at recent spending, use statements. Download one PDF per account per month and give each a sortable name, like scotia-chequing-2026-02.pdf, scotia-visa-2026-02.pdf or scotia-loc-2026-02.pdf. If you need months that are no longer available online, our guide to getting old bank statements explains the usual options.

Know which product you're converting

People often have several Scotiabank products, and the statements differ. It helps to know what to expect from each before you start.

Chequing and savings accounts

Deposit account statements typically show the statement period, an opening balance, a list of transactions with a date, description, withdrawal and deposit amounts, and often a running balance, followed by a closing balance. Money in increases the balance; money out reduces it. These are the most straightforward to convert.

Credit cards

Card statements usually show a previous balance, then payments and credits, purchases and other charges, interest, and the new balance. They also include a minimum payment and due date, which you don't need in your transaction data. Transactions often have both a transaction date and a posting date. On a card, purchases increase what you owe and payments reduce it, which is the opposite of how a chequing account feels.

Lines of credit

A personal or business line of credit statement usually looks like a hybrid. It has a balance owing, advances (money drawn), payments, and interest charged. Like a card, an advance increases the balance owed. Lines of credit are often linked to a chequing account, so the same movement appears on both statements: an advance on the line of credit and a deposit in chequing.

Business accounts

Business account statements can include more fee lines, batch deposits, and service charge summaries. The conversion is the same, but you'll want to keep fees as separate rows rather than netting them against deposits, because they're usually deductible business expenses and your accountant will want to see them.

Step-by-step conversion

1. Convert each PDF to rows

You have three practical options.

• Copy and paste from a PDF viewer into Excel works for a page or two. Expect misaligned columns and wrapped descriptions on their own rows.
• Power Query on Excel for Windows can import tables from PDFs. It's free and works well on clean layouts. See our Power Query bank statement guide for the steps.
• A statement converter like SheetStatement extracts each transaction to one row, produces a signed amount, and checks the opening and closing balances before export. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans handle more.

If you're comparing approaches, our article on PDF to Excel methods for bank statements goes through the trade-offs in more detail.

2. Standardize the columns

Aim for the same set of columns for every account, even if you leave some blank. That makes stacking statements trivial later:

Add the Account and Statement columns yourself. They seem redundant on a single statement but are essential once you combine many.

3. Fix the dates

Canadian statements may print dates in several ways: a short month name and day ("FEB 03"), a full date, or a numeric date. Numeric dates are where errors happen, because 03/02/2026 means 3 February in a day-first locale and March 2 in a month-first one. If Excel's regional setting doesn't match, it will misread some dates and leave others as text.

Use Power Query's Change Type Using Locale, or Text to Columns with an explicit date order, to convert the column. For short dates without a year, build the full date from the statement period:

=DATEVALUE(C2 & " " & YEAR(StatementEnd))

If a statement spans December and January, the December lines belong to the earlier year. Handle that with a helper:

=IF(MONTH(D2) > MONTH(StatementEnd), DATE(YEAR(StatementEnd)-1, MONTH(D2), DAY(D2)), D2)

Our guide to fixing bank statement dates in Excel has more variations.

4. Build the signed Amount

For deposit accounts, use deposits minus withdrawals:

=N(F2) - N(E2)

For credit cards and lines of credit, decide your convention up front. If you want everything from your own point of view, so that spending is negative across all accounts, make purchases, interest, fees and advances negative and payments positive. If you'd rather mirror the statement, make charges positive and payments negative. Either works, as long as you use one convention per account and adjust the balance check to suit.

5. Remove non-transaction lines

Delete opening balance, balance forward, subtotal, and "continued" lines, after noting the opening and closing balances. Also delete summary rows like "total deposits" if they came through. These rows are the most common reason totals double.

Prove every statement balances

This is the step people skip, and it's the one that makes your spreadsheet trustworthy.

For a deposit account:

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

For a credit card or line of credit, using the "mirror the statement" convention (charges positive):

=ROUND(PreviousBalance + SUM(Amount) - NewBalance, 2)

Each should return zero. If not:

• A difference equal to a single transaction usually means a missing row, often at a page break.
• A difference equal to twice a transaction means a reversed sign.
• A round difference (10, 100, 1,000) often points to a misread digit on a scan.

If the statement prints a running balance, add a row-level check so you can see exactly where things go wrong:

=ROUND(H1 + G2 - H2, 2)

The first non-zero value marks the problem line. The running balance formula guide explains this check and how to adapt it when balances are printed only once per day.

Finally, check continuity across months. Each statement's opening balance should equal the previous statement's closing balance. A gap means a missing statement.

Worked example: chequing plus a line of credit

Imagine a small consulting business with a Scotiabank business chequing account and a business line of credit. In March, the owner draws $5,000 from the line of credit to cover a slow month, pays a supplier, and later repays $2,000.

On the chequing statement, the converted rows might look like this:

On the line of credit statement, using the mirror convention (balance owed goes up with advances):

All figures are illustrative.

Three things to notice:

1. The $5,000 and $2,000 movements appear on both statements. They are transfers, not income or expenses. When you categorize, label both sides as "Transfer: line of credit" so they cancel out in any income or expense summary.
2. The interest on the line of credit is a real cost, and for a business it's typically an expense. It only appears on the line of credit statement, so if you only convert chequing you'll miss it.
3. The monthly fee on chequing is easy to overlook because it's small. Keep it as its own row.

Each statement still needs its own balance check. When both pass, you can stack them in one table with the Account column distinguishing them.

Combining a year of statements

Once each statement balances, put them all in one table:

1. Paste each statement's rows below the last, keeping the Account and Statement columns filled in.
2. Convert the range to a table (Ctrl+T) and name it.
3. Build a summary table with one row per account per statement, showing opening, sum of amounts, closing and difference, using SUMIFS. Every difference should be zero.
4. Sort by date and look for obvious duplicates at statement boundaries.

Our guide to combining multiple bank statements in Excel covers this in depth, including how to keep the file manageable as it grows.

Categorizing and using the data

Categories. Add a Category column and fill it with a lookup against a list of keywords and categories. Start with your most frequent payees; a short list often covers most of the rows. See Excel formulas to categorize bank transactions for formula patterns.

Transfers. Tag transfers between your own accounts so they don't inflate income or expenses. Credit card payments, line of credit draws and repayments, and savings transfers are the usual suspects.

Summaries. Build a pivot table with months as columns and categories as rows. Our bank statement pivot table guide shows how.

Tax preparation. For self-employed Canadians, a categorized year of business transactions is a helpful working file when preparing business income and expenses. Keep the original PDFs too. This is general information, not tax advice; ask a qualified accountant about your situation. Our guide to bank statements for tax preparation lists what preparers commonly want.

Accounting software. For QuickBooks Online, follow importing a bank statement into QuickBooks Online. For Xero, check the Xero CSV import format. For Wave, which is popular with Canadian freelancers, see importing a bank statement into Wave.

Keeping your records organized

A converted spreadsheet is only as useful as your ability to find and trust it later. A few habits make a big difference, especially if you'll hand the file to someone else.

Keep the PDFs next to the spreadsheet. Store the original statements in the same folder as the workbook, with the same naming pattern. If an accountant or lender questions a figure, you can open the matching statement in seconds.

Add a checks sheet. Put the per-statement summary (opening, sum of amounts, closing, difference) on its own sheet at the front of the workbook. Anyone opening the file can see at a glance that every statement balances.

Don't edit amounts by hand. If a row is wrong, fix it and re-run the balance check rather than typing over a total to make it match. A forced number hides the real problem.

Record what you changed. A short notes column, such as "merged wrapped description" or "removed duplicate header row", helps when you or someone else revisits the file months later.

Save a copy before big changes. Before you sort, categorize or delete rows across the whole table, save a version. It's the easiest way to recover from an accidental mass edit.

Troubleshooting

Totals are double what they should be. You've probably included summary rows, or combined two statements with overlapping dates. Remove summary lines and check statement boundaries.

Amounts won't sum. They're text. Strip currency symbols, commas and non-breaking spaces, then convert with VALUE. If negatives appear in parentheses, see converting parentheses to negative numbers.

Card statement balance check fails by the interest amount. Interest and fees are often listed in a separate section of the statement, away from purchases. Make sure you captured that section.

USD account mixed with CAD. If you hold a US dollar account, convert and keep it separately. Don't add USD and CAD amounts in the same column without a currency column and a clear conversion method.

Descriptions are split across two rows. Merge the wrapped text into the row with the amount and delete the leftover row. A converter that handles wrapped lines will save time here. For more help splitting long descriptions into useful parts, see splitting bank transaction descriptions in Excel.

Get your Scotiabank statements into Excel

Upload your statement PDFs to SheetStatement, check the rows and balance check for each, and export to Excel or CSV. The free plan covers 3 pages a month so you can test it on a real statement first.

FAQ

Can I export Scotiabank transactions directly to Excel?

Online banking typically lets you download recent transactions in a spreadsheet-friendly format. For complete statement periods with official balances, or for older months, convert the statement PDFs.

Should I convert my credit card and chequing statements together?

Convert them separately, check each statement's balance, then combine them in one table with an Account column. Tag card payments as transfers so you don't count spending twice.

How should I handle a line of credit?

Treat it as its own account. Advances and repayments are transfers when they move money to and from chequing, while interest is a cost that only appears on the line of credit statement.

Why do my dates look wrong?

Your Excel locale may not match the statement's date format. Convert the column with the correct locale or date order, and add the year from the statement period when dates print without one.

What does it mean if my balance check is off by a round number?

A round difference such as 100 or 1,000 usually means a digit was misread, which is more common on scanned statements. Check the rows on the page where the running balance first goes wrong.

Can I use my converted statements for a tax return?

They're a useful working file, and accountants often accept spreadsheets alongside the original PDFs. This is general information, not tax advice.

Is uploading statements safe?

Read the security page to see how SheetStatement handles files, and review any service's policy before uploading financial documents.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.