NAB Statement to CSV: Past the 731-Day Wall

The request usually arrives with a deadline attached. A broker wants six months of transactions in a spreadsheet. An accountant is reconstructing a financial year. The ATO has asked about a period from three years ago. Or a business partner has emailed a stack of statement PDFs and expects them tabulated by Friday.

NAB will export transactions for you, and for recent periods that is the right answer. The catch is a hard boundary: NAB Internet Banking shows up to 731 days of transaction history, while it holds seven years of statements. Cross that line and the export button stops being an option — but the statement PDF is still there. This post covers both sides of it.

Quick answer

Two routes get NAB transactions into CSV.

1. NAB's own export. In NAB Internet Banking, transaction history can be exported as a spreadsheet, a QIF file or a PDF. Fastest and cleanest when you have login access and the period falls inside the 731-day window.
2. Convert the statement PDF. Beyond 731 days, for closed accounts, or for statements someone sent you, the data only exists as one of NAB's archived statement PDFs. Upload it to a converter like BankStatementKit, which reads the transactions out and balance-checks them against the statement's own printed totals.

Rule of thumb: inside two years with a working login, export. Outside it, convert the statement.

Convert a NAB statement to verified CSV

Option 1: NAB's built-in transaction history export

If you have NAB Internet Banking access and your period is recent, start here.

1. Log in to NAB Internet Banking with your NAB ID and password.
2. Open the Accounts menu and select Transaction history.
3. Choose the account and the date range you need, then apply any search or filter you want carried through.
4. Select Export and choose your file type — spreadsheet, QIF or PDF.
5. Open the file in Excel or Google Sheets.

For statements rather than transaction history, the path is Accounts then Statements, where you pick the account and date range and download the statement PDF. NAB Internet Banking gives you up to seven years of those; the NAB app carries two.

Where the built-in download stops

• 731 days, and that's it. Transaction history in NAB Internet Banking is capped at roughly two years. Loan files, audits and amended returns routinely reach further back than that.
• Statements outlive transactions. Seven years of statements exist online while only two years of transactions are exportable, which means the older half of your history is PDF-only by design.
• The app is narrower than the browser. Two years of statements in the app versus seven in NAB Internet Banking, so a phone is the wrong tool for an old period.
• You need a live login. Closed accounts, a former business account, or a statement a client emailed you leave nothing to export.
• The export's shape differs from the statement's. NAB's spreadsheet export is commonly a single signed amount column, while the statement PDF prints debits and credits separately — so a mapping that works on one will not work on the other.

Option 2: Convert the NAB PDF statement to CSV

1. Download the statement PDF from Accounts > Statements in NAB Internet Banking, or use the file you were sent.
2. Upload it. The PDF is processed in memory and never stored; if it is password-protected, supply the password and it is unlocked in memory.
3. Transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance.
4. Check the verification label, then download the CSV.

Uploads are limited to 20MB or 50 pages, and scanned or photographed statements fall back to OCR automatically — useful for the older statements people photograph out of a folder.

Convert a NAB PDF statement

Why NAB PDFs trip up generic converters

The export and the statement are different artefacts. NAB describes its personal export as a spreadsheet, QIF or PDF, and it is generated from NAB's records rather than from the printed page. That means a tool or template built around an export will not necessarily line up with a statement PDF of the same period — column names, and possibly the way direction is carried, can differ between the two. Whichever you are working from, the direction of every amount has to be read from the document in front of you rather than assumed from the other one.

The details column wraps. NAB's transaction description carries merchant, location, card and reference text, and a single entry frequently spills onto more than one printed line. Line-by-line extraction turns one transaction into several fragments, most of them with no amount — the row count goes up and the balance chain quietly breaks. Continuation lines have to be folded back into the transaction they belong to.

Statement furniture sits in the table's coordinate space. The BSB and account block, the statement period, the account summary and the fine print at the foot are all text with numbers in it. Nothing about their position tells a naive parser they are not transactions.

Prove the CSV matches the statement

NAB statements give you two independent ways to check the conversion rather than trust it.

1. The running balance chain. Each transaction row prints a balance. Previous balance minus the debit plus the credit must equal the printed balance, row after row. A dropped, duplicated or sign-flipped transaction snaps the chain at exactly the row that caused it — which is what turns "the total is wrong" into "row 148 is wrong".
2. The account summary. The statement closes the period with an opening balance, total credits, total debits and a closing balance. Opening + total credits − total debits must equal closing, and the sums of your CSV's Debit and Credit columns must match those printed totals.

Running both by hand takes ten to fifteen minutes a statement, which is why almost nobody does it across a seven-year archive. BankStatementKit runs both on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy naming the row where the arithmetic stops agreeing. The layout notes live on the NAB statement converter page.

FAQ

The bottom line

NAB's export is the right tool inside 731 days. Outside it — and that is most tax, lending and audit work — the seven years of statement PDFs are all you have, and they use a different column shape from the export, so mapping matters more here than at most banks. Convert the statement, then make it prove itself against the opening and closing balances printed on the page.