What statement period can I convert in a single PDF?

HSBC's online banking lets you generate PDFs for any statement cycle (typically monthly), plus custom date ranges up to 7 years back via the 'Search transactions' feature. The converter handles up to 100 pages per upload — enough for 18+ months of an active personal account or 6+ months of a busy business account.

How are credits and debits handled in the CSV?

HSBC PDFs use separate Money Out (debit) and Money In (credit) columns and the CSV preserves that schema. Both columns are unsigned positive numbers so SUM() formulas work correctly. If your accounting software needs a single signed Amount column instead, use Excel's =MoneyIn-MoneyOut formula on import.

How do I import the CSV into Xero or QuickBooks?

For Xero: go to Bank Accounts → Manage Account → Import a Statement, choose 'Generic CSV', map Date → Date, Description → Description, Money Out → Spent, Money In → Received. For QuickBooks Online: select 'Three-column CSV' on import. For Sage and FreeAgent the headers are auto-detected.

Does this work with HSBC InvoiceFinance or HSBCnet exports?

HSBCnet already exports CSV directly — use that instead. This tool is for the standard PDF statements you download from HSBC personal and Business Internet Banking.

Can I convert several months at once?

Yes. Upload up to 12 HSBC PDFs in one batch and you'll get a single consolidated CSV sorted by date, with duplicate rows from overlapping statement periods automatically deduplicated.

Convert HSBC PDF Statements to CSV

HSBC UK issues bank statements as locked-down PDFs that don't open cleanly in Excel, Xero, or QuickBooks. This converter parses HSBC personal current account, HSBC Business Banking, and HSBC credit card statements into a tidy CSV with one row per transaction — date, description, money in, money out, and running balance — ready to import or pivot.

Built around how HSBC formats its statements

HSBC personal statements use a multi-column layout where the description can wrap across two or three lines and where Direct Debits, Faster Payments, and standing orders are tagged with codes like DD, FPI, FPO, SO, and BP. Naive PDF extractors break those rows apart and produce a CSV that takes longer to clean than to type out by hand. This tool understands the HSBC layout and keeps each transaction on a single row, with the wrapped description text re-joined and the transaction code preserved as a prefix.

HSBC Business Banking statements add a Sort Code and Account Number header on every page plus a continuation banner. Those repeated rows are stripped automatically so they don't pollute your data. Card statements (HSBC Credit Card, Premier Mastercard, and Advance) are detected separately because they use a different column order — the converter normalises them to the same schema as the current account output so a single Xero or QuickBooks import map works for everything.

Common HSBC bookkeeping workflows

Most users land here for one of three reasons. The first is monthly reconciliation: you've downloaded last month's PDF from HSBC online banking, but Xero's bank feed missed a few days or the feed dropped entirely. Convert the PDF, import the CSV via Xero's Manual Statement Import, and the gap closes in under a minute.

The second is year-end and Self Assessment. HMRC's January deadline drives a wave of sole traders and limited company directors needing 12 or 24 months of HSBC history in spreadsheet form. You can drop a folder of HSBC PDFs in one upload and get a single CSV back, sorted by date.

The third is forensic and audit work — solicitors, insolvency practitioners, and forensic accountants need HSBC transaction history in a structured format for disclosure bundles or asset tracing. The CSV preserves the running balance column so opening and closing balances can be verified against the original PDF.

What you get in the CSV

Columns are: Date (DD/MM/YYYY, UK format), Type (DD, FPI, FPO, SO, BP, CR, ATM, etc.), Description, Money Out, Money In, and Balance. Negative balances are kept as negatives rather than parentheses so Excel and Google Sheets sum them correctly. The first row is a header so you can hand the file straight to Xero, QuickBooks Online, FreeAgent, or Sage Business Cloud Accounting without remapping.

How it works

Upload HSBC PDF — Personal, business, or credit card statement
Auto-Parse Transactions — Date, description, amount, balance extracted
Download CSV — Import directly into Xero or QuickBooks

Key benefits

Handles HSBC personal current account format
Works with HSBC Business Banking statements
Supports HSBC credit card statements
DD/MM/YYYY dates parsed correctly for UK accounting software
Multi-page statements processed in one pass
Files auto-deleted after 1 hour — no permanent storage

Common use cases

Monthly bookkeeping for HSBC business accounts
Year-end reconciliation for sole traders
Importing 12 months of statements before tax deadline

Frequently asked questions

What statement period can I convert in a single PDF?: HSBC's online banking lets you generate PDFs for any statement cycle (typically monthly), plus custom date ranges up to 7 years back via the 'Search transactions' feature. The converter handles up to 100 pages per upload — enough for 18+ months of an active personal account or 6+ months of a busy business account.
How are credits and debits handled in the CSV?: HSBC PDFs use separate Money Out (debit) and Money In (credit) columns and the CSV preserves that schema. Both columns are unsigned positive numbers so SUM() formulas work correctly. If your accounting software needs a single signed Amount column instead, use Excel's =MoneyIn-MoneyOut formula on import.
How do I import the CSV into Xero or QuickBooks?: For Xero: go to Bank Accounts → Manage Account → Import a Statement, choose 'Generic CSV', map Date → Date, Description → Description, Money Out → Spent, Money In → Received. For QuickBooks Online: select 'Three-column CSV' on import. For Sage and FreeAgent the headers are auto-detected.
Does this work with HSBC InvoiceFinance or HSBCnet exports?: HSBCnet already exports CSV directly — use that instead. This tool is for the standard PDF statements you download from HSBC personal and Business Internet Banking.
Can I convert several months at once?: Yes. Upload up to 12 HSBC PDFs in one batch and you'll get a single consolidated CSV sorted by date, with duplicate rows from overlapping statement periods automatically deduplicated.