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.
Last updated August 18, 2026
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
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 CSV export: format and columns
Only have the PDF? Convert it above — same columns, no manual retyping.
HSBC Current and Advance account statement columns
| # | Statement column | What it contains | In the exported CSV |
|---|---|---|---|
| 01 | Date | DD MMM YYYY with a three-letter month, e.g. "03 Jan 2026". | Date |
| 02 | Description | Transaction text, e.g. "ATM Withdrawal" or "Direct Debit". | Description |
| 03 | Paid out | Money leaving the account, printed unsigned with a £ prefix — exported as a negative amount. | Amount |
| 04 | Paid in | Money arriving, printed unsigned with a £ prefix — exported as a positive amount. | Amount |
| 05 | Balance | Running balance; opening and closing are labelled "Opening Balance" and "Closing Balance". | Balance |
Some HSBC PDFs emit all three pound figures on one row (paid out, paid in, balance) and others only two — the parser handles both shapes.
HSBC Current account (payment-type variant) statement columns
| # | Statement column | What it contains | In the exported CSV |
|---|---|---|---|
| 01 | Date | "DD MMM YY" with a two-digit year, e.g. "05 Apr 24". | Date |
| 02 | Payment type and details | A payment-type code followed by the counterparty: DD (Direct Debit), SO (Standing Order), VIS (Visa card), BP (Bill Payment), CR (credit). The details can wrap onto the next line. | Description |
| 03 | Paid out | Money leaving the account, printed unsigned — exported as a negative amount. | Amount |
| 04 | Paid in | Money arriving, printed unsigned — exported as a positive amount. | Amount |
| 05 | Balance | Running balance, printed only on the last transaction of each day. | Balance |
In this variant the date is printed only on the first transaction of each day — following rows inherit it — and the balance appears only on the day's last row. Opening and closing are labelled BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD.
To convert a HSBC UK statement, upload the PDF above: ConvertStatement's dedicated HSBC parser reads its DD MMM YYYY dates and GBP amounts, extracts every transaction, and exports to CSV, Excel, OFX, or QBO — no AI, no manual cleanup.
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.
How ConvertStatement compares
Side-by-side comparisons with other statement converters — parsing approach, formats, pricing, and what happens to your data.
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 by default. All transfers use HTTPS encryption, and your data is deleted from memory as soon as processing completes.
How much does it cost to convert a HSBC statement?
You can convert 10 pages free without an account, or create a free account for 50 pages per month — all four formats (CSV, Excel, OFX, QBO) included. Paid plans start at $9/month for 300 pages.
Convert your HSBC statement now
No signup required. Upload your PDF and get results in seconds.
Upload HSBC statement