Scotiabank Statement to Excel Converter

For credit cards, Scotiabank says you can access up to seven years of eStatements from the time you make the switch. Years from before the switch were mailed on paper. Statements are typically issued monthly, depending on activity, payments and whether there is a balance.

Paper card statements convert too: scan them flat, one per file, and FlowParse reads them through OCR and proves them against the previous and new balance. Together with the eStatements, they rebuild the card's full history.

A Scotiabank chequing or savings statement gives the account holder, the transit and account number, the statement period and the opening balance, then the transactions — an Interac e-Transfer, a bill payment, a payroll deposit, a debit purchase, a cheque, a monthly fee — with withdrawals and deposits in separate columns and the balance beside them. The closing balance ends it.

FlowParse writes one row per transaction with the date, the full description, the cheque number where there is one and one signed amount in CAD, so the amount column sums to the change in balance.

The opening balance plus every signed transaction must equal the closing balance. FlowParse checks that on every Scotiabank statement, and checks each row against the running balance where it is printed. A deposit read as a withdrawal, or a cheque lost at a page break, fails at the row where it happened.

Statements that pass are marked reconciled; anything else is shown in the preview with the difference before you download.

The CRA generally expects records supporting a return to be kept for six years from the end of the last tax year they relate to. Scotiabank's seven-year archive covers that for personal accounts and most business accounts — but ScotiaConnect's online window is two years, and a closed account is a separate question.

So keep your own copies. A folder of saved Scotiabank PDFs, converted to one proved workbook per year, is both the record the CRA may ask to see and the data your accountant works from.

For a T1 with self-employment or rental income, a T2 corporate return or a mortgage application, Smart Merge takes up to 100 Scotiabank PDFs — chequing, savings, line of credit, credit card, business — and builds one workbook with every transaction in date order, the account and source on every row, and a check that each closing balance is the next opening balance.

Statements from RBC, TD Canada Trust, BMO, CIBC or Tangerine can be merged into the same workbook, matched column by column.

Canadian bookkeepers mostly work in QuickBooks Online, Xero or Sage. FlowParse exports a QBO file QuickBooks imports as bank transactions, a CSV for Xero or Sage, and an Excel file for review first.

The description stays whole — the e-Transfer sender, the bill payee, the cheque number — so each line can be matched to an invoice or a receipt and coded for GST/HST after import.

Withdrawals and deposits are unsigned columns; pasted into one list, they all become positive. A cheque number pasted into the amount column becomes a payment that never happened. A bill payment with a long payee name wraps over two lines and becomes two rows.

FlowParse signs by column, keeps cheque numbers in their own column and one transaction per row; the balance proof confirms nothing was split or dropped.

A renovation contractor in Halifax runs the business through a Scotiabank business account and pays materials with a Scotiabank credit card. Their accountant needs the fiscal year for the T2125 and the GST/HST return. The figures here are an illustration, not a real business's.

The contractor downloads twelve business statements and twelve card eStatements and uploads all 24. FlowParse returns one workbook, every statement proved, both accounts chained. Client deposits, supplier cheques — with their numbers — and the card repayments on both sides are filtered in minutes; the QBO file goes into QuickBooks, and the PDFs stay in the year's folder.

Coverage: each closing balance equal to the next opening balance, per account. Cheques: the cheque-number column matched against the register. Business: ScotiaConnect statements saved before they pass two years. Reconciled: every statement proved before its totals are used.

And keep the PDFs. The converted file is a working copy; the statement is the record for the CRA, a lender or a court.

Chequing, savings, line of credit, business and credit card statements list transactions between two balances and convert the same way.

Scotia iTRADE and other investment statements, tax slips and fee notices are valuations, summaries or single figures. Keep them with the file; convert the bank statements.

Scotiabank suggests reviewing statements regularly — the transactions, payments, fees and interest earned — to make sure everything is correct and to spot discrepancies. Twelve PDFs make that a slow job.

Converted, a year becomes one sheet: sort by amount to see the largest payments, filter by payee to spot a duplicate charge, total the monthly fees to see what the account really costs. A recurring charge that crept up is visible in one column instead of twelve documents.

Customers who switched to eStatements part-way through have an archive in two places: online statements from the switch onwards, paper statements before it. For credit cards, Scotiabank's seven years explicitly start at the switch.

Converted and merged, the two halves become one history. The balance chain shows whether the months around the switch are complete, and which statement to look for if they are not.