Lloyds Bank Statement to CSV: A Practical Guide

You need Lloyds transactions in a spreadsheet and they need to be accurate — every standing order, every card payment, every credit in the right direction. It is usually a Self Assessment return, a mortgage or remortgage file wanting several months of statements, a rental application, or a year of the account heading to a bookkeeper.

Whether Lloyds will just hand you a data file depends on which side of the bank you are on. Business customers have an export. Personal customers mostly have PDFs. This post covers both, the Lloyds-specific layout traits that break generic converters, and how to prove the CSV matches the statement.

Quick answer

There are two ways to get Lloyds transactions into CSV.

1. Lloyds' own export — mainly on the business side. In Online for Business you can select Statement options and then Export transactions (CSV, QIF), either from the statement options menu or after selecting View statement next to the account. That gives you a data file you can import into accounting software directly.
2. Convert the PDF statement. Personal current account customers generally get a statement PDF, with options to print, download or order a paper copy. Add closed accounts, old periods and statements sent by someone else, and the PDF is the common case. Upload it to a converter like BankStatementKit, which reads the rows out and balance-checks them against the statement's own printed figures.

Rule of thumb: business customer with a live login and the right date range, take the export. Personal customer, old statement, or someone else's document, convert the PDF.

Turn a Lloyds PDF into a verified CSV

Option 1: Lloyds' built-in statement download and export

1. Personal, in the app: log in, open the account, and select Statement options. From there you can print, download or order a paper copy of the statement.
2. Personal, in Internet Banking: open the account's statements and choose the period you want. Statements are available for seven years online, and the mobile app goes back ten.
3. Business, in Online for Business: select Statement options, then Export transactions (CSV, QIF). Alternatively select View statement next to the account, then Statement options, then Export transactions (CSV, QIF).
4. Credit cards: a Lloyds credit card statement is requested as a PDF — through online chat or downloaded in the app.

The asymmetry in that list is the thing to notice: the documented CSV export is a Business feature. On a personal account the statement is the artefact you get, so a personal statement reaches a spreadsheet by conversion rather than by export.

Where the built-in download stops

• The export is a business feature. If you are a personal customer, the CSV and QIF route in Online for Business is not a menu you have.
• Credit card statements are PDFs by request. There is no equivalent transaction export, so a credit card year is a stack of documents.
• Closed accounts have no login. Switched away, closed, or a joint account you have come off — you have whatever PDFs were saved.
• Statements someone sent you are documents. Accountants, brokers and letting agents receive PDFs and never get an export button.
• QIF is a legacy format. Plenty of modern tools want CSV, so a QIF export often means another conversion step anyway.

Every one of those cases ends in the same place: a PDF.

Option 2: Convert the Lloyds PDF statement to CSV

1. Open the PDF and check the account and period are the ones you need. If it was sent to you encrypted, have the password ready.
2. Upload it, entering the password if prompted — the file is decrypted in memory and never written to disk. Limits are 20MB or 50 pages, and a scanned or photographed statement falls back to OCR automatically.
3. Transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance. Lloyds' money-out and money-in figures map to Debit and Credit.
4. Check the verification label, then download the CSV.

Convert a Lloyds statement

Why Lloyds PDFs trip up generic converters

Payment type and description are separate fields. Lloyds identifies the payment method separately from the payee, which is helpful for categorising later and awkward to extract. A converter that flattens the page merges the two, so the type code ends up welded to the front of the description or, worse, is read as its own column of nonsense. Both columns have to be recognised as columns.

Money out and money in are two columns, not one signed number. Direction is carried entirely by which column a figure sits in. Lose the horizontal geometry and the converter guesses the sign, and a wrong guess turns a year of outgoings into income. This is the single most damaging failure mode on any UK statement layout, because the resulting file looks completely normal.

Old statements use old templates. Because Lloyds keeps statements for years, the PDFs people convert are frequently from a template that no longer matches what the bank issues today. A converter built around a hard-coded per-bank recipe fails on exactly the historic statements that matter for a seven-year tax enquiry. Reading the layout from the page rather than from the bank name is what keeps old statements working.

Prove the CSV matches the statement

A Lloyds statement gives you two independent checks.

1. The balance chain. Wherever a balance is printed against the transactions, the previous balance minus money out plus money in must equal it. One dropped, duplicated or mis-signed row breaks the chain at the point it went wrong, which is also where you look first. Note that some UK banks print a balance only against the last transaction of each day rather than on every row; if that is what your statement does, run the check day by day instead.
2. The opening and closing balances for the period. The statement states both. Opening balance, plus all money in, minus all money out, must equal the closing balance. If it does not, a row is missing or a sign is inverted.

By hand that is ten to fifteen minutes per statement, and multiplied across a mortgage file it is an afternoon. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy naming the row where the figures stop reconciling. For a shorter summary of the layout traits, see the Lloyds statement converter page.

FAQ

The bottom line

If you are on Online for Business with the right date range, use Lloyds' own CSV or QIF export — it is native and free. Personal customers, credit card statements, older periods and PDFs that arrived from someone else all go through conversion, and the conversion is worth proving. The separate Payment type column and the split money columns are precisely where a converter goes wrong without telling you.