How to Convert Westpac Bank Statements to Xero CSV (2026 Guide)
Upload your Westpac PDF statement to ReckonFlow and download a balance-verified CSV ready for Xero import. The Westpac parser handles both personal and business statement formats from Westpac Online Banking and Westpac One. Takes about 10 seconds per statement. Free for up to 30 statements per month.
Westpac Online Banking (CSV Export)
Westpac Online Banking allows you to export transactions directly to CSV. Heres how:
1. Log in to Westpac Online Banking at westpac.com.au
2. Go to Accounts and select the account you want to export
3. Click on "Statements" or "Transaction History"
4. Set your date range, you can export up to the last 7 years for most accounts
5. Look for the export option, it may be labelled "Download", "Export to CSV", or appear as a file icon
6. Choose CSV format if prompted. Some accounts also offer PDF or QIF
The exported CSV includes columns like Date, Transaction Details, Debit, Credit, and Balance. The date format is DD/MM/YYYY, which is standard for AU banks but not always compatible with Xero's expected format.
Westpac PDF Statements
If you only have PDF statements (common for paper-statement accounts or when a client sends you their statements), Westpacs portal may not offer a direct CSV export for older statement periods. In that case:
1. Download the PDF statement from Westpac Online Banking under the Statements tab
2. Open it to check its a full statement with all transaction rows visible
3. Use a PDF-to-CSV converter that understands Westpacs statement layout
Westpac PDFs use a different column layout than CBA or ANZ. The transaction description column is wider and sometimes wraps onto multiple lines. Generic PDF converters often merge these lines incorrectly, splitting a single transaction into two rows or dropping the description entirely.
Common Problems with Westpac CSV Exports
1. Date Format Mismatch
Westpac exports dates in DD/MM/YYYY format. If you open the CSV in Excel before importing to Xero, Excel may auto-convert these to MM/DD/YYYY. Xero expects YYYY-MM-DD. A date format mismatch is the most common reason a Westpac CSV import fails.
2. Debits and Credits in One Column
Some Westpac account types export all amounts in a single Amount column with debits shown as negative values (e.g. -150.00). Xeros CSV import expects separate Debit and Credit columns. If you import a single-column CSV, Xero may not recognize any entries.
3. Transaction Details Column Merges
Westpac combines the transaction description and reference number into one field. When Xero maps columns positionally, this merged field can push subsequent columns out of alignment. The data looks correct in Excel but the import produces wrong amounts.
4. Running Balance Column Interference
Westpacs CSV export includes a running balance column. Xeros CSV importer reads columns positionally and may interpret the balance column as an Amount column, which throws off every row after the first.
5. Statement PDFs Without a Corresponding Export
For older accounts or clients who receive paper statements, Westpac may only offer PDF format. These PDFs need dedicated parsing that understands Westpacs specific column layout, which differs from other AU banks.
How to Fix Westpac CSV Export Issues
For Date Formats
Open the CSV in a plain text editor (not Excel). Check that dates are in YYYY-MM-DD format. If they are DD/MM/YYYY, convert them before importing to Xero. Most AU bank statement tools handle this conversion automatically.
For Single-Column Debit/Credit
If your Westpac export has one Amount column with negative values for debits, you need to split it into separate Debit and Credit columns. In Excel you can use an IF formula, but a purpose-built converter does this automatically.
For Column Layout Problems
Xero imports CSV files positionally: it reads column 1 as Date, column 2 as Amount (or Debit, depending on the template). Westpacs column order may differ from what Xero expects, especially if the export includes extra columns like a running balance or reference number that Xero doesnt recognise. The fix is to rearrange columns or use a converter that handles Westpacs specific layout.
For PDF-Only Statements
If Westpac only offers PDF statements, you need a PDF-to-CSV converter that understands Westpacs statement format. Generic converters often fail on Westpac statements because the column layout (wider description field, different row spacing) differs from CBA and ANZ.
A Simpler Option: ReckonFlow
If the manual export-and-fix process sounds familiar, ReckonFlow handles all of these steps automatically:
- Upload a Westpac PDF or use the CSV you exported from Westpac Online Banking
- ReckonFlow identifies the Westpac format and maps columns correctly
- It splits debits and credits into separate columns
- It converts dates to Xero-compatible YYYY-MM-DD format
- It verifies the closing balance matches your statement before you import
Supported for Westpac Online Banking statements and Westpac PDF formats. Westpac One accounts are also supported. Free for 30 statements per month. With EOFY coming up on June 30, processing your Westpac statements now saves the rush later in the month.
Related Guides
- How to Convert CBA Bank Statements to Xero CSV: Commonwealth Bank export format explained
- How to Export ANZ Transactions to CSV: ANZ Internet Banking and ANZ Plus export guide
- Convert PDF Bank Statements to CSV: Australian Bank Guide: General guide covering all major AU banks
- Xero CSV Format Requirements: Column order, date format, and common import errors
---
Westpac column layout? Handled automatically
Upload your Westpac PDF and ReckonFlow maps the columns, extracts every transaction, and verifies the balance. No manual re-mapping needed.