How to export Lloyds statements (web & app)

You can export Lloyds transactions in a couple of minutes. On a laptop, sign in to Lloyds Online Banking, open the account you want, and choose a date range such as last 3, 6, or 12 months. Pick CSV for the most reliable results with this tool. On mobile, open the Lloyds app, go to the account, tap the menu or “Statements & documents”, then export. If you only see PDF, download it for your records and request CSV through the web. CSV gives you a simple table with columns like Date, Description, Paid out, Paid in, and Balance — exactly what this analyzer expects.

For best accuracy, export one account at a time. If you need to combine current account and credit card data, run the analyzer twice and merge the cleaned CSV files in a spreadsheet. You’ll keep account names in a separate column so you can filter later.

What this tool does

The Lloyds Statement Analyzer reads your CSV or OFX file in the browser and converts it into a clean, consistent dataset. It normalises dates to ISO format, turns Lloyds’ separate Paid out / Paid in columns into a signed amount, and auto-labels each line with a category such as Groceries, Eating Out, Transport, Bills, Subscriptions, or Income. It also estimates the merchant by cleaning up descriptors like AMZN Mktp UK or Netflix.com so you can see where the money really goes.

Once parsed, you’ll see totals for money in and money out, your net cashflow for the period, a table of top categories, and a detector for recurring charges. Recurring charges are flagged when the same merchant appears with a similar amount in at least three different months. It’s not perfect — some annual renewals won’t hit the threshold — but it’s a fast way to spot subscriptions and duplicate services.

Preset mapping for Lloyds CSV

Lloyds typically exports the following columns: Date, Description, Type, Paid out, Paid in, Balance. Dates are usually DD/MM/YYYY. The analyzer treats “Paid out” as a negative amount (Out) and “Paid in” as positive (In). If both appear on the same row, the tool uses whichever is non-empty. OFX files are supported too; we read DTPOSTED, TRNAMT, and NAME then convert them to the same clean format as CSV.

Categories you’ll see

Categories are rule-based and editable later if you download the CSV. We start with practical buckets: Income, Groceries, Eating Out, Transport, Shopping, Bills & Utilities, Rent & Mortgage, Entertainment, Travel, Health, Fees & Charges, Transfers, and Other. Keyword rules match common Lloyds descriptors so “TESCO” or “SAINSBURY” land in Groceries, “UBER” falls under Transport, “NETFLIX” shows up in Subscriptions, and so on. If a line doesn’t match a rule it’s tagged as Other; you can change that in the CSV and save your custom list for next time.

Cashflow, trends, and quick wins

The first number to look at is your net cashflow: money in minus money out over the period. If you run a 12-month export, you’ll spot seasonality: council tax spikes, holidays, or winter energy bills. Next, scan the Recurring table — it often reveals overlapping subscriptions or increases that slipped past you. Finally, sort the Transactions grid by Amount to see the largest debits; these are your quickest wins if you’re looking to free up cash without austerity budgeting.

Privacy, security, and good housekeeping

Your file never leaves the browser, and there is no server storage. If you’re using a shared computer, click Delete data after you’re done — it clears the in-memory dataset and the UI. For long-term record keeping, download the cleaned CSV and keep it with your annual files; it’s easier to search than PDFs. If your export is a scanned PDF, convert it to CSV in Lloyds Online Banking or ask the bank for a machine-readable copy.

FAQs

What’s next?

After exporting, try our UK paycheck & tax tools to plan your income, or our energy and cost-of-living calculators to benchmark household bills. Smart money decisions get easier when the numbers are all in one place.