Convert statements to excel.

ANZ Statement Converter

Statements can be requested through the ANZ app or via the Net Banking website.

You can convert your ANZ PDF statements to excel on this page. These are some of the more frequently processed layouts for ANZ.

Commonly processed types of accounts include:

  • ANZ Access Advantage Statement
  • ANZ Low Rate
  • Cheque Account

See the following guide for how to download your PDF statements.

Once you have your statements you may need to remove any password protection for our software to process it.

Choose “Tools” > “Protect” > “Encrypt” > “Remove Security.”

Remove Security: The options vary depending on the type of password security attached to the document. If the document has a Document Open password, click “OK” to remove it from the document.

Adobe website – Unlock your PDF file in seconds.

ANZ statements contain the year in the dates, this means that the formatted CSV output can be imported directly in accounting software like Xero, Quickbooks and MYOB.

The bank statement headers are spread across multiple lines, which means to correctly detect the table headers we parse multiple lines together to look for matches.

Table headers are displayed on each page of the bank statement that contains transactions, this helps with filtering other data such as notices and advertisements.

ANZ statements have different layouts and transaction data for different types of accounts. For example the ANZ Low Rate account contain Date Processed, Date of Transaction, Card Used, Transaction Details, Amount and Balance where as the Cheque Account statement contains Transaction Date, Value Date, Transaction Description, Debits, Credits and Balance.

Need Help?

Getting ANZ statements into excel is a common task. For any questions please reach out.