Convert HSBC Hong Kong Statement to Excel or CSV

HSBC Hong Kong delivers Business Integrated Account statements as bilingual PDFs, with up to eleven foreign currencies plus Hong Kong dollars presented as stacked per-currency ledgers in a single document. Business Internet Banking offers three distinct export paths: formal eStatement PDFs (seven-year archive, audit-ready), Transaction Download (current-period Excel, limited history), and the Xero direct bank feed (live stream, flattened to base currency). PDF extraction is the right choice for historical data, for non-Xero accounting software, for audit-ready output, and for any case where the per-currency separation in the statement must be preserved in the spreadsheet.

Most readers searching for HSBC Hong Kong statement to Excel arrive with the wrong path in mind, because HSBC's own marketing pages, forum threads, and third-party converter landing pages each answer a different version of the question. The three paths above are not interchangeable.

eStatement PDF. The formal statement, bilingual English and Traditional Chinese, multi-currency, retained in the eStatement archive for seven years. This is the only format the bank issues for the formal record, and it is the document the rest of this article is about: how to convert it into a structured spreadsheet without losing the per-currency layout or the Traditional Chinese narratives.

Transaction Download. An Excel export of recent activity, available directly inside Business Internet Banking, bounded to a short live-access window. Useful for a quick list of recent transactions in the current period; not an archive, not audit evidence, and not a replacement for the formal eStatement.

Xero direct bank feed. A live transaction stream from HSBC Hong Kong into Xero, with no PDF involved and the sub-currency ledgers collapsed into the base-currency equivalent. The right option for ongoing Xero reconciliation going forward; the wrong one for historical data, for non-Xero accounting systems, for audit working papers that must tie back to a source PDF, and for anyone reporting on individual currency positions that the feed flattens away.

HSBC Hong Kong is also a distinct product from HSBC UK. The online banking channels are different, the statement layouts are different, and the download paths are different. Readers working on an HSBC UK statement should start with the HSBC UK bank statement conversion guide instead; the midata export flow and the Internet Banking navigation covered there do not apply here. This article covers Hong Kong only.

Inside the Business Integrated Account statement PDF

The Business Integrated Account is HSBC Hong Kong's umbrella SME account product: multiple currency sub-ledgers held under a single account number, with three distinct propositions sold underneath it — Business Direct, BusinessVantage, and Sprint. Business Direct and BusinessVantage both advertise an Excel-format Transaction Download inside Business Internet Banking; Sprint's treatment varies by proposition detail, so verify against your own account before you assume an Excel export is available. The formal eStatement PDF is issued consistently across all three propositions.

Open any HSBC Hong Kong Business Integrated Account eStatement and the per-currency structure is immediate. Each currency the account holds opens its own section of the PDF, with its own opening balance, its own chronological transaction list, and its own closing balance. Per HSBC Hong Kong's current Business Integrated Account page, the foreign currencies available are RMB, USD, EUR, GBP, AUD, NZD, JPY, CAD, SGD, CHF, and THB, alongside HKD as the base. A statement for a regional trading company might carry HKD, USD, RMB, and EUR ledgers stacked in one PDF, each with its own running balance; a statement for a local SME trading only in Hong Kong might carry HKD alone. Same document format, different currency count.

This is the layout generic PDF-to-Excel converters mangle. Tools that treat the document as a single transaction stream flatten the sub-ledgers into one list and destroy the per-currency opening and closing balances, and with them any meaningful reconciliation. It is the single most common failure mode for this document, and the reason the extraction workflow later in this article keeps a currency column on every row of the output.

