pdftoexcel

Convert your HSBC UK statement to Excel

HSBC Advance, Premier, and HSBC credit-card statements. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

BankPDFtoXLS is an independent service. We are not affiliated with, endorsed by, or sponsored by HSBC UK Bank plc. The name "HSBC UK Bank plc" is used only to describe compatibility with statements you have legally obtained from your own account. See our trademarks policy.

Converting a HSBC UK statement, step by step

  1. 1. Drop your HSBC UK Bank plc PDF — digital or scanned, monthly statement or a combined multi-month export, up to 50 MB (or batch up to 25 files). Password-protected PDFs and image-only scans both work: scans go through vision OCR automatically.
  2. 2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
  3. 3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

HSBC UK statement structure and quirks

Sections in the PDF
Account summary · Transaction details · Interest summary · Charges
Transaction date format
DD MMM YY
Products we've parsed
HSBC Advance Account, HSBC Premier Account, HSBC Bank Account, HSBC Student Account, Online Bonus / Flexible Saver, HSBC Premier / Classic credit cards

HSBC UK statements use a single Transaction details block with running balance printed after every row — one of the cleanest layouts in UK retail banking. No separate deposits/withdrawals split means the LLM has very little ambiguity to resolve, which shows up as high first-pass accuracy.

Premier customers often receive consolidated statements that show current account, savings, and sometimes loan activity on one PDF. Each account section is treated as an independent running-balance stream; the XLSX export keeps them on separate sheets so category coding stays clean.

HSBC credit-card statements close on a cycle date with UK-standard DD MMM YY formatting. Purchases, Payments received, and Interest sections each parse into distinct row types; reconciliation runs against the printed new balance per cycle.

Which HSBC UK statements work

We handle checking, savings, credit-card, and business PDFs from HSBC UK Bank plc.

  • checking
  • savings
  • credit-card
  • business

Common issues with HSBC UK PDFs

Format-specific quirks that break naive PDF parsers — and how the reconciliation pipeline handles each one.

Premier-tier global view aggregates multi-currency accounts

HSBC Premier customers often hold linked accounts in multiple currencies (GBP current, USD savings, EUR account) that appear together on a single Premier statement. Each account block has its own currency code in the header and its own running balance, but the cover summary lists totals in GBP-equivalent only. Manual reconciliation that uses the cover total fails per-account. The parser preserves the per-account currency and runs separate running-balance checks per account, so the export keeps each on its own sheet without phantom currency conversions.

Direct-debit guarantee notices print like transactions

HSBC UK statements occasionally include a Direct Debit Guarantee notice block — a regulatory disclosure printed mid-document with the same column structure as the transaction stream but no actual amounts. Parsers that ingest every dollar/pound figure get confused by the example amounts in the notice. The parser detects the regulatory-notice signature (printed 'Direct Debit Guarantee' header) and excludes those rows from the transaction count.

Sort code + account number split across header rows

Unlike US statements where the account number appears in one place, HSBC UK statements split the sort code (XX-XX-XX format) and account number (8 digits) across two adjacent rows in the header. Naive parsers that look for a single account-identifier field can pick up only half. The parser combines them into a canonical 'sort code + account' identifier in metadata so cross-statement comparison and direct-debit-mandate matching work without manual concatenation.

Frequently asked questions

Does it work for HSBC Premier consolidated statements?
Yes. Premier PDFs that bundle current account + savings (and sometimes loan activity) on one file are split into independent running-balance streams; the XLSX export keeps them as separate sheets without manual demultiplexing.
Will HSBC Advance Account statements convert?
Yes. Advance uses the same single-block Transaction details layout as every other HSBC UK current account — the parser reads the per-row running balance and validates it against the printed end-of-month figure for a Verified badge.
What about HSBC credit-card PDFs?
Yes. Cycle-based credit-card statements flow through the LLM path with merchant and category preserved in Description, and reconciliation runs against the printed new balance per cycle — not the calendar month, so the exported period reflects the actual cycle window.
Can I batch multiple months of HSBC statements?
Drop up to 10 monthly PDFs in one go — any mix of Advance, Premier, or credit-card statements. The ZIP output contains separate XLSX / CSV / QBO files, one per input PDF.

Further reading

Engineering notes

Why your bank statement balance doesn't match: 7 specific causes and how to track each one down

When the sum of transactions doesn't equal the printed ending balance, the cause is almost always one of seven specific patterns. A field guide to identifying which one you have, and what to do about each.

11 min read

Engineering notes

Password-protected bank statement PDFs: how to convert them safely without uploading the password to a stranger

Most banks ship encrypted statement PDFs by default. The conversion is easy when you have the password and impossible when you don't, but the part that matters most is what happens to the password during the conversion itself.

9 min read

Workflows that rely on Verified output

Most HSBC UK statements that come through us are part of one of these workflows. Each link below explains how the reconciliation guarantee maps to that practice.

Forensic accountants

Discovery packets, multi-year tracing

Divorce attorneys

Opposing-counsel financial disclosure

Bookkeepers

Catch-up & bank-feed gaps

Scanned PDFs

Vision OCR + reconciliation

PDF to QBO

QuickBooks-ready OFX export

For QuickBooks workflows

Verified imports, no duplicates

Related banks our pipeline handles