If you process client bank statements, you already know the pain: every UK bank formats statements differently. HSBC uses DR/CR indicators with multi-line descriptions. Barclays splits Money In and Money Out into separate columns. Monzo exports 17-column CSVs.
This guide catalogues the major UK bank statement formats — their column layouts, quirks, and what trips up generic converters. Use it as a reference when processing statements from unfamiliar banks.
Quick Reference: UK Bank Statement Formats
| Bank | Column Layout | Date Format | Common Issue |
|---|---|---|---|
| HSBC | Single amount + DR/CR indicator | DD MMM YYYY | Multi-line descriptions wrap across rows |
| Barclays | Separate Money In / Money Out | DD/MM/YYYY | Year omitted on continuation pages |
| Lloyds | Single Payment/Receipt + type codes | DD MMM YY | Transactions split across page breaks |
| NatWest | Separate Paid In / Paid Out | DD/MM/YYYY | Long references overflow into amounts |
| Santander | Two-column Debit/Credit | DD/MM/YYYY | Cashback entries confused with refunds |
| Monzo | Single Amount + categories | DD/MM/YYYY | 17-column CSV includes pot transfers |
| Starling | Single Amount + categories | DD/MM/YYYY | Spaces/goals transfers mixed in |
| Halifax | Similar to Lloyds (same group) | DD MMM YY | Header layout differs from Lloyds |
Why Bank Formats Matter for Conversion
When converting PDF statements to Excel, the format determines accuracy. A generic PDF-to-Excel converter sees a grid of text — it doesn't know that HSBC wraps descriptions across two rows, or that Lloyds places the balance brought forward as the first transaction row, or that Monzo pot transfers should be excluded from main account totals.
This is why bank-specific parsers outperform generic ones. BankScan AI has format-specific rules for each UK bank, so it knows to combine multi-line HSBC descriptions, separate Barclays' Money In/Out columns properly, and filter Monzo's internal pot transfers.
HSBC: The Trickiest UK Format
HSBC statements are consistently the most requested conversion format, and for good reason — they're the hardest to parse correctly. Transaction descriptions frequently wrap across two rows, transaction codes (BGC, TFR, DD, SO) are embedded before descriptions, and the running balance resets at the top of each page in multi-page statements. Older HSBC statements (pre-2018) use a completely different layout, adding another layer of complexity.
Barclays: Dual-Column Simplicity
Barclays uses a clean layout with separate Money In and Money Out columns — but the date column sometimes omits the year on continuation pages, and business account statements include a separate charges page that needs to be processed independently. The dual-column format means you need to combine the columns into a single Amount field for most accounting software imports.
Monzo: Digital-First, Data-Heavy
Monzo statements are relatively clean but can export up to 17 columns in CSV format — most of which (category, merchant ID, notes, receipt references) aren't needed for bookkeeping. The real challenge is filtering out internal pot transfers (savings pot deposits and withdrawals) that inflate totals if not excluded.
The Solution: Bank-Aware AI Conversion
BankScan AI understands each UK bank's format natively. It knows which rows are transactions vs headers, which columns contain amounts vs metadata, and how to handle bank-specific quirks. The result: a clean Excel file with Date, Description, Amount, and Balance — regardless of which UK bank produced the original PDF.
Convert Any UK Bank Statement — Format Doesn't Matter
HSBC, Barclays, Lloyds, NatWest, Monzo, Starling — all handled automatically. Try free.
Try Free Now →Last updated: 8 May 2026. Statement formats checked against current bank PDFs as of this date.