Convert Lloyds statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, Sage files from the PDF.
Lloyds does not lock its statement PDFs, and neither do Halifax or Bank of Scotland, which share the same platform. Under 'Statement options' there is also 'Export transactions', which produces a CSV or QIF for a chosen period.
Drop your Lloyds statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in GBP.
Last updated
How to download a Lloyds statement as a PDF
- Log in to Lloyds Internet Banking and click the account you want.
- Above the transaction list choose 'Statement options'.
- Choose the download option and pick the statement month from the list.
- Use the download icon above the transactions (or your browser's save option) to save the PDF.
- In the Lloyds app: open the account, tap the three-dot menu, choose 'Download or print statement', pick the month and save it. The app gives you at least ten years of statements, which is more than most banks.
Then drop the file above; several months of Lloyds statements at once come back as one workbook.
Is the Lloyds PDF password-protected?
Lloyds does not lock its statement PDFs, and neither do Halifax or Bank of Scotland, which share the same platform.
What Lloyds statements look like
Date, Payment type, Details, Money out, Money in, Balance; also covers Halifax and Bank of Scotland layouts.
A Lloyds statement opens with 'Balance brought forward' and closes with 'Balance carried forward', and those two lines are the check figures for the whole month. Columns are Date, Payment type, Details, Money out, Money in, Balance, with a balance printed on every transaction line. Payment type is a three-letter code: DEB for debit card, FPO and FPI for Faster Payments out and in, DD, SO, TFR, BGC for bank giro credit, CHG for charges. Dates run as 03 Mar 26. Halifax and Bank of Scotland statements are the same table with a different logo, and the three are handled by the same reader.
Why not use Lloyds's own export?
Under 'Statement options' there is also 'Export transactions', which produces a CSV or QIF for a chosen period. The period is limited to about three months per file and the export lists transactions only: no opening balance, no running balance, and the type column (DEB, FPO, DD and so on) is separate from the description. It is fine for a quick look at recent spend. For year-end work, or for anything past the export window, the monthly PDF gives you the same rows with the balances attached and the dates in the statement's own format.
Where Lloyds statements trip up converters
- "Balance brought forward" and "carried forward" rows are used as opening/closing balances, not as transactions.
Which software Lloyds customers import into
Lloyds customers most often import into Xero, QuickBooks Online, Sage, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Lloyds questions
Should 'Balance brought forward' and 'Balance carried forward' appear as transactions in Excel?
No. Those two lines have no amount in Money out or Money in; they are the opening and closing balances. stmtai uses them to verify the month and writes them into the summary section of the sheet rather than into the transaction rows, so they will not be imported as bogus entries into your accounts package.
I bank with Halifax. Do I use the Lloyds converter?
Yes. Halifax, Bank of Scotland and Lloyds statements are produced by the same system and share the Date, Payment type, Details, Money out, Money in, Balance layout. Upload any of them here and the output will be the same shape.
What does the Lloyds 'Payment type' column turn into?
The code (DEB, FPO, DD, SO, TFR, BGC, CHG) is placed at the start of the description so it survives the import. If you want it in its own column, Text to Columns on the first space in Excel splits it off in one step, and the suggested category column already does most of the sorting the code was for.
How do I convert a Lloyds statement PDF to Excel?
Download it from Lloyds using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many Lloyds statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.