HSBC Bank Statement Converter
Convert your HSBC UK statement PDF to CSV, Excel, OFX, or QBO. Extract transactions automatically and download in the format you need. Our dedicated parser handles this bank with high accuracy.
Drop your bank statement here
PDF, up to 50 pages
Export formats
CSV
Universal spreadsheet format. Opens in Excel, Google Sheets, Numbers, or any data tool.
Excel (XLSX)
Native Microsoft Excel format with formatted columns and headers.
OFX
Open Financial Exchange format. Imports into Quicken, Mint, and most financial software.
QBO
QuickBooks Web Connect format. Direct import into QuickBooks Desktop and Online.
About HSBC statements
HSBC UK Current Account and Advance Account statements are downloaded as PDFs from HSBC Online Banking or the HSBC UK mobile app via the 'Statements' or 'Documents' section. Customers can pull individual monthly statements or a custom period; the file is identified at the top by 'HSBC' and a 'Statement' or 'Advance Account Statement' heading.
Identification uses the British 2-2-2 sort code and 8-digit account number — for example 'Sort Code: 40-11-56 Account Number: 12345678' — and the statement period is expressed as 'Statement Period: 01 Jan 2026 to 31 Jan 2026' with three-letter month abbreviations. Individual transaction rows follow the same DD MMM YYYY date format. Opening and closing positions are labelled 'Opening Balance £X,XXX.XX' and 'Closing Balance £X,XXX.XX'.
The ledger has five visible columns — Date, Description, Paid out, Paid in, Balance — but HSBC's PDF text output is inconsistent: some rows emit a single amount plus the balance, others emit Paid out, Paid in and Balance as three separate £ values on one line. ConvertStatement's HSBC parser handles both shapes in a single regex and recovers the correct sign by comparing prev_balance ± amount against the new balance within 0.01 tolerance.
How to convert your HSBC statement
- 01
Download your statement from HSBC
Log in to your HSBC UK online banking, navigate to Statements & Documents, and download the PDF for the period you need.
- 02
Upload the PDF above
Drag and drop the PDF into the upload area on this page, or click to browse. The parser detects your bank automatically.
- 03
Preview your transactions
Review the extracted transactions in the preview table. Verify dates, descriptions, and amounts are correct.
- 04
Choose your format and download
Select CSV, Excel, OFX, or QBO and download your converted file. Import it into your accounting software or spreadsheet.
HSBC statement format at a glance
HSBC UK Current Account and Advance Account statements use the date format DD MMM YYYY with the three-letter month abbreviation, for example '03 Jan 2026', and the statement period appears as 'Statement Period: 01 Jan 2026 to 31 Jan 2026'. The currency is GBP, amounts are prefixed with £, and numbers use US-style 1,234.56 punctuation. Each transaction line carries up to three pound figures — Paid out, Paid in, and Balance — although many rows collapse to just an amount and a balance, so the ConvertStatement parser matches both layouts. Opening Balance and Closing Balance are explicitly labelled with the £ figure that follows. The account is identified by a 2-2-2 sort code such as 'Sort Code: 40-11-56' plus an 8-digit account number, which is masked in the exported CSV, Excel, OFX or QBO file.
- Date format
- DD MMM YYYY
- Decimal format
- 1,234.56
- Currency
- GBP
- Column layout
- Date | Description | Paid out | Paid in | Balance — line shape: DD MMM YYYY Description £amount [£amount] £balance (two- or three-amount variant supported)
- Statement sections
- Statement · Advance Account Statement · Opening Balance · Closing Balance · Statement Period
Known HSBC parsing quirks
These are real layout details that make HSBC PDFs different from other banks. Our dedicated parser handles each one explicitly so the exported CSV, Excel, OFX, or QBO is always correctly signed and dated.
- HSBC UK uses 'DD MMM YYYY' with the three-letter month abbreviation (e.g., '03 Jan 2026'), normalised internally before date parsing
- Period header is 'Statement Period: 01 Jan 2026 to 31 Jan 2026' (note 'Period:' not 'from')
- Some statements emit a three-£ row (Paid out, Paid in, Balance) and others a two-£ row — the parser handles both within one regex
- Opening/closing labels are 'Opening Balance £X,XXX.XX' and 'Closing Balance £X,XXX.XX'
- Sort code uses 2-2-2 hyphenated form (e.g., 'Sort Code: 40-11-56'); account number is 8 digits and gets masked on export
Description prefixes the HSBC parser recognises
DDSOBPVISATMDirect DebitStanding OrderBill PaymentFaster PaymentContactlessBACSCHAPSTFRMulti-line handling: Each transaction is matched as a single line by a regex which supports both a two-amount layout (amount + balance) and a three-amount layout (paid out + paid in + balance).
Convert to a specific format
Other supported banks
ConvertStatement supports dedicated parsers for many other US, UK, and European banks. Same in-memory processing, same export formats.
Frequently asked questions about HSBC statement conversion
How do I download my HSBC UK bank statement as a PDF?
Log in to your HSBC UK online banking at hsbc.co.uk, navigate to your account, and select 'Statements'. Choose the statement period and download as PDF.
Do you support HSBC Advance account statements?
Yes. ConvertStatement supports both HSBC current account and HSBC Advance account statements. The parser automatically detects the account type.
Are HSBC statements in GBP supported?
Yes. Our HSBC parser is built specifically for UK statements in British Pounds (GBP). Dates in DD MMM YYYY format and amounts with the pound sign are fully supported.
Is my HSBC statement data safe?
Yes. ConvertStatement processes files entirely in memory. No bank data is stored, logged, or shared. All transfers use HTTPS encryption. Your data is deleted from memory as soon as processing completes.
How much does it cost to convert a HSBC statement?
ConvertStatement offers 3 free conversions per month (CSV format). Paid plans start at $9/month for 200 pages with all export formats including Excel, OFX, and QBO.
Convert your HSBC statement now
No signup required. Upload your PDF and get results in seconds.
Upload HSBC statement