Scotiabank (Bank of Nova Scotia) is one of Canada's Big Five banks, but the way you convert a Scotiabank bank statement to Excel depends entirely on which banking platform you use, and the two platforms offer vastly different export capabilities.
ScotiaConnect, Scotiabank's business banking portal, supports native transaction export to CSV, Excel, QFX, QBO, and BAI2 formats, with built-in date-range filtering and account selection. Scotia Online monthly eStatements are PDF documents, but online banking also downloads an account's transactions in Quicken or QuickBooks format for a statement period you choose. Convert the PDF eStatement when you need the data in Excel or CSV, the official statement layout, or an archived statement.
This distinction matters because it determines your entire workflow. The Canadian Bankers Association's 2024 How Canadians Bank survey reports that 77% of Canadians use digital channels for most banking transactions, so Scotiabank customers often start from either a portal export or a downloaded PDF statement. If you need Scotiabank statement data for bookkeeping, tax filing, or a QuickBooks/Xero import, first identify whether the account is in ScotiaConnect or Scotia Online.
Here's the short version:
- ScotiaConnect (business banking): You have native exports. Skip ahead to the ScotiaConnect export section below.
- Scotia Online (personal banking): Monthly eStatements are PDFs. Download transactions when a Quicken or QuickBooks file is what you need; convert the PDF when you need a spreadsheet or the official statement is the source.
This guide covers both paths and also addresses Scotiabank-specific parsing challenges (Canadian and US dollar accounts, Scene+ rewards data, and date formatting) that can break a clean spreadsheet output. If you work with statements from other Canadian banks as well, see five proven methods for converting any bank statement to Excel for a broader overview of your options.
How to Export Transactions From ScotiaConnect
ScotiaConnect is Scotiabank's business banking platform. If you have access, start with its native exports before using a PDF converter.
The key is choosing the right format for your destination system.
Choosing the Right Export Format
Start with where the data needs to end up.
For spreadsheet analysis and manual reconciliation:
- CSV and Excel (.XLS) give you raw transaction data in columns you can sort, filter, and pivot. CSV is the most portable option if you work across multiple tools; Excel suits a workflow that lives in Microsoft Office.
For accounting software import:
- QBO for QuickBooks Online or QuickBooks Desktop.
- QFX for Quicken personal and business finance software.
- OFX for Microsoft Money and other OFX-compatible applications.
- ASO for Sage Simply Accounting (now Sage 50).
For enterprise and treasury management:
- BAI2 is the standard for treasury management systems and enterprise cash management platforms. If your finance team or ERP requires BAI2, ScotiaConnect exports it natively.
- Custom Export (.DAT) for organizations with proprietary import requirements. Fixed Width Text and Tab Separated Text are also available for legacy systems that expect positional or tab-delimited data.
Not every user sees every format. Fixed length text, CSV, tab separated text and Excel are ScotiaConnect's four standard exports. BAI2, OFX, QFX, QBO and ASO are advanced exports, and your company's ScotiaConnect administrator grants each one to a user group (ScotiaConnect Group Information help). If QBO or BAI2 is missing from your format list, ask your administrator to add it to your group.
If you are importing into QuickBooks, use the QBO format rather than CSV. QBO carries transaction metadata that prevents duplicate entries during import and maps fields automatically. CSV works, but you will spend time manually mapping columns and cleaning up formatting. The same logic applies to QFX for Quicken users and ASO for Sage 50.
Exporting Transactions Step by Step
ScotiaConnect's File Export help sets out the one-time export:
- From the Account Information menu, select Transaction Search, then Transactions - One Time.
- Choose a Record Layout (Canada, USA or Global).
- Choose the Export Format.
- Choose a Transaction Type to narrow the results, which is useful before month-end reconciliation or before importing bank statements into QuickBooks.
- Choose a Date option: Current Day, Prior Day, Last Week, Last Month, or a date range.
- Set Include Headings to Yes or No, and choose whether to query by post date or value date.
- Click Select Accounts and pick the accounts to include.
- Click the Export icon, then save or open the file.
If you run the same export regularly, such as a monthly CSV pull for reconciliation, use Transactions - From Template instead. Configure the query once and save it as an Export ID, then pick that Export ID each period. This eliminates repetitive setup for recurring workflows.
Transaction History Retention
ScotiaConnect's help pages don't state how far back transactions can be exported. If a date range you need comes back empty, contact Scotiabank's business banking support for the older records, and ask well ahead of an audit or year-end filing rather than during it.
A Note for Personal Banking Customers
ScotiaConnect is for business banking only. If you bank personally with Scotiabank, the next section covers both the transaction download in online banking and the PDF eStatements. If you also manage accounts at other Canadian banks, you may find our guide on converting BMO bank statements to Excel or CSV useful for multi-bank reconciliation.
How to Convert Scotia Online PDF Statements to Excel
Personal accounts in Scotiabank's online banking give you two sources: a transaction download in Quicken or QuickBooks format, and monthly eStatements as PDFs. The download suits a Quicken or QuickBooks import. For Excel or CSV, or when the official statement is the record you need, start from the PDF.
Downloading Transactions From Personal Online Banking
Online banking on the web downloads an account's transactions for a statement period you choose. From the Accounts page, select the account, pick the statement period from the dropdown, and select Load more at the bottom of the list until every transaction in the period shows. Then select the download icon at the top of the screen and choose Download as QuickBooks (Scotiabank Help Centre). Quicken (QFX) is the other format on offer, and Microsoft Money accepts either file (Scotiabank Help Centre).
Scotiabank's help articles name only those two formats for the download; none of them mentions CSV or Excel. A QFX or QBO file goes straight into Quicken or QuickBooks. If you need a spreadsheet and your screen offers no spreadsheet option, convert the statement PDF as described below.
Two limits catch people out. The mobile app doesn't download transaction history yet, so sign in to online banking in a web browser to get the file (Scotiabank Help Centre). And transaction history goes back to January 1, 2018, but the list opens on the past 45 days by default, so pick the statement period you want before downloading (Scotiabank Help Centre). For anything earlier than 2018, the statement PDFs are the record.
For a Scotiabank credit card, the download articles don't say whether the card's transactions download the way a bank account's do. If your card shows no download option, its PDF statements, found as described in the next section, are the dependable source. A card statement carries purchases, payments, interest and fees in its own layout, and our guide to converting credit card statements to Excel, with a tie-out that proves every row was captured, covers how to set up its columns.
Downloading Your Scotia Online eStatements
Before converting anything, you need the PDF files. Scotiabank puts bank account and credit card statements in the same place, on the web and in the app:
- Sign in to Scotiabank online banking or the Scotiabank app.
- On the Accounts page, select the account or credit card you need statements for.
- Select Documents.
- Choose the statement and download the PDF.
Scotiabank keeps up to seven years of statements there, for bank accounts and credit cards alike, and its eStatements page describes 24 months of history to view, print or download, with statements archived for up to seven years. If you anticipate needing older data, download and archive your PDFs before they pass that seven-year mark. For a statement that is already older, contact Scotiabank personal banking support or visit your branch to request a copy.
Extraction Tools Built for Financial Documents
Tools built for extracting data from financial documents are the strongest option for converting Scotiabank PDF statements to Excel or CSV. They work from the document's structure (column alignment, tables that continue across pages, the difference between a debit and a credit) rather than simply reading characters off a page.
The workflow is straightforward. You upload your Scotia Online PDF eStatements, write a prompt in plain words describing what you need, and download a structured output file. For example, you might prompt:
"Extract transaction date, description, debit, credit, and running balance from this Scotiabank bank statement."
Each transaction comes back as a row, across every page of the statement. In the Excel file, dates come through as dates and amounts as numbers, and every row is traced to the page it came from, so you can check it against the statement.
You can convert your Scotiabank PDF statements to Excel: upload the PDFs, give your prompt, and get back an .xlsx or .csv file ready for analysis or import into QuickBooks, Xero, or another accounting tool. If you have several months of statements to process, one batch takes up to 6,000 files, so you can convert a full year of Scotiabank eStatements at once rather than processing them one at a time.
The prompt is flexible. You can be specific, listing exact fields and column names, or goal-oriented, such as "I need to reconcile these Scotiabank transactions against my invoices." If you are converting statements from a Canadian dollar account and a US dollar account together, ask for a currency column on every row, or run each currency as its own extraction, which avoids the manual cleanup described in the parsing challenges section below.
Alternative Approaches and Their Tradeoffs
A few other methods exist, though each comes with significant limitations for bank statement conversion:
- Manual copy-paste: You can select text in the PDF and paste it into Excel. For a single-page statement with a handful of transactions, this works in a pinch. For multi-page statements, columns misalign, line breaks split transactions unpredictably, and you spend more time cleaning the data than you saved by not typing it manually.
- Generic OCR tools: These convert scanned images to text but lack awareness of tabular structure. Financial documents with columnar layouts, where a number could be a debit, a credit, or a balance depending on its horizontal position, are particularly prone to misclassification.
- Tabular PDF extractors: Tools like Tabula or Camelot extract tables from PDFs and perform better than raw OCR. However, they struggle with multi-page table continuation, merged header rows, and the formatting inconsistencies common in bank-generated PDFs.
Scotiabank Statement Parsing Challenges and How to Handle Them
Getting your Scotiabank data into a spreadsheet is only half the battle. Whether you exported directly from ScotiaConnect or converted a PDF from Scotia Online, several Scotiabank-specific parsing challenges can produce messy, unreliable output. Here are the most common issues and how to fix them.
Scene+ Credit Card Rewards Data
Scene+ cards carry rewards figures alongside the spending. In online banking, a card transaction's details show the points it qualified for and whether an accelerated earn rate applied (Scotiabank Help Centre). Wherever points figures sit near the amounts on the page you are converting, a parser built for a plain date, description, amount and balance layout can misread them: a points figure lands in an amount field, or merges with the description text.
If you need the rewards data, extract Scene+ points as a separate column in your spreadsheet so it doesn't interfere with your debit, credit, and balance fields. If you don't need it for rewards tracking, tell your extraction tool to leave the points out. When cleaning up manually, check that your amount columns contain only numeric values: stray points data mixed into a transaction amount column will break any downstream calculations or accounting software imports.
CAD/USD Multi-Currency Statement Handling
Scotiabank keeps Canadian and US dollars in separate accounts. A US dollar account, such as the Scotia U.S. Dollar Daily Interest Account, is an account of its own, and the Scotiabank U.S. Dollar Visa card runs its transactions and fees in US dollars. A business or household that banks in both currencies therefore has two sets of statements whose amounts and running balances can't simply be added together. Purchases made in US dollars on a Canadian dollar card are a different case: they are converted on the account, and most Scotiabank cards add a 2.5% foreign currency conversion fee (Scotiabank credit card fees), so they reach the statement as Canadian dollar amounts.
Combining the CAD and USD statements into one flat table without marking them almost always produces errors: currency amounts get mixed together, and running balances become meaningless. The cleanest approach is to keep a separate worksheet or file per currency, each with its own headers and balance column. If you prefer a single worksheet, add a currency indicator column (CAD or USD) to every row and make sure your number formatting is consistent across both currencies. Either way, never rely on a single "amount" column to hold both CAD and USD figures without a clear currency identifier.
Date Format Ambiguity
Dates trip up statement conversions in two ways. A date like 05/06/2026 is ambiguous: Excel interprets it according to your computer's regional settings, which in Canada can be set to day-first or month-first, so it may swap the month and day without any warning. And a statement that prints dates without the year leaves the year to the statement period, so a statement running from December into January needs the right year on each row.
To prevent silent date errors, enforce a consistent date format during extraction rather than fixing it after the fact. If your converter allows you to specify an output date format, choose YYYY-MM-DD (ISO 8601), which is unambiguous regardless of locale. If you're cleaning dates after conversion, select the entire date column in Excel, open Format Cells, and set a custom format that matches your source data. Then spot-check dates between the 1st and 12th of any month, since those are the only rows where a day/month swap would go unnoticed.