Barclays UK Bank Statement Explained: Anatomy and Layout Quirks
What every section of a Barclays UK statement means - and the four layout quirks (3-letter transaction codes, Money In/Money Out columns, sort code + account number, UK date and currency format) that distinguish Barclays from US bank statements.
Barclays UK statements pack a lot of information into a clean visual layout. Three-letter transaction codes (CPC for card purchase, DD for direct debit, SO for standing order) replace the verbose ALL-CAPS descriptors common on US bank statements. Plain-English "Money In" and "Money Out" column headers replace Withdrawals/Deposits. And the UK convention of sort code + account number, DD/MM dates, and pound sterling all apply.
This guide explains the Barclays UK statement structure and four layout quirks.
Want to use this guide on your blog? Copy this embed code:
The 12 Universal Sections (and How Barclays UK Labels Them)
For the universal anatomy reference, see Understanding Bank Statement Formats. Barclays UK uses all 12 sections with UK conventions.
| Universal section | Barclays UK label |
|---|---|
| Bank header | "Barclays Bank UK PLC" with the eagle logo |
| Statement period | "Statement period" |
| Account holder block | Name and address |
| Account number | 8-digit account number (Quirk 3) |
| Routing | "Sort code" (6-digit) - NOT routing (Quirk 3) |
| Account summary | "Summary" with Opening balance, Money in, Money out, Closing balance |
| Transaction headers | Date, Description, Money in, Money out, Balance (Quirk 2) |
| Transaction rows | Type prefixes (CPC, DD, SO, FP, BAC, ATM) (Quirk 1) |
| Check images | Rare in UK (most payments are electronic) |
| Fees + interest | "Charges" and "Interest" |
| Daily balance summary | "Running balance" per row |
| Disclosure | "Important information" - FCA-mandated |
Quirk 1: Three-Letter Transaction Codes
Barclays uses concise transaction codes:
| Code | Meaning |
|---|---|
| CPC | Card Payment / Chip and PIN |
| DD | Direct Debit |
| SO | Standing Order |
| FP | Faster Payment |
| BAC | BACS Payment (UK ACH equivalent) |
| CHQ | Cheque |
| ATM | ATM withdrawal |
| TFR | Transfer (internal) |
| TX | Tax (HMRC payment) |
| CR | Credit transfer (generic incoming) |
The code appears at the end of each transaction description:
Date Description Money Out Money In Balance
03/01/26 SALARY FP 3,200.00 8,632.10
05/01/26 TESCO CPC 47.99 8,584.11
08/01/26 COUNCIL TAX DD 180.00 8,404.11
10/01/26 RENT SO 1,200.00 7,204.11Why this matters:
- For categorization: the code tells you the payment method, which often maps to a category (CPC = retail, DD = subscriptions, SO = rent/regular obligations)
- For parsing: PDFSub extracts the code as a separate transaction-type field
Quirk 2: "Money In" / "Money Out" Column Headers
Like PNC in the US, Barclays uses customer-friendly column headers:
Date Description Money In Money Out Balance
03/01/26 SALARY FP 3,200.00 8,632.10
05/01/26 TESCO CPC 47.99 8,584.11The columns are mutually exclusive (a transaction populates ONE of the two), and the running balance appears in the rightmost column.
Why Barclays does this: UK consumer banking strongly emphasizes accessibility. "Money In" and "Money Out" are unambiguous; "Credits" and "Debits" are accounting jargon.
For parsing: Recognize the column pair as a single signed amount (positive for Money In, negative for Money Out).
Quirk 3: Sort Code + 8-Digit Account Number
Like all UK banks, Barclays uses sort code + account number instead of ABA routing:
Account details
Sort code: 20-00-00 (specific to the Barclays branch/area)
Account number: 12345678 (the specific account)
IBAN: GB29 BARC 2000 00 12345678
BIC/SWIFT: BARCGB22Sort code reading: UK sort codes are typically formatted as three pairs separated by hyphens (20-00-00). The first 2 digits identify the bank (Barclays is generally 20-xx-xx), and the last 4 identify the branch/area.
Why this matters:
- Bank transfers within the UK use sort code + account number
- International transfers use IBAN
- Direct Debits and Standing Orders authenticate against sort code + account number
For accounting imports, the sort code+account combo replaces the US routing+account pair.
Quirk 4: UK Locale (DD/MM Dates, £ Currency, Same Number Format)
Barclays statements use UK locale conventions:
- Dates: DD/MM/YYYY (e.g.,
03/01/26= 3 January 2026, not 1 March 2026) - Currency: GBP / £ (pound sterling)
- Thousands separator: comma (
1,234.56- same as US) - Decimal separator: period (
1,234.56- same as US)
Note that UK shares US number formatting (1,234.56) - unlike continental Europe where comma is the decimal and period is the thousands separator (1.234,56). The MAIN UK-specific gotcha is the date order.
Why this matters: For automated imports, the locale must be set to UK so dates parse correctly. PDFSub auto-detects the locale from the bank template (Barclays UK = UK).
Where to Download Barclays UK Statements
- Sign in at barclays.co.uk
- Select the account -> Statements and documents
- Pick the statement period -> Download PDF
Barclays UK keeps up to 7 years of statements available online.
Converting to Excel, QBO, or Xero
- Process multi-currency bank statements - if you have GBP + USD/EUR mix
- QBO vs CSV vs OFX - format choice for accounting import
Xero is the most popular accounting platform for UK SMBs; Barclays statements convert cleanly to OFX for Xero. PDFSub recognizes all 4 Barclays UK quirks: 3-letter transaction codes are extracted as a separate category field, Money In/Out columns map to a signed amount, sort codes are preserved separately from account numbers, and the UK locale (DD/MM, £) is applied automatically.
Bank-Specific Variations to Compare
- HSBC UK bank statement explained (UK)
- Chase bank statement explained (US)
- Bank of America bank statement explained (US)
- Wells Fargo bank statement explained (US)
Barclays and HSBC UK are the two UK banks most commonly encountered by US-based accountants serving expat clients. They share the same UK conventions (sort code, DR/CR or Money In/Out, DD/MM dates, £) but have different transaction-code vocabularies. Worth learning both.