AU
Upload a Westpac statement PDF and every transaction comes back as clean rows — date, description, debit, credit and the running balance — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.
Westpac statements are clear on the page, but the description column packs in a lot — the payment method, the payee and often a receipt number — and that's exactly what a straight copy-paste turns into a tangle.
What a Westpac statement looks like
A Westpac transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, Australian format |
Description | The payment method, payee and often a receipt number |
Debit | Money out |
Credit | Money in |
Balance | Running balance after the transaction |
The Description column is where the detail lives — whether a payment was an EFTPOS purchase, a direct debit, an Osko or PayID transfer, a BPAY bill or an ATM withdrawal, plus a receipt or reference number for many of them. That text frequently wraps onto a second line, and a rough export reads the overflow as its own row, splitting one payment in two. The converter rejoins it so each transaction is a single, complete line with its receipt number kept alongside.
Westpac statements also show the account's BSB and number in the header, which is handy when you're matching transfers across several accounts.
Where to download your Westpac statement
- Westpac Online Banking: log in at westpac.com.au, choose the account, open Statements, select the period and download the PDF.
- Westpac app: tap the account, go to Statements, pick a statement and save the PDF.
A statement downloaded from Online Banking is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a mailed statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
- QuickBooks, Zoho and others — the same data in each one's format.
Before you download, the maths is checked: opening balance, plus credits, minus debits, has to reach the closing balance. Across a statement that runs to several pages, that reconciliation is what surfaces a transaction which would otherwise slip through between them.
Real-time payments and receipt numbers
Westpac was among the Australian banks to roll out Osko and PayID for near-instant transfers, and those land on your statement with a receipt number you can quote if a payment is ever questioned. Keeping that receipt number tied to the right transaction — instead of stranded on its own row after a line wrap — is one of the things a proper conversion gets right that a copy-paste doesn't.
Common snags with Westpac statements
- Wrapped description lines. Long payee and receipt-number lines get rejoined to the right transaction.
- Receipt numbers. These stay attached to their payment rather than being pushed onto a separate row.
- Business accounts. Westpac business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a Westpac statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
Where do I download my Westpac statement?keyboard_arrow_down
In Westpac Online Banking or the app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
Can I import it into Xero or MYOB?keyboard_arrow_down
Yes. Export an import-ready bank file and the transactions arrive as statement lines you reconcile as usual in Xero, MYOB or QuickBooks.
Are Osko and PayID payments handled?keyboard_arrow_down
Yes. They show in the description with their receipt number, and the converter keeps that number attached to the transaction it belongs to rather than dropping it onto a separate row.
Does it read scanned Westpac statements?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Online Banking will always convert faster and cleaner than a scan or photo.
