HSBC · statement conversion
Convert HSBC bank statements to Excel, Xero or QuickBooks
HSBC's statement tables are instantly recognisable by one header: “Payment type and details”, a combined narrative column that mixes the transaction type (VIS, DD, BP, TFR) with the payee text. Rowford's HSBC template keys on that vocabulary, alongside Paid out / Paid in columns, and keeps the full narrative intact in your exports.
Full preview & reconciliation free · export from $39 one-time · nothing uploaded
How Rowford reads a HSBC statement
The HSBC template matches the columns as HSBC prints them — separate money-in and money-out columns folded into one signed amount for export:
DatePayment type and detailsPaid outPaid inBalance
- “Payment type and details” is treated as the description column — type codes like DD or VIS stay in the narrative, because bookkeepers use them to spot direct debits and card payments at a glance.
- Multi-page HSBC statements repeat the column headers on every page; the parser recognises repeated header rows by their signature and skips them so they never appear as phantom transactions.
- Paid out / Paid in are unsigned columns folded into signed amounts (paid out = negative) for export.
What ends up in your export
Date (re-formatted per target: dd/mm/yyyy for Xero, QuickBooks, Sage and FreeAgent), the full description as printed, the signed amount, and — in the generic CSV and Excel formats — the running balance. Every row carries a confidence score in the preview, and the whole statement must reconcile (opening + transactions = closing) before you rely on it. Deterministic, template-based extraction: the same statement produces the same output, every time.
HSBC questions
Which HSBC statements work?
Digital PDF statements from HSBC UK online banking — personal and business current accounts using the Paid out / Paid in layout. Scans are refused rather than OCR’d.
What happens to the HSBC transaction type codes (DD, VIS, BP)?
They are kept, as printed, at the start of the description — nothing is stripped or rewritten. If you prefer them gone for a particular workflow, they are trivially removable in your spreadsheet after export.
My HSBC statement runs to six pages — is that a problem?
No. Pages are read in order, per-page repeated headers are skipped automatically, and the reconciliation check runs across the whole statement, opening balance to closing balance.