Convert Lloyds Bank statements to Excel and CSV
To convert a Lloyds Bank statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export every transaction with date, description, signed amount and running balance, in the same columns as statements from any other bank.
Not affiliated with Lloyds Bank. statement.work is an independent tool. Lloyds Bank is a trademark of its owner and is named here only to describe the statements this page is about.
About Lloyds Bank statements
Lloyds Bank is one of the UK’s largest high-street banks and part of Lloyds Banking Group, which also includes Halifax and Bank of Scotland. Lloyds serves a large number of personal and business customers, so its statements are a regular part of UK bookkeeping.
What the statements typically contain
- Account details (sort code and account number) and the statement period.
- An opening balance, and totals for money in and money out.
- A transaction table with date, description, type, money in, money out and balance.
- Short payment-type codes on many transactions, with a key on the statement.
Formats differ between personal and business accounts and change over time, so treat this as a guide.
Common conversion problems
- Payment type column. A separate type column (debit card, Faster Payment, direct debit and so on) is useful but shifts other values when copied as text. statement.work keeps the transaction and its amount together.
- Money in and money out columns. Two amount columns become one signed amount, so totals and pivots work.
- Statements from several group brands. A client may have a Lloyds business account and a Halifax personal account. They look different but should end up in the same columns.
- Multi-page balances. Balances repeated at page breaks are not transactions.
How to convert it
- Download the statement PDF from online banking, or use a scan or photo.
- Upload it to statement.work.
- Review each transaction’s date, description, amount, balance and category.
- Export to Excel or CSV.
- Check the closing balance.
Using payment types for categories
Payment types are a strong hint for categorization. Direct debits are mostly recurring bills, card payments are day-to-day spending, and Faster Payments in are often customer receipts. For another UK bank with type codes, see HSBC UK.
Questions
Are Lloyds and Halifax statements the same?
Both brands belong to Lloyds Banking Group, but they are separate brands with their own statements. statement.work doesn't rely on templates, so both convert to the same columns.
What do codes like FPO and DEB mean?
Codes like these indicate the payment type. For example, FPO and FPI usually mean a Faster Payment out or in, DEB a debit card payment, and DD a direct debit. Check the key on your statement for the exact list.
Is statement.work affiliated with Lloyds Bank?
No. statement.work is independent and is not affiliated with or endorsed by Lloyds Bank or Lloyds Banking Group.