Bulk convert NAB statements to CSV

A NAB Rewards Platinum statement and a NAB transaction account statement don't look alike on the page, but they need to end up as the same shape of row once they're in a spreadsheet: date, description, one amount in debit or credit, and a balance that carries forward correctly. A card statement's "purchase" is a transaction account's "debit," and if a converter doesn't reconcile that, mixing the two in one file produces a mess of inconsistent columns that a bookkeeper then has to fix by hand before reconciling anything.

That reconciliation happens automatically here: NAB purchases parse as debits, payments as credits, and the running balance is carried through, so a Low Rate Visa statement and an everyday account statement line up column for column in the same merged CSV.

Getting to that merged file works the same way it does for any bank. NAB only ever hands over eStatements one period at a time, through Internet Banking or the app, with nothing that exports a year of transactions in one go. Batch conversion takes ten of those PDFs per run, and a calendar year of one account clears in two.

Every row comes out with date, description, debit, credit and category columns, which drops straight into Xero, MYOB, QuickBooks or a plain spreadsheet. Where a file fails, it's usually a bank mismatch, and that file is called out by name with no credit charged, so it can be fixed and rerun without touching the files that already converted cleanly.