BankPDFtoXLS turns a Lloyds Bank statement PDF into a spreadsheet with the columns the statement prints, and it checks 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. The 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 the spreadsheet looks like
The Type code stays 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
The converter is tested against five Lloyds statements, in both layouts: 229 transactions in all. 223 of them balance against the row before. The Ledger column marks the other 6 for you to check: 2 it filled in and 4 it flags.
Convert a Lloyds statement
- Upload the PDF on the home page.
- Check page one in the preview. It is free, with no email and no card.
- Create an account to convert every page. The pricing page lists the plans.
The PDF is deleted when its conversion finishes.
Other banks
- Convert HSBC Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
The converter reads other banks' statements too. See every supported bank.