HSBC Bank Statement to Excel Converter

Converting HSBC Statements to Excel

HSBC UK statements are clear to read but awkward to reuse. Transactions sit under Paid out and Paid in columns, the payment type is a short code at the start of each line, and on many statements the date and the balance are not printed on every row. Copying a page into Excel usually leaves you with amounts in the wrong column, blank dates and a balance column full of gaps. Finlyzers reads the statement as a table and gives you clean, separate columns to work with.

What an HSBC UK Statement Usually Shows

• Account summary: sort code, account number, statement period, opening balance, totals paid out and paid in, and the closing balance.
• Transaction table: columns typically labelled Date, Payment type and details, Paid out, Paid in and Balance.
• Grouped days: when several transactions happen on the same day, the date is often printed once against the first of them, and the balance only after the last one.
• Balance lines: pages usually open with a balance brought forward and close with a balance carried forward. These are balances, not transactions, so they are left out of the transaction list.

In the spreadsheet, each transaction sits on its own row with its own date, so sorting, filtering and pivot tables behave as you would expect.

HSBC Payment Type Codes

The first part of each description tells you how the money moved. Common examples include:

• VIS for Visa debit card payments, and ))) for contactless card payments.
• BP for bill payments and transfers you set up in online banking.
• CR for money received, such as salary or a customer payment.
• DD and SO for direct debits and standing orders.
• ATM for cash withdrawals and CHQ for cheques.

These codes stay with the description, so a filter on VIS or ))) shows card spending, while DD and SO show your regular commitments.

When You Need the PDF Rather Than a Download

HSBC UK online banking usually lets you download recent transactions as a file. That covers the last few weeks on your own account, but it does not help in some common situations:

• Older periods. Past months are generally kept as statement PDFs, and transaction downloads may not reach back far enough.
• Client records. Accountants and bookkeepers are often sent a year of HSBC PDFs by a client rather than given access to online banking.
• Lender and agent requests. A mortgage lender or letting agent may ask for statements, and you may want the same figures in a spreadsheet to check what they will see.
• Closed accounts. Once an account is closed, its old statements may be the only record you have.

Using the Output With UK Accounting Software

• Excel or CSV for working papers, Self Assessment figures or a landlord's schedule of rent received and expenses paid.
• OFX for Xero, FreeAgent or QuickBooks, so transactions can be matched during bank reconciliation. See bank statement to OFX.
• CSV for Sage or any tool that asks you to map the columns yourself. See bank statement to CSV.

Many HSBC UK business customers already have a bank feed connected to their accounting software. Converting PDFs is still useful for backfilling the months before the feed started, for a second account that was never connected, or for bringing earlier records into Making Tax Digital compatible software. Before importing, check which dates the feed already covers so you do not create duplicates.

HSBC Statements From Other Countries

HSBC operates in many countries, and statement layouts differ between them. English-language HSBC statements from outside the UK can be uploaded as well, but the column names, currency and date order may not match the UK layout described here. Check the dates in your downloaded file before importing it anywhere that assumes UK day-month order.

Other Banks and Statement Types

If you also bank with Lloyds or Barclays, see the Lloyds and Barclays converter pages. Converting an HSBC credit card statement? Use the credit card converter. For paper statements that have been scanned or photographed, try the scanned statement converter.