The bilingual layout is the second property specific to HSBC Hong Kong statements that a reader should understand before extracting anything. Column headers, branch identifiers, and transaction narratives all carry both English and Traditional Chinese text. Payee names frequently appear in Chinese with an English transliteration alongside them, or the other way around depending on the counterparty. Any correct extraction output must preserve the Traditional Chinese (繁體) characters intact, encoded as UTF-8 rather than ANSI, and specifically not normalised to Simplified Chinese. HK writing convention is Traditional, and an output file that swaps in Simplified characters is an immediate credibility problem for any HK-based reviewer. The same bilingual handling shows up across HK finance documents generally; the Hong Kong bilingual invoice extraction for English and Traditional Chinese PDFs walkthrough covers the invoice side of the same problem.

In the transaction narrative field, HSBC Hong Kong separates two transfer types with different labelling. Same-day domestic HKD and renminbi transfers are labelled FPS (Faster Payment System); cross-border transfers carry the SWIFT telegraphic-transfer narrative format, often shortened in practice to SWIFT/TT. The distinction matters for reconciliation against supplier invoices, for cost-of-funds reporting, and for separating domestic-operational cash movements from cross-border flows when the month's activity is explained to a controller or auditor. The Hong Kong Monetary Authority's Faster Payment System reference records that the Faster Payment System, launched by the Hong Kong Monetary Authority on 17 September 2018, operates 24x7 and supports payments in both Hong Kong dollars and renminbi, which is why an HSBC Hong Kong statement covering a month of trading will carry FPS-labelled entries in both currencies any day of the week, including weekends and public holidays.

A related point worth flagging for readers running FX hedges or cost-of-funds reporting: HSBC Hong Kong is a leading offshore renminbi (CNH) centre, and the statement treats offshore CNH transactions as distinct from onshore CNY clearings. If downstream reporting depends on the distinction, keep it in the extraction; a reconciliation that merges the two will misrepresent the FX position.

One scope note. HSBC Hong Kong business customers often hold a corporate credit card paired with the Business Integrated Account, and the credit card statement is a separate document type with its own format and extraction pattern. The workflow in the rest of this article is about the bank statement, not the card statement, and the two should be treated as separate extraction jobs.

Downloading the HSBC Hong Kong eStatement PDF

The formal eStatement lives behind three HSBC Hong Kong channels, each producing the same underlying PDF. Business Internet Banking is the desktop online-banking platform for businesses, separate from HSBC UK Internet Banking, and where most customers download the eStatement as part of a monthly routine. Business Express is the HSBC Hong Kong mobile app for SME banking, providing the same eStatement download on mobile for customers who bank primarily from a phone. The Smart Solution portal at smartsolution.business.hsbc.com.hk is HSBC's wider SME toolbox, used for onboarding, trade finance tools, and other SME services; some customers reach statement archives through it as part of a broader HSBC setup, but readers who do not already use Smart Solution rarely need to set it up solely to download eStatements.

Whichever channel is used, the document to pull is the formal eStatement, not the Transaction Download option covered in the opening disambiguation. The eStatement is the archival bilingual multi-currency PDF; Transaction Download is a current-period Excel of recent activity. For audit files and historical work, only the eStatement will do.

Retention figures matter for any backfill decision. HSBC Hong Kong's eStatement archive retains seven years of formal statements, which is the window for tax, audit, and dispute-resolution purposes. Electronic advices (eAdvice) retain only three months, a meaningfully shorter window, so transactional notifications beyond that period need to be reconstructed from the eStatement itself rather than pulled from eAdvice. Live-access statement periods inside Business Internet Banking are typically twelve months rolling; older periods within the seven-year window may require the dedicated eStatement retrieval flow rather than the current-statement view, and the exact path varies depending on when the account was opened and which proposition it sits under.

For bookkeepers and accountants running month-end across multiple Hong Kong banks, the HSBC Hong Kong flow differs slightly from the equivalents at other HK banks. The document outputs are structurally similar — bilingual multi-currency PDFs — but the download navigation and file conventions are bank-specific. Readers handling multi-bank books will find the Hang Seng statement extraction walkthrough and the Bank of China (Hong Kong) statement to Excel workflow useful companion pieces; the extraction logic downstream of the PDF is the same across banks, but the act of getting the PDF out of each bank's portal is not.

