NAB statement to CSV

Getting the PDF out of NAB

1. Log into NAB Internet Banking with your NAB ID and password.
2. Select Accounts in the menu, then Account statements.
3. Choose the account from the drop-down list, pick a Date range or enter a custom one, and select Search.
4. Tick up to 25 statements and select Download. They land in your browser’s download folder.

NAB Internet Banking reaches back up to seven years of statements; the NAB app, up to two.

A closed account’s statements are under Account statements, then Closed or Hidden Accounts, for up to seven years, but only if you opted into online statements before you closed it.

Business accounts take a Business NAB ID rather than a Personal one when you change their statement settings.

From NAB’s own help: Access online account statements and letters.

What a NAB statement looks like, and what we do with it

The first page opens with an Account Balance Summary and the dates the statement starts and ends, then Transaction Details under Date, Particulars, Debits, Credits and Balance. Transactions are listed earliest first, each payee and amount trailing a line of dots, and the table breaks across pages with Carried forward and Brought forward lines. The iSaver statement we tested spanned six months on two pages, the second closing with a panel of government withholding tax for the financial year. The NAB Business Visa statement of a company’s commercial card is laid out apart from this: page one gives the Company Account No and Your Account Summary, from Balance from previous statement to Closing Balance, then a Transaction record for the billing account, a Cardholder summary listing every card, and a page or more for each cardholder under Date, Amount A$, Details, Explanation, the GST columns and Reference.

Dates spell the month in three letters and carry the year, day first.

We read the month by name and write each date year first.

Balances carry a Cr or Dr suffix after the figure.

The suffix gives the figure its sign.

A transaction runs over two lines: the date, the channel and the reference on the first, then the payee and the amount on the second, joined by a long row of dots.

We join the second line to the first and read the amount from the end of the dots.

The list opens with a Brought forward row, and an interest rate line carries a balance with no amount beside it.

The opening balance comes from the first. We leave the rate line out.

Opening balance, Total credits, Total debits and Closing balance sit together at the top of the first page.

A row we missed or misread would leave our totals short of NAB’s, so we hold ours against them.

The commercial card prints the balance owed with DR after it, and a payment into the card with CR.

We read a DR balance as what is owed and a CR row as a payment, and the rows have to carry the previous balance to the closing one.

Each cardholder’s pages name their own card number and print no opening balance. The Closing Balance on page one is the billing account and every card together.

We read the billing account and the cards it lists as one account, the company’s, so the closing balance checks every purchase, payment and fee.

On a cardholder’s page the amount comes before the details, and Explanation and the GST columns are lines of blanks for the cardholder to fill in. A purchase in another currency adds a FRGN AMT line that repeats its date and amount.

We leave the blanks out of the columns, and add the foreign amount to the purchase’s details rather than counting it twice.

What this page is based on

One NAB iSaver statement, a personal savings account, covering six months across 2025 and 2026. Every row agreed with the running balance, and the sums of our credits and debits equalled the two totals NAB printed on page one. Three months of a local council’s NAB Business Visa statements from 2024, each a billing account and two or three cards, 18 to 34 transactions: the rows carried the previous balance to the closing one to the cent, and each card’s rows added up to the total printed under them, on one card across a page break. No two of these are consecutive statements of one account, so none has been joined to the next.

No NAB transaction account statement has been tried yet, business or personal, nor a NAB personal credit card. A recent transactions PDF from Internet Banking is, as NAB puts it, not a statement but a report of recent activity, and we have not converted one.

Once it is converted, the import steps for each accounting package are the same for every bank.

Questions

Privacy, scans and price work the same for every bank, and the home page answers them.