Convert National Bank of Canada Bank Statement to Excel
National Bank of Canada chequing statements follow the classic Canadian layout: each line carries the date, a description, an amount placed in either the withdrawals or deposits column, and the balance after the transaction. Because the bank serves clients in both official languages, descriptions may appear in French or English depending on your profile settings, which trips up generic parsers and makes retyping doubly tedious. Rebuilding a month of activity by hand means keying hundreds of cells, realigning columns that shifted during copy-paste, and hoping no amount landed on the wrong side. SheetMyBank reads the PDF text layer directly, keeps withdrawals and deposits in their own columns, and reconstructs the balance so the whole statement becomes a clean Excel table in seconds.
To grab a statement, sign in to National Bank online banking, select your account, and click Documents and statements; in the mobile app, open the account and tap More to reach the same section. The bank’s help centre indicates documents are archived for up to seven years for many account types, so older records are worth saving locally before they age out. When you convert with SheetMyBank, the file never leaves your machine — parsing happens inside the browser tab itself. Each extracted row is then compared against the printed balance column, so a missed or duplicated transaction is flagged immediately.
Drop your National Bank of Canada statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
National Bank of Canada statement FAQ
My National Bank statement has French transaction descriptions. Will conversion still work?
Yes. SheetMyBank extracts descriptions as-is, accents included, because it reads the PDF’s embedded text rather than guessing from patterns. French entries like « Virement Interac » come through exactly as printed, ready for filtering in Excel.
How far back can I retrieve National Bank eStatements online?
National Bank’s help centre notes archives of up to seven years for current accounts and Mastercard statements. If you need records beyond what appears under Documents and statements, contact the bank — and keep local copies going forward.
Some National Bank downloads include cheque images. Does that break the converter?
No. Cheque images are ignored during extraction; only the transaction table is parsed. You still get the cheque number from the description line, so you can match cleared cheques in your spreadsheet afterwards.