ANZ Statement to Excel Converter

When statements don't cover the dates you need, ANZ suggests a Transaction Report for the last 30, 60, 90 or 120 days, generated from View statements in Internet Banking or the Statements tab in the app. It is useful for a lender who wants the last three months up to yesterday, between statement dates.

A Transaction Report is a PDF list of transactions; FlowParse converts it into rows like a statement. Where it prints an opening and closing balance, the same proof applies.

Opening balance plus every signed transaction must equal the closing balance, and each row must follow from the running balance before it. FlowParse checks both on every statement. A deposit read as a withdrawal, or a line lost at a page break, fails at the row where it happened.

Statements that pass are marked reconciled; anything else is shown in the preview with the difference.

The Australian financial year runs from 1 July to 30 June, which rarely lines up with statement periods. Smart Merge takes up to 100 ANZ PDFs — everyday, savings, business, credit card — and builds one workbook in date order with the account and source on every row, chaining each statement's closing balance to the next opening balance per account. Filter to the financial year after the merge.

Statements from CommBank, Westpac, NAB or Bendigo can be merged into the same workbook, matched column by column.

Australian bookkeepers and BAS agents mostly work in Xero, MYOB or QuickBooks Online. FlowParse exports a CSV for Xero's or MYOB's bank import, a QBO file for QuickBooks, and an Excel file for review first.

Because the description is kept whole — the BPAY biller, the PayID sender, the direct-debit company — each line can be matched and coded after import, including for GST.

A business lodging quarterly BAS needs each quarter's bank transactions coded for GST, and the ATO generally expects business records to be kept for five years. A closed account from three years ago is still inside that window.

Converted ANZ statements give the BAS agent a quarter's transactions in one table, proved against the bank's balances; the PDFs, kept alongside, are the records the ATO may ask to see.

Withdrawals and deposits are unsigned columns; pasted into one list they all become positive. An Australian date like 03/04/2025 is the 3rd of April and becomes March 4th in an American template. A BPAY payment with its biller code and reference wraps over two lines and becomes two rows.

FlowParse signs by column, writes unambiguous dates and keeps one transaction per row; the balance proof confirms nothing was split or dropped.

A café owner moved their business banking away from ANZ last year and closed the old account in March. Their accountant needs July to March from the closed account and April to June from the new bank. The figures here are an illustration, not a real business's.

The export no longer works for the closed account, but its statements are still in Internet Banking. The owner downloads them, adds the new bank's statements, and uploads everything. Smart Merge returns one workbook for the financial year, each statement proved, both accounts chained, and the transfer that moved the balance across visible on both sides. The CSV goes into Xero, coded for GST, without retyping a line.

Coverage: each closing balance equal to the next opening balance, per account. Period: the financial year or BAS quarter filtered after the merge. Reconciled: every statement proved before its totals are used.

And keep the PDFs. The converted file is a working copy; the statement is the record for the ATO, a lender or a court.

Everyday, savings, business and credit card statements list transactions between two balances and convert the same way. Transaction Reports convert as lists of transactions.

Notices — interest rate changes, fee notices, account letters — and annual interest summaries are not transaction lists. Keep them; convert the statements.

A household or a small business often has an ANZ everyday account, a savings account, a credit card and perhaps a home loan offset, each with its own statement. Separately they are four folders of PDFs; transfers between them look like income on one side and spending on the other.

Converted and merged, the four become one workbook with the account on every row. The transfers pair up — the same amount, the same date, opposite signs — and can be excluded in one filter, leaving the real income and spending visible for the year.

ANZ's FAQ covers a message some customers see: "This account is not eligible to receive online statements". The reasons it gives are that the account itself is not eligible for online statements and notices, or that you as the user are not eligible to view them for that account.

In that case the statements still exist — on paper, or through a replacement statement ordered by email. Either converts: email PDFs exactly, paper through OCR, each proved against its balances. For accounts that are eligible, ANZ encourages switching to online statements so they are available as soon as they are issued, which is also the easiest way to build an archive you can convert later.