UK
Upload an HSBC statement PDF and every transaction comes back as clean rows — date, description, paid out, paid in and the running balance — with the closing figure checked before you download. Export to Excel, CSV, or an import file for Xero, QuickBooks or Zoho.
HSBC is a global bank, but a UK current-account statement has one local quirk that undoes a copy-paste: a short payment-type code sits at the front of every line, and pasting the PDF into a spreadsheet smears it into the payee or the money column.
What an HSBC statement looks like
An HSBC current-account statement uses these columns:
Column | What's in it |
|---|---|
Date | The day the transaction was applied |
Payment type and details | A code, then the payee |
Paid out | Debits |
Paid in | Credits |
Balance | Running balance after the transaction |
The payment-type code is the HSBC detail to know. HSBC abbreviates how the money moved: VIS for a Visa debit-card payment, DD for a Direct Debit, SO for a standing order, BP for a bill payment, TFR for a transfer, ATM for a cash withdrawal and CR for a credit paid in. Those codes are handy once the statement is a spreadsheet — filter every card payment or Direct Debit in a click — but because they lead each description, a rough export pushes them into the wrong column. The converter keeps the code with its transaction, on the right row.
It's worth noting HSBC owns first direct and M&S Bank, and those statements follow the same style — so if you're converting one of those, the same approach applies.
International payments and currency
Being a global bank shapes what turns up on an HSBC statement. International transfers, payments to overseas accounts and foreign card spending are common, and a foreign purchase often shows the converted sterling amount with the original currency noted in the description. That extra detail is easy to lose in a copy-paste, so the converter keeps it on the transaction — which matters if you're an expat, run a business that pays suppliers abroad, or hold an HSBC account precisely because you move money between countries. Each line still reconciles against the sterling running balance, whatever currency it started in.
Where to download your HSBC statement
- HSBC Online Banking: log in at hsbc.co.uk, choose the account, open Statements, pick the period and download the PDF.
- HSBC UK Mobile Banking app: tap the account, go to Statements, choose a month and save the PDF.
A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a paper statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or QuickBooks — an import-ready bank file so the lines arrive as statement entries to reconcile.
- Tally, Zoho and others — the same data in each one's format.
Before you download, the maths is checked: opening balance, plus paid in, minus paid out, has to reach the closing balance. On a multi-page HSBC statement, that check is what catches a single line dropped between pages.
Common snags with HSBC statements
- Foreign transactions. Overseas card spending and international transfers keep their currency detail and still reconcile to the sterling balance.
- Premier and Advance accounts. HSBC's account tiers use the same statement layout, so the conversion is identical.
- first direct and M&S Bank. Both are HSBC and follow the same style, so the same conversion works.
Frequently asked questions
Can I convert an HSBC statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
What do the codes like VIS and BP on my HSBC statement mean?keyboard_arrow_down
They describe how the money moved: VIS is a Visa debit-card payment, DD a Direct Debit, SO a standing order, BP a bill payment, TFR a transfer and ATM a cash withdrawal. The converter keeps each code with its transaction.
Does it work for first direct statements?keyboard_arrow_down
Yes. first direct is part of HSBC and uses the same statement layout, so the same conversion handles it.
Will it read a scanned HSBC statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Online Banking will convert faster and cleaner than a scan.
