How to Convert ANZ Statements to CSV or Excel

Why Convert ANZ Statements?

ANZ (Australia and New Zealand Banking Group) is one of Australia's 'Big Four' banks, with over 8 million customers across Australia, New Zealand, and the Asia-Pacific region. ANZ's PDF statements serve personal customers, small businesses, and corporate clients who need transaction data for ATO tax returns, BAS preparation, and financial record-keeping. ANZ statement PDFs have a traditional banking layout with clearly separated debits and credits. BankRead extracts every transaction from ANZ statements into a structured spreadsheet format with AI categorization.

Understanding the ANZ Statement Format

ANZ transaction account statements use a portrait PDF with transactions listed chronologically in a table showing Date, Transaction Details, Debit, Credit, and Balance. The header includes the BSB, account number, account name, and statement period. ANZ credit card (Visa, Mastercard) statements display an account summary followed by detailed transactions with Date, Description, and Amount. ANZ New Zealand statements follow the same structure with NZD amounts.

How to Convert with BankRead

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

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your ANZ 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 ANZ Statement PDF

1. Log in to ANZ Internet Banking at anz.com.au or the ANZ App.
2. Select the account from your account overview.
3. Navigate to 'Statements' in the account menu.
4. Select the statement period — ANZ stores eStatements for up to 7 years.
5. Click 'Download' to save the PDF to your device.

What Data Gets Extracted

BankRead extracts the following fields from your ANZ statement:

• Transaction date (DD/MM/YYYY)
• Transaction details (e.g., 'VISA PURCHASE COLES EXPRESS MELBOURNE AU')
• Debit amount (purchases, direct debits, ATM withdrawals)
• Credit amount (salary, transfers in, refunds, interest)
• Running balance (AUD or NZD)
• AI-assigned category (e.g., Fuel, Supermarkets, Transport, Insurance, Salary)

Export Options

Once your ANZ 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 ANZ Statements

• ANZ statements clearly separate Debit and Credit columns, making extraction straightforward and accurate.
• ANZ Visa and Mastercard credit card statements are supported alongside transaction accounts.
• ANZ New Zealand account statements follow the same layout and are fully supported in NZD.
• Multi-page statements are handled in a single upload — no need to split PDFs.
• ANZ Business account statements use the same tabular format as personal accounts.

Common Issues and Solutions

• ANZ 'Visa Purchase' descriptions include the merchant name and location but may truncate longer names. BankRead extracts the available text and uses AI to categorize accurately.
• ANZ statements may include an 'Interest Summary' section at the end. This is aggregate data and is not extracted as individual transactions.
• ANZ Progress Saver and ANZ Online Saver accounts may have very few transactions (mainly interest). BankRead handles these low-activity statements correctly.

Frequently Asked Questions