Banks

Convert ANZ Bank Statements to Excel

Convert ANZ statement PDFs to Excel and CSV, with withdrawals and deposits in their own columns and every balance checked. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your ANZ statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.

What an ANZ statement looks like

  • An ANZ statement has five columns: Date, Transaction Details, Withdrawals ($), Deposits ($) and Balance ($).
  • The date is printed as day and month, such as 28 JAN, with the year left to the statement's period. Your spreadsheet keeps the date as printed.
  • The transaction details often run onto a second line, such as the reference of a transfer. We keep that line in the same row, so each transaction is one row.
  • An OPENING BALANCE line starts the statement and comes through as a row of its own.

What your spreadsheet looks like

Date Transaction Details Withdrawals ($) Deposits ($) Balance ($) Ledger
27 JAN OPENING BALANCE 2,140.00 ok
28 JAN EFTPOS PURCHASE A CAFE 6.50 2,133.50 ok
31 JAN ANZ INTERNET BANKING TRANSFER WAGES A COMPANY 1,250.00 3,383.50 ok
01 FEB ACCOUNT SERVICING FEE 5.00 3,378.50 ok

The rows above are an example, not a real statement.

In the files for Xero, QuickBooks and FreeAgent, each transaction gets its full date, with the year taken from the statement's period.

How we test it

We test against two ANZ statements, eleven pages in all: 77 transactions, and every one of them balances against the row before it.

Convert an ANZ statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.