How to Convert NAB Statements to CSV or Excel

Why Convert NAB Statements?

NAB (National Australia Bank) is one of Australia's 'Big Four' banks, serving over 9 million customers including personal, business, and corporate clients. NAB is particularly popular among small and medium businesses in Australia. NAB's PDF statements are regularly needed for ATO tax returns, BAS lodgement, bookkeeping, and mortgage applications. NAB statements use a familiar tabular layout that's consistent across account types, but extracting this data into a spreadsheet by hand remains slow and error-prone. BankRead automates the process, converting NAB PDFs into structured, categorized spreadsheet data in seconds.

Understanding the NAB Statement Format

NAB transaction account statements use a portrait PDF with transactions in a table showing Date, Transaction Details, Debit, Credit, and Balance. The header includes the BSB, account number, account name, and statement period. NAB credit card (Visa) statements display a summary section followed by detailed transactions with Date, Description, and Amount. NAB business account statements include reference numbers. All amounts are in AUD ($).

How to Convert with BankRead

Follow these steps to convert your NAB PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your NAB online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your NAB Statement PDF

1. Log in to NAB Internet Banking at nab.com.au or the NAB Mobile Banking app.
2. Select the account from your accounts overview.
3. Click 'Statements' or 'eStatements' in the account menu.
4. Choose the statement period — NAB stores eStatements for up to 7 years.
5. Click 'Download' to save the PDF statement to your device.

What Data Gets Extracted

BankRead extracts the following fields from your NAB statement:

• Transaction date (DD/MM/YYYY, Australian format)
• Transaction details (e.g., 'VISA DEBIT PURCHASE CARD XXXX COLES SUPERMARKET')
• Debit amount (purchases, direct debits, fees)
• Credit amount (salary, transfers, interest)
• Running balance (AUD)
• AI-assigned category (e.g., Supermarkets, Fuel, Insurance, Salary, Dining)

Export Options

Once your NAB statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for NAB Statements

• NAB statements clearly separate Debit and Credit columns, making extraction accurate and reliable.
• NAB Visa credit card statements are supported alongside transaction and savings accounts.
• NAB business account statements include additional reference numbers that are captured in the description.
• Multi-page statements are processed in a single upload with no page limit.
• NAB iSaver and NAB Reward Saver account statements may have few transactions (mainly interest) — these are handled correctly.

Common Issues and Solutions

• NAB Visa purchase descriptions include the card's last four digits and merchant name. BankRead extracts the full description text for accurate categorization.
• NAB's 'Interest Summary' section at statement end is aggregate data and not extracted as individual transactions.
• NAB Business Account statements with very high transaction volumes (100+ per month) may span many pages. BankRead processes all pages in a single upload.

Frequently Asked Questions