How to Convert an HSBC Statement to CSV
HSBC UK produces statement PDFs in noticeably different layouts depending on the product: a personal Bank Account statement does not look like a Premier statement, which does not look like a Kinetic business statement. That layout variety is why generic PDF-to-CSV tools often mangle HSBC statements, misreading columns or dropping the balance.
Here is the reliable route from any HSBC statement to a clean CSV.
Download the statement from HSBC
In the HSBC UK app, open the account, tap Account details, then Statements, pick the month and download the PDF. In online banking it is under Statements in the account view. HSBC keeps several years of statements available, so you can pull a full history if you need it.
Convert it in the browser
Drop the PDF onto PivotBank. The parser recognises HSBC's layouts specifically, including the paid out / paid in / balance column arrangement and multi-line descriptions, and shows every extracted transaction in a preview grid. The running balance is recalculated across the whole statement as a correctness check: if the numbers do not chain, you will see exactly where.
Nothing is uploaded at any point. The statement is parsed locally in your browser, which is why the tool is safe for client statements as well as your own.
What the CSV looks like
The export gives you one row per transaction with columns for date, type, description, money out, money in and balance. That structure imports directly into Excel, Google Sheets, Xero, QuickBooks and Sage. If you prefer a single signed amount column (some tools want that), choose CSV and pick the signed-amount layout on export.
Scanned and older HSBC statements
Paper statements that were scanned or photographed also work: PivotBank runs OCR in the browser when it detects a non-digital PDF. Accuracy on clean scans is high, and the balance verification acts as the safety net, since OCR mistakes almost always break the balance chain and get flagged.
For a full walkthrough of HSBC specifics, formats and FAQs, see the dedicated HSBC statement converter page.