Westpac Bank Statement to Excel Converter

Converting Westpac Statements to Excel

A Westpac statement is a tidy document, but it is still a PDF. Selecting the transaction table and pasting it into Excel usually gives you one long column of text, with amounts that will not add up and descriptions broken across rows. If you are catching up on a year of bookkeeping, or a client has sent you a folder of statements, that clean-up takes longer than the actual work. Finlyzers reads each statement and gives you a spreadsheet with one row per transaction and the balance checked on every line.

How a Westpac Statement Is Laid Out

• Header: account name, BSB and account number, and the statement period.
• Summary: an opening balance, totals for money in and money out, and a closing balance.
• Transaction table: typically a date, a transaction description, separate debit and credit columns and a running balance. Exact column labels can vary between account types and statement versions.
• Fees and interest: account fees and any interest earned appear as their own rows, which is useful when you want to claim or report them separately.

Everyday accounts such as Westpac Choice, savings accounts such as Westpac Life, and business transaction accounts broadly follow this pattern.

Westpac Description Wording to Look For

Descriptions are written out in words. The wording below is common, though it changes over time and between account types:

• Deposit: incoming payments, often with the payer's name and a reference such as an invoice number.
• Payment by authority: a payment a business collects from your account under a direct debit arrangement.
• BPAY: bills paid through BPAY to a named biller.
• EFTPOS purchase / debit card purchase: card spending, usually with the merchant name and suburb.
• Osko or PayID payments: fast transfers to and from other people, sometimes labelled as such in the description.
• Withdrawal: ATM withdrawals and transfers out.

Because these words stay in the Description column, you can filter in Excel to pull out, say, every payment by authority to check your recurring costs.

Why Bookkeepers Convert Westpac PDFs

Westpac Online Banking can export recent transactions, and a bank feed may already be connected to your accounting software. Converting the PDF is still the practical route when:

• Backfilling a ledger: the bank feed only starts from the day it was connected, and you need the months before that.
• Year-end catch-up: a sole trader or small business hands over twelve monthly statements just before the tax return is due.
• Closed or inherited accounts: you can no longer sign in, but you have the statements.
• Lender requests: a broker asks for recent statements for a home loan application and you want a spreadsheet summary of income and regular outgoings.
• Rental properties: separating rent, agent fees, council rates and repairs for each property.

Getting Westpac Data Into Your Software

From the same upload you can download:

• OFX for Xero or QuickBooks Online.
• CSV if you prefer to map the columns yourself or work in Google Sheets.
• QIF for desktop software that still uses it.

If you use MYOB, check which bank statement file formats your edition imports before choosing one. When importing CSV anywhere, make sure the software is set to DD/MM/YYYY dates.

The spreadsheet also works well for preparing a BAS: sort the quarter's transactions, tag each one, and hand your accountant a file instead of a PDF.

Other Australian Banks

If you hold accounts at more than one bank, the NAB statement converter and the ANZ statement converter give you the same column layout, so everything can be combined in one workbook.

Converting a Westpac credit card statement? Use the credit card converter. For paper statements, try the scanned statement converter.