Convert a CommBank CSV for Xero or QuickBooks

Commonwealth Bank of Australia · NetBank CSV export

CommBank's NetBank export is the single most common reason people end up hand-editing a CSV: it usually arrives with no header row at all. Accounting software sees the first transaction where it expects column names, and either rejects the file or silently eats a row.

Exporting from NetBank

Open the account in NetBank, use the transaction list or the export option, choose your date range and select CSV. There is also an OFX option on some account types, which you can import directly if your software accepts it; use this converter when you need CSV reshaped or want a consistent output.

What the export looks like

A CommBank CSV commonly has four unlabelled columns in this order: transaction date, signed amount (money out negative), description, and running balance. Dates are Australian day-first, so 03/04/2026 means 3 April.

Column	Map it to
1: date	Date
2: signed amount	Amount
3: description	Description (or Payee)
4: running balance	Leave unmapped

Convert it

Drop the file into the converter. It is read in your browser and never uploaded.
Set First row to Data, since there are no headers. Columns then appear as Column 1, Column 2 and so on.
Set Dates in file to DD/MM/YYYY so April is not read as March.
Check the preview, then download Xero CSV, QuickBooks CSV or OFX.

Convert your CommBank CSV free

The balance column trap: never map the running balance as Amount. If your imported figures look like account totals rather than individual transactions, that is what happened.