How to export from HSBC
Before using StatementFlow you need the CSV from your HSBC account.
Where to find itExport from HSBC online banking: Statements → Download → CSV
What StatementFlow fixes
HSBC gives you a clean CSV or a digital PDF statement, but the column names and formats don't match what Xero expects on import. StatementFlow renames the columns, reformats the dates, and cleans any values that would make Xero reject the file - all in your browser, no upload and no OCR.
Column transformations applied
Date → Date (reformatted to UK date (DD/MM/YYYY))
Description → Description (trimmed)
Paid In → Credit (strip_currency)
Paid Out → Debit (strip_currency)
How to use this preset
1. Export your CSV from HSBC using the instructions above.
2. Click "Get started free" — the preset loads automatically.
3. Drop your CSV into StatementFlow.
4. Review the changes — dates reformatted, columns renamed.
5. Download the fixed file and import it into Xero.
Common questions
How do I convert a HSBC CSV to Xero format?
StatementFlow re-shapes your HSBC CSV export into the column layout Xero expects - renaming columns, reformatting dates and cleaning values - entirely in your browser. Typical run time is under a minute. It also reads digital HSBC PDF statements the same way.
Is this different from the usual PDF bank statement converters?
Yes. Most PDF converters upload your statement to a server and OCR-guess the numbers off an image. StatementFlow reads the text in a digital PDF or a CSV right in your browser - nothing uploaded, no OCR - and checks every figure against the statement's own balance before you export.
What does StatementFlow change in the HSBC export?
Date → Date (reformatted to UK date (DD/MM/YYYY)); Description → Description (trimmed); Paid In → Credit (strip_currency); Paid Out → Debit (strip_currency).
Does my file get uploaded to a server?
No. All processing happens in your browser. Your file data never leaves your computer.