Question 1

How do I get the statement from my Hong Kong bank?

Accepted Answer

For HSBC Hong Kong, log on to HSBC Online Banking, hover over “Banking”, select “View eStatements and eAdvices” under “eStatements & eAdvices”, filter by category, account and document type, and select the one you want. HSBC says its eStatements and eAdvices are in PDF. In BOCHK Internet Banking, open the latest e-Statement under “Message”. In Standard Chartered HK Online Banking, select “eStatements” and click “View”. In BEA Online, select “Accounts Services”, then “View e-Statement / e-Advice” from the menu on the left; BEA says its e-Statements are in PDF format. In the Citi Mobile app for Citibank Hong Kong, tap the account, tap “Statements” and view or download a pdf version. In DBS iBanking, click “My Accounts”, choose “eStatement” and confirm with your Secure Device or a one-time password. In ICBC (Asia) Internet Banking, select “Account Services”, then “e-Statement”, then “View e-Statement”; ICBC (Asia) says its e-Statements are in PDF. If what you downloaded is a PDF or an Excel file (.xlsx, .xls), upload it to ExtractPro and you get back an Excel file with one transaction per row.

Question 2

How far back can I get old statements, and how long do I have to keep them?

Accepted Answer

Each bank sets its own limit. HSBC keeps eStatements for integrated, HKD current and HKD savings accounts for up to 84 months. BOCHK lists 7 years (84 months) for the consolidated monthly e-Statement. Standard Chartered HK says eStatements in Online Banking and the SC Mobile app accumulate up to 7 years, from 1 January 2020. Hang Seng offers up to the past 7 years of statements online. BEA says you can access e-statements for up to the past seven years. Citibank Hong Kong lets you view up to 7 years of past e-Statements. DBS lets you view up to 84 eStatements issued within the past 7 years. ICBC (Asia) lets you filter e-Statements generated within the last 84 months. The Inland Revenue Department’s guidance on business records lists bank statements among the records to keep, and says they are to be “retained for a period of not less than 7 years”.

Question 3

When should I convert the statement instead of the transaction history?

Accepted Answer

When you need months that the on-screen list does not reach. HSBC shows, for a current or savings account, the transactions since your last bank statement, and keeps its eStatements for up to 84 months, so for earlier months the statement is the file to convert. Standard Chartered HK has a “Download CSV file” option for transaction details. If you have the statement of an earlier month, or one a client sent you, upload it as it is.

Question 4

How do I use the Excel file for bank reconciliation?

Accepted Answer

The ExtractPro Excel file has one transaction per row, with date, description and amount in separate columns (and the balance, when the statement shows it) and amounts as numbers. With the custom format you split amounts into two columns, debit and credit, and choose the column order, the date format and whether to download Excel or CSV. With that file you match each bank transaction against your records, in a spreadsheet or in your accounting software. For a month that HSBC no longer shows on screen, convert that month’s eStatement and reconcile from it.

Question 5

Is my banking data secure?

Accepted Answer

Yes. We process your statements in memory and keep a copy for a limited time, in private storage, for support and to improve conversion; it isn’t shared with anyone.

Question 6

How many conversions can I do for free?

Accepted Answer

The Free plan includes 2 conversions per month, no card required: sign up with your email or Google account and convert straight away. For more volume there are paid plans, with no commitment.

Question 7

How do I cancel? Is there a commitment?

Accepted Answer

No commitment. You cancel yourself from your account in under a minute: go to Account and select “Cancel subscription”. You keep the plan until the end of the period you’ve already paid for, then move to the free plan. No paperwork, no penalty.

Convert your bank statement to Excel for bank reconciliation

Secure

Built for firms

Accurate

How it works

Upload your statement

We organise it

Download the Excel file

What your Excel file contains

One transaction per row

Amounts as numbers

Dates as dates

Your file is not shared

Simple pricing

Starter

Professional

Business

Frequently asked questions

Supported banks

Hong Kong guides