National Bank of Canada · Canada

National Bank Statement to Excel, CSV & QuickBooks

National Bank keeps statements in Documents and statements, and business clients can export transactions to CSV, QBO, OFX or QFX. The catch: business transaction history only goes back 25 months and statement searches cover 2 years at a time. Here's when the export is enough, and when to convert the PDF statements instead.

Last updated 21 November 2026

At a glance

Official statement format
PDF statements under Documents and statements, in online banking and the National Bank app
Business statement archive
Up to 7 years for current accounts (since April 2016); Mastercard statements since August 2020
Business transaction export
PDF, CSV, QBO, OFX or QFX; up to 10,000 transactions per export (1,000 for PDF)
Business transaction history
Up to 25 months for bank accounts and credit card operations
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

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 statementBusiness transaction exportTransaction history on screen
WhereDocuments and statements (web and app)Online banking for business, ExportAccount page
FormatsPDFPDF, CSV, QBO, OFX, QFXScreen only (print via browser)
ReachUp to 7 years for business current accountsWhatever the history shows: up to 25 monthsUp to 25 months for business
LimitsBusiness search covers 2 years at a time10,000 transactions per CSV/QBO/OFX/QFX export; 1,000 per PDF30 transactions per page; defaults to last 7 days
Best forYear-end, audits, older periods, catch-up bookkeepingRecent periods going straight into QuickBooksFinding 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

  1. Sign in to online banking.
  2. Select the bank account, then click Documents and statements.
  3. Choose the document type and time period, then click Search.
  4. Download the statements.

Personal, in the National Bank app

  1. Select the bank account, then tap More.
  2. Tap Documents and statements.
  3. Select the time frame, tap Search, then choose the statement.

Online banking for business

  1. In the left menu under Accounts and transactions, click Statements.
  2. Select one or more accounts.
  3. Filter by period and category (account statements, cheque images or credit card statements). Each search covers up to 2 years.
  4. 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

  1. Download the PDF statements for every month in the period. Business clients can grab a ZIP of several at once.
  2. Upload them to AI Bank Statement. Use OCR mode if any are scanned.
  3. Choose the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  4. Download one transaction per row with date, description, withdrawals, deposits and balance.
  5. 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

Choose your output format

Frequently asked questions

How do I download a National Bank statement?

National Bank's help centre says to sign in to online banking, select the bank account, click Documents and statements, choose the document type and time period, then click Search and download. In the app, select the account, tap More, then Documents and statements.

How far back can I get National Bank statements?

For online banking for business, National Bank says current-account records have been kept since April 2016 for a maximum of 7 years, and Mastercard statements for 7 years since August 2020. The business statement search covers a 2-year date range at a time, so several searches may be needed. The personal help pages don't state a retention period.

Can I export National Bank transactions to CSV or QuickBooks?

In online banking for business, yes. National Bank lists PDF, CSV, and QBO/OFX/QFX export formats, with up to 10,000 transactions per export in CSV, QBO, OFX and QFX. Only the transactions shown by your filters are exported, and business transaction history goes back up to 25 months.

What if I need transactions older than 25 months?

The business transaction export can only include what the transaction history shows, which is up to 25 months. For older periods, download the PDF statements and convert them to Excel, CSV or QuickBooks CSV.

Can I convert a National Bank credit card statement?

Yes. National Bank says the full credit card statement is downloaded from Download my eStatements in online banking or the app. Convert that PDF with the same workflow, and import it against the credit card account, not the bank account.

What about old Laurentian Bank statements?

National Bank says personal clients can view pre-migration Laurentian Bank statements in online banking under Migrating to National Bank, then Statements. For business clients, it recommends downloading or printing the past 12 months of Laurentian statements, and says past statements will be made available gradually from January 2027. Those PDFs convert the same way.

More bank guides

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing