HSBC bank feed for Xero: post the days and months the feed misses

Where the native HSBC feed falls short

HSBC UK has a direct Xero feed covering business current, savings, credit card and foreign currency accounts, importing twice a day on a 90-day open banking consent with up to twelve months of history shared at setup. Transactions arrive on a deliberate 24-hour delay, HSBC Kinetic runs on a separate feed of its own, and corporate accounts need third-party provider permissions enabled in HSBCnet before they will connect at all.

Three HSBC-specific things decide whether the feed actually covers you. The first is the 24-hour delay. HSBC lets a transaction's reference change within a day of posting, so Xero holds new lines back rather than import them and then correct them - documented behaviour rather than a fault, and the reason the account never shows today's activity. It has its own long-running request on Xero's product ideas board. The second is HSBC Kinetic, which the main HSBC UK feed does not cover. Kinetic connects on a feed of its own, only from a mobile device, and only from the same handset the Kinetic app was installed and signed into at least once - awkward when the person reconciling is not the person holding the phone. The third is corporate: HSBC Corporate accounts will not connect until third-party provider permissions are switched on in HSBCnet, which is an internal request inside the bank rather than a setting in Xero. On top of those, the ordinary limits apply. Consent expires every 90 days and the feed stops on the expiry date, not on the day somebody notices. Backfill is capped at twelve months, so an older account's early history has to come from statements either way. A credit card feed is created against the master account and brings the subsidiary cards in with it, so the cards arrive as one combined feed. StatementClear works from the statements HSBC already gives you in PDF, CSV or Excel: upload the missing period, map the columns once, and dedupe checks every line against what has already posted, so covering a gap never double-counts the overlap.

The manual way, every month

• Log in and export a statement (and hope the format didn't change)
• Reformat columns, dates and signs until Xero's importer accepts it
• Upload the CSV into the right account and pray nothing doubled up
• Eyeball the balance, fix what broke, repeat next month

And after all that, it still isn't a feed - it's a one-off import you'll redo next month.

The StatementClear way: a real feed

Upload the statement and it posts into Xero as a live bank feed through Xero's Bank Feeds API - deduped, balance-checked and ready to reconcile. Not another file to import. Converters hand you a CSV; this arrives in Xero the way a bank feed does.

1. Step 1

   Connect Xero

   Link your org and pick the account that is missing transactions.

2. Step 2

   Upload your HSBC statement

   PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.

3. Step 3

   We check it first

   Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.

4. Step 4

   It lands as a feed

   Clean lines arrive in Xero through the Bank Feeds API, ready to reconcile.

Questions about HSBC and Xero

Where this comes from

Everything above about what Xero's native feed covers, what its manual import accepts and how feed lines reach a bank account comes from Xero's own documentation. The relevant pages are below, so you can check the claim rather than take it.

• About bank feedsXero's own account of which feeds exist, how they connect and what they do not cover.
• Import a CSV bank statementThe manual import: the formats it accepts, and how it handles lines it has seen before.
• Bank Feeds API overviewThe interface StatementClear posts through, and the reason a fed line is not an imported one.

Related accounts

• Barclays bank feed not working in Xero? Post the missing period as feed lines
• NatWest bank feed for Xero: post the periods the feed did not deliver
• Credit card bank feed for Xero: for the cards Xero cannot feed
• No Xero feed for your foreign bank account? Import its statements as one.