HSBC Bank Statements Explained: Format, Layout & Transaction Codes

If you have ever opened an HSBC statement and wondered what BP, VIS or CR actually mean, why the balance column is blank on most rows, or why one payment seems to span three lines, you are not reading it wrong. HSBC statements pack a lot of structure into a dense layout, and that structure differs between HSBC UK, first direct, HSBC Business and HSBC Hong Kong.

This guide walks through an HSBC statement block by block: what every header field is, how the account summary works, what each transaction type code means, and what a composite statement is. At the end there is a practical section on getting the data out into Excel, CSV or QuickBooks without losing rows.

The three blocks of an HSBC UK statement

Almost every HSBC UK personal statement, whether it arrives as paper or as a PDF eStatement, is built from the same three blocks in the same order.

Block 1 — the identity header

The top of page one identifies the account. On a typical HSBC UK personal statement you will find:

• Account name — the name the account is registered in
• Sortcode — six digits in 40-XX-XX format. HSBC UK sort codes sit in the 40- range
• Account number — eight digits
• Sheet number — the sequential statement number, not the page number. Sheet 47 means this is the 47th statement issued on the account
• IBAN and BIC — the international identifiers, usually printed above or beside the sort code and account number
• Statement period — the "from" and "to" dates the statement covers

Block 2 — the account summary

Below the header sits a summary box. This is the page people mean when they search for the "HSBC summary page". It reconciles the whole period in four figures:

• Opening balance — the balance carried forward from the previous statement
• Payments in — total credits during the period
• Payments out — total debits during the period
• Closing balance — opening balance plus payments in, minus payments out

These four numbers are your fastest integrity check. If you export the statement to a spreadsheet, sum your extracted credits and debits and confirm they match this box exactly. If they do not, a row was dropped or a sign was flipped somewhere in the transaction list.

Block 3 — the transaction table

The transaction list uses five columns on personal statements:

Date | Payment type and details | Paid out | Paid in | Balance

HSBC Business Banking's online view labels the same information slightly differently — Date | Type | Description | Paid out | Paid in | Balance — and brackets the period with explicit BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD rows.

Dates on UK statements use DD/MM/YYYY. This matters more than it sounds: 04/07/2026 is 4 July, not 7 April. Spreadsheet software set to a US locale will silently reinterpret it.

HSBC transaction type codes, explained

HSBC prefixes each entry in the details column with a short code for the payment type. There is no cross-bank standard for these — Barclays and NatWest use different sets — so this list is specific to HSBC.

Payments going out

• BP — Bill Payment. A payment you made through online or telephone banking to a company or person. This is what most Faster Payments show up as.
• DD — Direct Debit. A company collects a variable amount from your account under a mandate you previously authorised. Also covers other BACS debits.
• SO — Standing Order. A fixed, regular payment you set up yourself to the same recipient.
• VIS — Visa debit card payment, processed through the Visa network. Most card purchases.
• ATM — Cash machine withdrawal.
• CHQ — Cheque. The cheque number is usually printed alongside.
• DR — Debit, and on a balance figure it indicates the account is overdrawn.
• MAE / CIR / SOL — Maestro, Cirrus and Solo card transactions. These are legacy card schemes and appear mainly on older statements.

Money coming in

• CR — Credit. Used for salary, pension, HMRC payments and most incoming transfers.
• DIV — Dividend payment.
• INT — Interest. Credit interest earned, or debit interest charged on an overdraft.

Either direction

• TFR — Transfer. Typically a movement between accounts, including your own HSBC accounts. It can appear in either the Paid out or the Paid in column depending on direction.
• REV — Reversal. A charge that was applied and then returned.

If you hit a code that is not on this list, only HSBC can trace it back to a specific transaction — it is worth calling rather than guessing, especially on older or business accounts.

Two layout quirks that break copy-paste

If you have ever selected an HSBC PDF, pasted it into Excel and ended up with a mess, these two behaviours are why.

The details field wraps across multiple lines. The "Payment type and details" column holds the type code plus the merchant or payee detail, and HSBC lets it run onto two or three lines when it is long. A plain copy-paste treats each visual line as a new row, so one payment becomes three fragments — and only the first one has a date and an amount attached.

The balance only prints on each day's closing line. HSBC does not repeat the running balance on every transaction. When several transactions share a date, the balance appears once, on the last one. If you assume one balance per row, most of your rows will come out blank and any reconciliation built on that column will fail.

Both behaviours are consistent and both are solvable — but they need a parser that understands the statement's structure, not a text dump.

What is a composite statement in HSBC?

A composite statement is a single consolidated document covering all of your accounts rather than one statement per account. Instead of receiving separate statements for your current account, savings and each currency account, everything arrives in one file.

