HSBC UK Bank Statement Explained: Anatomy and Layout Quirks
What every section of an HSBC UK statement means - and the four layout quirks (sort code + account number instead of routing, DR/CR markers, UK date format DD/MM, multi-currency accounts) that distinguish UK bank statements from US ones.
HSBC UK statements look quite different from US bank statements - and that's not surprising, given UK banking conventions evolved separately. Sort codes replace routing numbers. DR/CR markers replace plus/minus signs. Dates appear DD/MM/YYYY instead of MM/DD/YYYY. And HSBC's global reach means many customers have multi-currency accounts that hold GBP, USD, EUR, and HKD all on one statement.
This guide explains the HSBC UK statement structure and the four quirks that distinguish UK bank statements from their US cousins.
Want to use this guide on your blog? Copy this embed code:
The 12 Universal Sections (and How HSBC UK Labels Them)
For the universal anatomy reference, see Understanding Bank Statement Formats. HSBC UK uses all 12 sections with UK conventions.
| Universal section | HSBC UK label |
|---|---|
| Bank header | "HSBC UK Bank plc" with the red hexagon logo |
| Statement period | "Statement period" |
| Account holder block | Name and address |
| Account number | 8-digit account number (Quirk 1) |
| Routing | "Sort code" (6-digit) - NOT routing (Quirk 1) |
| Account summary | "Summary" with Opening balance, Money in, Money out, Closing balance |
| Transaction headers | Date, Description, Amount, DR/CR (Quirk 2) |
| Transaction rows | One per posting; DD/MM date format (Quirk 3) |
| Check images | Less common in UK (most payments are electronic) |
| Fees + interest | "Fees" and "Interest paid" |
| Daily balance summary | "Balance after transaction" per row |
| Disclosure | "Important information" - FCA-mandated |
Quirk 1: Sort Code Replaces Routing Number
UK banks identify accounts using sort code (a 6-digit number identifying the bank/branch) and account number (an 8-digit number identifying the specific account). The US ABA routing number does not exist.
HSBC UK Account Details
Sort code: 40-22-26
Account number: 12345678
IBAN: GB29 HBUK 4022 26 12345678
BIC/SWIFT: HBUKGB4BFor international transfers, the IBAN (International Bank Account Number) combines country, bank, sort code, and account number into one 22-character identifier.
Why this matters for parsing:
- Tools built for US ABA routing numbers will fail to extract sort codes correctly (different format, different position)
- For accounting imports, QuickBooks/Xero require different fields for UK accounts than US ones (routing vs sort code/IBAN)
- IBAN is the most useful identifier for international reconciliation
Quirk 2: DR / CR Markers Instead of Plus / Minus
UK bank statements use single amount columns with DR (debit) / CR (credit) markers:
Date Description Amount DR/CR
03/01/26 SALARY 3,200.00 CR
05/01/26 TESCO STORES 47.99 DR
08/01/26 FASTER PAY OUT 500.00 DRWhere US banks would show:
- Negative number with
-sign, OR - Number in parentheses
(), OR - Two separate columns (Withdrawals/Deposits, Subtractions/Additions, etc.)
UK banks show: single column, sign indicated by trailing DR or CR marker.
Why this matters for parsing: Tools expecting a signed numeric column will read "3,200.00 CR" as just "3,200.00" and miss the credit indicator. The DR/CR marker is the sign in UK statements.
Quirk 3: UK Date Format (DD/MM/YYYY)
UK bank statements use DD/MM/YYYY date format:
03/01/2026 means 3 January 2026 (the third of January)US format would be:
01/03/2026 means 3 January 2026 in the US (the third of January)The result LOOKS the same in this example but the digit order is different. For ambiguous dates (days 1-12), this causes data corruption.
Example of the danger:
- UK statement:
05/06/2026= 5 June 2026 - US tool parsing: reads as 6 May 2026
If a UK statement is imported into a tool configured for US dates, transactions land in the wrong month - which only becomes obvious during reconciliation.
PDFSub auto-detects the locale from the bank template (HSBC UK = UK locale = DD/MM dates) and normalizes correctly.
Quirk 4: Multi-Currency Accounts (HSBC Premier and Global Money)
HSBC's global account products let one customer hold balances in multiple currencies on the same account number. A single statement may show:
HSBC CURRENCY ACCOUNT
GBP £5,420.00
USD $8,250.00
EUR €3,180.00
HKD HK$12,500.00Each currency has its own transaction list, summary, and balance. This is unique to HSBC and a few other globally-oriented banks (Citibank, Barclays International).
Why this matters:
- For accountants with expat clients, the multi-currency account is the source of most reconciliation complexity
- Each currency's transactions need to be exported and converted to the client's reporting currency at the appropriate date-of-transaction rate
- HSBC's PDF includes the FX rate at the statement date but not necessarily transaction-date rates
PDFSub recognizes HSBC multi-currency accounts and lets you export each currency separately for downstream FX conversion in Excel.
Where to Download HSBC UK Statements
- Sign in at hsbc.co.uk
- Select the account -> Statements
- Pick the statement period -> Download PDF
HSBC UK keeps 6 years of statements (UK regulatory minimum for retail accounts; business accounts may have longer retention).
Converting to Excel, QBO, or Xero
- Convert HSBC bank statements to Excel - the conversion workflow
- Process multi-currency bank statements - especially relevant for HSBC global accounts
- QBO vs CSV vs OFX - format choice for accounting import
Xero is the most popular accounting platform in the UK; HSBC UK statements convert cleanly to OFX for Xero import. PDFSub recognizes all 4 HSBC UK quirks: sort codes are preserved as a separate field, DR/CR markers are mapped to signed amounts, dates are parsed as DD/MM, and multi-currency accounts are split by currency.
Bank-Specific Variations to Compare
- Chase bank statement explained (US)
- Bank of America bank statement explained (US)
- Wells Fargo bank statement explained (US)
- Barclays UK bank statement explained (UK)
HSBC UK is the most internationally-oriented UK bank. If you're working with an expat client who has both US and UK accounts, the date-format and column-structure differences are the most common source of reconciliation errors - knowing them upfront saves hours.