How to Convert an HSBC Statement to Excel, Xero or QuickBooks

HSBC Online Banking and the app show recent activity, and Open Banking feeds pull it into Xero or QuickBooks — until the feed drops, the account closes, or you need history the feed never covered. Then you're back to PDF statements. Here's how to convert an HSBC statement PDF into Excel, CSV, or a Xero/QuickBooks-ready file, scanned copies included.

Get your HSBC statement PDF

1. Sign in at hsbc.co.uk (or the HSBC UK app).
2. Open the account and go to Statements / Documents.
3. Choose the statement period and download the PDF. HSBC keeps several years of statements online.

HSBC business accounts (Business Banking, HSBC Kinetic) work the same way.

Convert it

1. Open Convert Bank Statements and drop the HSBC PDF in.
2. Every transaction is extracted automatically — no template setup.
3. Check the balance badge: Balanced means opening balance + money in − money out equals the printed closing balance.
4. Export as Excel, CSV, OFX, or QuickBooks .QBO and import into Xero, Sage, or QuickBooks.

HSBC-specific tips

• Open Banking gaps are the whole point. Feeds cover recent activity only; older periods and lapsed connections are PDF-only — the catch-up scenario this is built for.
• Dates as DD/MM/YYYY. UK statements and UK Xero/Sage expect day-first dates; the export keeps them consistent so nothing shifts.
• HSBC credit cards convert with correct charge/payment polarity.
• Scanned or photographed statements work too; the balance check catches OCR misreads. See the scanned statement guide.

Is it accurate?

Every account is reconciled the way a bookkeeper would check it. If a row breaks the math, it's flagged for review instead of silently exported. Details on our security page.

FAQ

Does this work for HSBC business accounts? Yes — HSBC current accounts, savings, business, and credit cards, digital or scanned.

Which format for Xero? OFX imports with the least mapping; CSV works with a one-time column map.

Is my data safe? Your PDF is never stored and never used to train AI. See our Privacy Policy.

How much does it cost? 15 free pages on sign-up. Page packs start at $12 and never expire. See pricing.

Convert an HSBC statement now →

Related guides

• Convert a Barclays statement
• Convert a Lloyds statement
• Import a bank statement PDF into Xero
• Convert a scanned bank statement (OCR)

---

Not affiliated with or endorsed by HSBC. HSBC is a trademark of HSBC Group. Xero is a trademark of Xero Limited; QuickBooks of Intuit Inc.