Santander bank feed issues in Xero? Post the missing transactions as feed lines

Where the native Santander feed falls short

Santander Business Banking connects to Xero over open banking on a periodic consent. Personal accounts do not, which catches sole traders running a business through one. Santander Corporate Banking is a different login altogether - a Company ID, a User ID and its own password - and practitioners on Xero's community and AccountingWEB report reconnections that hang and transactions arriving weeks after the date they carry.

Santander's problem is not usually a dead feed, it is a feed you cannot fully trust. Practitioners on Xero's community and on AccountingWEB have described two recurring patterns: a reconnection that authorises and then hangs, and transactions appearing in Xero weeks after the date they carry. The second is the dangerous one, because nothing looks broken - the account shows a feed, recent lines are there, and the hole only surfaces when a reconciliation will not balance or a VAT return is being checked. Eligibility is the other half of it. Feeds are offered on Santander Business Banking and not on personal accounts, which is a real problem for sole traders and small partnerships running everything through one account: the connect screen simply has nothing for them. Santander Corporate Banking is a separate proposition again, with a Company ID, a User ID and its own password, and authorising a feed across that is a job in itself. The periodic open banking consent applies on top of all of it. A month that arrived late through the feed will not post twice, and a month that never arrived at all can be posted in full.

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 Santander 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 Santander 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
• 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
• No Xero feed for your foreign bank account? Import its statements as one.