Connect a bank feed in Xero by going to Accounting → Bank accounts → Add bank account, searching for your bank, and authorising the connection through your bank’s own internet banking portal. Once authorised, Xero pulls in transactions automatically every business day. If your bank doesn’t support a direct feed, you can still add the account and import statements manually using OFX, QIF, QBO, QFX, or CSV files.
The fastest route to a working feed:
Pro Tip: If Xero prompts for credentials during setup or later, the person who originally connected the bank account must be the one to re-enter them. Logging in as a different user won’t satisfy the prompt.
A correctly mapped Xero bank feed, verified with a 7-day reconciliation test, is the foundation of accurate, low-effort bookkeeping for any small business.
| Point | Details |
|---|---|
| Setup path | Go to Accounting → Bank accounts → Add bank account, authorise via your bank’s portal, and map to the correct Chart of Accounts entry. |
| Historical import | Xero allows up to 12 months of historical transactions on initial setup; align the start date with your last reconciled period. |
| Manual import fallback | When no direct feed exists, import OFX, QIF, QBO, QFX, or CSV files; OFX is the most reliable format for UK banks. |
| Troubleshooting order | Check Xero Status and Bank Feeds Disruptions first, then re-enter credentials, then wait 24 hours before disconnecting and reconnecting. |
| Priceandaccountants | Priceandaccountants handles end-to-end feed setup, account mapping, and a 7-day reconciliation check for small businesses. |
A Xero bank feed pulls your bank transactions directly into Xero each business day, removing the need to enter them manually. Once transactions land in Xero, they sit in the reconciliation screen waiting to be matched against invoices, bills, or spend categories. That daily import is the engine behind Xero bank reconciliation: the cleaner the feed, the faster the month-end close.
Before you start, confirm you have:
| Prerequisite | Why it matters |
|---|---|
| Active Xero subscription | Bank feeds require a paid plan; the free trial supports them, but check your plan level. |
| Online banking access | You must be able to log into your bank’s internet banking portal, including any MFA device. |
| Chart of Accounts set up | Each bank account needs a matching ledger account before the feed can be mapped correctly. |
| Admin or Standard user role in Xero | Lower permission levels cannot add bank accounts or authorise feeds. |
On historical data: Xero allows you to import up to 12 months of historical transactions during initial setup, which gives you a solid reconciliation baseline from day one. After that, new transactions arrive automatically. For many banks, transactions typically appear early each business day once the feed is active, though this varies by institution and is not a guaranteed cut-off time.
Check the Xero Bank Feeds Disruptions page and the Xero Status dashboard before you start troubleshooting locally. A surprising number of feed failures are caused by scheduled bank maintenance or a platform-wide issue, not anything you’ve misconfigured.
Follow these steps in order. The whole process takes around five minutes for most banks.
Pro Tip: If you manage multiple bank accounts, connect them one at a time and verify each feed before moving to the next. Troubleshooting two feeds simultaneously is significantly harder than catching a mapping error on a single account.
Not every bank supports a direct Xero connection. When that’s the case, you can still add the account in Xero and keep your books current through manual statement imports.
Adding the account without a feed: Go to Accounting → Bank accounts → Add bank account, search for your bank, and if no direct feed appears, select Add without bank feed. You still need to create a matching Chart of Accounts entry at this stage; skipping it means imported transactions have nowhere to land.
Supported file formats for manual import:
| Format | Notes |
|---|---|
| OFX | Most reliable for transaction data; widely supported by UK banks. |
| QIF | Older format; some banks still export it, but date formatting can vary. |
| QBO | QuickBooks Online format; accepted by Xero for cross-platform migrations. |
| QFX | Quicken format; functionally similar to OFX. |
| CSV | Most flexible but requires careful column mapping; prone to import errors if headers differ. |
Xero’s reconciliation screen handles all five formats, though OFX is the most consistent choice when your bank offers it.
Importing a statement without creating duplicates:
Some banks that lack a native Xero feed do offer a connection via Yodlee, Xero’s third-party aggregator. Yodlee feeds work by storing your bank login credentials (encrypted) and fetching transactions on your behalf. They’re functional, but they require more maintenance: any change to your bank’s login page, MFA setup, or password triggers a re-authentication prompt. If you’re managing a high volume of transactions, a multi-account banking strategy that consolidates accounts with direct-feed banks can reduce this overhead considerably.
Most day-to-day feed problems fall into one of three categories: a stale consent, a credential change at the bank, or a temporary platform issue. Here’s how to handle each.
Spotting and acting on in-app prompts:
When to reconnect completely:
Pro Tip: Wait at least 24 hours before disconnecting and reconnecting a feed. Many interruptions resolve on their own once scheduled bank maintenance or a transient API error clears. A full reconnection is not always necessary and occasionally introduces new issues.
For Yodlee-based feeds specifically, the fix is often simpler: go to Manage account → Refresh feed and re-enter your bank login credentials when prompted. Re-entering credentials is the recommended first step before a full disconnect for aggregator feeds.
Work through this list in order before contacting support.
| Issue | First fix | Escalate if |
|---|---|---|
| Transactions stopped importing | Check Xero Status; re-enter credentials | Still failing after 24 hours |
| Feed shows as disconnected | Reconnect via Add bank account | Reconnection fails repeatedly |
| Duplicate transactions appearing | Review import dates; delete duplicates in Xero | Duplicates persist after manual review |
| Authorisation error at bank portal | Clear browser cache; try incognito mode | Error persists across browsers |
A live feed is the starting point, not the finish line. These steps turn raw transaction imports into a tidy set of books.
Pro Tip: After setting up bank rules, run a 7-day reconciliation test. If the suggested matches look wrong, the issue is almost always the Chart of Accounts mapping, not the rule itself. Fix the mapping first, then rebuild the rule.
For broader bookkeeping tips once your feeds are running, the bookkeeping tips for busy business owners guide covers cadence and common pitfalls in plain language.
The single most common mistake we see when clients set up their own Xero bank feeds is mapping a credit card account to a bank transactional account type in the Chart of Accounts. It sounds like a minor detail. It isn’t. The moment you do that, every credit card payment appears as a bank transfer rather than a liability reduction, and your balance sheet starts lying to you. By the time someone notices, there are months of entries to untangle.
Our standard quality check after any feed setup is straightforward: confirm the opening balance matches the bank statement to the penny, then run a 7-day reconciliation. If the closing balance in Xero agrees with the bank at the end of that week, the mapping is correct and the feed is reliable. If it doesn’t, the discrepancy almost always points back to the Chart of Accounts entry chosen at setup.
The other thing worth saying: consent expiry on Open Banking feeds catches people off guard. The feed goes quiet, no error is thrown immediately, and by the time the client notices, there’s a two-week gap to backfill. Setting a calendar reminder to reconfirm consent every 90 days costs nothing and prevents that problem entirely.
If you’d rather have someone handle the setup, mapping checks, and initial reconciliation for you, that’s exactly what our managed Xero service covers.
Spending an afternoon wrestling with authorisation screens and Chart of Accounts mappings is time most founders and finance managers don’t have. Priceandaccountants sets up your Xero bank feeds end to end: account matching, historical transaction import, bank rule creation, and a 7-day reconciliation check to confirm everything is landing correctly before we hand it back to you.
For a typical small business with two to four bank accounts, the setup and verification process is completed within one to two business days. You get a clean reconciliation screen, correctly mapped accounts, and rules in place for your most common transaction types. No guesswork about whether the credit card is mapped to the right ledger entry.
If you’re migrating from another system or dealing with a feed that’s been broken for weeks, our team at Priceandaccountants can diagnose the issue, backfill missing transactions, and rebuild the connection properly. Get in touch through our accounting services page to discuss what your setup needs.
