UK Bank Statement Converter

ClearlyLedger converts UK bank statement PDFs from Barclays, HSBC UK, Lloyds, NatWest, Santander, Halifax, Nationwide, Monzo, Starling and Revolut into clean Excel and CSV. It handles day-first dates, Faster Payments, Direct Debits, standing orders, card references and grouped transaction rows before balance verification.

Last updated 2026-10-26

United Kingdom banks ClearlyLedger converts

ClearlyLedger ships dedicated statement profiles for 10 United Kingdom banks. Each profile expects the layout that bank actually prints, rather than treating every PDF as a generic table.

Bank Date format Currency Typical length
BarclaysDD MMM YY£ GBP4–20 pages
HSBC UKDD MMM YY£ GBP4–18 pages
Lloyds BankDD MMM YY£ GBP4–18 pages
NatWestDD MMM YYYY£ GBP3–10 pages
Santander UKDD/MM/YYYY£ GBP3–8 pages
MonzoDD MMM YYYY£ GBP5–25 pages — Monzo statements are verbose with every contactless tap as a separate row
Starling BankDD MMM YYYY£ GBP3–15 pages
Revolut UKDD MMM YYYY£ GBP5–30 pages depending on currency and crypto activity
HalifaxDD MMM YY£ GBP3–10 pages
Nationwide Building SocietyDD MMM YYYY£ GBP3–10 pages

Statement conventions in United Kingdom

United Kingdom statements in our profile set use DD MMM YY, DD MMM YYYY, DD/MM/YYYY date ordering and are denominated in £ GBP. Check ambiguous transaction dates carefully: a DD MMM YY statement read as US ordering produces plausible-looking but wrong dates for every day below the thirteenth of the month, which is why the United Kingdom profiles pin the order rather than inferring it per row.

Layout quirks these profiles handle

  • Installed the world's first cash-dispensing ATM in Enfield, north London, in 1967, a milestone widely credited to Barclays specifically
  • Money out / Money in columns instead of Debit / Credit
  • Description includes payee plus reference on a single line
  • Direct debit and standing order types embedded in description
  • HSBC UK Bank plc has operated as a legally separate, ring-fenced entity from HSBC's investment banking arm since 2019 UK ring-fencing rules took effect, so retail statement branding and terms reference 'HSBC UK' specifically, not the wider HSBC Group
  • HSBC's global headquarters moved from Hong Kong to London in 1993, following the Group's acquisition of Midland Bank, one of the UK's largest high-street banks at the time

Importing into United Kingdom accounting tools

Export to CSV and import into Xero, QuickBooks, Sage or FreeAgent — the tools United Kingdom bookkeepers most often run. Amounts and dates are normalised on export so the column mapping in the import wizard resolves without hand-editing.

Conversions are processed in memory, are never used to train AI models, and the workflow is built to align with UK GDPR and the Data Protection Act 2018 for United Kingdom account holders.

Related ClearlyLedger resources

Loading interactive converter… Try ClearlyLedger free