Does it handle the Money in / Money out split correctly?

Yes. Each block is parsed independently, then merged into a single chronological stream sorted by posting date. The sum is validated against opening - closing balance, so any missed row surfaces as a mismatch rather than silently skewing the running total.

Will Club Lloyds reward credits show up?

Yes. Club Lloyds interest and reward payments land as their own transaction rows in Money in with 'Club Lloyds' preserved in Description. Summing those rows across a tax year gives your reward total without a separate lookup.

What about Lloyds Avios credit-card PDFs?

Yes. Avios Rewards cycle-based statements use the standard UK credit-card layout — merchant, category, and Avios earned per row are preserved in Description, and reconciliation runs against the printed new balance per cycle.

Can I convert Classic Account and Easy Saver together?

Drop up to 10 Lloyds PDFs mixing current account and savings in one upload — each parses independently and downloads as separate XLSX / CSV / QBO files in the same ZIP.

Convert your Lloyds statement to Excel

Classic Account, Club Lloyds, Platinum Account, and Lloyds credit-card statements. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

BankPDFtoXLS is an independent service. We are not affiliated with, endorsed by, or sponsored by Lloyds Bank plc. The name "Lloyds Bank plc" is used only to describe compatibility with statements you have legally obtained from your own account. See our trademarks policy.

Drag bank statement PDFs here

or click to browse · PDF · up to 50 MB each · max 25 per batch

How the Lloyds conversion works

1. Drop your Lloyds Bank plc PDF — digital or scanned, monthly statement or a combined multi-month export, up to 50 MB (or batch up to 25 files). Password-protected PDFs and image-only scans both work: scans go through vision OCR automatically.
2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

Inside a Lloyds statement: format details

Sections in the PDF

Account summary · Money in · Money out · Interest and charges

Transaction date format

DD MMM YY

Products we've parsed

Classic Account, Club Lloyds, Silver / Platinum / Club Lloyds Private Banking, Easy Saver / ISA Saver, Lloyds Avios Rewards, Lloyds Platinum credit card

Lloyds current-account statements split by direction into Money in / Money out blocks, with an Interest and charges footer. The parser merges the two blocks chronologically and validates the reconstructed running balance against the printed opening and closing balances. UK-standard DD MMM YY dates normalised to ISO on export.

Club Lloyds customers get additional benefits that show as interest or reward credits in the Money in block — these appear as their own transaction rows with 'Club Lloyds' in the Description, so filtering to see cumulative reward earnings is one spreadsheet operation.

Lloyds Avios Rewards and Platinum credit-card statements close on a cycle date and use the standard UK credit-card layout. These flow through the LLM path and reconcile against the printed new balance.

Which Lloyds statements work

We handle checking, savings, and credit-card PDFs from Lloyds Bank plc.

checking
savings
credit-card

Where Lloyds PDFs trip up manual conversion

Format-specific quirks that break naive PDF parsers — and how the reconciliation pipeline handles each one.

Club Lloyds reward conditions affect monthly interest tier

Club Lloyds pays a higher interest tier only on months you meet the qualifying-direct-debit minimum. The interest row at month-end reflects either the qualifying-tier rate or the base rate, but the statement header shows only the published APY range — not the rate actually applied. The parser tags each Club Lloyds interest row with the effective rate band in metadata so eligibility audits can be done against an external direct-debit log without manually reverse-calculating.

Standing Order block separated from Money out

Lloyds prints recurring Standing Orders in their own block at the bottom of the statement, separately from the Money out section that holds card payments and direct debits. Parsers that read only the Money out block miss every standing-order debit, breaking the running-balance reconciliation. The parser merges Standing Orders back into the chronological transaction stream by their printed payment date, while preserving a 'recurring payment' tag in metadata for budget-categorisation work.

Avios Rewards card statements close on cardholder anniversary

Lloyds Avios Rewards credit-card statements close on the cardholder's account-opening anniversary date rather than calendar month-end, so the cycle window shifts permanently for the life of the card. Tax-prep workflows that batch by calendar month produce gaps. The export keeps each statement's printed cycle dates in metadata and the QBO exporter uses the cycle-close date as the batch date so QuickBooks imports without duplicate-detection conflicts at year-end.

Questions we get most often

Does it handle the Money in / Money out split correctly?: Yes. Each block is parsed independently, then merged into a single chronological stream sorted by posting date. The sum is validated against opening - closing balance, so any missed row surfaces as a mismatch rather than silently skewing the running total.
Will Club Lloyds reward credits show up?: Yes. Club Lloyds interest and reward payments land as their own transaction rows in Money in with 'Club Lloyds' preserved in Description. Summing those rows across a tax year gives your reward total without a separate lookup.
What about Lloyds Avios credit-card PDFs?: Yes. Avios Rewards cycle-based statements use the standard UK credit-card layout — merchant, category, and Avios earned per row are preserved in Description, and reconciliation runs against the printed new balance per cycle.
Can I convert Classic Account and Easy Saver together?: Drop up to 10 Lloyds PDFs mixing current account and savings in one upload — each parses independently and downloads as separate XLSX / CSV / QBO files in the same ZIP.

Guides and engineering notes for Lloyds

Engineering notes

Why your bank statement balance doesn't match: 7 specific causes and how to track each one down

When the sum of transactions doesn't equal the printed ending balance, the cause is almost always one of seven specific patterns. A field guide to identifying which one you have, and what to do about each.

11 min read

Engineering notes

Password-protected bank statement PDFs: how to convert them safely without uploading the password to a stranger

Most banks ship encrypted statement PDFs by default. The conversion is easy when you have the password and impossible when you don't, but the part that matters most is what happens to the password during the conversion itself.

9 min read

Workflows that rely on Verified output

Most Lloyds statements that come through us are part of one of these workflows. Each link below explains how the reconciliation guarantee maps to that practice.

Forensic accountants

Discovery packets, multi-year tracing

Divorce attorneys

Opposing-counsel financial disclosure

Bookkeepers

Catch-up & bank-feed gaps

Scanned PDFs

Vision OCR + reconciliation

PDF to QBO

QuickBooks-ready OFX export

For QuickBooks workflows

Verified imports, no duplicates