Lloyds Bank · United Kingdom

Lloyds Bank Statement to Excel, CSV & Xero | AI Bank Statement

Lloyds gives you PDF statements in Internet Banking and the app, which holds at least 10 years of them. Business customers can also export transactions as CSV or QIF. Here's how to get each, and how to turn any Lloyds PDF statement into clean Excel, CSV, Xero or QuickBooks data.

Last reviewed 14 October 2026

At a glance

Official statement format
PDF, from Internet Banking and the Lloyds app
Statements in the app
At least 10 years
Spreadsheet export
CSV or QIF for business (Online for Business); a 12-month midata history for personal current accounts
Paper copies
Order in Internet Banking or the app; arrive within 10 working days
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

How to download a Lloyds PDF statement

In Internet Banking (personal)

  1. Log in and select Statement options from your account page.
  2. Choose to print or download the statement, or order a paper copy.

In the Lloyds app (personal)

  1. Log in, select the account and open the three-dot menu.
  2. Select Download or print statement.
  3. Choose the month and year, then save, print or email the PDF from your device.

The app gives immediate access to at least 10 years of statements, so you rarely need to order paper copies for older periods.

In Online for Business

Online for Business has had a refreshed design since June 2026, so you may see either layout:

  • New layout: select Transactions under the account, then Statement options › Monthly PDFs.
  • Original layout: Statement options › Monthly PDFs.

Exporting Lloyds transactions

Business (Online for Business)

  • New layout: Statement options › Export transactions (CSV, QIF).
  • Original layout: View statement next to the account, then Statement options › Export transactions (CSV, QIF).

Personal: midata

Your midata file is a 12-month transaction history of your personal current account. In online banking, select More Actions next to the current account, expand Account Services, select Midata Export, choose the account and select Start download.

When exports aren't enough

  • You need a statement period, not a search. Exports don't carry the statement's opening and closing balances, which is what reconciliation checks against.
  • You need more than 12 months. midata covers 12 months; your PDF statements in the app go back at least 10 years.
  • You only have the PDFs. Accountants and bookkeepers often get statements from clients as PDFs, without access to their banking.

Converting a Lloyds PDF statement

Pasting a PDF statement into Excel usually merges columns and splits descriptions across rows. AI Bank Statement reads the statement as laid out:

  1. Upload one or more Lloyds PDF statements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. Download one transaction per row, with date, description, money out, money in and balance in separate columns.

Dates stay day-first and amounts stay in pounds.

Getting Lloyds data into Xero or QuickBooks

When a bank feed is missing a period, or you're catching up a client's books from PDFs:

  • Xero: choose Xero CSV, then import it as a bank statement for the matching account.
  • QuickBooks: choose the 3- or 4-column CSV that matches your import settings, then upload it from file.

Lloyds credit card statements convert the same way with the credit card statement converter.

Choose your output format

Frequently asked questions

How far back can I get Lloyds statements?

Lloyds says its mobile app gives immediate access to at least 10 years of statements. Business documents in the paper-free Digital Inbox are available for 10 years.

Can I export Lloyds transactions as CSV?

Business customers can, in Online for Business: Statement options, then Export transactions (CSV, QIF). Personal customers can download a midata file, a 12-month transaction history of their current account. For a full statement period, convert the PDF statement.

How often does Lloyds send statements?

Lloyds usually sends a statement every month you make payments from your account, and always sends one at least once a year.

I need a paper Lloyds statement. How long does it take?

You can order one in Internet Banking (Statement options) or the app (three-dot menu, Order paper statements). Lloyds says it arrives within 10 working days. If you just need the data, downloading the PDF and converting it is faster.

Can I import a converted Lloyds statement into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV as the output, then use the statement import option in your accounting software.

Is it safe to upload a Lloyds statement?

Statements show your sort code, account number and transaction history. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Stop retyping statements by hand

Upload a PDF and download clean Excel, CSV, Xero or QuickBooks data in about 30 seconds.