About National Bank of Canada statements
National Bank of Canada is a Montreal-headquartered bank offering personal and business banking in French and English.
National Bank chequing statements cover a monthly period and typically list each transaction with its date, a description, the amount withdrawn or deposited, and the resulting balance. They are stored in each account's Documents and statements area together with other account documents, and you find them by document type and time period. Amounts use a decimal point, as on other Canadian statements.
Typical Canada statement headings and where they go in your export:
| On the statement | In your export |
|---|---|
| Date | Date |
| Description | Description |
| Withdrawals | Debit (and negative Amount) |
| Deposits | Credit (and positive Amount) |
| Cheque/Debit | Debit (and negative Amount) |
| Deposit/Credit | Credit (and positive Amount) |
Also known as Banque Nationale and National Bank Canada.
How to download your National Bank statement as a PDF
- Sign in to your National Bank online bank.
- Select your bank account, then click Documents and statements.
- Choose the document type and time period, then click Search.
- Download the statement PDF.
- In the app, select the account, tap More, then Documents and statements.
Menu names can change between app and website versions.
Tips for converting National Bank statements
- A time-period search in Documents and statements can return several statements at once; download them all and combine them into one Excel file or one sheet per statement.
- If any dates look swapped after converting, set Read dates as to the order your statement uses, then run the balance check to confirm the result.
Importing National Bank transactions into accounting software
For QuickBooks, Xero, Sage 50 and Wave, export CSV or OFX after checking the preview. Amounts are written as plain numbers without the $ sign, so they import cleanly as values. Step-by-step help: QuickBooks, Xero.
More Canada banks
BMO, CIBC, Desjardins, RBC, Scotiabank, Simplii, Tangerine, TD . Canada overview
This is an independent tool and is not affiliated with, endorsed by or connected to National Bank of Canada. The name is used only to describe which statements the converter can read.
Frequently asked questions
How do I download a National Bank statement?
In the online bank, select your account, click Documents and statements, choose the document type and time period, then click Search and download the statement. In the National Bank app, select the account, tap More, then Documents and statements, choose a time frame and tap Search.
Can I convert National Bank statements to Excel?
Yes. Download the statement PDF from Documents and statements and load it into the converter, which runs in your browser. It maps the date, description, amount and balance columns and exports Excel, CSV or OFX, so several months can go into one spreadsheet or your accounting software.
Is it safe to convert my National Bank statement here?
Yes. The conversion happens on your own device; your National Bank statement is not uploaded, stored or shared. This site is independent and not affiliated with National Bank of Canada.