⇄ StatementShift

Convert a Westpac Australia CSV for Xero or QuickBooks

Westpac Australia commonly exports money out and money in as two separate columns. Xero wants the opposite: one column where money out is negative. Flatten that by hand and it is very easy to end up with a file where every transaction reads as income.

Exporting from Westpac Online Banking

Open the account, go to the transaction list, set your date range and export as CSV. Westpac also offers OFX and QIF on some accounts, which skip the conversion step if your software accepts them directly.

What the export looks like

Typically: account, date, a narrative or description field, a debit amount column, a credit amount column, running balance, and sometimes categories. Amounts in the debit and credit columns are usually unsigned. Dates are day-first.

Convert it

1. Drop the file into the converter. Nothing leaves your computer.
2. Map the money out column to Debit and the money in column to Credit. Leave Amount as (none). The converter produces one signed amount from the pair.
3. Map the narrative field to Description, and leave balance unmapped.
4. Set Dates in file to DD/MM/YYYY, check the preview, then download.