Three ways to get National Bank data out
National Bank gives you different tools depending on whether you bank personally or through online banking for business.
| PDF statement | Business transaction export | Transaction history on screen | |
|---|---|---|---|
| Where | Documents and statements (web and app) | Online banking for business, Export | Account page |
| Formats | PDF, CSV, QBO, OFX, QFX | Screen only (print via browser) | |
| Reach | Up to 7 years for business current accounts | Whatever the history shows: up to 25 months | Up to 25 months for business |
| Limits | Business search covers 2 years at a time | 10,000 transactions per CSV/QBO/OFX/QFX export; 1,000 per PDF | 30 transactions per page; defaults to last 7 days |
| Best for | Year-end, audits, older periods, catch-up bookkeeping | Recent periods going straight into QuickBooks | Finding one transaction |
If you're doing bookkeeping for a business client and the period is within the last 25 months, the native CSV or QBO export is often the quickest route. For anything older, or for a personal account, use the PDF statements.
How to download National Bank statements
Personal, on the web
- Sign in to online banking.
- Select the bank account, then click Documents and statements.
- Choose the document type and time period, then click Search.
- Download the statements.
Personal, in the National Bank app
- Select the bank account, then tap More.
- Tap Documents and statements.
- Select the time frame, tap Search, then choose the statement.
Online banking for business
- In the left menu under Accounts and transactions, click Statements.
- Select one or more accounts.
- Filter by period and category (account statements, cheque images or credit card statements). Each search covers up to 2 years.
- Download one statement, or select several to get a ZIP file. National Bank keeps the ZIP for 7 calendar days, so save it straight away.
The business export: useful, with three catches
National Bank's business export is better than most Canadian bank downloads. It offers CSV for Excel, and QBO, OFX or QFX for accounting software. But:
- It exports only what the filters show. National Bank's history page defaults to the last 7 days. Set the date range first, or the export will be a week long.
- History stops at 25 months. Anything older isn't in the transaction history, so it can't be exported. The statements go back further.
- It's not a statement. The export has no statement period, opening balance or closing balance in the layout your accountant or auditor expects.
Credit card statements
For a National Bank Mastercard, the full monthly statement comes from Download my eStatements: on the web, go to Overview, select the card, then Download my eStatements; in the app, select the card and tap More. It's a PDF.
When converting card statements, check the signs before import. Purchases increase what's owed and payments reduce it, which is the opposite of a bank account. The credit card statement converter covers this workflow.
Converting a National Bank PDF statement
- Download the PDF statements for every month in the period. Business clients can grab a ZIP of several at once.
- Upload them to AI Bank Statement. Use OCR mode if any are scanned.
- Choose the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
- Download one transaction per row with date, description, withdrawals, deposits and balance.
- Check the opening and closing balances against the PDF.
Convert each account separately, and keep USD accounts apart from CAD accounts so each file imports into the matching account.
National Bank to QuickBooks or Xero
- QuickBooks Online: if your period is within 25 months and you have business online banking, National Bank's own QBO export may be enough. For older periods or PDF-only clients, choose QuickBooks 3- or 4-column CSV. QuickBooks accepts up to 1,000 lines and 350 KB per upload, so split a busy year into smaller files. See QuickBooks 3-column vs 4-column CSV to pick the right layout.
- Xero: choose Xero CSV and import it as a bank statement for the matching account.
The Canada guide covers CRA record-keeping and the date-format rules for QuickBooks, Xero and Wave.
National Bank checklist for bookkeepers
- set the date filter before exporting, as the default is 7 days
- use PDFs for anything older than 25 months
- download statement ZIPs within 7 days
- keep CAD and USD accounts in separate files
- keep Mastercard statements separate from bank accounts
- check dates are in the order your software expects
- don't overlap an imported file with an active bank feed
- keep the original PDFs as the source records