Guides · Lloyds
Lloyds splits money in and money out into two columns.
Most exports use one signed column and let a minus sign carry the meaning. Lloyds does not: Debit Amount and Credit Amount are separate fields, and only one of them is ever filled.
The file
Transaction Date, Transaction Description, Debit Amount, Credit Amount, Balance.
Two columns, not one signed figure
Debit Amount and Credit Amount. Direction is structural rather than a minus sign, which removes the single most common import error before it can happen.
A row with neither is skipped
If both columns are empty the row carries no money and is not imported — heading and summary rows do not become £0.00 transactions.
Balance is read when present
A running balance on each row makes checking a closing figure straightforward.
Transaction Date, spelled out
Not just “Date”. Along with the two amount columns it is how a Lloyds file is recognised.
Why this shape is safer
The sign error cannot happen here.
On a single signed column, reading the convention backwards turns every expense in the year into income. The books still balance — debits and credits are equal and opposite either way — so nothing downstream notices, and the trial balance describes a business that made money it never made. With separate Debit and Credit columns there is no sign to misread: the column a figure sits in is the direction. It is the one format where that whole class of error is designed out rather than guarded against.
FAQ
Lloyds exports, in practice.
Which column means money out?
Debit Amount. Credit Amount is money in. Only one is populated on any given row.
What if both columns have a figure?
That is not a shape Lloyds produces. A row is read as a debit when the debit column carries a value, otherwise as a credit.
Does Halifax or Bank of Scotland export the same way?
They are Lloyds-family shapes and read cleanly by column name — Halifax uses Debit / Credit. They import today without a dedicated parser.
Is the description usable for rules?
Yes. Transaction Description is the field rules match against, and it is a single consistent column rather than being split across payee and memo.
Are the dates UK order?
Yes — 05/01/2025 is 5 January.
More formats
What the other exports look like.
Founding firms · 20 of 25 places left
Help shape the tool you’d want to use.
We’re taking our first firms as founding members. You get a direct hand in what Entrio becomes — and lock in founding-member pricing for as long as you stay. 33% off, locked for as long as you stay. Best suited to firms who like sharpening the tools they work with.
Tell us what your firm actually needs. What fits real practice gets built.
Talk to the person building Entrio — not a ticket queue.
Founding firms get first response when something needs fixing or explaining.
Keep your founding rate for as long as you stay — it never expires, never rises.
Import a Lloyds export and see the trial balance it makes.
Fourteen days free. No card. A sample client is waiting when you sign up — before any real client data goes near it.