LL

Bank PDF to Excel or CSV

Lloyds business PDF to Excel or CSV

For Lloyds Online for Business: use its native CSV export when it covers your needs, or review a saved PDF transaction summary before converting.

Try 1 page free. No subscription required.

Lloyds Online for Business: CSV export or PDF summary

  1. Use Lloyds Online for Business for the business account you need to review. Check its transaction export option before converting a PDF.
  2. Lloyds' functionality guide lists CSV and QIF transaction exports with a maximum of 1,000 lines per export. Confirm the current on-screen options and split the date range if needed.
  3. For a PDF transaction summary, the guide points to the Statement Options menu. If that saved PDF is your starting document, preview its transaction rows here.

This guide is specifically for Online for Business, not Lloyds personal banking or Commercial Banking Online. Keep the bank's original document for reference. A transaction summary is not necessarily the same document as an issued statement.

Read Lloyds' Online for Business functionality guide (PDF) ·

Check exports before using them in bookkeeping

  • When splitting a long date range, check the first and last transaction in each file so you do not miss rows or count overlapping rows twice.
  • Confirm debit and credit direction, currency and date interpretation against the source. Check opening and closing balances where the PDF includes them.
  • Use the native CSV when it meets your needs. For extracted PDF rows, review the preview and adapt the columns to your accounting import.

Fictional Lloyds business PDF review example

An invented £2,000.00 opening balance, a £180.40 payment and a £350.25 receipt produce £2,169.85. These rows are synthetic; they are not a Lloyds layout, customer document or bank compatibility test. Possible ExtractoCSV columns with comma delimiters, decimal points and ISO dates. Your PDF may contain different fields. Review the actual preview before downloading more pages.

Date,Description,Reference,Debit,Credit,Balance
2026-11-02,Materials purchase,EXAMPLE-L1,180.40,,1819.60
2026-11-03,Invoice receipt,EXAMPLE-L2,,350.25,2169.85

Convert any bank statement by format

Use the general converter when you want an immediate first-page preview instead of a guide for Lloyds Bank business.

Bank statement PDF to Excel or CSV

How to convert your Lloyds Bank business statement

  1. 1

    Choose the saved Lloyds business PDF summary or statement containing the transaction rows you need.

  2. 2

    Upload the PDF to the public converter and compare the first-page preview with the original.

  3. 3

    Download CSV or XLSX, review amounts and dates, and map the columns before importing.

Does your statement have multiple pages?

The first PDF page is free to preview. Additional pages converted in ExtractoCSV use credits. The bank's native CSV export does not use ExtractoCSV credits.

Calculate price

Why convert your Lloyds Bank business statement?

Use ExtractoCSV when a saved business PDF is the only document you have and you need editable transaction rows. If you can download the required CSV directly from Lloyds, use it instead. A free first-page preview lets you check the extraction before converting more pages.

Frequently asked questions

Can Lloyds Online for Business export CSV transactions?

The bank's functionality guide documents CSV and QIF exports, with a listed limit of 1,000 lines per export. Check the current options for your account and use the native CSV when it meets your needs.

Where is the PDF transaction summary?

Lloyds' Online for Business guide lists the monthly PDF transaction summary under Statement Options. Check the document and period before converting its rows.

Does this cover Lloyds personal accounts?

No. This page covers Online for Business. Personal banking and Commercial Banking Online have separate instructions.

Do I need to pay ExtractoCSV for Lloyds' native CSV?

No. ExtractoCSV's page credits apply to converting documents here, not to downloads from Lloyds. If you already have a usable CSV, you do not need PDF conversion.