Convert a Lloyds Bank statement to Excel

Lloyds Internet Banking can export recent transactions, but its limits make the PDF statement the practical source for anything longer.

Not every Lloyds Bank statement layout has been tested, so try one statement free and check the balance result before you convert a batch. RowBalance is an independent product of Forclev LLC and is not affiliated with, endorsed or sponsored by Lloyds Bank. Lloyds Bank is a trademark of its owner, named only to describe statement compatibility.

Try a sample statement first, nothing to upload and no pages used:

Sample data: the US checking sample from Summit National Bank. Try it with the US checking (PDF) button.

Balanced Opening $5,234.10 + transactions = closing $14,670.88, the closing balance on the statement.

Opening
$5,234.10
Money in
$12,978.51
Money out
$3,541.73
Closing (statement)
$14,670.88
Closing (computed)
$14,670.88
Difference
$0.00

Downloading the PDF

In Internet Banking on desktop, select the account, open the account menu, choose to download or print a statement and pick the period. Several years of statements are kept online.

The CSV export is limited

The transaction export is desktop-only and covers a limited recent window with a capped number of rows per file (reported as 12 months and 150 transactions; confirm current limits with Lloyds). For a full year, converting the monthly PDFs is more reliable.

Layout notes

Lloyds statements typically use Date, Description, Type, In, Out and Balance columns, where Type is a short code such as DD or FPI. RowBalance keeps the description together, reads UK dates and checks the running balance.

How to do it

  1. Download the Lloyds PDF statements.
  2. Drop them above and check the balance badges.
  3. Export Excel or CSV, or OFX, QBO and Xero CSV on a paid plan.

Excel and CSV are free for up to 5 pages a day, or 10 with a free account. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.

Questions

How do I export a full year of Lloyds transactions?

Download the twelve monthly PDFs and convert them in a batch on a paid plan, merging into one file.

Is RowBalance affiliated with Lloyds?

No. Lloyds Bank is a trademark of Lloyds Banking Group, used only to describe compatibility.

Related guides