Lloyds Bank statement from PDF to Excel
Drop your Lloyds Bank statement PDF and download the transactions in Excel, CSV, QBO (QuickBooks) or OFX. It is converted in your browser: the PDF is not uploaded anywhere.
Tested with real Lloyds statements
Tested with two real Lloyds Bank statements published by public bodies. In both, the opening balance plus the transactions gives the closing balance printed by the bank.
How to convert a Lloyds statement to Excel
- Download the statement as a PDF from Lloyds online banking. It has to be the PDF the bank generates, not a photo or a scan.
- Drop it on the converter. The transactions show on screen in a few seconds.
- Look at the balance check: if the opening balance plus the transactions gives the bank’s closing balance, the whole statement was read.
- Download the file in Excel, CSV, QBO or OFX.
What you get in Excel
One row per transaction with the date, the description, the signed amount and the balance. Dates and amounts are real dates and numbers, not text, so you can sum, filter and sort straight away. For bookkeeping software there is a QBO file for QuickBooks and an OFX file.
What to know about Lloyds statements
- Lloyds “accessible” PDFs end every cell with a full stop, as in “45.00.”. Those are removed so the amounts are real numbers.
- Rows such as “STATEMENT OPENING BALANCE” and “BROUGHT FORWARD” are treated as balances, not as transactions.
Your statement stays on your computer
The PDF is read inside your browser. It is not uploaded, it is not stored and nobody else sees it. How that works.
What it costs
Viewing the transactions and checking the balances is free, and you can download 3 statements a month without paying. For more, there is a 7-day pass for £8 and a plan for £16 a month. See pricing.
Other banks
Chase Wells Fargo U.S. Bank TD Bank HSBC NatWest All tested banks
Private Statement Converter is not affiliated with Lloyds Bank. Names and trademarks belong to their owners.
Trying it with your Lloyds statement costs nothing.
Convert a statement