How to Import an HSBC UK Bank Statement into QuickBooks (and Xero)
Convert an HSBC UK PDF statement to QBO format and import it into QuickBooks Online (or Xero) in four steps. Covers UK sort codes, DR/CR markers, DD/MM/YYYY dates, and HSBC Premier multi-currency accounts.
You have an HSBC UK PDF statement and you need it inside QuickBooks or Xero. Maybe it's a small business current account with monthly volume. Maybe it's an HSBC Premier statement with multi-currency sub-accounts (GBP, EUR, USD) that need to be split. Maybe you're a UK-based accountant onboarding a client. The PDF is structured, but QuickBooks and Xero use US conventions by default and need careful handling for UK formats.
This is the workflow. Four steps. The same flow handles Xero - you just swap the export format.
Want to use this guide on your blog? Copy this embed code:
Why You Can't Just Upload the HSBC UK PDF
QuickBooks Online accepts file uploads in .qbo, .ofx, .qfx, and .csv. It does not accept PDF directly for bank imports.
Xero (popular in the UK) supports .ofx, .csv, .qbo, .qfx, and .qif. Same constraint: no PDF.
The workflow starts with a format conversion. For format details, see our QBO vs CSV vs OFX guide.
Step 1: Download the HSBC UK PDF
- Sign in at hsbc.co.uk (personal) or business.hsbc.uk (business)
- Open the account you need
- Click My documents -> Statements
- Pick the statement period
- Click Download (PDF)
HSBC UK keeps up to 7 years of statements available this way.
A note on HSBC Premier and Global Money multi-currency accounts: a single account may have sub-balances in GBP, EUR, USD, and other currencies. The PDF includes each currency's transactions in a separate block. Each currency typically maps to a separate QuickBooks / Xero account (since the base currency for the QuickBooks file is fixed).
Step 2: Upload to PDFSub
Open PDFSub's Bank Statement Converter. Drag the HSBC UK PDF into the drop zone or click to browse.
PDFSub recognizes the HSBC UK template automatically. Locale auto-detection picks up UK conventions (DD/MM/YYYY dates, GBP defaults, sort code format) without needing manual configuration. The extraction runs server-side and the file is not persisted.
HSBC UK-specific handling that PDFSub does automatically:
- DD/MM/YYYY dates are parsed correctly (not flipped to MM/DD as US-only tools would)
- Sort code (XX-XX-XX) is preserved in the export header - QuickBooks and Xero treat this as account metadata
- DR / CR markers next to amounts are converted to signed amounts (
+for CR,-for DR) - Numbers with thousands separators using comma or full stop are parsed correctly (UK convention:
1,234.56) - Multi-currency Premier accounts are split into separate export files - one per currency (GBP, EUR, USD)
- IBAN and BIC codes are captured as metadata if present on the statement header
- Balance brought forward (B/F) and Balance carried forward (C/F) lines are excluded from transactions
Step 3: Choose the Right Export Format
| Destination | Format | Why |
|---|---|---|
| QuickBooks Online | .qbo |
Native format, no column mapping, automatic duplicate detection |
| QuickBooks Desktop | .qbo or .iif |
QBO via Web Connect, IIF for batch imports |
| Xero (UK) | .ofx |
Preferred - includes account metadata and duplicate IDs; CSV requires column mapping |
| Sage (UK) | .csv or .ofx |
CSV most common for Sage 50, OFX for Sage Business Cloud |
| FreeAgent | .ofx or .csv |
OFX preferred for FreeAgent |
| FreshBooks | .csv |
Only supported import format |
For UK accountants, Xero is the most common destination, so .ofx is usually the right choice. For HMRC-compliant QuickBooks UK setups, use .qbo.
Step 4a: Import the .QBO into QuickBooks Online
- In QuickBooks, go to Banking (or Transactions -> Bank transactions)
- Click Link account in the top right
- Choose Upload from file at the bottom of the dialog
- Drag the
.qbofile in - Select the QuickBooks account this statement belongs to
- Confirm the date range and click Next
- Review the parsed transactions in the For Review tab
For multi-currency Premier accounts, repeat for each currency-split file (one each for GBP, EUR, USD).
File limits: QuickBooks Online caps uploads at 350 KB per file and 1,000 transactions per import.
Step 4b: Import the .OFX into Xero (Same Flow)
- Go back to PDFSub and export as
.ofxinstead of.qbo - In Xero, navigate to Accounting -> Bank accounts
- Click on the relevant bank account
- Click Manage account -> Import a statement
- Drag in the
.ofxfile - Xero detects the format and parses the transactions
- Review and confirm
Xero UK handles GBP natively. For EUR/USD sub-accounts on HSBC Premier, you'll need separate Xero bank accounts in the matching currency.
Common Errors and Fixes
Dates parsed as the wrong format. If your transactions are showing in the wrong order or QuickBooks rejects dates as invalid, the file may have been exported with US date format. PDFSub uses UK DD/MM/YYYY for HSBC UK statements by default. Re-export from PDFSub with Date format: DD/MM/YYYY explicitly selected.
Amounts off by a factor of 100 or 1000. UK convention uses 1,234.56 (comma as thousands separator, full stop as decimal). Some import tools misinterpret this as 1234.56 or 1.234,56 (European convention). PDFSub normalizes to a single decimal format on export. If you see suspicious amounts, check that you used .qbo or .ofx (which include explicit decimal markers) instead of .csv.
DR/CR markers showing in description. PDFSub should convert DR (debit) and CR (credit) markers to signed amounts on export. If you see "DR" or "CR" text in the QuickBooks description field, re-export with Convert DR/CR to signed amounts checked.
Multi-currency import errors. QuickBooks Online requires Multi-currency to be enabled (Settings -> Account & Settings -> Advanced -> Currency) before you can import non-GBP transactions. Enable this BEFORE importing the EUR or USD split files from a Premier statement.
Different bank than HSBC? PDFSub recognizes 20,000+ bank templates, including the UK Big Five (HSBC, Barclays, Lloyds, NatWest, Santander UK) and most building societies. For a software-agnostic primer on bank statement imports into QuickBooks, see How to Import Bank Statements into QuickBooks Online.
When You Already Have HSBC UK's Native CSV (Limited History)
HSBC UK offers CSV export from Online Banking -> Statements. Catches:
- Only the last ~24 months
- For Premier multi-currency, the CSV is per-currency (you have to export GBP, EUR, USD separately)
- Transaction feed only - no opening balance, no closing balance, no Balance B/F or C/F markers
- Sort code may be absent from the CSV header
For audit, HMRC compliance, or historical onboarding, the PDF -> PDFSub -> QBO workflow above is the right path.
Summary
- Download the HSBC UK PDF from hsbc.co.uk (up to 7 years; Premier accounts include all currency sub-balances)
- Upload it to PDFSub's Bank Statement Converter
- Export as
.qbo(QuickBooks UK) or.ofx(Xero, FreeAgent, Sage Business Cloud) - UK dates and DR/CR markers handled, Premier splits by currency - Banking -> Upload from file -> done. No column mapping, automatic duplicate detection
For full HSBC UK per-section layout (sort code, DR/CR markers, DD/MM/YYYY dates, multi-currency accounts), see the HSBC UK bank statement explained deep-dive.