Convert HSBC Hong Kong Bank Statement to Excel

An HSBC One or Premier statement is less a bank statement than a portfolio report: the integrated account rolls HKD current and savings, foreign currency sub-accounts, time deposits, and sometimes investments into one document, with a separate transaction section per currency. Add the bilingual layout — English descriptions alongside Chinese, sometimes on the same line — and dates written DD/MM/YYYY, and retyping a month into Excel becomes genuinely error-prone. An expat reconciling salary in HKD against USD savings, or an SME owner splitting HKD revenue from CNY supplier payments, ends up rebuilding several mini-statements by hand and praying no digit slipped. SheetMyBank reads each currency section as its own run of transactions, keeps the HKD, USD, and RMB balances separate, interprets the DD/MM/YYYY dates correctly rather than swapping day and month, and hands back Excel rows that already line up with the printed running balance.

HSBC Hong Kong delivers eStatements through both online banking and the HK mobile app — look under the statements or eStatements area of your account view, pick the account and month, and download the PDF; paper statements you have scanned work too, because the built-in OCR reads scans and even phone photos, not just digital PDFs. From there, drop the file onto SheetMyBank. Nothing uploads: the parsing code runs inside your browser tab, so a document listing your salary, balances, and every counterparty stays on your machine — it even works offline once the page has loaded. As rows are extracted, each one is re-verified against the running balance for its currency section, and any line that breaks the chain is flagged in the preview and written to a separate Warnings sheet instead of hiding in the output.

Drop your HSBC Hong Kong statements here (PDF or photo)

One file or many — processed entirely on this device, nothing is uploaded. Scans and photos are read with on-device OCR (beta).

Free for your first 5 pages each month · Processed on your device · Balance-verified output

HSBC Hong Kong statement FAQ

My HSBC HK statement mixes English and Chinese — does that confuse the converter?

No. The amounts, dates, and running balances that drive the extraction are numeric and unambiguous, and Chinese characters in descriptions are carried through into the description column as text. For scanned statements, the OCR is tuned for the English/numeric fields that matter for reconciliation, so bilingual layouts still produce verifiable rows.

How are the HKD, USD, and RMB sections of an integrated account handled?

Each currency section is parsed as its own sequence with its own running balance, so balance verification never tries to chain an HKD figure into a USD one. You get one coherent set of rows per currency that you can keep on separate sheets or merge yourself.

I only have an older statement as a paper scan — can I still convert it?

Yes. If HSBC’s online archive no longer covers the period you need, scan or photograph the paper copy and convert that instead — the OCR layer handles scans and photos, and the same balance check runs afterwards to confirm the rows it read actually add up.