Scotiabank statement to Excel: reconcile any Scotia PDF in a minute

If you bank with The Bank of Nova Scotia and you're tired of retyping every line off your PDF statement into Excel, this is the lazy way to do it. Drop the PDF on Balancely and you get back a reconciled, four-sheet workbook in under a minute — Summary, All Transactions, Vendor Summary, and Categories. No regex template per statement layout, no manual sign cleanup, no copy-paste.

Balancely is built specifically for Canadian statements. Scotiabank is one of the issuers we test against on every release. Here's how it works for Scotiabank customers and what you can do with the output.

The 60-second flow

1. Sign up at balancely.ca/signup (free, no credit card).
2. Hit Convert, pick Credit card or Bank, drag your PDF onto the dropzone.
3. Wait 30–90 seconds while Statement AI reads every transaction.
4. Spot-check the preview tabs. Categories auto-fill from any rules you've saved previously.
5. Click Download ▼ and pick a format — Excel (.xlsx), CSV, or QuickBooks (.qbo).

That's it. The workbook lands in your downloads folder; the job appears in your history for 30 days (free), one year (Pro), or seven years (Business).

What Scotiabank statement types we handle

• Scotiabank Gold American Express, Passport Visa Infinite, and Momentum Visa Infinite
• Scotia Momentum No-Fee Visa, Value Visa, and Scotia Rewards Visa
• Scene+ Visa and the Scene+ Visa for students
• Scotia Basic Plus Bank Account, Preferred Package, and Ultimate Package chequing
• Scotia Business Banking and ScotiaOne Account for Business

If your specific product isn't listed, try it anyway. Statement AI handles arbitrary Canadian PDF layouts with the same engine and reconciler. If reconciliation fails, the workbook ships with an amber “check totals” flag so you know to double-check before forwarding to your accountant.

The four sheets, and what to expect

Summary

One row per statement. Opening balance, payments, returns, purchases & fees, interest, new balance, minimum payment, period dates, reconciled status. For credit-card statements, every cell renders as a negative outflow — summing the column equals the change in balance, which is what your bookkeeper expects. For bank statements, canonical signs are preserved. See the three-sheet workbook explainer for the full design rationale.

All Transactions

Every transaction across every uploaded PDF, sortable and filterable. Date, type (PURCHASE/PAYMENT/RETURN/FEE/INTEREST/CASH_ADVANCE), description, category, signed amount, FX note where present. Foreign-currency line continuations are folded back onto the parent transaction so Scotiabank statements that span CAD and USD reconcile cleanly.

Vendor Summary

Top vendors by absolute spend. Description text gets lightly normalized (first 40 chars, uppercased) so “UBER EATS HELP.UBER.” and “UBER EATS HELP.UBER.COM” roll up together instead of fighting for column inches.

Categories

Aggregated by your saved vendor → category rules. The 14 default categories are tuned for Canadian freelancers — Meals (50% deductible), Vehicle & Fuel, Office Supplies, Software & Subscriptions, Professional Services, and more. Tag a Petro-Canada transaction once, and every future Scotiabank statement auto-categorizes it. Manage rules at /dashboard/categories.

Scotiabank layout quirks Balancely handles

• Statements with both a primary card and supplementary cards are reconciled against the combined Account Summary, not the per-cardholder subtotals (which would double-count).
• Scotia's "Cash-Like Transactions" section (cash advances and quasi-cash) is correctly classified as CASH_ADVANCE.
• American Express co-branded transactions on Gold AmEx statements keep their FX continuation lines tied to the parent purchase.
• Reward redemptions printed in the transactions table as zero-dollar lines are flagged with a warning rather than dropped — you see them in the workbook.
• Statement period dates printed in the "MMM DD, YYYY to MMM DD, YYYY" format are converted to ISO without manual intervention.

Exporting straight to QuickBooks

Instead of Excel, click Download ▼ → QuickBooks (.qbo) on the preview. The file is OFX 2.x Web Connect — QuickBooks Desktop and Online both accept it directly. Your category from the saved rules lands in the QuickBooks Memo field on each transaction, which is the cleanest way to surface bookkeeping context without remapping to QuickBooks' own category system.

Bookkeepers who reconcile multiple Scotiabank accounts for clients can use the same flow per account: one PDF per upload, one .qbo per statement. Multi-statement batches export as a zipped bundle so your import workflow is one click.

Privacy and what Balancely keeps

Your PDF is processed in memory and discarded the moment the workbook is built. We don't archive Scotiabank statements. The audit row that lands in our Postgres database contains the filename, the document type, parser confidence, reconciliation result, and a few summary totals — no individual transactions. See the security page for the full posture.

Start with one statement

The free tier gets you two conversions to start — one credit-card and one bank statement. Pro is $9.99/month for 25 PDF conversions a month; Business is $19.99/month for 60. Prices in USD. No credit card to start.

Create an account and drop your Scotiabank statement on the dashboard. The workbook should land in your downloads folder before you finish your coffee.