This terminology is used primarily by HSBC Expat, the Jersey-based offshore arm, so it is most relevant if you hold multiple currency or savings accounts there rather than a standard HSBC UK retail account. In online banking you select "composite statement" from the account dropdown to view it, with history available going back up to 72 months.

How HSBC statement layouts differ by region and brand

The HSBC name covers several quite different statement formats.

HSBC UK personal

The five-column layout described above, DD/MM/YYYY dates, sort code and 8-digit account number, sheet numbering, amounts in pounds.

first direct

first direct is a division of HSBC UK and its accounts sit on HSBC's 40- sort code range, so the underlying payment type codes are the same family. The statement styling is first direct's own, but if a converter handles HSBC UK correctly it will generally handle first direct.

HSBC Business Banking

Adds explicit BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD rows and splits the details column into separate Type and Description columns. Useful, because it removes the ambiguity of parsing the code out of a free-text field.

HSBC Hong Kong

This is a genuinely different document — a multi-section Statement of Account rather than a single transaction list. A typical HSBC One, Premier or Jade statement runs:

1. Financial Position — a summary "as at" the statement date, with Integrated Account, Others and Total columns in HKD equivalent
2. Financial Reminder — upcoming dates and items
3. Account Summary – Deposit Services — Account Number, CCY, Overdraft Limit, Balance and HKD Equivalent, with the Integrated Account's sub-accounts itemised and sub-totalled
4. Card Type — each card with its credit limit and balance
5. Insurance — policy numbers, sums insured and premiums, where held
6. Transaction History — presented per sub-account, with columns Date, Transaction Details, Deposit, Withdrawal and Balance, opening with a B/F BALANCE line

The key structural difference: the HKD savings and current accounts share one Integrated Account number in the 360-235519-888 format and appear as separate line items within it, while standalone legacy accounts appear under "Other Account" with their own numbers. DR after a balance denotes a debit.

Practically, this means an HSBC Hong Kong statement contains several transaction tables, not one. Any extraction that grabs "the transaction table" will silently capture only the first sub-account.

HSBC US

Uses US conventions — MM/DD/YYYY dates, routing number instead of sort code, and Deposits / Withdrawals column naming.

Getting your HSBC statement into Excel, CSV or QuickBooks

First, check what your online banking offers

Before converting anything, look at what HSBC will give you directly. Online banking often offers a transaction download in CSV, OFX or QIF alongside the PDF. If the period you need is available that way, take it — it is machine-readable by definition and skips extraction entirely.

The catch is range: download windows are usually limited to recent months, they rarely cover closed accounts, and mortgage applications, audits and accountants typically ask for the official PDF statements specifically. That is when you need conversion.

Converting the PDF

What to verify after conversion

Four checks catch nearly every extraction problem:

• Row count — does the number of transactions match what you count on the statement?
• Date interpretation — did 05/09/2026 stay 5 September, or did it become 9 May?
• Signs — are debits and credits on the correct side? A flipped sign is the most common silent error.
• Closing balance — does opening balance, plus credits, minus debits equal the printed closing balance?

If all four pass, the export is trustworthy. If the closing balance is off by exactly one transaction's value, you have a dropped row or a sign error, and the amount of the discrepancy usually tells you which transaction to look at.

Frequently asked questions

What does BP mean on an HSBC statement? Bill Payment — a payment you made through online or telephone banking to a company or person. Most Faster Payments appear as BP.

Why is the balance column blank on most of my rows? HSBC prints the running balance once per day, on that day's final transaction, rather than on every row. It is not missing data.

What date format does HSBC use? DD/MM/YYYY on UK statements, MM/DD/YYYY on HSBC US statements. Check before importing anywhere.

Can I get an HSBC statement as CSV directly? Often yes, for recent periods, via the transaction download in online banking. For older periods, closed accounts, or when an official statement is required, you will need to convert the PDF.

Do first direct statements use the same codes as HSBC? Broadly yes — first direct is part of HSBC UK and shares the same payment type code family.

How far back can I get statements? This varies by entity and account type. HSBC Expat, for example, offers up to 72 months of history in online banking. Check your own online banking for the exact window available to you.

Related reading

• HSBC Bank Statement Review — Complete Analysis & Conversion Guide
• Accurately Convert PDF Bank Statements to CSV
• How to Convert Bank Statements to Excel
• How to Edit PDF Bank Statements for Accuracy

Related tools

• Bank Statement PDF to Excel
• PDF to CSV Converter
• PDF to QBO Converter

---

Working with a statement layout not covered here? Get in touch — we test against real statement formats and add support for new ones regularly.