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 periodic 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.

The manual way, every month

• Download the statement for the missing period
• Check the file format, dates and signed amounts
• Import into the correct Xero account and review overlaps
• Compare the closing balance and reconcile the lines

A usable CSV or OFX from the provider may be enough. Native PDF import is also available for eligible US and Canadian Xero organisations.

Review the statement, then choose how to import it

Preview the extraction, check the transactions, then send eligible lines through Xero's Bank Feeds API or download a Xero-ready CSV. Direct delivery supports dates within the last year and can be blocked by another provider's feed connection. Use CSV for older history. Overlap checks cover previous uploads to the same StatementClear feed, so also check any period already imported from other sources.

1. Step 1

   Start with your statement

   Preview a file before choosing how to get it into Xero.

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

   Review dates, amounts and signs. Balance checks use the source data, and overlap checks use prior StatementClear uploads.

4. Step 4

   Send to Xero or download CSV

   Send eligible lines directly to Xero or download a Xero-ready CSV. You complete reconciliation in Xero.

See the PDF-to-Xero workflow · Check PDF import in your region

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.

• Import a PDF bank statementNative PDF import in the US and Canada, with plan and document requirements. Checked 30 September 2026.
• 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