Skip to main content
International · Processed in your browser · financial data never uploaded

Convert a ANZ bank statement to Excel

Convert a ANZ statement PDF to Excel or CSV in your browser. StatementSift detects date, description, amount and balance columns, then checks row-by-row balance continuity before export. ANZ statements use this layout: ANZ Statement of Account lists one row per transaction in the order Date, Transaction Details, Withdrawals (Debit), Deposits (Credit) and Balance — debits and credits sit in separate columns, dates print as '12 Mar 2024', with the account number and statement period shown in the header.

Debit / credit columnsstatement layout
DD MMM YYYYdate format
XLSX / CSVexport paths
ANZ statement reconciliation proof workspace
  1. Choose PDF
  2. Review transactions
  3. Export your data
Drag & drop or click to select filesFiles are processed locally in your browser, never uploaded

Choose a PDF with selectable text from online banking. Parsing runs locally; incomplete balance evidence is marked for review. Check the extracted rows against your statement before exporting.

Columns

ANZ Statement of Account lists one row per transaction in the order Date, Transaction Details, Withdrawals (Debit), Deposits (Credit) and Balance — debits and credits sit in separate columns, dates print as '12 Mar 2024', with the account number and statement period shown in the header.

Best source

Sign in to ANZ Internet Banking or the ANZ App, open Statements / eStatements, pick the period and download the official PDF statement (text-based) rather than a screenshot or a scan — scanned copies make OCR misread the debit, credit and balance columns.

Review target

Flagged rows, opening and closing balances.

Watch-outs for ANZ statements

01

ANZ separates money out and money in into debit and credit columns. If a row is flagged, first check whether the sign was assigned correctly.

02

Wrapped merchant descriptions can push the next line out of alignment; check long descriptions when the balance proof fails.

03

Opening balance, closing balance and page-break continuation rows are not ordinary transactions, so review the first and last rows on multi-page statements.

How to convert a ANZ statement

  1. 1

    Download your ANZ statement as a text-based PDF from online banking.

  2. 2

    Drop the PDF into the local converter on this page.

  3. 3

    Review detected columns, opening and closing balances, and every flagged row.

  4. 4

    Export to Excel, CSV, or QuickBooks/OFX only after the reconciliation looks right.

Frequently asked questions

No. Reading the PDF, detecting rows, checking balances and building the export all run locally in your browser. Your ANZ statement is not uploaded or sent to an AI service.

Sign in to ANZ Internet Banking or the ANZ App, open Statements / eStatements, pick the period and download the official PDF statement (text-based) rather than a screenshot or a scan — scanned copies make OCR misread the debit, credit and balance columns.

Treat the export as a format conversion, not financial, accounting, tax or legal advice. Verify key figures and consult a qualified professional before relying on the output.

Updated · StatementSift team

Related guides