Financial Documents

How to Convert ANZ Bank Statements to Excel or CSV

Guide to converting ANZ bank statements to Excel or CSV. Covers native export limits, conversion methods, and MYOB or Xero import for Australian teams.

Published
Updated
Reading time
10 min
Topics:Financial DocumentsBank StatementsAustraliaExcelANZBAS preparationbank statement conversion

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 Internet Banking exports transactions from the last two years for open accounts, and its transaction reports cover the last 30, 60, 90 or 120 days. You choose the export's format from a software-package dropdown, and the CSV file ANZ's page describes opens directly in Excel.


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. To download it:

  1. Log in to ANZ Internet Banking and select the account from the homepage.
  2. Click Download at the top of the Transactions tab.
  3. Select the Time period.
  4. Select a Software package from the dropdown, choosing the CSV option if the file is going into Excel.
  5. Click Download.

The limitations are significant. The export only covers the last two years of transactions, and only for open accounts. 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. For older periods or a closed account, this option is unavailable entirely. A closed account keeps its PDF statements (in the ANZ App, tap More, then View statements; closed accounts appear at the bottom of the list), but ANZ warns that online statements are lost once every linked account is closed, so save them before closing the last one. If you only need a few months, ANZ's Transaction Report covers the last 30, 60, 90 or 120 days: in the ANZ App, select the account, open the Statements tab and choose Get a Transaction Report.

ANZ Plus is documented differently. ANZ's ANZ Plus help describes monthly statements in the app, under Profile then Statements, and no transaction export, so for an ANZ Plus account the statement PDF is the starting point.

Suncorp Bank customers move to ANZ during 2027 and keep banking with Suncorp until then, so an account's statements from before its move are Suncorp's. Our guide to converting Suncorp Bank statements to Excel or CSV covers that part of the history.

Best for: Pulling recent transaction data (within the last two years, on an open account) 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, a closed or ANZ Plus account's history, 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.

To get the PDF from ANZ Internet Banking, select the account, choose View statements on the left, pick the account from the dropdown and click Download. In the ANZ App, select the account, tap Statements, open the statement and tap the share icon at the top right. A statement you can no longer see online can be ordered under View statements, Order a replacement statement: it arrives in 3 to 5 business days by mail, or two by email.

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 set the date format to DD/MM/YYYY explicitly when you open a CSV in Excel or import one into Xero.
  • 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.

For recent history on an open account, ANZ's bank feed may make conversion unnecessary. ANZ lists both Xero and MYOB among the platforms its feeds support, and a feed is set up under Settings, then Manage bank feeds, in ANZ Internet Banking or Internet Banking for Business. ANZ's bank feeds page offers a choice of history once, at first setup: Last 2 years (the current and previous financial year), Current year, or None. From then on the feed sends transactions overnight after each business day. Converted statements cover what the feed cannot reach: periods before the history chosen at setup, a feed set up later with no history, closed accounts, and statements needed as the bank issued them, with balances and totals, for an audit, a BAS review or onboarding a client's old books.

Where the data comes from converted statements, each platform has its own format requirements, and ANZ statement data needs preparation before it will import cleanly.

MYOB Import Path

MYOB's statement import does not take CSV. MYOB's support page on importing bank statements lists QIF or OFX files for MYOB Business and OFX, QFX, QIF or OFC for AccountRight, each under 10MB, with dd/mm/yy dates where the bank offers a choice. A CSV saved from Excel will not import, however its columns are laid out.

Outside the feed, ANZ's own export gives you a MYOB-ready file only if its software-package dropdown offers QIF or OFX. ANZ's page does not list the options, so check the dropdown before converting anything. For PDF statements the route is two steps: extract the statement into a spreadsheet, then turn the spreadsheet into a QIF or OFX file.

Three details decide whether that file imports cleanly:

  • Dates must stay Australian. ANZ statements use DD/MM/YYYY, which matches MYOB's Australian locale, so the risk is Excel having turned them into MM/DD values or text strings along the way. Check them in the spreadsheet and keep dd/mm in the file you build.
  • Amount signing must survive the conversion: money in positive, money out negative. A flipped sign imports without an error and only shows up later as a reconciliation mismatch.
  • 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, turn into extra transactions or split payees in the import file.

Check the spreadsheet for these issues before converting it, since unwinding a bad import takes longer than the original conversion. Our guide on importing bank statement data into MYOB covers the QIF and OFX conversion step and MYOB's import screens.

Xero Import Path

Xero's CSV statement import needs only two fields: Date and Amount. You assign your file's columns to Xero's fields during the import, and Payee, Description and Reference are optional. Keep amounts in one signed column, money in positive and money out negative.

The optional fields still earn their place. 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.

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.

  1. 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.
  2. Verify statement continuity. Each month's opening balance should match the previous month's closing balance exactly.
  3. Combine transactions chronologically and check for duplicate rows at month boundaries.
  4. 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.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours