AU
About Westpac statements
Westpac is one of Australia's big four banks and one of the oldest companies in the country. Whether you bank in branch or online, the statement is the same monthly PDF, downloaded from Westpac Online Banking or the app, under Statements.
The part a copy-paste can't handle is the layout. A Westpac statement carries Osko and PayID receipt numbers in the description, across Date, Description, Debit, Credit and Balance columns. The converter reads all of that into its own columns instead of losing it.
You keep AUD (Australian dollars) amounts and DD/MM/YYYY dates end to end, so nothing needs re-checking after the import. Even a photographed page converts — OCR pulls the columns out, and the reconciliation check runs regardless of how the PDF was made.
You end up with a file Xero accepts on the first try, with the PDF-wrangling taken care of before it gets there.
Why people convert Westpac to Xero
Xero's bank feeds don't always reach back as far as you need, and older Westpac months often aren't in the feed at all. Converting the statement PDF lets you bring those months in by hand, cleanly, instead of typing each line into the reconcile screen.
For anyone reconciling Westpac against Xero after the fact, the value is in not retyping. You keep the original PDF as your source, convert it, and reconcile the imported lines — the figures stay tied back to the statement.
Import a Westpac statement into Xero
Xero takes the CSV through its own Import a Statement screen.
- Convert the PDF above and download the Xero CSV.
- In Xero: Accounting → Bank accounts.
- Open the account, then Manage account → Import a statement.
- Upload the CSV — the date, description and amount columns line up.
- Reconcile the imported lines as usual.
The totals are checked first
Every file is reconciled first: opening balance plus money in, minus money out, should land on the closing balance. If it doesn't, you see it here instead of finding out inside Xero.
Frequently asked questions
How does a Westpac statement get into Xero?expand_more
Yes — the CSV goes in through Xero's Import a Statement screen and the date, description and amount columns line up, so you go straight to reconciling. If Xero asks you to confirm the column mapping the first time, save it and later imports remember the layout.
How is a Westpac statement laid out?expand_more
A Westpac statement carries Osko and PayID receipt numbers in the description, across Date, Description, Debit, Credit and Balance columns. The converter reads each of those into its own column, so the Xero-ready CSV imports into Xero cleanly.
Where do I download the Westpac statement?expand_more
From Westpac Online Banking or the app, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Does it work on a scanned Westpac statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Do I have to pay up front?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the Xero file needs a free sign-in.