Cómo convertir estados de HSBC UK a CSV o Excel

¿Por qué convertir estados HSBC UK?

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.

Entendiendo el formato de estados HSBC UK

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.

Cómo convertir con BankRead

Sigue estos pasos para convertir tu estado PDF de HSBC UK a CSV o Excel:

1. Descarga tu estado, exporta una hoja de cálculo o toma una foto — Obtén el PDF desde tu portal bancario en línea de HSBC UK, exporta transacciones como CSV o Excel, o toma una foto de un estado en papel con tu teléfono.
2. Sube a BankRead — Arrastra y suelta el PDF, CSV, Excel o imagen en tu panel de BankRead. En móvil, toca 'Tomar foto' para capturar directamente.
3. La IA procesa tu estado — La IA de BankRead lee cada transacción de PDFs de texto, hojas de cálculo, documentos escaneados o fotos — extrayendo fechas, descripciones y montos, luego categorizando automáticamente.
4. Revisa los datos extraídos — Verifica la tabla de transacciones en pantalla para confirmar que los datos son correctos. La categorización IA se aplica automáticamente.
5. Exporta a CSV o Excel — Haz clic en el botón de exportar para descargar tus datos limpios y estructurados como archivo CSV o Excel.

Cómo descargar tu estado PDF de HSBC UK

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.

Qué datos se extraen

BankRead extrae los siguientes campos de tu estado HSBC UK:

• 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)

Opciones de exportación

Una vez procesado tu estado HSBC UK, puedes exportar los datos en dos formatos:

• CSV (valores separados por comas) — Ideal para importar en software contable como QuickBooks, Xero, Wave o FreshBooks. Compatible con prácticamente cualquier aplicación de hoja de cálculo incluyendo Google Sheets.
• Excel (.xlsx) — Hoja de cálculo lista con columnas y encabezados formateados. Ideal para análisis personalizado, tablas dinámicas o compartir con tu contador.

Consejos para estados HSBC UK

• 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.

Problemas comunes y soluciones

• 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.

Preguntas frecuentes