UK
Drop a Lloyds statement PDF into the converter and you get every transaction back as clean rows — dates, descriptions, money out, money in and the running balance — with the closing balance checked against the maths before you download. No copy-paste, no fixing wrapped text.
If you've tried selecting the text in a Lloyds PDF and pasting it into Excel, you already know why that fails: the columns collapse, the payment codes end up glued to the descriptions, and the balance shifts a row out of place. This page covers how a Lloyds statement is actually laid out, where to download one, and how to get the figures into a spreadsheet or your accounts.
Where to download your Lloyds statement
You can get a PDF from either Internet Banking or the mobile app, and both go back about seven years.
- Internet Banking: sign in at lloydsbank.com, pick the account, and open Statements. Choose the period and select Download (PDF) rather than the on-screen view.
- Mobile app: open the account, tap Statements, choose a month, then Download or Share the PDF.
A statement pulled this way is a proper digital PDF, so the text is selectable and conversion is clean. If someone has scanned or photographed a paper statement instead, the converter runs OCR on it — that just takes a little longer.
What a Lloyds statement looks like
Lloyds uses a five-column layout that trips up most generic converters:
Column | What's in it |
|---|---|
Date | `DD Mon YY`, e.g. `03 Apr 24` — and it only prints once per day, so several rows can share one date |
Payment type and details | A short code followed by the description |
Money out | Debits |
Money in | Credits |
Balance | The running balance after that transaction |
The bit people miss is the payment-type code at the front of each description. Lloyds abbreviates how the money moved, and those codes carry real meaning when you're categorising later:
- DEB — debit card payment
- FPI / FPO — Faster Payment in / out
- DD — Direct Debit
- SO — Standing Order
- TFR — transfer between your own accounts
- BGC — Bank Giro Credit (often salary or a refund paid in)
- CSH — cash withdrawal
Because these sit inside the description column, a plain PDF export smears them into the payee name. The converter keeps the code and the description together, on the right row, so a payment reads as one clean line instead of two half-lines.
Getting the numbers into Excel or your accounts
Once it's read the statement, you can take it wherever you keep your books:
- Excel or Google Sheets — a tidy `.xlsx` or CSV with real numbers you can sum and filter, one row per transaction.
- Xero or QuickBooks — an import-ready bank feed file, so the lines come in as statement lines you reconcile normally.
- Tally, Zoho and others — the same clean data in the format each one expects.
Every figure is checked before you download: opening balance plus money in, minus money out, has to equal the closing balance. Anything that doesn't tie out is flagged rather than quietly passed through — which matters most with Lloyds statements that run to several pages, where a single missed line would throw the whole month.
Common snags with Lloyds statements
- Long descriptions wrap onto two lines. A card payment to a shop with a long name can spill over; the converter joins it back into one entry.
- Dates that only appear once. Since the date isn't repeated for every row, each transaction still gets its correct date rather than a blank.
- Joint and multiple accounts. If your PDF covers more than one account, each keeps its own opening and closing balance so nothing gets merged by mistake.
- Halifax and Bank of Scotland look similar. They're all Lloyds Banking Group, so their statements share this layout — the same conversion works for those too.
Frequently asked questions
Can I convert a Lloyds statement to Excel for free?keyboard_arrow_down
Yes. You can convert a Lloyds statement to a clean Excel or CSV file free to start, with the totals checked so the import lines up first time.
What do the codes like DEB and FPO on my Lloyds statement mean?keyboard_arrow_down
They describe how the money moved: DEB is a debit-card payment, FPI and FPO are Faster Payments in and out, DD is a Direct Debit, SO is a Standing Order, TFR is a transfer, and BGC is a Bank Giro Credit. The converter keeps them attached to the right transaction.
Does it work on a scanned or photographed Lloyds statement?keyboard_arrow_down
Yes. If the PDF is a scan rather than a download from online banking, the converter reads it with OCR. A statement downloaded straight from Internet Banking will always be cleaner and faster.
Will it work for Halifax or Bank of Scotland statements?keyboard_arrow_down
Yes. All three are part of Lloyds Banking Group and use the same statement layout, so the same converter handles them.
