National Bank Statement to Excel & CSV

Profile review and source checks

Reviewed 2026-10-19. National Bank of Canada, Canada: layout notes reviewed; not a conversion test of every statement or a bank endorsement. Confirm the period and headers.

Synthetic CAD example for National Bank of Canada: opening 1,000.00 + receipt 100.00 - payment 100.00 = closing 1,000.00. Omitting both rows still balances.

What does a National Bank statement PDF look like?

Printed structure: PDF with Date, Description, Withdrawals ($), Deposits ($), Balance ($)

Date notation: YYYY-MM-DD. Money notation: C$ CAD. Observed statement size: 3–10 pages.

What fields does National Bank of Canada print on each transaction row?

Check these National Bank of Canada layout details against your PDF:

• National Bank checkpoint 1: Remains especially concentrated in the Quebec market even today, unlike Canada's other 'Big Six' banks, which operate more evenly across the whole country
• National Bank checkpoint 2: Bilingual French / English headers on Québec consumer statements — column headers auto-mapped
• National Bank checkpoint 3: ISO date format (YYYY-MM-DD) unlike most CA banks — no year inference required
• National Bank checkpoint 4: À la carte rewards redemptions posted as negative withdrawals
• National Bank checkpoint 5: Interac e-Transfer rows include sender and receiver names plus security-question reference

Checkpoint for National Bank of Canada

Before importing CAD values, review this source feature: Remains especially concentrated in the Quebec market even today, unlike Canada's other 'Big Six' banks, which operate more evenly across the whole country. Keep the YYYY-MM-DD date column and original narration together while comparing the 3–10 pages with the PDF.

Reviewing National Bank of Canada output

Compare YYYY-MM-DD dates, CAD signs and page boundaries with the National Bank of Canada PDF. Check the first and final transactions; reconciliation alone cannot prove completeness.

National Bank of Canada export and review resources

• Import National Bank statement into QuickBooks
• Canada bank statement converter hub

For data handling, read our security policy and privacy policy. For download restrictions, see source review and reconciliation limits.