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

A Barclays feed that has stopped is usually expired 90-day open banking consent, renewable from Xero. A Barclays or Barclaycard account that never appeared on the connect screen is not available over open banking at all, because that coverage is narrower than the paid feed PSD2 retired. Either way, StatementClear posts the statements into Xero as feed lines.

Barclays feeds fail in two different ways and only one of them is worth troubleshooting. A feed that worked and stopped is usually the 90-day consent, renewable from Xero once you can get through Barclays online banking - which may want the PINsentry reader before it lets you. An account that never appeared on the connect screen is the other case, and no amount of reconnecting will conjure it: open banking coverage is narrower than the paid direct feed it replaced. Either way there is a period of transactions the feed will not deliver. StatementClear posts Barclays and Barclaycard statements into Xero as live feed lines, deduped and balance-checked.

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 has no feed.

  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

Related accounts

Stop importing Barclays statements. Start feeding them.

Tell us how your Barclays setup is structured and we'll get you connected.

Browse every bank and platform or read the Xero bank feed guides.