Convert NAB bank statements to Excel or CSV

You can end up with more than one kind of PDF from NAB: statements, and recent-transaction reports that the bank says are not statements. If you have a folder of these files to turn into a spreadsheet for BAS, a tax return or a lender, this page explains how they convert and what to watch for. Upload the PDFs and you'll have Excel or CSV files to work with.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your NAB statement into Excel

  1. Download the PDF statement from NAB online banking

    • Log in to NAB Internet Banking or the NAB app.
    • In Internet Banking, select 'Accounts' in the menu and choose 'Account statements'; in the app, tap the account and then 'Statements'.
    • Choose the account, pick a 'Date range' (or a custom range), select 'Search', select up to 25 statements, and select 'Download' (in the app, tap the statement date and 'Share').
    • Save the statement for the period you need as a PDF.
    Go to NAB Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your NAB statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about NAB statements

Up to 25 statements per download

Internet Banking lets you select up to 25 statements and download them together. You can upload that batch as it is. Each statement's period is read, and duplicates, overlaps and gaps across the set are flagged, which saves checking the dates on 25 files by hand.

Six months on one statement

Unless you've asked for something different, most NAB accounts get a statement every six months, so one PDF can hold hundreds of transactions. That's where a balance check earns its keep: if a single line is misread, the closing balance won't reconcile, and you'll know before importing.

Reports that aren't statements

The recent-transactions PDF is a report, and the bank itself says it is not a statement. It converts fine, but if a lender or auditor asked for statements, give them the statement. If a report and a statement cover the same days, the overlap is flagged.

Seven years online, two in the app

NAB keeps up to seven years of statements in Internet Banking but only two years in the app. If an older statement seems to be missing on your phone, log in on a computer before assuming it's gone.

When the export is enough

For the last two years, Transaction history can be exported as a spreadsheet, QIF file or PDF. Beyond that, or when a reconciliation has to start and finish on the bank's own figures, convert the statements. Debit and credit columns come out as one signed amount per row.

Output and review

From NAB PDF to your books

Accounting tip

If the books are in MYOB, NAB's QIF export covers the last two years, and MYOB imports QIF statement files. Older statements converted here go into Xero as the Xero-ready CSV, or into QuickBooks Online as the QuickBooks-ready file with its Date, Description and Amount columns.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

NAB statement questions

Why does the NAB app only show two years of statements?
The app keeps up to two years of statements, Internet Banking up to seven. Log in on a computer for the older ones, download them, and upload them here. You can select up to 25 at a time in Internet Banking, and the whole batch converts together.
Can I convert NAB's recent transactions PDF?
Yes, it converts like a statement and gives you the same Excel or CSV output. Just remember the bank describes it as a report rather than a statement, so it may not satisfy someone who asked for statements, and its dates may overlap a statement you also upload.
Can I import converted NAB rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your NAB statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by NAB.