Skip to content
stmtai

Convert NAB statement PDFs to Excel, Xero and CSV.
Xero, MYOB, Excel files from the PDF.

NAB statement PDFs open without a password. Transaction history in NAB Internet Banking covers up to 731 days and can be exported from the Export link above the balance column as CSV, QIF or a PDF listing.

Drop your NAB statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in AUD.

Last updated

How to download a NAB statement as a PDF

  1. Log in to NAB Internet Banking and open the account from the accounts list.
  2. Choose Statements from the account menu. Available statements are listed by period.
  3. Select the statement you need and choose Download.
  4. Save the PDF to your computer. Up to seven years of statements are available here.
  5. In the NAB app: open the account, tap Statements, choose the period and download. The app only shows the last two years, so go to Internet Banking for anything older.

Then drop the file above; several months of NAB statements at once come back as one workbook.

Is the NAB PDF password-protected?

NAB statement PDFs open without a password.

What NAB statements look like

Date, Particulars, Debits, Credits, Balance.

NAB statements use Date, Particulars, Debits, Credits and Balance, with dates written as day, abbreviated month and a two-digit year (03 Jul 25). Particulars is where the work is: a payment often takes two or three lines, the payee on one and a reference or receipt number below, and the converter joins them into a single description. There is an Opening Balance line and a Closing Balance line, and NAB also prints Total Debits and Total Credits at the end, which are used as a second check on the sums. Classic accounts are statemented every six months, so a single PDF can hold a couple of hundred rows; business accounts are usually monthly.

Why not use NAB's own export?

Transaction history in NAB Internet Banking covers up to 731 days and can be exported from the Export link above the balance column as CSV, QIF or a PDF listing. The CSV includes a Balance column and a category, though the transaction detail is split awkwardly across Transaction Type and Transaction Details. NAB Connect business users get a Simple transaction history with running balances and an Advanced report with more formats. Past two years there is no export at all, only the statement archive, and that is the point at which converting the PDF becomes the practical option.

Where NAB statements trip up converters

  • "Particulars" often spans two lines with a reference number; merged into one description.

Which software NAB customers import into

NAB customers most often import into Xero, MYOB, Excel.

NAB questions

Why does one NAB transaction sometimes come out as two rows?

It should not, and if it does the file is worth sending in. NAB wraps Particulars across lines, and the parser uses the presence of a date and an amount to decide where a transaction starts. A wrapped line with no amount is appended to the row above. The running balance check catches the rare case where that goes wrong.

My six-monthly NAB statement is 30 pages. Is that a problem?

No. Long statements are common on Classic Banking accounts and the converter handles them as one document, stripping the repeated page headers and the carried-forward balance line at the top of each page. The row count and closing balance are checked against what NAB printed, so a page dropped by a flaky download is reported.

How do I convert a NAB statement PDF to Excel?

Download it from NAB using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many NAB statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in Australia

All banks and formats · See a sample result