National Bank of Canada Statement to CSV/Excel - QuickBooks & Xero Import
National Bank of Canada publishes electronic statement access across its app and online bank, but the downloaded PDF is still a human-readable bank document rather than a bookkeeping import. Exact Statement converts National Bank statement PDFs into clean CSV or Excel while keeping Canadian references and cheque-image context reviewable.
Files are validated locally, split into chunks, then uploaded directly to secure storage.
Official National Bank materials say electronic statements, documents, and cheque images are available through the National Bank app and online bank, and statement delivery preferences can be changed in online preferences.
Where To Download National Bank Statements
National Bank is best handled as an electronic-delivery page with app, online-bank, and delivery-preference behavior called out explicitly.
Electronic statements live in the app and online bank
National Bank says statements and communications can be received through the National Bank app and online bank.
Delivery preferences are changed after sign-in
National Bank says customers can opt for electronic statements by signing in and changing their preferences.
Cheque images are viewable online
National Bank says images of cheques drawn on the account are available through online banking and can be printed or downloaded.
Notifications can arrive by email or text
National Bank says customers receive an email or text when a monthly statement becomes available online.
What Usually Matters In National Bank Statements
The useful difference here is not just the bank name. It is the combination of electronic delivery, cheque-image access, and product-specific statement behavior.
Electronic delivery and online retrieval are tightly linked
National Bank frames statements as part of its broader electronic communications flow.
Cheque images are supporting evidence, not statement rows
They are valuable for review, but they are not a substitute for the transaction table in the statement PDF.
Notification settings matter for document collection
Email or text notifications affect how quickly users realize a monthly statement is available.
Consolidated statement assumptions can fail
National Bank migration materials explicitly note that some National Bank products do not provide consolidated statements.
Canadian references still need cleanup for import
Transfer, cheque, and memo text still need to survive the final conversion step.
Protected files must be opened first
If a National Bank PDF is protected, unlock it before upload. Exact Statement does not remove bank PDF passwords for you.
Common National Bank Import Pitfalls
Most National Bank issues come from mixing document types and assuming the online documents are already target-schema ready.
Using cheque images as if they were statement rows
Cheque images are evidence documents, not a replacement transaction table.
Assuming consolidated statements always exist
National Bank materials warn that some product combinations do not provide consolidated statements.
Dropping Canadian memo and transfer context
That makes later reconciliation and audit work harder.
Treating a downloaded PDF as already import-ready
The statement still needs signed amounts and software-specific columns.
Preview A Cleaned National Bank Export
These sample rows emphasize Canadian statement behavior with transfer references, cheque context, and review-friendly balances.
| Date | Amount | Payee | Description | Reference | Transaction Type | Balance | Currency | Account ID |
|---|---|---|---|---|---|---|---|---|
| 03/03/2025 | -1540.00 | Client payment | INTERAC E-TRANSFER FROM CLIENT | INTERAC | Debit | 6814.12 | CAD | ****4016 |
| 04/03/2025 | 875.00 | Contractor | CHEQUE 1108 | 1108 | Credit | 5939.12 | CAD | ****4016 |
| 05/03/2025 | 76.48 | Canadian Tire | DEBIT PURCHASE CANADIAN TIRE | CARD | Credit | 5862.64 | CAD | ****4016 |
| 06/03/2025 | -3010.00 | Payroll | PAYROLL DIRECT DEPOSIT | PAYROLL | Debit | 8872.64 | CAD | ****4016 |
| 07/03/2025 | 14.95 | NBC fee | ACCOUNT MAINTENANCE FEE | FEE | Credit | 8857.69 | CAD | ****4016 |
Sample rows for preview only. National Bank examples emphasize electronic delivery, cheque-image adjacency, and Canadian reference retention.
How National Bank Fields Map Into Accounting Imports
The important work is preserving National Bank statement context while normalizing the final file for the destination software.
| Field In Statement PDF | Exact Statement Output | QuickBooks Online | Xero CSV |
|---|---|---|---|
| Statement or posting date | Normalized Date | Date | Date |
| Merchant / transfer / memo text | Payee + cleaned Description | Description | Payee + Description |
| Deposit / withdrawal amount | Signed Amount | Amount or Credit/Debit | Amount + Transaction Type |
| Cheque / card / memo reference | Reference | Optional or merged | Reference |
| Running balance | Balance for XLSX review | Not required | Not required |
Sources: National Bank deposit account agreement · National Bank migration guide · Intuit CSV format guide · Xero CSV import guide.
National Bank of Canada Statement to CSV - Frequently Asked Questions
Yes. National Bank materials say statements, documents, and communications can be received through the app, online bank, and digital notifications when electronic delivery is enabled.
Yes. National Bank says cheque images can be viewed online and printed or downloaded.
National Bank says you can sign in and opt for electronic statements in your preferences.
National Bank says customers can receive an email or text when a monthly statement becomes available online.
Unlock it before upload. Exact Statement does not remove National Bank PDF passwords for you.
Need the official help pages? National Bank deposit agreement · National Bank migration guide · support@exactstatement.com.
Convert Your National Bank of Canada Statement Now
Upload a National Bank of Canada statement PDF and export a clean CSV or Excel file for QuickBooks Online, Xero, or spreadsheet review.