Bank by bank conversion guides

Every bank exports a slightly different CSV. These guides cover what each bank's export looks like, which columns to map, and the specific thing most likely to break your import. The converter itself is free and runs entirely in your browser.

Open the converter

New Zealand

ANZ

Signed amount column, date sits late in the row.

ASB

FastNet export with payee and memo split out.

Westpac

Amount layout varies by account type.

BNZ

Rich narrative fields, maps well to Xero.

Kiwibank

Separate credit and debit columns plus a balance.

Australia

CommBank

NetBank exports with no header row at all.

ANZ Australia

Headerless or minimal-header exports, day-first dates.

NAB

Wide export with extra category columns.

Westpac Australia

Separate debit and credit columns.

United Kingdom

Barclays

Signed amount, memo split across fields.

HSBC UK

Often exports with no header row.

Lloyds

Separate debit and credit amount columns.

Monzo

Very wide export, most columns are noise.

Bank not listed? The converter works with any CSV. Auto-detection handles most files, and you can assign every column by hand when it does not. Try it with your export.
© 2026 StatementShift · Converter · Xero guide · QuickBooks guide