Convert NAB Bank Statements to CSV & Excel

National Australia Bank internet-banking PDFs use DD MMM YY dates and separate debit/credit columns. StatementKit writes Xero-ready CSV or Excel with YYYY-MM-DD dates and AUD amounts as numbers.

NAB at a Glance

Full Name: National Australia Bank

Country: Australia

Currency: AUD

Date Format: DD MMM YY (e.g. 15 Jan 26)

Layout: Date | Transaction Details | Debit | Credit | Balance

Also searched as: NAB statement to Excel

NAB Statement Format

NAB Internet Banking offers a CSV for recent activity, but the official PDF is what you keep for BAS and audits — and it does not paste cleanly into Xero. StatementKit reads Debit and Credit as one signed amount and restores the four-digit year from the statement period.

BPAY, Osko, and PayID references stay in the description.
Business and Classic Banking use the same core table.
Password-protected PDFs must be unlocked before upload.

How to Convert a NAB Statement

In NAB Internet Banking, open the account and download the statement PDF.
Upload it to StatementKit.
Download CSV for Xero or MYOB, or Excel for review.

Frequently Asked Questions

Can I import the CSV into Xero?

Yes. Dates are YYYY-MM-DD. Use Xero’s bank statement import and map Date, Description, and Amount.

Is this useful for BAS?

Yes. A spreadsheet is easier to code for GST than paging through a PDF. Keep the original PDF with the export.

Do you support other Australian banks?

Yes — Bendigo, CommBank, ANZ, Westpac, and every other Australian bank PDF.

Convert NAB Statements to CSV & Excel