Convert Lloyds Statement to CSV
Convert Lloyds Bank statement PDFs into CSV with structured fields for transaction date, description, money in, money out, and running balance. Works with personal current accounts, savings, and Lloyds business accounts.
Sample Lloyds CSV output
What's unusual about Lloyds statements
- Lloyds uses Money in and Money out columns rather than signed amounts — these map to
paid_inandpaid_out. - Transaction type codes include
DD,SO,CPT(Card Payment),TFR,BGC(Bank Giro Credit), andATM. - Multi-page statements use "Statement continued" headers that are stripped automatically.
- Opening balance and balance brought-forward rows are excluded from the transaction output.
How to download your Lloyds statement PDF
- Sign in to Lloyds Internet Banking or the Lloyds app.
- Select the account you want a statement for.
- Choose Statements and pick the period.
- Select Download as PDF (avoid printing and rescanning — the original PDF gives the cleanest conversion).
- Upload the PDF to StatementCSV and export as CSV or Excel.
Frequently asked questions
How do I download my Lloyds statement as a PDF?
Sign in to Lloyds Internet Banking, select the account, choose Statements, pick a date range, and select "Download as PDF". The Lloyds app also supports downloading statements.
Does StatementCSV handle Lloyds "Money in" and "Money out" columns?
Yes. Lloyds uses separate Money in and Money out columns rather than signed amounts. These map directly to paid_in and paid_out in the exported CSV.
Are Lloyds business and Commercial Banking statements supported?
Yes. Personal current accounts, savings, and Lloyds business accounts all convert with the same column structure.
Will the CSV include header metadata like sort code?
No. Sort code, account number, and branch address at the top of the statement are excluded. Your CSV contains only transaction rows.
Convert statements from other UK banks
Dedicated converters for the most common UK bank statement formats.