HSBC statements use separate "Paid out" and "Money in" columns — a layout that breaks naive CSV attempts, because every figure reads as positive. Conversion fixes the signs first; then Xero's OFX import needs no mapping at all.
Convert the statement first
- Upload the HSBC PDF to the converter.
- NoRekey infers each row's sign from its column — money out negative, money in positive — and verifies every sign against the running balance. Descriptions split across lines are stitched back together.
- Download the OFX export (or CSV if you prefer to map columns).
Import into Xero
- In Xero, open the bank account and choose Manage account → Import a statement.
- Select the OFX file. Xero reads dates, descriptions and signed amounts directly — no mapping screen.
- Reconcile as you would with a live feed.
HSBC-specific notes
- Day-grouped balances: HSBC often prints a balance only on the last transaction of each day. The conversion handles balance-less rows natively — the day-close figures anchor the verification.
- Business and personal statements both convert; import each account into its matching Xero bank account (currencies must match — Xero enforces this, correctly).
Reconciling
The statement balance in Xero should land exactly on the statement's printed closing balance, because the conversion had to reconcile before export. If it doesn't, check for an overlapping bank feed — see duplicate transactions after import.