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-09-10

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. Date ordering is the single most common source of silent conversion errors — 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

  • Traces its origins to a London goldsmith-banking partnership established in 1690, making it one of the oldest banking names still in use anywhere in the world
  • 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
  • Payment type abbreviations: BP, DD, SO, ATM, VIS, CR, TFR — useful for category mapping

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

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free