HSBC statement to Excel
HSBC splits money movement into two columns — Payments Out and Payments In — which means a naive export gives you two amount columns and a sum that is meaningless. The converter folds them into one signed amount, withdrawals negative and deposits positive.
Column layout
UK and international HSBC statements use the five-column form, with dates written as dd Mmm yy.
| Account type | Date column | Description column | Money out | Money in | Balance |
|---|---|---|---|---|---|
| Current accounts | Date | Description | Payments Out | Payments In | Balance |
Why the two columns have to be merged
Excel cannot sum a debit column and a credit column against each other, and a pivot table on two amount columns tells you nothing. Folding them into one signed amount is the difference between a sheet you can reconcile and a sheet you have to fix by hand.
Brought forward and carried forward
HSBC repeats a Brought Forward line at the top of each page and a Carried Forward line at the bottom. Those are running totals, not transactions, so they are excluded — otherwise every page adds two phantom rows and your opening balance doubles.
Questions
Does it handle HSBC credit cards too?
Yes. Card statements list debits and credits in a single amount column, so nothing needs merging and the export is a straight four-column table.
Which currency does it record?
The currency printed on the statement. Multi-currency HSBC accounts print the account currency in the header, and that is what gets used.
Will the dd Mmm yy dates convert properly?
Yes — they are normalised to YYYY-MM-DD, so sorting and date filters in Excel and Google Sheets work without further formatting.
Try it on your own statement
No account, no card, no email. Convert one file and check the rows against the original.
Open the converter