Lloyds is the UK's largest retail bank by current accounts. As a result, Lloyds bank statements are among the most common documents UK accountants and bookkeepers deal with. While Lloyds statements are relatively clean compared to HSBC, they have specific quirks that can cause conversion errors if you're not prepared.
Lloyds Bank Statement Format
Lloyds uses a single Payment/Receipt column with transaction type indicators and a running balance on the right. The format includes:
- Date: DD MMM YY format (e.g., 15 Jan 26)
- Description: Merchant name with transaction type prefix
- Type column: Transaction codes — DD (Direct Debit), SO (Standing Order), BGC (Bank Giro Credit), FPO (Faster Payment Out), FPI (Faster Payment In), DEB (Debit Card)
- Payment column: Money out (debits)
- Receipt column: Money in (credits)
- Balance: Running balance after each transaction
Common Lloyds Conversion Issues
1. Transactions Split Across Page Breaks
Lloyds multi-page statements sometimes split transactions across pages — the date and description on one page, the amount on the next. Generic converters treat the continuation as a separate transaction, creating phantom entries. You need to manually identify and merge split transactions, or use a bank-aware converter that handles this automatically.
2. Standing Order Descriptions Are Truncated
Lloyds truncates standing order descriptions to 18 characters. A standing order to "INSURANCE COMPANY LTD" becomes "INSURANCE COMPAN" — which can make reconciliation harder.
3. The Balance Brought Forward Row
The first row of every Lloyds statement shows the balance brought forward. This is not a transaction — it's an opening balance. Generic converters often mistake it for a transaction, creating an incorrect entry. This must be excluded from your transaction list.
4. Type Codes Embedded in Descriptions
Lloyds prepends transaction type codes (DD, SO, BGC) to descriptions. These need to be either stripped or preserved depending on your needs — but they should never be treated as part of the merchant name.
Halifax note: Halifax (part of Lloyds Banking Group) uses a similar format but with different header layouts and slightly different type code conventions. If you're processing both Lloyds and Halifax statements, be aware the formats are similar but not identical.
Three Ways to Convert Lloyds Statements to Excel
Method 1: Manual Copy-Paste
Open the PDF, copy the transaction table, paste into Excel. You'll need to manually fix merged cells, split transactions across pages, and remove the balance brought forward row. Time: 10-15 minutes per statement.
Method 2: Adobe Acrobat Export
Use Acrobat's Export PDF tool. Works reasonably well for Lloyds because the table layout is clean, but still misaligns transactions split across page breaks. Time: 5-8 minutes.
Method 3: AI-Powered Conversion
BankScan AI understands Lloyds' format natively — it strips type codes, merges split transactions, excludes the BBF row, and outputs a clean Excel with Date, Description, Amount, and Balance columns. Time: Under 30 seconds.
Convert Lloyds Statements in Seconds
Upload a Lloyds PDF, get a clean Excel spreadsheet. Handles type codes, page breaks, and BBF rows automatically.
Try Free Now →Last updated: 8 May 2026. Lloyds and Halifax are trademarks of Lloyds Banking Group plc.