Scotiabank Statement to CSV: eStatements Are PDF-Only

Scotiabank (officially the Bank of Nova Scotia) is one of Canada's Big Five banks and the most international of the group, serving millions of personal, small business, and commercial clients across Canada and dozens of other markets. That scale means Scotiabank PDF statements land on the desks of Canadian accountants, bookkeepers, and business owners every single day. And here is the catch: while Scotiabank archives up to 7 years of eStatements online, every one of them is delivered as a PDF. There is no button that turns a monthly statement into a spreadsheet. This guide covers every reliable way to convert Scotiabank statements into CSV, Excel, or QBO, whether you hold a Preferred Package chequing account, a Scene+ Visa, a Gold American Express, or a Scotiabank business account.

Can You Download CSV Directly from Scotiabank?

Only partially, and it depends heavily on which side of the bank you are on. Scotia online banking exposes a recent-transaction download on day-to-day chequing and savings accounts, and business clients on the separate ScotiaConnect platform get genuinely good export options (CSV, Excel, even BAI2). But for everyone in between, the gaps are significant. That covers most personal customers, and anyone working from statements.

• eStatements are PDF-only: Scotiabank delivers monthly statements as PDF documents, full stop. There is no CSV or Excel version of a statement, even though up to 7 years of them sit in your online archive.
• The transaction download only covers recent activity: The export in personal online banking is a live activity feed, not a statement archive. How far back it reaches varies by account type, but it is a fraction of the 7 years of history available as PDFs.
• Credit cards are the weak spot: Scene+ Visa and other Scotiabank card accounts are built around the monthly PDF statement. Spreadsheet-friendly exports for card activity are limited and vary by card, so a full year of credit card data almost always means working from the PDFs.
• The good export tools are business-only: CSV, Excel, fixed-width, BAI2, and accounting-software formats live inside ScotiaConnect, Scotiabank's business banking platform. If you are a personal customer, or a bookkeeper who only receives the client's PDFs, none of that helps you.
• No scanned-statement support: Paper statements from an older or closed Scotiabank account cannot be exported from online banking at all. The PDF (or a scan of it) is all you have.

In practice, that means any job longer than a recent reconciliation ends up running through the monthly PDF statements: a full personal tax year, a CRA review, a mortgage application that needs 12 months of history, or bookkeeping catch-up for a client. Scotiabank keeps up to 7 years of them online, which makes the PDF the most reliable long-term source of truth. The question is how to get the data back out.

The manual alternatives are painful. Copy-pasting from a Scotiabank PDF into Excel mangles the column alignment, splits wrapped descriptions across rows, and silently drops negative signs. Excel's built-in PDF import does better with simple tables but stumbles on Scotiabank's section headers, carried-forward balances, and rewards summaries. For one short statement you might get away with 20 minutes of cleanup; for a year of statements across two accounts, you are looking at hours of error-prone work that a purpose-built converter finishes in under a minute. Scotiabank is hardly unique here. RBC and BMO have their own export gaps, and our 2026 converter roundup compares the tools that fill them.

Scotiabank Statement Formats and Quirks

Scotiabank uses distinct statement layouts for personal day-to-day accounts, credit cards, and business banking. Knowing which one you are holding makes a real difference to the converted output.

The credit card date trap: Scotiabank credit card statements list transactions as MMM DD (often with both a transaction date and a posting date) and leave the year to the statement header, because each statement covers a single billing cycle. If you are batching several months of Scene+ Visa statements, the converter has to read the year from the header rather than the rows. CapyParse does this automatically and outputs ISO dates (YYYY-MM-DD), so a December purchase that posts in January never lands in the wrong tax year.

Scene+ points are not money: Scotiabank prints Scene+ rewards activity on Scene+ Visa statements: points earned, points redeemed, current balance. A naive PDF scraper will happily pull a 4,500-point line into your amount column and quietly wreck the reconciliation. CapyParse recognises the rewards section as non-monetary and keeps it out of your transaction rows entirely.

