Scotiabank Statement to CSV: Working Around the 2018 Cutoff

Scotiabank keeps two different archives, and people only find out when they need the older one. The Help Centre is clear about both: statements are visible for the last seven years, but searchable transaction history is available dating back to 1 January 2018. Those are not the same shelf, and the export lives on the shorter one.

So if you are pulling together a mortgage application, a CRA review, an estate file, or several years of business activity for a bookkeeper, there is a good chance the transactions you want are only reachable as a statement PDF. This post covers Scotia Online's own download, exactly where it runs out, and how to turn the PDF into a CSV you can prove is complete.

Quick answer

1. Scotia Online's transaction download. From an account, choose a statement period, load all the transactions, and use the download icon. Scotiabank's Help Centre documents a QuickBooks download this way and notes the feature is being reworked.
2. Convert the eStatement PDF. For anything before 2018, any period outside the transaction view, or a statement you were sent rather than one you can log in to see, upload the PDF to BankStatementKit. It extracts the transactions and balance-checks the result against the statement's own printed totals.

Rule of thumb: if the transactions load on screen and you are heading into accounting software, use Scotiabank's download. If you need a spreadsheet, or the transactions predate 2018, convert the statement.

Turn a Scotiabank eStatement into a verified CSV

Option 1: Scotiabank's built-in transaction download

Following Scotiabank's own Help Centre steps:

1. Sign in to Scotia Online and open the Accounts page, then select the account.
2. Choose the statement period you want from the dropdown.
3. Scroll to the bottom of the transactions and keep selecting Load more until the current statement period total is displayed — the download only captures what has actually loaded.
4. Select the download icon at the top of the screen.
5. Choose the download option you want and save the file.

Where the built-in download stops

• Transaction history begins 1 January 2018. Scotiabank's Help Centre states that outright. Nothing older can be exported this way, no matter which format you pick.
• The on-screen default is 45 days. Anything beyond that needs a month search or a custom range before you can even load it.
• There is a 1,000-transaction-per-day ceiling. Scotiabank caps how many processed transactions display for a given day, which matters for busy business accounts.
• You have to load everything first. Miss a Load more click and the download quietly omits the transactions that never rendered — a failure mode you will not notice until the totals disagree.
• The documented format is for accounting software. A QuickBooks-shaped file is not a spreadsheet, and it is not what a lender or a bookkeeper working elsewhere asked for.

Option 2: Convert the Scotiabank PDF statement to CSV

1. In Scotia Online, open the account's statements area and save the eStatement PDF for the period you need — anything within the seven-year window.
2. Upload it. The file is processed in memory and never stored; if it is password-protected, supply the password at upload.
3. Transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit and Balance.
4. Read the verification label, then download the CSV. Files are capped at 20MB or 50 pages per upload.

Convert a Scotiabank statement

There is no Load more equivalent to forget here: the statement PDF contains the full period by definition, so a heavy month converts in one pass.

Why Scotiabank PDFs trip up generic converters

Descriptions wrap, and Scotiabank's are long. Interac e-Transfer entries carry counterparty names, preauthorized debits carry merchant descriptors and reference strings, and both routinely overflow the description column onto a second physical line. A converter that treats every line as a transaction manufactures rows with no amounts and inflates your transaction count.

Withdrawals and deposits are two separate money columns. They are not one signed figure. Flatten them without remembering which column each amount came from and every debit on the statement comes out as a credit — the kind of error that survives all the way to a reconciliation that will not close.

Credit card statements are a different document entirely. A Scotia Visa statement lists purchases, payments, interest and fees in sections with no running account balance, so anything that assumes a chequing-style register with a balance column will misread it. It has to be read as its own layout and verified against printed totals instead.

Prove the CSV matches the statement

The transactions being present is not the same as the transactions being right. A Scotiabank chequing statement gives you two independent ways to prove it:

1. The running balance chain. For each row, previous balance minus the withdrawal plus the deposit must equal the balance printed on that row. If a transaction was dropped or read twice, the chain breaks precisely at that row — the check finds the error and locates it in one pass.
2. The statement's opening and closing figures. Opening balance plus total deposits minus total withdrawals must equal the printed closing balance, and the number of rows you extracted should match what the statement accounts for.

For a Scotia Visa statement there is no running balance, so the printed summary — previous balance, payments, purchases, interest, new balance — does the verifying. BankStatementKit performs these checks on every conversion and labels the output VERIFIED, DISCREPANCY or FAILED, with a discrepancy naming the row where the numbers stop agreeing.

FAQ

The bottom line

Scotiabank's download is fine for recent activity headed into accounting software, but the 1 January 2018 transaction-history cutoff and the Load more requirement mean it fails on exactly the requests that matter most — the multi-year ones. For those, work from the eStatement PDF, and check the output against the balances the statement prints rather than assuming. More on the layout on the Scotiabank statement converter page.