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. Whether you bank in branch or online, the statement is the same monthly PDF, downloaded from Internet Banking or the mobile app, under Statements.
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.
Currency stays GBP (pounds) and the DD/MM/YYYY dates carry straight through, exactly as they appear on the statement. Even a photographed page converts — OCR pulls the columns out, and the reconciliation check runs regardless of how the PDF was made.
From there it's a normal QuickBooks import: the heavy lifting of reading the PDF is already done.
Why people convert Lloyds to QuickBooks
QuickBooks bank feeds can miss older periods, and a Lloyds feed connection sometimes drops or never covered the months you need. Converting the PDF gives you a file to upload for exactly those gaps, so the history is complete before you reconcile.
For anyone reconciling Lloyds against QuickBooks after the fact, the value is in not retyping. You keep the original PDF as your source, convert it, and reconcile the imported lines — the figures stay tied back to the statement.
Import a Lloyds statement into QuickBooks
QuickBooks Online takes a CSV; QuickBooks Desktop takes a .qbo Web Connect file.
- Convert the PDF above. For QuickBooks Online download the QuickBooks CSV; for Desktop download the QBO.
- QuickBooks Online: Banking → Bank transactions → Link account → Upload from file.
- Pick the CSV, map Date / Description / Amount, choose the account, and import.
- QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then select the .qbo.
infoOne honest caveat
The QBO file carries a placeholder bank id, so QuickBooks Desktop can reject it with an OL-301 error ("not a participating financial institution") until you set your own bank's id. For a reliable import, use the QuickBooks CSV in QuickBooks Online instead — we don't claim the QBO will import everywhere.
The totals are checked first
Every file is reconciled first: opening balance plus money in, minus money out, should land on the closing balance. If it doesn't, you see it here instead of finding out inside QuickBooks.
Frequently asked questions
Will the Lloyds file import into QuickBooks?expand_more
In QuickBooks Online the CSV imports cleanly under Banking → Upload from file. The Desktop QBO can hit an OL-301 error ("not a participating financial institution") until you set your own bank's id — so for Online, stick with the CSV.
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 QuickBooks-ready file imports into QuickBooks 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.
Can I use a photo of my Lloyds statement?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 QuickBooks file needs a free sign-in.