Convert Lloyds statements to Excel & CSV
Turn Lloyds Bank plc PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your Lloyds statement is never uploaded.
Drop Lloyds bank statement PDFs here
or choose files · multiple files OK · scanned PDFs & photos supported
Select PDF statements- 🔒 Never uploaded
- ∞ Free & unlimited
- ✓ Balance-checked
- Your PDF never leaves your device
- Unlimited pages, no signup
- Works offline
- Every row balance-checked
Lloyds statement format at a glance
Date, Description, Type, Money In, Money Out and Balance columns, with the Type column holding a short code such as DEB, DD, FPO or BGC.
| Bank | Lloyds Bank plc |
|---|---|
| Country | United Kingdom |
| Currency | GBP |
| Typical date format | DD MMM YY |
| Statements supported | Current account, Savings, Credit card, Business account |
| Export to | Excel, CSV, Xero, QuickBooks, FreeAgent, Sage, OFX, QIF, JSON |
How to download your Lloyds statement as a PDF
- Log on to Lloyds Internet Banking or open the Lloyds app.
- Choose the account, then look for its statements option.
- Pick the statement period you need — older statements may sit in a separate archive or documents area.
- Download the PDF version of the statement.
Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.
Tips for converting Lloyds statements
- The Type column is ready-made categorisation: DEB is a debit card payment, DD a Direct Debit, SO a standing order, FPI and FPO are Faster Payments in and out, BGC a Bank Giro Credit and CPT a cash machine withdrawal. Keep it as its own column in Excel.
- On many Lloyds statement designs Money In sits to the left of Money Out — the reverse of several other banks. If you map columns by hand in an import wizard, double-check which is which.
- Because every row carries a running balance, swapped in/out columns show up immediately: a whole run of highlighted rows in the balance check usually means the columns were read the wrong way round, not that dozens of amounts are wrong.
Helpful guides
- PDF statement to Excel: every method compared
- Import Lloyds transactions into QuickBooks
- Import Lloyds statements into Xero
- Reconcile a bank statement in Excel
How the conversion stays accurate
When your Lloyds statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.
Lloyds statement conversion FAQ
What do DEB, FPI, FPO and BGC mean on my Lloyds statement?
They are transaction types. DEB is a debit card purchase, FPI an incoming Faster Payment, FPO an outgoing Faster Payment and BGC a Bank Giro Credit (often salary or benefits). DD, SO and CPT mean Direct Debit, standing order and cash machine withdrawal.
Can I convert a statement I downloaded from the Lloyds app?
Yes, as long as it is the PDF statement the app produces rather than a screenshot. Screenshots and photos can still be read with on-device OCR, but a genuine PDF statement is faster and far more accurate.
Is it safe to convert my Lloyds statement here?
Yes. Your Lloyds PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.
Can I convert Lloyds credit card statements too?
Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.
Other banks in United Kingdom
Convert your Lloyds statement now
Free, unlimited and private. No signup, no upload, no catch.
Choose PDF statements