Convert a National Bank of Canada bank statement to Excel
Convert a National Bank of Canada statement PDF to Excel or CSV in your browser. StatementSift detects date, description, amount and balance columns, then checks row-by-row balance continuity before export. National Bank of Canada statements use this layout: National Bank of Canada statements use a debit/credit ledger: Date, Description, Debit/Withdrawals, Credit/Deposits, and Balance — being Quebec-based, field labels often appear in both English and French, with an opening balance at the top and a closing balance at the bottom.
Drop your bank statement PDFs (multiple allowed) and StatementSift detects the date/description/amount/balance columns locally and reconciles row by row. Financial data is never uploaded or sent to any external AI. Text-based PDFs (from online banking) work best.
Columns
National Bank of Canada statements use a debit/credit ledger: Date, Description, Debit/Withdrawals, Credit/Deposits, and Balance — being Quebec-based, field labels often appear in both English and French, with an opening balance at the top and a closing balance at the bottom.
Best source
Sign in to National Bank online banking or the app, open the Documents/Statements section, and download the official PDF for the chosen account and month — use the text PDF rather than a screenshot or scan, which can misalign columns.
Review target
Flagged rows, opening and closing balances.
Watch-outs for National Bank of Canada statements
National Bank of Canada separates money out and money in into debit and credit columns. If a row is flagged, first check whether the sign was assigned correctly.
Wrapped merchant descriptions can push the next line out of alignment; check long descriptions when the balance proof fails.
Opening balance, closing balance and page-break continuation rows are not ordinary transactions, so review the first and last rows on multi-page statements.
How to convert a National Bank of Canada statement
- 1
Download your National Bank of Canada statement as a text-based PDF from online banking.
- 2
Drop the PDF into the local converter on this page.
- 3
Review detected columns, opening and closing balances, and every flagged row.
- 4
Export to Excel, CSV, or QuickBooks/OFX only after the reconciliation looks right.
Frequently asked questions
No. Reading the PDF, detecting rows, checking balances and building the export all run locally in your browser. Your National Bank of Canada statement is not uploaded or sent to an AI service.
Sign in to National Bank online banking or the app, open the Documents/Statements section, and download the official PDF for the chosen account and month — use the text PDF rather than a screenshot or scan, which can misalign columns.
Treat the export as a format conversion, not financial, accounting, tax or legal advice. Verify key figures and consult a qualified professional before relying on the output.
Updated · StatementSift team