hsbc bank statement example

Name the market, account and currency first

An HSBC statement issued in one country will differ from one issued in another in its identifiers, date convention, payment vocabulary and currency. Before reading an amount, establish which market issued the document and which currency the figures are denominated in. Record both with every row you extract; without them a later reader cannot tell what the numbers mean.

Where a relationship spans markets, the same customer can hold accounts whose statements look quite unlike each other. That is expected, and it is why a parser that worked on last month's document may need checking against this one.

A multi-currency relationship has several balances

If you hold balances in more than one currency, each has its own opening and closing figure and its own period activity. They do not aggregate without an explicit conversion decision, and that decision is yours: which rate, as at which date, and for what purpose.

Reconcile each currency separately. A combined figure produced by a spreadsheet adding numbers from different currency columns is not a balance, it is an artefact.

Foreign exchange information belongs with the transaction

A cross-border transfer or a card purchase in another currency may carry exchange details: the original amount, the converted amount and sometimes the rate or a fee. Those elements belong together. Keeping only the converted figure leaves you with a number you cannot explain, and keeping only the original leaves you with one that does not reconcile against the balance.

Give the original amount, the original currency and the converted amount their own columns at extraction time.

Moving money between HSBC currency balances

Internal movements between accounts, especially across currencies, appear on two statements with two different amounts. They are not income and not spending. Tag them at extraction; matching them later by amount is impossible when an exchange rate separated the two sides.

A date difference between the debit and the credit is also normal when the accounts sit in different markets.

Reconciling one account at a time

Each currency's own balances and activity form their own identity to verify. Only after each passes should you assemble an overall view, and then with currency and internal-transfer columns present.

Shadow any per-line balance with your own calculation; the line where they stop agreeing is the one to examine.

Obtaining the documents

Request one file per account and per currency from your own HSBC banking. Keep the currency in the file name so the context is obvious when you return to the folder.

The issued PDF is the record. Any spreadsheet you build from it is a working copy.

Several currencies behind this hsbc bank statement example

Market and currency head this list because an HSBC relationship can produce several statements that look alike but are not comparable.

An HSBC dataset is trustworthy when:

• Every row names the issuing market and its currency
• Original and converted amounts were both retained for FX transactions
• Each currency balance reconciles on its own before any aggregate

Three currencies here, one on a domestic account

A single-currency domestic statement needs none of this bookkeeping, which is the clearest contrast available. UK scheme documentation, where the account sits in that market, comes from Pay.UK, which operates the UK retail payment systems.

The authentic file goes to the Excel converter or the CSV converter; the extraction guide documents the checks.

HSBC bank statement example: FX rows and reporting currency