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. The file you want is the official statement PDF from Internet Banking or the mobile app, under Statements, not a printed mini-statement or a transaction search.
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. That's exactly the detail that gets scrambled when you paste a PDF into a spreadsheet, and exactly what the converter preserves, column by column.
Dates come through as DD/MM/YYYY and the figures stay in GBP (pounds), so the converted file matches what you'd expect locally. A scanned statement is no problem; it's read with OCR into the same layout, with the balance checked either way.
You end up with a file Zoho Books accepts on the first try, with the PDF-wrangling taken care of before it gets there.
Why people convert Lloyds to Zoho Books
If you're reconciling a client's Lloyds account in Zoho Books, you'll hit months with no live feed. A converted CSV imports straight into Banking → Import Statement, so the gaps fill in without retyping.
It's handy mid-year too, not just at catch-up. A one-off Lloyds account, a statement the feed skipped, or a closed account you still need on file — convert the PDF and it goes into Zoho Books like any other import.
Import a Lloyds statement into Zoho Books
Zoho Books imports a CSV — there's no separate Zoho file, so you use the clean CSV.
- Convert the PDF above and download the CSV.
- In Zoho Books: Banking → pick the account → Import Statement.
- Upload the CSV and map Date / Description / Amount.
- Import, then categorise the lines.
The totals are checked first
Before the Zoho-ready CSV downloads, the running balance is checked end to end. A missing or doubled line is caught at this step, not after it's already in Zoho Books.
Frequently asked questions
Does Zoho Books need a special file?expand_more
No special file — Zoho Books imports a plain CSV, so you use the clean CSV from here. Go to Banking → your account → Import Statement, then map Date, Description and Amount. There's a preview before it commits, so you can check the columns matched before the lines post.
What does a Lloyds statement look like?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 Zoho-ready CSV imports into Zoho Books 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.
Do I need to pay or sign in?expand_more
Yes — the CSV downloads with no login and no charge to start.

