Convert a Barclays CSV for Xero or QuickBooks

Barclays UK · Online Banking CSV export

Barclays gives you a reasonably tidy CSV with a single signed amount, which is a good start. The friction is elsewhere: the descriptive text is spread across more than one field, and the account identifier column travels along for the ride.

Exporting from Barclays online banking

Open the account, find the statement or transaction download option, choose your date range and pick CSV. Barclays also offers QIF and OFX formats; if your accounting software takes OFX directly, that route skips conversion entirely.

What the export looks like

Typically a row number, the date, an account identifier, a signed amount (money out negative), a subcategory such as the payment method, and a memo holding the payee text. Dates are UK day-first.

Field	Map it to
Date	Date
Amount	Amount
Memo	Payee or Description
Subcategory	Description or Reference
Number, Account	Leave unmapped

Convert it

Drop the file into the converter. It is read in your browser and never uploaded.
Set Dates in file to DD/MM/YYYY and keep Output dates as DD/MM/YYYY for a UK Xero organisation.
If you are exporting OFX, set the currency to GBP.
Check the preview and download.

Convert your Barclays CSV free