New: Export Bank Statements Straight Into Xero

This morning I emailed some of our most active customers with one question: what would make HSBC Statement Converter something your team could not do without?

About an hour later, an accounting firm that has converted close to 3,000 pages with us since May replied with a single, clear answer:

"Main thing for us I would say is to allow us to export into a csv file that follows the same template as Xero."

So we built it. Every converted statement now has a Xero (.csv) download option.

Why the normal CSV wasn't good enough

Our standard CSV is built to be read by people: separate Money In and Money Out columns, a running balance, and the transaction type. That is what you want when you're checking a statement in Excel.

Xero's bank statement import wants something different. It expects a single amount column where money out is negative, a date it can parse without guessing, and no balance or type columns. Importing our standard CSV worked, but it meant fiddling with the column mapping every time, and two separate amount columns don't map cleanly at all. For a firm importing dozens of statements a week, that adds up.

What the Xero export looks like

Date	Amount	Payee	Description	Reference
14/03/2026	-54.34	LLOYDS CASHBACK	Direct debit
14/03/2026	1600.00	ACME LTD INVOICE 1042	Credit

• One signed amount. Money in is positive, money out is negative, exactly as Xero expects.
• Dates in DD/MM/YYYY. Banks print dates in every format imaginable; we normalise them so Xero never reads 03/04 as the wrong month.
• A date on every line. Many banks print the date once per day. Xero rejects lines without a date, so each transaction carries the date it belongs to.
• No balance lines. "Balance brought forward" rows aren't transactions, and Xero rejects zero-amount lines, so they are left out.
• The full bank description as the payee, so Xero's bank rules and reconciliation suggestions have something to match on.

How to import it into Xero

1. Convert your statement as usual and open the download menu
2. Choose "Xero (.csv)"
3. In Xero, go to the bank account you're importing into and choose Import a Statement
4. Upload the file. The columns are already named the way Xero names them, so the mapping step is a confirmation rather than a puzzle
5. Reconcile the lines as you normally would

One tip: if your statement period overlaps a period that is already in Xero, check the date range before importing so you don't create duplicate lines.

What's next

We already categorise every transaction — income by source, HMRC, wages, suppliers, director transfers and so on. The obvious next step is carrying those categories into the Xero file so lines arrive pre-coded to your chart of accounts. If that would save your team time, tell me; the requests we get are what we build next.

And thank you to the firm that asked. One email, one sentence, one new feature the same day. That's the kind of feedback that makes this product better for everyone.