What we do
Tools
Industries
Department
How we workLet's talk →
Home/Xero/Xero Bank Feeds
Xero

Bank Feeds in Xero: How to Connect One, and What to Do When It Goes Quiet

You've just added the business account and want transactions flowing in, or the Reconcile tab hasn't shown anything new since Tuesday. A Xero bank feed brings statement lines from your bank into Xero on its own. It arrives one of two ways: a direct feed, where Xero has an agreement with your bank, or a third-party connection such as Yodlee for banks without one. Where there's no feed, or a feed leaves a gap, a statement file fills in.

Adding a bank feed in Xero

  1. 1

    Open Add Bank Account

    Accounting Bank accounts Add Bank Account

    Search for your bank and pick it from the results. Payment providers such as Stripe and PayPal can be added here too, and there's no limit on how many accounts you connect.

  2. 2

    Authorize at your bank

    Follow the prompts to sign in on your bank's own screen, or give consent on its open banking page in markets that use one, and choose which accounts to connect.

  3. 3

    Pull history if it is offered

    Some feeds offer to bring in earlier transactions when you connect. If the option isn't there, import a statement file for the earlier dates.

    Watch for: the date the feed starts from. Lines before it come from a file, and lines after it should only come from the feed.

  4. 4

    Refresh before you reconcile

    Direct feeds update on their own. Many Yodlee-powered connections can be refreshed from Xero when you're ready to work. Clearing the lines after that is covered on the Xero bank reconciliation page.

A direct feed or a Yodlee-powered connection

Direct feed

An agreement between Xero and your bank

  • Lines arrive automatically once you've authorized it.
  • Statement lines show up ready to reconcile, with no file to download.
  • Authorized at the bank, through its own login or open banking consent.
Yodlee-powered

A third-party connection where Xero has no agreement

  • Reaches thousands of online banking sites and financial institutions.
  • Some connections sign in with your banking login, and new multi-factor prompts at the bank can interrupt them.
  • Usually refreshable by hand from inside Xero.

If Xero offers a direct feed for your bank, take it. Use a Yodlee connection where there isn't one, and expect to renew it now and then.

When a Xero feed goes quiet or skips days

The connection needs renewing

How you'll know: No new lines for several days, and the bank account in Xero shows a message about its connection.

Fix: Reconnect from that account in Xero and go through your bank's authorization again. On a Yodlee connection that uses your banking login, update the saved login if you've changed your password.

Days missing between two dates

How you'll know: The feed is working again, but the days it was down never came through.

Fix: If your feed offers to pull earlier transactions, try that first. If not, download a statement file for just those dates from online banking and import it.

A bank login that now asks for a code

How you'll know: A Yodlee-powered feed that ran fine stops after the bank adds multi-factor sign-in.

Fix: Search for the bank again in Add Bank Account. If Xero now offers a direct feed for it, switch to that.

An import that overlapped the feed

How you'll know: Lines show up in pairs for the days your file and the feed both covered.

Fix: Remove the imported copies from the account's bank statements list, never the feed's own lines, and cut the next file to the missing dates only.

Importing a bank statement into Xero when there is no feed

From the bank account in Xero, open Manage Account, choose Import a Statement, and upload a file exported from online banking in OFX, QIF, QBO, QFX or CSV. With a CSV you can check and adjust the columns in Xero before the import is final.

Imports work. They also only happen when someone remembers, and a bank CSV often needs its columns rearranged first. For accounts that will never have a feed, n-frames builds the export step: it takes the bank's or provider's own export or API, reshapes it into Xero's import layout, and trims it to the dates Xero doesn't have yet, so the import is one upload with nothing doubled.

Xero bank feed questions

How do I set up a bank feed in Xero?

Go to Accounting, Bank accounts, Add Bank Account, search for your bank, and follow the authorization prompts. Xero connects through a direct feed or open banking where your bank offers one, and through a third-party connection such as Yodlee where it doesn't.

What if my bank isn't supported for a direct Xero feed?

Search for it anyway, because a Yodlee-powered connection may cover it. If nothing does, export statements from online banking and import them as OFX, QIF, QBO, QFX or CSV files. n-frames builds the step that turns your bank's export into a ready-to-import file, so the upload is the only manual part.

My Xero bank feed stopped working. What do I do?

Open the bank account in Xero and look for a connection message. Reconnecting through your bank's authorization fixes most direct and open banking feeds, and a Yodlee connection may need your updated banking login. Then check the dates for a gap and import a statement for any days that are missing.

Is Xero bank feed data secure?

Feeds travel over an encrypted connection, and they're read-only, so Xero can't make payments through a bank feed. Direct and open banking feeds are authorized at your bank, which means Xero doesn't hold your banking password. Some Yodlee connections do sign in with your banking login, which is worth knowing when you choose.

Does Xero support open banking?

Yes, in markets with an open banking framework. Many UK banks connect this way: you give consent on your bank's own screen, and the feed runs under that consent rather than a one-off agreement between Xero and the bank.

Can Stripe or PayPal be a bank feed in Xero?

Yes. Xero lists payment providers such as Stripe and PayPal alongside banks when you add a bank account, so their transactions arrive in a feed of their own.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.