Extracting the PDF into Excel or CSV

A correct extraction output for this document has a predictable shape: one row per transaction, a currency column identifying which sub-ledger the transaction belongs to, per-currency opening and closing balances preserved so the running balance reconciles to the figures printed on the PDF, the bilingual narrative kept in a single memo field with Traditional Chinese characters intact, and the FPS or SWIFT/TT label either left inside the narrative or split into a separate transaction-type column. Anything less and the reconciliation work downstream gets harder rather than easier.

The practical workflow is short. Upload the eStatement PDF, write a prompt that describes what to pull and how the spreadsheet should be structured, and download the result as Excel (.xlsx), CSV (.csv), or JSON (.json) — whichever the accounting package downstream expects. The output persists in the dashboard afterwards, which matters for teams running multiple statements a month and wanting to find last quarter's extraction without re-running it.

The prompt is where the HSBC Hong Kong-specific requirements get captured. A prompt adapted from the patterns finance teams already use for month-end close might read:

I'm reconciling an HSBC Hong Kong Business Integrated Account eStatement for monthly bookkeeping. Extract: Transaction Date (YYYY-MM-DD), Value Date (where shown), Currency (the sub-ledger the transaction belongs to, e.g. HKD, USD, RMB, EUR), Narrative (keep bilingual English and Traditional Chinese text intact, and preserve the FPS or SWIFT/TT label where present), Debit Amount, Credit Amount, Running Balance. One row per transaction. Repeat Currency on every row so per-currency running balances reconcile to the opening and closing balance shown on each sub-ledger of the PDF. Retain Traditional Chinese characters as UTF-8; do not romanise or translate. Include a source-page reference so each row can be tied back to the original PDF page.

That prompt shape — goal first, then a field list, then explicit behavioural rules — is what a prompt-driven extractor needs to produce a file a bookkeeper can open directly in Excel without post-processing. The alternative of a fixed template per bank collapses quickly against the real variation in Business Integrated Account layouts: HKD-only versus HKD-plus-four-currencies, BusinessVantage versus Business Direct, monthly versus quarterly. Prompting describes the desired output once and lets the extractor handle the variation.

The output then imports naturally into the accounting package in use. Excel for internal analysis or audit working papers; CSV for import into QuickBooks, Sage, MYOB, FreeAgent, Zoho Books, and other non-Xero platforms; JSON for downstream API-driven pipelines where extracted data feeds a finance system or a cost-analysis tool. For readers handling a full year of historical HSBC Hong Kong statements in one backfill, batch processing applies the same prompt across every uploaded PDF in a single job, producing consistent outputs without re-entering instructions for each statement.

This is the capability the product is built around: bilingual and multi-currency bank statement extraction configured through a prompt rather than a fixed template. Traditional Chinese is handled inside the same language-support layer that covers the platform's broader script coverage, and the per-currency column is produced by instructing the AI on what the output should contain rather than by choosing a preset for each bank. For context on what reconciliation looks like once the structured data is in hand, the bank statement reconciliation step-by-step walkthrough covers the broader framework for tying extracted bank-statement rows back to supplier invoices and the bookkeeping ledger.

When the Xero direct bank feed is the right answer and when PDF extraction is

HSBC Hong Kong operates an officially supported Xero direct bank feed, promoted on the BusinessGo tool pages and via the Xero HSBC Hong Kong partnership, that streams transactions live from the bank into Xero without any PDF step in the middle. For customers whose accounting system is Xero, whose need is ongoing reconciliation going forward, and whose reporting sits happily at base-currency level, the feed is the simpler option. It handles the day-to-day; there is no reason to extract PDFs for transactions the feed already delivers.

The conditions under which PDF extraction is the better path are specific.

