Bank Statement Kit logo Bank Statement Kit Convert PDF
Lloyds Bank

Convert your Lloyds Bank statement to CSV or Excel

Upload your Lloyds Bank statement and get a clean, structured spreadsheet in seconds.

Upload your Lloyds Bank PDF PDF up to 20MB or 50 pages

First conversion free · No sign-up needed · PDF never stored

Balance-checked

Every conversion is reconciled against the statement's own printed totals.

Processed in memory

Your PDF is parsed and discarded. It is never written to disk.

Up to 50 pages

Handles multi-month statements up to 50 pages or 20MB per upload.

How it works

  1. STEP 1

    Upload the PDF

    Drop in the statement. Password-protected files are unlocked with the password you supply.

  2. STEP 2

    Rows are extracted

    Dates, descriptions, amounts and running balance are read into the seven standard columns.

  3. STEP 3

    Download the CSV

    Open it in Excel, Google Sheets, QuickBooks or Xero.

Built for the quirks of Lloyds Bank statements

A Lloyds statement carries a real Payment type column, separate from the description — a short code identifying the payment method (DEB for a debit card purchase, DD for a Direct Debit, TFR for a transfer, FPO and FPI for faster payments out and in, BGC for a bank giro credit, CPT for a cash machine withdrawal, SO for a standing order, CHQ for a cheque) while the details column carries the payee. That separation is genuinely useful and it is the first thing generic converters lose, collapsing two columns into one and mangling both. Money out and money in sit in their own columns rather than as one signed figure, so direction is carried purely by horizontal position. Lloyds keeps statements online for seven years, and ten in the mobile app, which means the PDFs people actually convert are often years old and produced by an older statement template than the one on screen today.

What the output looks like

Seven standard columns VERIFIED
DateNarrationReferenceValue DateDebitCreditBalance
01/04/2025Opening balance01/04/202512,480.00
03/04/2025Card payment - groceryREF4482103/04/202564.2012,415.80
07/04/2025Salary creditREF4490307/04/20253,200.0015,615.80
12/04/2025Standing order - rentREF4501012/04/2025950.0014,665.80

Illustrative rows. Every conversion is checked so that opening + credits − debits = closing.

Your statement stays yours

Never stored

The PDF is processed in memory and discarded when the conversion finishes.

Proven, not guessed

Output is labelled VERIFIED, DISCREPANCY or FAILED so you know what you got.

30-day history

Past conversions are kept for 30 days and you can delete them at any time.

Scans handled

Scanned or photographed statements fall back to OCR automatically.

Questions

Lloyds exports CSV for business accounts — does that cover me?

Only if you bank with Lloyds through Online for Business, which offers an export of transactions to CSV or QIF. Personal current account customers generally get statement PDFs plus the option to print or order a paper copy, so a personal statement usually reaches a spreadsheet by conversion rather than export.

My Lloyds statement is from several years ago. Will it still convert?

It should. Lloyds keeps statements available for around seven years online and further back in the app, so old PDFs are common, and they were produced by older statement templates. The layout is read from the page itself rather than from a stored per-bank recipe, so a 2018 template is treated on its own terms.

How do I know nothing was dropped from my Lloyds statement?

Every conversion is reconciled against the figures Lloyds printed — the balance chain through the transactions and the opening and closing balances for the period. The result is labelled VERIFIED, DISCREPANCY or FAILED, and a DISCREPANCY points at the exact row where the numbers stop agreeing.

Try it on your next statement

Your first conversion is free — no account needed. Pro is /month for high-volume, month-end work.

Convert your Lloyds Bank statement

Prefer the long version? Read the full Lloyds Bank statement to CSV guide, including Lloyds Bank's own export options.

Convert another bank's statement

BarclaysStatement to CSV →HSBCStatement to CSV →NatWestStatement to CSV →All banksBrowse every supported bank →