Convert HSBC UK statements to Excel & CSV
Turn HSBC UK Bank plc PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your HSBC UK statement is never uploaded.
Drop HSBC UK bank statement PDFs here
or choose files · multiple files OK · scanned PDFs & photos supported
Select PDF statements- 🔒 Never uploaded
- ∞ Free & unlimited
- ✓ Balance-checked
- Your PDF never leaves your device
- Unlimited pages, no signup
- Works offline
- Every row balance-checked
HSBC UK statement format at a glance
Date, Payment type and details, Paid out, Paid in and Balance columns, where each description starts with a short payment-type code and the date appears once per day.
| Bank | HSBC UK Bank plc |
|---|---|
| Country | United Kingdom |
| Currency | GBP |
| Typical date format | DD MMM YY |
| Statements supported | Current account, Savings, Credit card, Business current account |
| Export to | Excel, CSV, Xero, QuickBooks, FreeAgent, Sage, OFX, QIF, JSON |
How to download your HSBC UK statement as a PDF
- Log on to HSBC UK online banking or the HSBC UK Mobile Banking app.
- Pick the account from your account list.
- Go to the statements section for that account (in the app it is usually reached from the account's own menu).
- Select the statement period and save it as a PDF.
Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.
Tips for converting HSBC UK statements
- Descriptions begin with payment-type abbreviations such as DD (Direct Debit), SO (standing order), CR (credit), BP (bill payment) and VIS (Visa debit card). They are useful for categorising, so consider splitting them into their own column after export.
- Contactless card payments are commonly marked with a ))) symbol, which looks like stray punctuation in a spreadsheet. It's harmless — leave it or find-and-replace it once the data is in Excel.
- The Balance column is often filled in only on the last transaction of each day. If a day doesn't tie out, check that day's rows as a group rather than hunting for a single bad line.
- Second and later transactions on the same day have no date of their own on the PDF; make sure the preview shows the correct date on every row before you export.
Helpful guides
- PDF statement to Excel: every method compared
- Import HSBC UK transactions into QuickBooks
- Import HSBC UK statements into Xero
- Reconcile a bank statement in Excel
How the conversion stays accurate
When your HSBC UK statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.
HSBC UK statement conversion FAQ
What do codes like DD, SO, BP and VIS mean on an HSBC statement?
They describe how the money moved: DD is a Direct Debit, SO a standing order, BP a bill payment, VIS a Visa debit card payment and CR a credit. They stay with the description text, so you can filter or build a pivot table on them in Excel.
Can I convert an HSBC UK credit card statement too?
Yes. HSBC credit card statements typically show two dates for each line — when the transaction happened and when HSBC received it — so check which one you want as the main date. Import the result into a credit card account, not your current account.
Is it safe to convert my HSBC UK statement here?
Yes. Your HSBC UK PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.
Can I convert HSBC UK credit card statements too?
Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.
Other banks in United Kingdom
Convert your HSBC UK statement now
Free, unlimited and private. No signup, no upload, no catch.
Choose PDF statements