Santander bank feed issues in Xero? Post the missing transactions as feed lines
Santander Business Banking has a Xero feed; personal accounts do not, and practitioners report reconnections that hang and transactions arriving weeks after their date. A feed that delivers late looks healthy until a reconciliation will not balance. StatementClear posts Santander statements into Xero as feed lines, deduped against whatever the feed eventually delivers.
Santander is the one where the feed is technically there and the transactions still are not. Xero community and AccountingWEB threads describe reconnections that hang after being authorised, and lines that turn up weeks after the date they carry - which is worse than a clean break, because the account looks fed and nobody checks it until a reconciliation refuses to balance. Add a personal account that cannot be connected at all, and a corporate platform with its own login, and somebody ends up verifying against the statement anyway. StatementClear posts Santander statements into Xero as live feed lines, deduped and balance-checked.
14 days, no card. Connect Xero and post a real statement before you decide anything.
Where the native Santander feed falls short
Santander Business Banking connects to Xero over open banking on a 90-day 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 90-day open banking consent applies on top of all of it. StatementClear takes a different route to the same ledger: download the statement Santander already produces as PDF, CSV or Excel, map the columns once, and every line is compared against what has already posted and checked against the running balance before it goes anywhere. 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
- 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.
- Step 1
Connect Xero
Link your org and pick the account that is missing transactions.
- Step 2
Upload your Santander statement
PDF, CSV or Excel - whatever you can export. Map the columns once and we remember the mapping.
- Step 3
We check it first
Duplicates are skipped, the running balance is verified, and sign errors are caught before anything posts.
- Step 4
It lands as a feed
Clean lines arrive in Xero through the Bank Feeds API, ready to reconcile.
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.
- 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
Stop importing Santander statements. Start feeding them.
Connect Xero, drop in a Santander statement, and watch the lines arrive as feed lines.
14 days, no card. Connect Xero and post a real statement before you decide anything.
Browse every bank and platform or read the Xero bank feed guides.