How to Import HSBC Bank Statement into Xero

To import your HSBC statement into Xero: download your PDF from uk.hsbc.com → My Banking → Accounts → Statements & Documents, convert it to CSV using Bank Statement Converter (free, under 20 seconds), then upload via Accounting → Bank Accounts → Import a Statement. No manual re-keying — all transactions transfer automatically.

Step 1: Download Your HSBC Statement

  1. 1. Log in at uk.hsbc.com and select your account from the Accounts overview
  2. 2. Click 'Statements & Documents' in the left-hand account menu
  3. 3. Select the statement period (month and year) you need
  4. 4. Click 'View statement' to open the PDF in your browser
  5. 5. Click the download icon or use your browser's Save option to save the PDF

Step 2: Convert PDF with Bank Statement Converter

Upload your PDF to Bank Statement Converter — select CSV output — download in under 20 seconds.

Step 3: Import into Xero

  1. 1. In Xero, go to Accounting → Bank Accounts
  2. 2. Select the bank account you want to reconcile
  3. 3. Click 'Import a Statement' (or 'Manage Account → Import a Statement')
  4. 4. Click 'Browse' and select your CSV file from Bank Statement Converter
  5. 5. Map the columns: Date → Date, Description → Payee, Amount → Amount
  6. 6. Click 'Import' — transactions appear in your bank reconciliation feed

Frequently Asked Questions

How do I download my HSBC bank statement?
Log in at uk.hsbc.com and select your account from the Accounts overview → Click 'Statements & Documents' in the left-hand account menu → Select the statement period (month and year) you need → Click 'View statement' to open the PDF in your browser → Click the download icon or use your browser's Save option to save the PDF
What CSV format does Xero require for bank import?
Xero expects a CSV with at minimum: Date, Description (or Payee), and Amount. Credits are positive values; debits are negative. Bank Statement Converter outputs a Debit and Credit column — combine into a single Amount column in Excel before importing to Xero.
Can I import OFX into Xero?
Yes. Xero also accepts OFX format. Select OFX/QBO output in Bank Statement Converter if you prefer OFX over CSV — Xero handles both equally well.
Does Xero automatically categorize imported transactions?
Xero applies Bank Rules to auto-categorize recurring transactions (e.g., always coding 'Stripe' as Sales). New transactions require manual categorization in the reconciliation screen.
Is my HSBC data safe to upload?
Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup