Convert a Scotiabank Statement to Excel

Scotiabank statement conversion across Canadian and Caribbean operations, and the verification checks worth running.

Scotiabank operates in Canada, the Caribbean and Latin America, with statements that differ by market in both language and currency.

One bank, many currencies and conventions

A Scotiabank Canada statement is in Canadian dollars with bilingual headers. A Scotiabank Jamaica statement is in Jamaican dollars. A Scotiabank Chile statement is in Chilean pesos with Spanish headers and, likely, a decimal comma.

The lesson generalises: neither language, nor currency, nor number format can be inferred from the bank name. All three have to come from the file.

Currencies with no decimal fraction

The Chilean peso is not conventionally subdivided in everyday use, so statements print whole numbers. The Japanese yen behaves similarly.

This removes the decimal point as a signal entirely. A number like 1.234.567 in a Chilean statement is one million two hundred thousand-odd pesos, with periods as thousands separators and no decimal at all.

Verifying across conventions

The balance chain is convention-agnostic in a useful way: whatever interpretation you apply to the amounts, if it is the right one the chain reconciles and if it is wrong it does not. That makes it the definitive test regardless of currency.

Converting across markets

Convert each market's statements separately Do not merge PDFs from different countries — layouts, languages and number formats differ.
Note the currency of each export No currency column is added, so record which currency each file is in, and never sum across files in different currencies.
Verify per account and per currency Each is an independent chain.
Then combine if you need a consolidated view With an explicit conversion to a base currency, using a rate you choose deliberately.

Consolidating across currencies

If you genuinely need one total across several currencies, do the conversion explicitly with a documented rate rather than letting a tool sum the raw amounts.

Which rate you use is a decision — period-end, period-average, or transaction-date — and it materially changes the answer. A tool that quietly picks one for you has made an accounting judgement on your behalf.

Frequently asked questions

Are Caribbean Scotiabank statements supported?

They are read from the table on the page like any other statement, whichever market issued them. Check the Completeness sheet on your first one.

Can I get one total across all my Scotiabank accounts?

Not by summing the raw amounts. Convert each currency to a base currency at a rate you choose, and keep the original amounts alongside so the calculation is auditable.

How are whole-number currencies handled?

They are kept exactly as printed, 1.234.567 included, so nothing in the spreadsheet depends on reading them. Set the thousands separator to match before you turn the column into numbers.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.