How to export transactions from Westpac
In Westpac Online Banking, open the account and look for an Export option on the transactions page. Choose the date range and the CSV format. Business accounts with a Xero bank feed can use a file import to fill any gap before the feed started.
Menus change. Westpac updates its online banking from time to time, so the exact button names may differ from what's described here. If you can't find the option, search Westpac's help pages for “download transactions”.
What a Westpac CSV looks like
| Bank Account | Date | Narrative | Debit Amount | Credit Amount | Balance | Categories | Serial |
|---|---|---|---|---|---|---|---|
| 032000123456 | 05/01/2026 | EFTPOS PURCHASE WOOLWORTHS 1234 | 48.20 | 2451.80 | OTHER | ||
| 032000123456 | 06/01/2026 | DEPOSIT ACME PTY LTD SALARY | 1850.00 | 4301.80 | PAYMENT |
Dates are day-first (05/01/2026 is 5 January). Narrative is the description. Money out is in Debit Amount and money in in Credit Amount; the converter merges them into one signed amount with money out negative. Categories and Serial aren’t needed by Xero.
Common problems with Westpac files in Xero
- Two amount columns. Xero’s statement CSV expects one signed amount. The converter combines them.
- Dates read as US format. If the file is opened in a spreadsheet with US settings, 05/01/2026 can become 1 May. The converter reads Westpac dates day-first and writes DD/MM/YYYY for an Australian Xero organisation.
- Extra columns. Account number, categories and serial numbers are left out so Xero’s column matching is simple.
Import the converted file into Xero
- In Xero, go to Accounting → Bank accounts, find the account and choose Manage account → Import a statement.
- Upload the file. For an OFX file, Xero imports straight away. For a CSV, Xero asks you to match the columns: Date → Transaction Date, Amount → Transaction Amount, Payee → Payee, Description → Description.
- Check the preview Xero shows, complete the import, then reconcile as usual.
Our Xero import guide covers each screen and the messages you might see.
Frequently asked questions
Does it work for St.George, Bank of Melbourne or BankSA?
They belong to the Westpac group but may use a different export layout. Try the file: if a column isn’t recognised, you can choose it in step 2.
Which date format should I use for Xero in Australia?
DD/MM/YYYY. The converter picks it automatically for an Australian bank file.
Should I import CSV or OFX into Xero?
Either works. OFX needs no column matching; CSV lets you check the payee and description.
What is the Serial column?
A cheque or serial number for some transactions. Xero doesn’t need it, so it isn’t included.
Is my Westpac data uploaded?
No. The conversion happens in your browser and the file stays on your device.