HSBC UK Statements to Excel: Native CSV and Search-Filter Checks

HSBC UK offers XLS and CSV from the transaction list; inspect that native route first. This guide covers the UK product and the task described below.

Export the transaction search when it matches your task

HSBC UK’s official help describes XLS and CSV downloads from the transaction list, separately from PDF statements. Choose the account, open Search and filter, set the relevant conditions, run the search and use Download below the results. Inspect the actual offered format and coverage. A native file is usually the first source to consider for tabular analysis; it does not guarantee the dates needed for every task.

This guide concerns the UK account’s offered activity. It does not reproduce HSBC’s file headers or validate any real statement layout. Keep the untouched bank file before creating a smaller working view. If PDF is the record available to you, collect the issued HSBC document and compare manual or extracted rows with it.

Document the filter before comparing a total

A selected keyword, amount or date condition can intentionally exclude valid transactions. That is useful for a merchant search but can invalidate a full-cycle balance check. Save the search conditions in a private source register. For a complete-cycle task, inspect and clear irrelevant restrictions instead of assuming every exported file contains all movements.

Suppose an invented cycle has receipts of 250 and outflows of 100 and 10. A search that excludes the 10-unit fee leaves a plausible two-row table but changes the net movement. Do not add an unexplained balancing entry. Check the filter, coverage, pages and source meanings until the omission is resolved. The arithmetic exercise below illustrates that discrepancy without claiming it occurred in HSBC.

Define one cash convention and one date basis

For a deposit-account working table, use positive for posted inflows and negative for outflows. Inspect the actual source to determine the date represented; the export date is source metadata. Keep another meaningful date or category in a separate worksheet column if required. Do not apply deposit-cash signs to a card liability without a different documented interpretation. A manually prepared example is:

date,description,amount
2026-09-01,Example receipt,250.00
2026-09-02,"Example supplier, office",-100.00
2026-09-03,Example fee,-10.00

Import the working CSV through Data → From Text/CSV in Excel, inspect comma separation, dates and decimal numbers, then load. Microsoft’s import guide explains the preview; RFC 4180 describes quoting a description containing a comma. These are invented rows, not HSBC’s export format. Save XLSX in Excel after checking; LocalExtract exports CSV.

Compare opening plus signed movements with closing only when those figures describe the same account, currency and complete period. A search subset needs its own labelled analysis. Even a matching total does not verify every date, description or row.

Check the method with invented records

We recomputed three deliberately constructed cases on October 11, 2026 using decimal arithmetic: complete rows, an omitted fee and a duplicated movement. The reference total and every number are invented. This checks the reconciliation method only: no bank account, real PDF, OCR result or LocalExtract output was tested. The same learning aid is used across these guides.

Illustrative units, not a real account balance.

Download the blank document checklist or synthetic check data. CSV · JSON.

Frequently Asked Questions

Does HSBC UK provide a native table?

The official help describes XLS and CSV from transaction search. Inspect the actual file and offered dates for your account.

Why does my merchant-search total differ from the statement?

A keyword or amount restriction can intentionally omit other movements. Label it a subset and do not reconcile it as the full cycle.

Can I add a balancing row to fix a discrepancy?

Do not invent a transaction. Check filters, account, period, missing rows and signs against the original until the cause is identified.

Is the example an HSBC CSV?

No. It is an invented three-field working table. No native column layout, real PDF or app output was validated.

If PDF is the relevant source

LocalExtract processes one PDF at a time on the device and exports CSV with date,description,amount. Parsing and OCR do not require uploading the statement. This is a working table that needs comparison with the original; no bank compatibility was validated here. There is no direct XLSX, QBO or OFX export, bulk queue or automatic accounting sync. To obtain XLSX, import the checked CSV and save from Excel.

The free evaluation covers ten pages in total. Pro is USD 10/month or USD 60/year. Account, subscription, update and periodic Pro checks need network access. See downloads and product scope.

Sources and verification scope

Public official guidance checked October 11, 2026. Account controls, document availability and bank layouts were not authenticated-tested. The method exercises use invented records, not actual bank samples or measured extraction results.

• Bank guidance 1

Updated October 11, 2026: Added task-specific source decisions, date/amount examples and CSV import checks. No bank format or app output was validated.

Use the available native table, preserve its search conditions and distinguish subset analysis from full-cycle reconciliation. Trial PDF extraction only when PDF is the relevant source you have.