Convert a Lloyds Bank CSV for Xero or QuickBooks

Lloyds Bank UK · Internet Banking CSV export

Lloyds exports money out and money in as two separate unsigned columns. Xero and most other packages want a single signed column with money out negative, so this file always needs reshaping before it will import correctly.

Exporting from Lloyds internet banking

Open the account, use the statement download or export option, choose your date range and select CSV (the "Excel/CSV" option). Halifax and Bank of Scotland exports follow the same shape, so this guide applies to those too.

What the export looks like

Typically: transaction date, transaction type code, sort code, account number, transaction description, debit amount, credit amount, and running balance. Dates are UK day-first.

Field	Map it to
Transaction Date	Date
Debit Amount	Debit
Credit Amount	Credit
Transaction Description	Payee or Description
Transaction Type	Reference
Sort code, account number, balance	Leave unmapped

Convert it

Drop the file into the converter. Everything runs in your browser.
Leave Amount as (none) and set the two amount columns as Debit and Credit.
Set Dates in file to DD/MM/YYYY.
Check that spending shows as negative in the preview, then download.

Convert your Lloyds CSV free

Leave sort code and account number unmapped. They are identical on every row, so they add nothing to your books and it is better not to carry them into your accounting system at all.