Download your Lloyds Bank statement PDF and convert every transaction to a clean Excel or CSV file in seconds — HMRC, Xero, mortgage broker, and visa submissions all covered.
Go to lloydsbank.com and sign into Internet Banking
Click your current account, savings, or credit card account
Select "Statements" from the left-hand account menu
Choose the month and click Download PDF — no password needed
Lloyds Banking Group: Halifax and Bank of Scotland are part of Lloyds Banking Group and use identical statement formats. All three work with this converter without any changes.
| Section | What It Contains |
|---|---|
| Account Summary | Account holder name, sort code, account number (masked), statement period |
| Opening Balance | Balance at start of statement period |
| Transaction Table | Date | Transaction description | Money in | Money out | Balance |
| Faster Payments | Payee name and reference — "FPS OUT John Smith Ref: RENT" |
| Direct Debits | Company name and mandate reference |
| Closing Balance | Balance at end of statement period |
Here is a real example of how raw PDF bank statement text is transformed into a clean Excel file:
| Raw PDF → Clean Excel | |
|---|---|
| Raw PDF text (messy) | Clean Excel output |
| 15/06/2026 FASTER PAYMENT RECEIVED JOHN SMITH REF JUNE RENT 1,500.00 3,248.50 CR | Date: 2026-06-15 Description: Faster Payment Received — John Smith / June Rent Credit: 1500.00 Balance: 3248.50 |
| 18/06/2026 DIRECT DEBIT VIRGIN MEDIA DR 49.99 3,198.51 | Date: 2026-06-18 Description: Direct Debit — Virgin Media Debit: 49.99 Balance: 3198.51 |
| 22/06/2026 VIS PURCHASE TESCO STORES 4291 DR 67.43 3,131.08 | Date: 2026-06-22 Description: Visa Purchase — Tesco Stores 4291 Debit: 67.43 Balance: 3131.08 |
Dates standardised to YYYY-MM-DD. Currency symbols removed. Debit and Credit in separate columns. Ready for Xero, QuickBooks, HMRC, or Tally import.
Every major UK bank statement format is auto-detected. DD/MM/YYYY dates converted, sort codes preserved in narrations, £ GBP amounts as plain numbers — ready for Xero, Sage, or HMRC submission.
All major high-street bank PDFs supported. Faster Payments and BACS references preserved. Statements going back 7 years all work without any reformatting.
Digital bank PDF and CSV exports both accepted. Monzo statement PDFs and Starling statements auto-detected without manual column mapping.
Building society and challenger bank formats all covered. Nationwide FlexAccount, Halifax Clarity, First Direct 1st Account — all extract cleanly.
🇬🇧 UK use cases: HMRC Self-Assessment expense tracking • Xero & FreeAgent import • Mortgage broker cash-flow submission • UKVI visa bank evidence • Companies House annual accounts
→ Dedicated UK Bank Statement Converter
Whether you are in India or an NRI abroad using an Indian bank account, upload your PDF and get a clean Excel file instantly — HDFC password prompts handled automatically.
Private sector bank PDFs auto-detected. Password-protected HDFC statements unlocked with your DOB (DDMMYYYY). UPI reference IDs and NEFT/IMPS narrations fully extracted.
Public sector formats supported including YONO e-passbook and branch-printed statements. Indian number system (1,23,456.00) converted to standard Excel format.
UPI app statements and Google Pay transaction PDFs fully supported. Debit/credit directions correctly identified from narration text.
🇮🇳 India use cases: ITR filing & income proof • Tally Prime bank reconciliation • GST return verification • CA bookkeeping • Home loan & personal loan applications • Student visa fund proof
→ Dedicated Indian Bank Statement Converter
All major US bank statement PDFs auto-detected. MM/DD/YYYY dates standardised, $ USD amounts as plain numbers, single signed-amount columns split into Debit/Credit automatically.
All major US bank formats including 2024–2025 redesigned layouts. ACH, Zelle, and wire references preserved. Credit card statements also supported.
US neobank PDF and statement exports both handled. No manual column mapping — Date, Description, Debit, Credit, Balance all extracted automatically.
🇺🇸 US use cases: QuickBooks Online bank feed import • Schedule C expense categorisation • Mortgage underwriting cash-flow review • SBA loan 12-month cash flow • CPA bookkeeping