HSBC statements differ between markets and account products. Before converting, identify the account, currency, and period printed on your document rather than assuming that another country's layout will match.
Prepare a statement for one account
Use your region's official HSBC app or banking website to locate and download the PDF. For UK access questions, see HSBC UK's statement guidance. Other markets may use different menus or document options.
If your statement is password protected, prepare an unlocked copy using the password-protected PDF guide.
Separate currencies before conversion
Our extracted statement model contains one account and one currency, and the standard workbook has one Summary sheet and one Transactions sheet. It does not provide an independent sheet for each currency or a currency field on every transaction.
For a combined or multi-currency document, obtain separate account or currency statements where possible. Do not combine balances in different currencies to check whether an export adds up.
Convert and inspect the workbook
- Open the HSBC converter and upload the PDF.
- Download Excel after processing.
- Confirm the detected currency and account details in Summary.
- Compare transaction dates and amounts with the PDF.
- Check totals for the specific account and currency you intended to convert.
The transaction fields are Date, Description, Debit, Credit, and Balance. The standard export does not include dedicated exchange-rate, payment-reference, or secondary-date columns. Keep the original statement if you need those details.
Watch date interpretation
An ambiguous date can look valid even when its month and day are reversed. Compare a date that clearly identifies the format, then inspect transactions around the statement's start and end. Also check which date the document uses for posting versus making a payment.
For accounting imports, read the Xero guide or the QuickBooks guide before choosing an export.