National Australia Bank ยท Australia

NAB Statement to Excel, CSV & Xero | AI Bank Statement

NAB keeps seven years of statements in Internet Banking but only two years in the app, and most accounts get a statement every six months. Here's how to get NAB statements and exports, and how to turn NAB PDFs into Excel, CSV, Xero or QuickBooks data.

Last reviewed 14 October 2026

At a glance

Official statement format
PDF, in NAB Internet Banking and the NAB app
Statements online
Up to seven years in Internet Banking; up to two years in the app
Statement frequency
Every six months for most accounts, unless you ask otherwise
Transaction export
Spreadsheet, QIF or PDF, up to two years (731 days) of history
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

How to download NAB statements

In NAB Internet Banking

  1. Select Accounts in the menu and choose Account statements (business: Statements).
  2. Choose the account and a date range, then select Search.
  3. Select up to 25 statements and select Download, or View document for one.

In the NAB app

  1. Tap the account, then Statements.
  2. Tap the statement date, then Ok on the security message.
  3. Tap Share to share or download it.

The app shows up to two years of statements; Internet Banking goes back seven. For a statement with today's date, you can order a current account statement, ready the next business day.

Things to know about NAB statements

  • Six-monthly by default. Most NAB accounts get a statement every six months, so one PDF can hold half a year of transactions.
  • Closed accounts: statements are visible for up to seven years if you'd opted into online statements before closing (Account statements โ€บ Closed or Hidden Accounts).
  • Recent transactions aren't a statement. NAB's app can produce a PDF of recent transactions, but NAB says it's a report of recent activity, not a statement.

NAB's transaction export

In Internet Banking, open Transaction history, filter by account and date range, then select Export for a spreadsheet, QIF file or PDF. It covers up to two years (731 days). NAB Connect business users can export CSV, PDF or QIF reports.

For anything older than two years, a full statement period, or a client's PDFs, convert the statements.

Converting a NAB PDF statement

  1. Upload one or more NAB PDF statements. Batch upload handles a year of statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. Download one transaction per row, with date, description, amounts and balance in separate columns.

Dates stay day-first and amounts stay in Australian dollars.

Getting NAB data into Xero, QuickBooks or MYOB

  • Xero: choose Xero CSV and import it as a bank statement. NAB's free bank feeds also connect to Xero, from when they're set up.
  • QuickBooks: choose the 3- or 4-column CSV and upload it from file. NAB doesn't list QuickBooks among its bank feed providers, so importing is the usual route.
  • MYOB: MYOB Business imports statements as QIF or OFX. NAB's QIF export or its MYOB bank feed covers MYOB.

NAB credit card statements convert with the credit card statement converter.

Choose your output format

Frequently asked questions

How far back can I get NAB statements?

NAB says you can access up to seven years of bank account statements in NAB Internet Banking, and up to two years in the NAB app. Closed accounts show up to seven years if you'd opted into online statements before closing.

Can I download several NAB statements at once?

Yes. In Internet Banking, select Accounts, then Account statements, choose the account and date range, select Search, and you can select up to 25 statements to download.

How often does NAB send statements?

NAB says most accounts get a statement every six months unless you've asked otherwise. You can change the statement cycle by contacting NAB through the app.

Can I export NAB transactions to Excel?

Yes. In Internet Banking, open Transaction history, filter by account and date range, then select Export for a spreadsheet, QIF or PDF. It covers up to two years (731 days). Older transactions are only in your statements.

Can I import a converted NAB statement into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV as the output. NAB's free bank feeds cover Xero, MYOB and others, but NAB doesn't list QuickBooks among them.

Is it safe to upload a NAB statement?

Statements show your BSB, account number and transaction history. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Stop retyping statements by hand

Upload a PDF and download clean Excel, CSV, Xero or QuickBooks data in about 30 seconds.