Scotiabank Statement to CSV/Excel - QuickBooks & Xero Import
Scotiabank publishes one of the clearer statement help pages in Canada, including separate web and app paths plus product-specific statement cadence, but the document you download is still a bank PDF rather than an accounting import. Exact Statement converts Scotiabank statement PDFs into clean CSV or Excel while keeping Canadian references and balance fields reviewable.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Official Scotiabank guidance: up to 7 years of account statements are available online; web path is Accounts > account > Documents, and the app path is Home > account > Manage > View all statements.
Where To Download Scotiabank Statements
Scotiabank is strong source material because it publishes both the web path, the app path, and the statement cadence by product.
Use Documents in online banking
Scotiabank says you select the bank account from Accounts, then choose Documents to view statements.
Use Manage in the mobile app
In the app, Scotiabank says you tap the account, tap Manage, and then View all statements.
Seven-year access is published
Scotiabank says you can access up to 7 years of account statements online.
Statement cadence depends on the product
Scotiabank says chequing, savings, and cards are usually monthly, investments quarterly, and mortgages yearly.
What Usually Matters In Scotiabank Statements
This page works because Scotiabank draws a clear line between recent activity, account statements, and product-specific statement cadence.
Recent activity is not the same as a statement period
Scotiabank says recent transactions can be viewed online or in the app, but the formal statement remains its own document.
Different products do not publish on the same schedule
Monthly, quarterly, and yearly statement rhythms change how users backfill missing periods.
Canadian transfer references still matter
Interac and bank-specific memo text are often needed later for reconciliation or audit review.
App and web statement paths are different
That is normal, but it is a real difference users notice when they are trying to retrieve PDFs quickly.
QBO and Xero still want their own schema
A Scotiabank PDF can be accurate and still need target-specific cleanup before import.
Protected files must be opened first
If a statement PDF is protected, unlock it before upload. Exact Statement does not remove Scotiabank PDF passwords for you.
Common Scotiabank Import Pitfalls
The main mistakes here come from mixing activity screens, statement PDFs, and different product cadences into one assumption.
Using recent activity instead of the statement PDF
That can break month-end reconciliation when statement periods and activity filters do not line up.
Assuming every Scotiabank account gets a monthly statement
Scotiabank explicitly says some products are quarterly or yearly.
Dropping Interac and fee labels during cleanup
Reference text is often the difference between a useful import and a hard-to-audit import.
Copy-pasting rows without separating balances from amounts
This is a common spreadsheet failure on balance-heavy PDFs.
Preview A Cleaned Scotiabank Export
These sample rows emphasize Canadian current-account patterns and a statement-period export that still keeps review-friendly balance fields.
| Date | Amount | Payee | Description | Reference | Transaction Type | Balance | Currency | Account ID |
|---|---|---|---|---|---|---|---|---|
| 03/03/2025 | -1200.00 | Client payment | INTERAC E-TRANSFER PAYOUT | INTERAC | Debit | 6384.11 | CAD | ****1149 |
| 04/03/2025 | 144.22 | Bell Canada | PRE-AUTHORIZED DEBIT BELL CANADA | PAD | Credit | 6239.89 | CAD | ****1149 |
| 05/03/2025 | 28.51 | Uber | DEBIT PURCHASE UBER TRIP | CARD | Credit | 6211.38 | CAD | ****1149 |
| 06/03/2025 | -2890.00 | Payroll | PAYROLL DIRECT DEPOSIT | PAYROLL | Debit | 9101.38 | CAD | ****1149 |
| 07/03/2025 | 16.95 | Scotiabank fee | MONTHLY ACCOUNT FEE | FEE | Credit | 9084.43 | CAD | ****1149 |
Sample rows for preview only. Scotiabank examples emphasize statement cadence, Interac references, and balance-aware review output.
How Scotiabank Fields Map Into Accounting Imports
The important work is preserving statement-period fidelity while normalizing the file into the destination import schema.
| Field In Statement PDF | Exact Statement Output | QuickBooks Online | Xero CSV |
|---|---|---|---|
| Statement or transaction date | Normalized Date | Date | Date |
| Merchant / transfer / fee text | Payee + cleaned Description | Description | Payee + Description |
| Deposit / withdrawal amount | Signed Amount | Amount or Credit/Debit | Amount + Transaction Type |
| Interac / card / memo reference | Reference | Optional or merged | Reference |
| Running balance | Balance for XLSX review | Not required | Not required |
Sources: Scotiabank statements centre · Scotiabank help centre · Intuit CSV format guide · Xero CSV import guide.
Scotiabank Statement to CSV - Frequently Asked Questions
Scotiabank says you can access up to 7 years of account statements online and in the app.
Scotiabank says you select the bank account from the Accounts page and then choose Documents.
Scotiabank says you tap the account from Home, tap Manage, and then tap View all statements.
Not if you need the formal statement period. Scotiabank treats recent activity and account statements as different views, which is why month-end reconciliation usually starts from the statement PDF.
No. Scotiabank says most chequing, savings, and card statements are monthly, while investments are quarterly and mortgages are yearly.
Unlock it before upload. Exact Statement does not remove Scotiabank PDF passwords for you.
Need the official help pages? Scotiabank statements centre · Scotiabank help centre · support@exactstatement.com.
Convert Your Scotiabank Statement Now
Upload a Scotiabank statement PDF and export a clean CSV or Excel file for QuickBooks Online, Xero, or spreadsheet review.