Convert ANZ New Zealand Bank Statements to CSV

Upload your ANZ New Zealand PDF statement, and the converter extracts transaction date, description, debit, credit, and running balance into a CSV file. Download the structured data file in seconds, ready to import into your accounting software or spreadsheet.

CSV files give you maximum flexibility: every accounting package, spreadsheet application, and data analysis tool accepts comma-separated values. You control the column mapping, formulas, and analysis workflow without being locked into proprietary formats.

How do I convert an ANZ New Zealand statement to CSV?

1. Download your ANZ New Zealand statement as PDF from ANZ Internet Banking or the ANZ app.
2. Upload the PDF to BankStmtConverter.com — no registration required.
3. The converter extracts transactions, dates, amounts, and running balance.
4. Download the CSV file and open it in Excel, Google Sheets, or import it into your accounting software.

The process takes under a minute for statements up to 50 pages. Multi-page statements are handled automatically; you get a single CSV with all transactions in chronological order.

What data gets extracted from ANZ statements?

ANZ New Zealand statements typically show transaction date, description (merchant name or transfer details), debit amounts, credit amounts, and a running balance after each transaction. The converter preserves all five fields as separate CSV columns.

Transaction descriptions include payee names for transfers, merchant names for card purchases, and reference codes for direct debits. The converter keeps the full description text so you can filter or categorize transactions later. Value dates (when funds actually move) appear as the transaction date; posting dates are not separately shown on ANZ consumer statements.

Opening and closing balances are checked against the running balance column to catch extraction errors. If the final balance does not match the statement's printed closing balance, the converter flags a data integrity warning before you download.

Working with CSV files from ANZ statements

Once you have the CSV, your workflow depends on your tools. Accounting software typically requires you to map CSV columns to its expected fields during import: transaction date to Date, description to Narration or Memo, debit to Money Out, credit to Money In. Check your software's bank import or CSV upload feature for the exact field names.

In Excel or Google Sheets, open the CSV and assign column headers if they are not already present: Date, Description, Debit, Credit, Balance. You can then build pivot tables to summarize spending by category, use =SUMIF() to total debits by keyword ("=SUMIF(B:B,"*Countdown*",C:C)" sums all debits with "Countdown" in the description), or create charts showing balance trends over time.

Popular workflows include:

• Importing into MYOB, Xero, or QuickBooks via their CSV bank statement upload (map columns during import).
• Appending multiple months of statements into a single CSV master file for year-end analysis.
• Using spreadsheet filters to reconcile specific transactions against invoices or receipts.
• Running custom Python or R scripts for cash flow forecasting or anomaly detection.

CSV format means you are not dependent on software-specific importers. If your accounting tool changes or you switch to a new analysis method, the raw CSV data remains readable and portable. One accounting firm reconciles 40 ANZ business accounts monthly by converting statements to CSV, importing into Excel, then using a macro to flag unmatched transactions before pushing to MYOB.

Does it work with scanned ANZ statements?

Yes. Many ANZ business customers receive paper statements or download image-based PDFs from older archived periods. The converter applies OCR to extract transaction tables from scanned or photographed pages.

OCR accuracy is high for ANZ's standard statement layout: clean fonts, consistent table structure, and clear column alignment. The system cross-checks extracted totals against the printed opening and closing balance on the statement. If OCR misreads a digit and the balance does not reconcile, you receive a warning so you can review the CSV before importing it into your accounts.

For best results, scan at 300 dpi or higher if you are digitizing paper statements. The converter handles slight skew and normal photocopy artifacts without issue.

Column structure and delimiter details

The CSV uses commas as delimiters and double-quotes around text fields that contain commas (such as "Countdown Supermarket, Auckland"). Most spreadsheet applications and accounting tools auto-detect this format when you open or import the file.

Typical column order: Date, Description, Debit, Credit, Balance. Debits and credits appear as positive numbers in their respective columns; blank cells represent zero (a debit transaction leaves the Credit column empty). The Balance column shows the running total after each transaction, matching the rightmost column on the ANZ PDF.

Date format is DD/MM/YYYY, the New Zealand standard. If your accounting software expects MM/DD/YYYY, apply a find-replace or use a spreadsheet formula to reformat before import: =TEXT(DATEVALUE(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,4)),"MM/DD/YYYY").

Example: three ANZ transactions in CSV format

A small business receives payment, pays a supplier, and withdraws cash. The ANZ statement shows:

12/03/2025, Invoice 4521 - ABC Contractors, , 2450.00, 8930.50
13/03/2025, Paymark Purchase - Bunnings Te Rapa, 387.60, , 8542.90
14/03/2025, ATM Withdrawal - ANZ Queen Street, 200.00, , 8342.90

Each row: Date, Description, Debit, Credit, Balance. The credit of $2,450.00 increases the balance to $8,930.50. The two debits reduce it to $8,342.90. Import this CSV into your accounting software, map columns, and the transactions appear ready to categorize and reconcile.

Data privacy and file handling

Uploaded PDFs and generated CSV files are deleted from the server within one hour of processing. No statement data is retained, logged for analysis, or used to train machine learning models. The conversion runs entirely on secure infrastructure; your ANZ transaction history remains private.

For extra assurance, download the CSV immediately and clear your browser's download history if you are on a shared computer. The converter does not require registration, so no email or personal information is collected.

Related converters for ANZ New Zealand

Need a different format? You can also convert ANZ New Zealand statements to Excel for pivot tables and advanced formulas, QuickBooks for direct QBO import, Xero for automatic bank reconciliation, or OFX for compatibility with MYOB and other desktop accounting tools. See all New Zealand banks supported by the converter.