Banks

Convert Lloyds Bank Statements to Excel

Convert Lloyds Bank statement PDFs to Excel and CSV, with the payment type codes in a column of their own and every balance checked. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your Lloyds Bank statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.

What a Lloyds statement looks like

  • A current Lloyds statement has six columns: Date, Description, Type, Money In (£), Money Out (£) and Balance (£).
  • An older layout heads them Date, Pmnt, Details, Money Out, Money In and Balance, with money out before money in. Your spreadsheet keeps each layout's own order.
  • The Type column holds a short code, such as DEB for a debit card payment, FPI for a Faster Payment in or DD for a Direct Debit. What each code means.
  • Every row has its own date, written like 02 Jan 24, and its own balance.

What your spreadsheet looks like

We keep the Type code in a column of its own, so you can filter the spreadsheet by it: every Direct Debit, or every card payment.

Date Description Type Money In (£) Money Out (£) Balance (£) Ledger
06 Mar 24 SUPERMARKET DEB 56.18 1,283.82 ok
06 Mar 24 A FRIEND FPI 25.00 1,308.82 ok
07 Mar 24 MOBILE NETWORK DD 18.00 1,290.82 ok
08 Mar 24 MONTHLY FEE CHG 3.00 1,287.82 ok

The rows above are an example, not a real statement.

How we test it

We test against five Lloyds statements, in both layouts: 225 transactions in all. 221 of them balance against the row before. The Ledger column flags the other 4, so you know which rows to check.

Convert a Lloyds statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.