United Kingdom · GBP

Convert Lloyds Bank Bank Statements to Excel

Lloyds statements use a five-column layout — date, payment type, details, money out, money in — plus a balance column that only prints at day boundaries. Payment type codes (DEB, FPI, DD, TFR) classify each row. The converter fills balances, normalizes dates and splits amounts cleanly.

Drop your bank statement here

PDF, JPG or PNG · up to 25 MB

No signup required · Files deleted after processing · How files are handled

Works with statements from 1,000+ banks

How Lloyds statements are structured

Payment type column (DEB, FPI, FPO, DD, TFR, SO)
Balance printed at day boundaries only
DD MMM YY dates
Business statements append a summary of charges

Fields extracted

ISO-normalized date
Payment type + details combined into a searchable description
Money out / money in mapped to debit / credit
Balance filled for every row

How to download a Lloyds statement

1Log on to Lloyds internet banking.
2Choose the account and open “Statements”.
3Select the month and download as PDF.
4Upload the PDF here to convert.

Common Lloyds conversion problems

Sparse balance column leaves most rows without a balance.

Balances are computed for every row and checked against the day-boundary figures.

Payment type codes are cryptic in raw exports.

Codes are preserved and can be used as an Excel filter column, with the full details kept alongside.

Example output

A converted Lloyds statement lands in these columns:

Date	Description	Debit	Credit	Balance
22 Jan 2026	DEB MARKS&SPENCER	£38.90	—	£2,204.66
23 Jan 2026	FPI ACME PAYROLL	—	£2,215.75	£4,420.41
24 Jan 2026	DD THAMES WATER	£46.00	—	£4,374.41

Lloyds Bank conversion FAQ

Are Halifax and Bank of Scotland statements the same format?

They are close relatives within Lloyds Banking Group with small differences; each is detected and parsed with its own rules.

Can I convert several months of Lloyds statements at once?

Yes — batch upload is available on paid plans, and each PDF is processed independently.

StatementConvert is an independent service and is not affiliated with, endorsed by, or sponsored by Lloyds Banking Group plc. Lloyds Bank trademarks belong to their respective owners.