Convert National Bank of Canada statements to Excel or CSV
National Bank keeps statements under Documents and statements in online banking: select your account, choose the period, click Search and download the PDF. Whether it is in English or French (relevé), BankConv converts it to an Excel, CSV or Google Sheets file with withdrawals, deposits and balance on each line.
Updated
Download your National Bank account statement (relevé de compte)
- 1.Sign in to National Bank online banking (nbc.ca), or the National Bank app.
- 2.Select your bank account, then click Documents and statements (Documents et relevés in French). In the app, tap More first.
- 3.Choose the document type and period, then click Search (Rechercher).
- 4.Download each statement.
Do you need to convert at all?
Online banking for business lets you export transactions as PDF, CSV or QBO/OFX/QFX. National Bank's personal help pages don't describe a transaction export.
In business online banking, up to 10,000 transactions per CSV, QBO, OFX or QFX export (1,000 for PDF), from up to 25 months of history. The transaction view shows the last 7 days by default, so widen the filters first.
National Bank of Canada export formats: CSV, QBO, OFX, QFX
What to know about National Bank of Canada PDFs
- English or French statements
- If you bank in French, look for French headings such as Retraits, Dépôts and Solde, and amounts with a comma for decimals and a space for thousands (1 875,30). Open the CSV with a French (Canada) locale, or check that amounts came out as numbers before you sum them.
- Business statements come as a ZIP
- In online banking for business, selecting several statements downloads them as one ZIP file, which National Bank keeps for 7 calendar days. Unzip it and upload the PDFs. The statement search covers a date range of up to 2 years at a time.
- Dates without a year
- National Bank usually prints dates like 3 Sep, without the year. Add it from the statement period; a December statement that runs into January is where it usually goes wrong.
National Bank statements downloaded from online banking are usually text-based PDFs, in English or French depending on how you bank. Each transaction line should become one row; check French headings and comma-decimal amounts after converting.
How to get National Bank transactions as CSV
The route depends on whether you use personal or business online banking.
- Business accounts, recent activity: in online banking for business, select the account, widen the filters past the default 7 days, click Export and choose CSV.
- Personal accounts, or full statements: open Documents and statements, download each statement, upload them to BankConv (up to 10 at a time), and export CSV or Excel.
Statements are also the version lenders and accountants usually want, because they show the opening and closing balance.
What to check before you import
Use the balances on the statement to check the result, one account at a time.
- Balance: opening balance plus deposits minus withdrawals should equal the closing balance.
- Numbers: on French statements, confirm every amount is a number, not text.
- Year: add the year to each date from the statement period.
- Overlap: if you also exported a business CSV, remove rows that appear in both.
Banking with Desjardins as well? Its French relevés convert the same way.
To bring the rows into QuickBooks, see importing into QuickBooks. Other Canadian banks are on the Canadian banks page.
Sources: National Bank: How do I view my bank statement online? · Banque Nationale : Comment consulter mon relevé bancaire en ligne? · National Bank Business: Export transactions to my accounting software · National Bank Business: How do I view my transactions? · National Bank Business: View or download account statements
Columns you get
| Date | Description | Withdrawals | Deposits | Balance |
|---|---|---|---|---|
| 3 Sep | Interac e-Transfer received M GAGNON | 200.00 | 2,615.40 | |
| 4 Sep | Bill payment HYDRO-QUEBEC | 118.62 | 2,496.78 | |
| 5 Sep | Payroll deposit ACME INC | 1,940.25 | 4,437.03 | |
| 8 Sep | Interac purchase METRO #234 MONTREAL | 74.19 | 4,362.84 |
Sample rows in National Bank of Canada's layout, fictional data. First 5 pages free to check.
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.
National Bank of Canada statement questions
Can I export National Bank transactions to CSV?
In online banking for business, yes. Click Export and choose CSV, up to 10,000 transactions at a time. National Bank's personal help pages don't describe an export, so for personal accounts download the statements and convert them in BankConv.
Can BankConv convert a National Bank relevé in French?
Yes. BankConv reads the table on the page, so French headings convert the same way as English ones. Check that comma-decimal amounts came out as numbers in your spreadsheet.
Can I get National Bank statements in the app?
Yes. In the National Bank app, tap your account, then More, then Documents and statements. Choose the period, tap Search and select the statement.