How to Convert ANZ Bank Statements to Excel or CSV

To convert an ANZ bank statement to Excel or CSV, use ANZ's native CSV export when you only need recent transaction rows; use the PDF eStatement plus a structured extraction tool when you need running balances, opening and closing totals, older periods, or a file ready for MYOB/Xero import.

According to ANZ's support documentation on accessing account statements and transaction exports, ANZ provides CSV transaction exports covering the last two years for open accounts and transaction reports for the last 30, 60, 90, or 120 days, but offers no native Excel download option. ANZ's statement support page also notes a 90-day limit for V2 Plus accounts, so Plus users should confirm the available history in the app before relying on ANZ's native export options.

Three Ways to Convert ANZ Statements to Excel

There are three practical approaches to getting ANZ bank statement data into a spreadsheet. Each involves different trade-offs around effort, data completeness, and reliability.

Manual Copy-Paste from PDF

The most basic method: open your ANZ eStatement PDF, select the transaction rows, and paste them into Excel. For a single-page statement with a handful of transactions, this can work in a pinch.

The problems surface quickly. Column alignment breaks on paste, with dates, descriptions, and amounts frequently landing in the wrong cells. Running balances and opening/closing totals rarely transfer intact. Multi-line transaction descriptions (common with ANZ's EFTPOS and direct debit entries) collapse or split unpredictably. For a multi-page statement, you repeat the entire process page by page, manually cleaning each batch.

Best for: A one-off extraction from a short, single-page statement where you can visually verify every cell.

Not viable for: Anyone processing more than a few statements, or anyone who needs the data to be reliable without manual cell-by-cell checking.

ANZ's Native CSV Transaction Download

ANZ Internet Banking lets you download transaction data as a CSV file directly. This gives you structured columns (date, description, amount) that open cleanly in Excel without alignment issues.

The limitations are significant. The CSV export only covers the last two years of transactions. It provides raw transaction-level data with no running balances, no opening or closing totals, no interest or fee breakdowns, and no statement structure. You get a flat list of transactions rather than anything resembling the original statement layout. If you need data from older periods, this option is unavailable entirely.

Best for: Pulling recent transaction data (within the last 24 months) when you only need dates, descriptions, and amounts in a clean format.

Falls short when: You need the full statement layout, running balances, data older than two years, or a structured record that matches what your accountant or auditor expects to see.

AI-Powered PDF Extraction

The third approach is to upload your ANZ eStatement PDF to an extraction tool that reads the document's structure and outputs a formatted Excel or CSV file. Unlike copy-paste, this method parses the PDF layout programmatically, preserving dates, descriptions, amounts, running balances, and opening/closing totals in their correct columns.

For ANZ statements specifically, this handles formatting details that trip up manual methods: DD/MM/YYYY date normalization (so Excel doesn't misinterpret 03/04/2026 as March 4th instead of 3 April), multi-line description parsing where a single transaction spans two or three lines in the PDF, and running balance extraction across page breaks.

With Invoice Data Extraction, you can extract data from ANZ bank statements automatically. You upload ANZ eStatement PDFs (bank statements are a core supported document type) and receive structured Excel or CSV output with dates, amounts, descriptions, and running balances parsed correctly. Each output row references the source page number, so you can verify any figure against the original PDF. Multi-page statements process without manual intervention, and batch processing handles up to 6,000 files in a single job, which matters if you are converting a full year of monthly ANZ statements at once.

If you need a broader view of how this approach applies beyond ANZ, our guide on converting bank statements from any bank to Excel covers the general workflow.

Best for: Anyone who needs complete ANZ statement data with running balances and totals, especially across multiple statements or historical periods.

ANZ Statement Formatting Checks Before Import

Before importing converted ANZ data into MYOB, Xero, or a BAS workbook, verify the points that most often create silent reconciliation errors:

DD/MM/YYYY dates: Make sure Excel has not interpreted Australian dates as MM/DD/YYYY. Spot-check transactions from the first 12 days of the month and import CSV files with an explicit DD/MM/YYYY date setting.
Wrapped descriptions: BPAY payments, international transfers, direct debits, and payroll entries can span multiple lines. Compare the converted row count with the original statement and look for rows with descriptions but no amount.
Running balance continuity: The opening balance plus credits minus debits should reach the closing balance shown on the statement. Any mismatch means rows are missing, duplicated, or signed incorrectly.
Interest and fee rows: Check statement-summary totals against extracted interest credits and account fees so non-standard line items are not skipped or placed in the wrong column.
Page-break artefacts: Remove repeated headers and footers, then check month-end or page-boundary transactions where wrapped descriptions are most likely to be split.

Getting ANZ Statement Data into MYOB and Xero

Converting ANZ statements to Excel is rarely the end goal. For most accountants and bookkeepers, the converted data needs to land in MYOB or Xero for bank reconciliation. Each platform has specific format requirements, and ANZ statement data needs preparation before it will import cleanly.

MYOB Import Path

MYOB accepts bank statement imports in OFX, QIF, or formatted CSV. If you've converted your ANZ eStatement to Excel, the most practical route is saving it as a CSV with MYOB-compatible column headers.

Three format details will determine whether your import succeeds or fails:

Date format must match MYOB's expected format (typically DD/MM/YYYY for Australian company files). One advantage with ANZ statements: the DD/MM/YYYY dates already align with MYOB's Australian locale, so you avoid the US/AU date confusion that affects statements from international banks. Still, verify entries are parsed as dates rather than text strings before exporting.
Amount signing needs to be correct. MYOB expects debits and credits to be clearly distinguished. Some conversion methods dump everything into a single "Amount" column with positive and negative values, while MYOB may expect separate Debit and Credit columns depending on your import configuration.
Description fields must be clean, single-line entries. Multi-line artefacts from PDF conversion, where a single transaction's description wraps across two or three lines, will break column alignment and either error on import or create duplicate rows.

The reliable workflow is: convert to a structured spreadsheet first, audit the data for these issues, then export as CSV in the correct format. Skipping the verification step and importing directly from an unchecked source is how you end up with reconciliation mismatches that take longer to fix than the original conversion. For a detailed walkthrough of the MYOB-specific formatting, see our guide on importing bank statement data into MYOB.

Xero Import Path

Xero supports CSV bank statement imports with specific required columns: Date, Amount, Payee, Description, and Reference. Not all columns need to contain data, but the headers must be present and correctly named for Xero to map the fields.

Xero also supports direct ANZ bank feeds, which automate transaction imports for connected accounts. But bank feeds only cover a rolling window of recent transactions, typically 90 days, sometimes up to 12 months depending on the bank and feed provider. For historical statement data, for accounts not connected to bank feeds, or when onboarding a new client whose prior bookkeeper never set up feeds, CSV import from converted statements is the alternative path.

When preparing your converted ANZ data for Xero, map your spreadsheet columns to Xero's expected headers before saving as CSV. The Payee field is particularly useful for Xero's auto-matching rules, so preserving the transaction counterparty from the original statement, rather than merging it into a generic description, will save time during reconciliation. Our guide on importing bank statements into Xero covers the column mapping and import steps in detail.

Bank feeds do not solve historical clean-up work: for BAS reviews, audits, or onboarding a client's old books, converted ANZ eStatements provide importable data for periods outside the feed window.

Consolidating Multiple ANZ Statements for BAS and GST Reconciliation

For a quarterly BAS, convert all three monthly ANZ eStatements into one spreadsheet before you start coding transactions. For annual reviews, audit support, or onboarding a client's old books, do the same across the full statement set.

Convert each monthly ANZ eStatement PDF using the same method and output columns. If your extraction tool supports batch upload, process the full quarter or year together.
Verify statement continuity. Each month's opening balance should match the previous month's closing balance exactly.
Combine transactions chronologically and check for duplicate rows at month boundaries.
Reconcile the totals against the original statement balances before importing into MYOB, Xero, or a BAS workbook.

For quarterly BAS preparation, batch extraction avoids manually joining three monthly spreadsheets. The same workflow applies to lending applications, audit support, or historical-book clean-up. If a client banks across multiple institutions, see the bank-specific equivalents for converting NAB bank statements to Excel or CSV and converting Westpac bank statements to Excel or CSV.