Convert a National Bank of Canada bank statement to Excel
Convert a National Bank of Canada statement PDF to Excel or CSV right in your browser — date, description, amount and balance are detected automatically, with a row-by-row balance check, and your statement is never uploaded. 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. Text-based PDFs downloaded from National Bank of Canada online banking convert most accurately.
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.
How we read a National Bank of Canada statement
- 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.
- Date format：YYYY-MM-DD
- 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.
Watch-outs for National Bank of Canada statements
- National Bank of Canada splits money in and out into two separate columns (withdrawals/debits and deposits/credits). The converter merges them into one signed amount so the balance check can run; double-check that a credit didn't get the wrong sign on any flagged row.
- Multi-line descriptions (a long merchant name wrapped onto two lines) are the most common cause of a shifted row — if a row doesn't reconcile, that's the first thing to check.
- Transactions that carry over a page break, and the opening/closing balance lines, are handled separately from regular rows; verify the first and last rows of each page after a multi-page statement.
How to convert a National Bank of Canada statement
- 1Download your National Bank of Canada statement as a PDF from online banking.
- 2Drop the PDF into the converter below — it parses locally.
- 3Review the detected columns and the balance check; verify any flagged rows.
- 4Export to Excel, CSV, or QuickBooks/OFX.
Frequently asked questions
No. The entire conversion — reading the PDF, detecting columns, the balance check and building the Excel file — runs locally in your browser. Your National Bank of Canada statement is never uploaded or sent to any AI.
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.
National Bank of Canada text-based PDFs are in the sweet spot and convert accurately at the row level. Either way, verify key figures before use — the row-by-row balance reconciliation flags suspect rows for you.
Updated · StatementSift team