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.

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.

  1. Step 1

    Connect Xero

    Link your org and pick the account that has no feed.

  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

    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 Santander and Xero

Related accounts

Stop importing Santander statements. Start feeding them.

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

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