How to Convert HSBC UK Statements to CSV or Excel

Why Convert HSBC UK Statements?

HSBC is the largest bank in Europe by total assets and one of the most widely used banks in the United Kingdom, serving over 14 million UK customers. HSBC UK issues monthly PDF statements for current accounts, savings accounts, and credit cards. UK accountants, small business owners, and self-employed individuals often need to convert these into spreadsheet format for HMRC tax returns, VAT reporting, or integration with accounting packages like Xero, Sage, or FreeAgent. HSBC statement PDFs use a consistent layout, but the British date format and specific terminology require UK-aware parsing. BankRead understands HSBC UK's format and extracts clean, categorized data.

Understanding the HSBC UK Statement Format

HSBC UK current account statements use a portrait PDF listing transactions in a table with Date, Payment Type and Details, Paid Out (debits), Paid In (credits), and Balance. Dates use the UK format (DD/MM/YYYY). The header shows the sort code, account number, statement number, and sheet number. HSBC UK credit card statements display a summary (previous balance, payments, purchases, interest, new balance) followed by transaction details with Date, Description, and Amount. Business current account statements follow the same layout with potentially higher transaction volumes.

How to Convert with BankRead

Follow these steps to convert your HSBC UK PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your HSBC UK online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your HSBC UK Statement PDF

1. Log in to HSBC UK Online Banking at hsbc.co.uk with your username and secure key.
2. Navigate to the account and click 'Statements' or 'View statements.'
3. Select the month you need from the statement list.
4. Click 'Download' or 'Save as PDF' to save the statement.
5. HSBC stores statements for up to 7 years — select older periods from the date dropdown.

What Data Gets Extracted

BankRead extracts the following fields from your HSBC UK statement:

• Transaction date in UK format (DD/MM/YYYY)
• Payment type and details (e.g., 'DIRECT DEBIT — BRITISH GAS SERVICES')
• Paid out amount (debits, standing orders, direct debits)
• Paid in amount (salary, credits, transfers in)
• Running balance (£ sterling)
• AI-assigned category (e.g., Utilities, Salary, Insurance, Council Tax)

Export Options

Once your HSBC UK statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for HSBC UK Statements

• HSBC UK statements use British date format (DD/MM/YYYY) — BankRead preserves this format in the output. You can reformat dates in your spreadsheet if needed.
• HSBC payment types (VIS, DD, SO, BGC, TFR) are abbreviations — BankRead includes the full description alongside the payment type code.
• Multi-page statements from high-activity accounts (30+ transactions/month) are processed in a single upload.
• HSBC UK Premier and Advance account statements follow the same layout as standard current accounts.
• HSBC statements may include a 'Interest and charges' summary section — this is separate from the transaction list.

Common Issues and Solutions

• HSBC UK statements use abbreviations for payment types: VIS (Visa/card payment), DD (Direct Debit), SO (Standing Order), BGC (Bank Giro Credit), TFR (Transfer). These codes appear alongside the full description and don't affect extraction.
• Some HSBC statements include a separate 'Unpresented Cheques' section for cheques issued but not yet cleared. BankRead extracts only posted transactions.
• HSBC Business current account statements may include a reconciliation summary that is not extracted as individual transactions.

Frequently Asked Questions