A non-Xero accounting package. QuickBooks, Sage, MYOB, FreeAgent, Zoho Books — none of these are the feed's destination. Customers on any of these platforms need structured transaction data in a format their software accepts, and that is CSV or Excel produced from the PDF.

Audit-ready Excel or CSV as the required deliverable. Live Xero ledger entries are not the same artefact as a working paper attached to an audit file. When the deliverable is a reconciled spreadsheet tied back to the source statement, extraction is the route.

History predating the feed connection. Feeds start from the date they are connected, not from the account's full history. A firm taking on a new HK client whose prior year needs bookkeeping, or backfilling a period that preceded the feed setup, needs the eStatement PDFs extracted — the feed cannot retrieve what it never saw.

A feed gap to resolve. Feeds occasionally miss transactions or lag. When the bank ledger and Xero do not reconcile, a PDF-against-ledger comparison is the resolution path, and that requires the extracted statement.

Per-currency preservation. This is the condition that catches HSBC Hong Kong customers most often. The feed flattens sub-currency ledgers into base-currency equivalents; the per-currency balances that matter for multi-currency reporting are destroyed in the process. Any customer whose reporting is genuinely multi-currency — meaning the HKD, USD, and RMB positions are individually material to the business — needs the PDF extraction path to keep them separate.

The two paths are not alternatives for the same job. A customer running Xero-only ongoing reconciliation, with no audit-working-paper requirement, no history to backfill, and reporting in base currency, is well served by the feed alone. A customer with any of the conditions above will need PDF extraction either as the primary path or as a complement to the feed — feed for the live month, extraction for the audit file and the historical backfill.

Readers whose HK books span multiple banks apply the same decision bank by bank. The Standard Chartered Hong Kong statement conversion workflow covers the same feed-versus-extraction question for a sibling HK bank with its own Xero partnership; the specific conditions change little, but the mechanics of getting the PDF out of each bank's portal are distinct.

Audit-ready output for HKICPA statutory audit work

Bank-statement data offered as audit evidence has to tie back to the source document. An HKICPA-licensed CPA reviewing a working paper will expect every transaction row to be traceable to the page of the original PDF it came from, the running balances to reconcile against the opening and closing figures printed on the statement, and no manual editing step between the raw extraction and the imported working paper that could have altered figures without a trail. A spreadsheet the bookkeeper tidied up before sending to the auditor is not an audit-acceptable artefact; a spreadsheet produced directly from the PDF, with attribution preserved, is.

In practical terms, that means the extracted file carries a per-row source-page reference identifying which PDF page each row came from, running balances broken out per currency and reconciled against the sub-ledger opening and closing figures on the statement, and the bilingual narrative preserved without edits so a reviewer checking a transaction against the source does not have to decode bookkeeper cleanup along the way.

An HSBC HK statement for audit preparation follows a short sequence. Pull the formal eStatement PDFs for the full audit period — for a statutory audit, that typically spans the financial year, drawing from the seven-year eStatement archive covered earlier. Run the extraction to produce the reconciled per-currency working paper. Attach both the original PDF and the extracted spreadsheet to the audit file so the trail from source document to working paper is complete.

The capability that matters for this workflow is the automatic per-row source-file and page-number attribution: every row in the output spreadsheet carries a reference back to the PDF page it came from, which is the audit-trail property an HKICPA reviewer expects the working paper to provide. That is not a formal audit certification of the bank statement itself — that remains the bank's responsibility — but it removes the manual cross-referencing step that tends to be the slowest part of audit preparation.

For multi-bank engagements, the same audit-trail logic applies regardless of which HK bank issued the PDF. An HKICPA reviewer looks for the same properties across HSBC Hong Kong, Hang Seng, Standard Chartered Hong Kong, and Bank of China (Hong Kong) working papers: source-document attribution, reconciled balances, no silent edits. The Hong Kong statutory audit documentation requirements walkthrough covers the broader framing of what the full audit file should contain alongside the bank-statement working paper.