How to Convert Scotiabank Statements to CSV or Excel

Why Convert Scotiabank Statements?

Scotiabank (Bank of Nova Scotia) is Canada's most international bank, operating in over 30 countries and serving millions of customers. Their PDF bank statements contain detailed transaction data for chequing, savings, and credit card accounts. For business owners, accountants, and anyone managing personal finances, having this data in CSV or Excel format is essential — whether for tax filing, expense reports, budgeting, or importing into accounting software like QuickBooks or Xero. BankRead's AI converts Scotiabank statements to structured spreadsheet data in seconds.

Understanding the Scotiabank Statement Format

Scotiabank chequing statements use a portrait PDF layout with transactions grouped by date. The table columns are Date, Description, Withdrawals, Deposits, and Balance. The statement header includes the account number, transit number, statement period, and account summary. Scotiabank Visa and Amex credit card statements have a different layout: they show a summary of account activity at the top, followed by a detailed transaction list with Date, Description, and Amount. Scotia Scene+ reward point activity may also appear on Visa statements.

How to Convert with BankRead

Follow these steps to convert your Scotiabank PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Scotiabank online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your Scotiabank Statement PDF

1. Sign in to Scotia OnLine at scotiabank.com with your card number and password.
2. From the Accounts page, select the account you want to export.
3. Click 'Statements' or 'View eStatements' in the account menu.
4. Select the statement month — Scotiabank stores eStatements for up to 7 years.
5. Download the PDF by clicking the statement date link or the PDF icon.

What Data Gets Extracted

BankRead extracts the following fields from your Scotiabank statement:

• Transaction date (posted date as shown on the statement)
• Description / merchant name (e.g., 'POS — METRO INC MONTREAL QC')
• Withdrawals (debit amounts)
• Deposits (credit amounts)
• Running balance after each transaction
• AI-assigned category (e.g., Groceries, Transport, Entertainment)

Export Options

Once your Scotiabank statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for Scotiabank Statements

• Scotiabank statements group transactions by date — BankRead preserves this chronological order in the output.
• Scene+ reward transactions and interest charges are extracted as regular line items, so nothing is missed.
• Scotiabank Visa and Amex credit card statements have different layouts from banking statements — both are fully supported.
• USD account statements display amounts in US dollars. BankRead extracts the values as shown without conversion.
• Scotiabank's iTRADE investment account statements are not banking statements — these are not supported. Stick to chequing, savings, and credit card statements.

Common Issues and Solutions

• Scotiabank occasionally reformats their eStatement templates. If a newer statement looks different, BankRead's AI adapts to layout changes automatically.
• Some Scotiabank PDFs include a 'pre-authorized payment summary' — this is extracted as part of the transaction table.
• Scotiabank joint account statements show all transactions from all account holders. BankRead extracts everything; filter by description in your spreadsheet if needed.

Frequently Asked Questions