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.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your NAB statement into Excel
-
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.
-
Upload it here
Scans and phone photos work too.
-
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.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | 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.
-
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?
Can I convert NAB's recent transactions PDF?
Can I import converted NAB rows into QuickBooks or Xero?
Convert your NAB statement to Excel
Page 1 free, no sign-up to see it; just an email to download.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by NAB.