Barclays bank feed not working in Xero? Post the missing period as feed lines

Where the native Barclays feed falls short

Barclays business accounts connect to Xero over open banking on a 90-day consent, replacing the paid direct feed that PSD2 retired in March 2020. Xero's guidance is blunt about the consequence: open banking coverage does not match what the old feed reached, and an account type that does not appear on the connect screen is not available at all. Barclaycard Business is the one people run into most.

Barclays is the clearest example of a feed getting worse rather than better. PSD2 took effect in March 2020 and retired the old paid direct feed; the open banking connection that replaced it does not reach every account the old one did, and Xero's own guidance says so. The practical test is the connect screen: if the account type is not listed there, it is not available over open banking, and the documented answer is to import statements by hand. Barclaycard Business is the account this bites most often - community threads asking why it will not connect have been running for years, including a standing request on Xero's ideas board from somebody who has never got it to work. Barclays.net, the corporate platform, sits in similar territory. Reauthorisation carries its own friction: the 90-day renewal runs through Barclays online banking, and an error part-way through usually means logging in with the PINsentry card reader rather than the app. Whichever of these applies, the gap is the same shape - a period that exists on a statement and nowhere in Xero. StatementClear takes the PDF, CSV or Excel export Barclays or Barclaycard already gives you, maps the columns once, checks the running balance against the statement, and posts the lines through Xero's Bank Feeds API so they arrive as feed lines rather than as an import.

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 Barclays 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 Barclays 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

• HSBC bank feed for Xero: post the days and months the feed misses
• NatWest bank feed for Xero: post the periods the feed did not deliver
• Santander bank feed issues in Xero? Post the missing transactions as feed lines
• Credit card bank feed for Xero: for the cards Xero cannot feed