Convert Lloyds Bank Bank Statement to Excel
Lloyds statements list Date, Payment type (DEB, DD, FPI, FPO, SO, TFR and friends), Details, Money out, Money in, and Balance. The payment-type column is a categorization shortcut — FPI/FPO distinguish inbound and outbound Faster Payments, DEB marks debit-card spend — and the converter keeps those codes with each row. The two money columns are mapped to Debit and Credit and validated against the printed balance so column drift cannot silently corrupt the data.
Download statements in Internet Banking: choose the account, open Statements, and use the PDF download option (Lloyds keeps up to 7 years). Everything runs client-side in your browser. For bookkeepers preparing VAT returns or year-end accounts from Lloyds statements, the Excel output lands with debits, credits, and a totals row ready to tie back to the statement summary.
Drop your Lloyds Bank statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
Lloyds Bank statement FAQ
How do I download a Lloyds statement PDF?
Log in to Lloyds Internet Banking, select the account, open Statements, choose the period, and download as PDF. Up to around 7 years of statements are available online.
What happens to Lloyds payment-type codes like FPI and DEB?
They stay at the start of the Description cell. FPI (Faster Payment in) rows will show in Credit, FPO and DEB rows in Debit — so type codes and amount direction stay consistent.
Can I convert Halifax or Bank of Scotland statements here too?
They share Lloyds Banking Group infrastructure and very similar layouts, so they generally convert fine — but see the dedicated Halifax page for specifics on that brand’s statement quirks.