Separate withdrawal and deposit columns: Scotiabank chequing and savings statements split money out and money in across two columns, with a running balance alongside. CapyParse exports both the original two-column layout and a normalised signed amount column in the same file, so you can import into QuickBooks (which prefers a signed amount) or pivot in Excel (where two columns are often easier to work with).

Multi-line descriptions: Interac e-Transfer, bill payment, and pre-authorised debit entries on Scotiabank statements often wrap across two or three lines, with the payee on one line and the reference number on the next. Row-based PDF scrapers split these into phantom transactions or orphan the amount from its description. CapyParse stitches wrapped lines back into a single transaction row with the full narrative intact, which is exactly what you want when matching payees in QuickBooks or building categorisation rules in Excel.

Convert Scotiabank PDF to CSV with CapyParse (Step-by-Step)

Here is how to turn any Scotiabank PDF statement into a clean CSV, Excel, or QBO file in under a minute.

Scotiabank Credit Card and Business Accounts

CapyParse handles more than Scotiabank chequing accounts. Here is what to expect with the main Scotiabank product lines.

Scene+ Visa, Gold Amex, Passport, and Momentum Cards

Scotiabank's card lineup (the Scene+ Visa, Scotiabank Gold American Express, Passport Visa Infinite, Momentum Visa Infinite, and their no-fee siblings) follows the standard Scotiabank credit card statement format: an account activity summary up top, then a transaction list with transaction date, posting date, description, and a single amount column, plus a Scene+ rewards summary on Scene+-earning cards. CapyParse tags purchases, payments, refunds, interest, and fees separately so your Excel export distinguishes real spend from card payments automatically. Foreign currency purchases, common on the no-FX-fee Passport Visa Infinite, are preserved alongside their CAD equivalent so cross-border spending reconciles cleanly. A typical use case: a sole proprietor who put 2,400 CAD of deductible expenses on a personal Scene+ Visa over the year can convert all 12 statements, filter by merchant in Excel, and hand the accountant a clean expense schedule instead of a stack of PDFs.

Scotiabank Business Banking and ScotiaConnect

If your business runs on ScotiaConnect, you already have strong native exports: balance and transaction reporting can be downloaded as CSV, Excel, fixed-width text, or BAI2, with reusable export templates and formats aimed at QuickBooks and other accounting packages. But ScotiaConnect access is scoped to the business's own users. Bookkeepers and accountants working from emailed PDF statements, or anyone reconstructing history for an account without reporting entitlements, are back to the PDF. The same is true for small businesses that bank through regular Scotia online banking rather than ScotiaConnect: their statements are PDF-only, just like personal accounts. CapyParse converts Scotiabank business account statements while preserving cheque numbers, EFT and bill payment descriptions, and the separate debit and credit columns, so the output reconciles against QuickBooks Online, Xero, or Sage without manual cleanup. Multi-account business statements (an operating account and a payroll account in one PDF, for example) are split into separate files automatically.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Export your Scotiabank statement as a QBO file from CapyParse and import it directly into QuickBooks Online via Banking > Upload transactions, or into QuickBooks Desktop via File > Utilities > Import > Web Connect Files. The QBO format skips CSV column mapping entirely, which matters most for credit card statements where there is no native spreadsheet export to fall back on. Note that connecting Scotiabank to the QuickBooks bank feed only helps going forward. Feeds typically backfill a few months at most, so historical catch-up still runs through the PDF statements. For a detailed walkthrough, see our guide on importing bank statement CSVs into QuickBooks.

Excel and Google Sheets

The CSV export opens directly in Excel or Google Sheets. All transaction fields appear in separate columns: date, description, withdrawal, deposit, running balance, and a normalised signed amount. Everything is ready for sorting, filtering, pivot tables, or custom HST/GST categorisation formulas. The Excel (.xlsx) export preserves transaction-type tags on credit card statements so you can slice Scene+ Visa activity by purchases, payments, or interest in one click.

Already have an export file from ScotiaConnect? If it came out as QBO or OFX rather than CSV, see our QBO to CSV conversion guide to flatten it into a spreadsheet.

Tips for Scotiabank Conversions

Frequently Asked Questions

Related Articles