UK
About Lloyds statements
Lloyds is one of the big four UK high-street banks and part of Lloyds Banking Group, which also runs Halifax and Bank of Scotland. You grab the statement PDF from Internet Banking or the mobile app, under Statements — same as you would for any branch-based account.
It helps to know how the statement is put together. Lloyds prints a short payment-type code at the start of each line — DEB for a debit card, FPI and FPO for Faster Payments in and out, DD, SO and BGC — and shows the date only once per day. A plain PDF export flattens that structure; the converter keeps each piece in its own column.
You keep GBP (pounds) amounts and DD/MM/YYYY dates end to end, so nothing needs re-checking after the import. Scanned or photographed PDFs work too: OCR reads them into the same columns, and the running balance is checked before anything downloads.
You end up with a file Xero accepts on the first try, with the PDF-wrangling taken care of before it gets there.
Why people convert Lloyds to Xero
If you're catching up a set of books in Xero, or onboarding a client, you'll have Lloyds PDFs that never came through a feed. Converting them gives you an Import a Statement file for each gap, so the history lines up without manual entry.
It also saves the back-and-forth at year end. Instead of asking a client for a CSV their Lloyds login may not even offer, you take the PDF they already have and convert it, so the numbers in Xero match the statement line for line.
Import a Lloyds statement into Xero
Xero takes the CSV through its own Import a Statement screen.
- Convert the PDF above and download the Xero CSV.
- In Xero: Accounting → Bank accounts.
- Open the account, then Manage account → Import a statement.
- Upload the CSV — the date, description and amount columns line up.
- Reconcile the imported lines as usual.
The totals are checked first
The totals are checked before you download. If a row is missing, the statement gets flagged right here — so a gap shows up before it reaches Xero or your client, not after.
Frequently asked questions
Does the CSV go straight into Xero?expand_more
Yes — the CSV goes in through Xero's Import a Statement screen and the date, description and amount columns line up, so you go straight to reconciling. If Xero asks you to confirm the column mapping the first time, save it and later imports remember the layout.
How is a Lloyds statement laid out?expand_more
Lloyds prints a short payment-type code at the start of each line — DEB for a debit card, FPI and FPO for Faster Payments in and out, DD, SO and BGC — and shows the date only once per day. The converter reads each of those into its own column, so the Xero-ready CSV imports into Xero cleanly.
Where do I download the Lloyds statement?expand_more
From Internet Banking or the mobile app, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
What if my Lloyds PDF is just a scan?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Is it free?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the Xero file needs a free sign-in.