NAB statement to CSV

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

Dates spell the month, written 7 Oct 2025.

We read the month by name and write the date as 2025-10-07.

Balances carry a Cr or Dr suffix, written 3,522.85 Cr.

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.

The first page prints Opening balance, Total credits, Total debits and Closing balance.

We compare our totals with the printed ones, so a missed row shows up.

We have tested one real NAB iSaver statement: two pages, 34 transactions, every running balance matched, and the printed total credits and debits matched to the cent.

We have only tested the NAB iSaver savings account statement. Scanned or photographed statements do not work, because there is no text in them to read.

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

Questions