Xero Bank Feeds: Setup, Troubleshooting & Best Practices

Xero Bank Feeds: Everything You Need to Know

Bank feeds are one of Xero's most valuable features. They automatically import transactions from your bank accounts into Xero, eliminating manual data entry and ensuring your records stay current. Here is how to set them up, troubleshoot issues, and get the most out of them.

What Are Bank Feeds?

A bank feed is a direct, secure connection between your bank account and Xero. Once set up, your transactions are automatically imported into Xero, usually within one business day of appearing on your bank statement.

This means you do not need to manually enter transactions or upload bank statements. The data flows automatically, saving you time and reducing errors.

Setting Up Bank Feeds

Step 1: Add Your Bank Account in Xero

Navigate to Accounting then Bank Accounts and click Add Bank Account. Search for your bank - Xero supports direct feeds with most major Australian banks including ANZ, CBA, NAB, Westpac, Bendigo Bank, Bank of Queensland, and many more.

Step 2: Authenticate with Your Bank

Follow the prompts to connect your bank account. The process varies by bank:

Direct bank feeds - Xero connects directly through partnerships with banks. You may need to authorise the connection through your internet banking portal. This is the most reliable feed type.

Yodlee feeds - For banks without direct partnerships, Xero uses Yodlee as an intermediary. You provide your internet banking credentials, which Yodlee stores securely to retrieve your transactions.

Step 3: Choose Your Account

If you have multiple accounts with the same bank, select which ones to connect. Map each bank account to the corresponding account in your Xero chart of accounts.

Step 4: Set Your Start Date

Choose how far back to import transactions. If you are setting up Xero for the first time, you might want historical data. If migrating from another system, start from the date you switched.

Bank Feed Best Practices

Connect All Business Accounts

Do not just connect your main transaction account. Connect every account that handles business transactions:

• Business cheque/transaction account
• Business savings accounts
• Business credit cards
• PayPal business account
• Stripe (via Xero's integration)

Each account should be reconciled separately.

Set Up Bank Rules

Bank rules automatically categorise recurring transactions when they come through the feed. Set up rules for:

• Regular bills (rent, phone, insurance, subscriptions)
• Regular income (recurring client payments)
• Bank fees and charges
• Merchant facility fees

The more rules you set up, the less manual categorisation you need to do during reconciliation. Over time, SortBooks can learn your categorisation patterns and handle even the transactions that do not match existing rules.

Reconcile Regularly

Bank feeds only import transactions - they do not reconcile them. You still need to review each imported transaction, confirm the categorisation, and mark it as reconciled.

Do this weekly at minimum. With bank rules and AI categorisation handling the obvious transactions, your weekly reconciliation becomes mostly a review and approval process rather than manual data entry.

Do Not Duplicate Transactions

A common mistake when first setting up bank feeds is to also manually enter or import the same transactions. This creates duplicates that distort your reports. Once bank feeds are running, let them be the single source of truth for imported transactions.

Troubleshooting Common Issues

Bank Feed Stopped Working

This is the most common issue. Your bank feed may stop importing for several reasons:

• Changed banking password - If you changed your internet banking password, you need to update it in Xero. Go to your bank account settings and re-authenticate.
• Bank maintenance - Banks occasionally perform maintenance that temporarily interrupts feeds. Wait 24-48 hours and check again.
• Expired authentication - Some banks require you to re-authorise the connection periodically. Check for any notifications in Xero.
• Account closed or changed - If your bank changed your account number or you opened a new account, you need to set up a new feed.

Missing Transactions

If specific transactions are not appearing:

• Check the transaction date - bank feeds import based on the date the bank processes the transaction, not the date you initiated it
• Pending transactions may not appear until they clear
• Some transaction types (like scheduled payments) may not be included in certain feed types

Duplicate Transactions

If you see duplicate transactions:

• Check if you have both manually entered and bank-fed versions of the same transaction
• Look for transactions that were imported through both a direct feed and a manual CSV upload
• Use the "Find and Match" feature in reconciliation to match duplicates and remove the extra entries

Wrong Account Mapping

If transactions are coming into the wrong Xero account:

• Go to your bank account settings in Xero
• Check the account mapping
• Correct it and re-import if necessary

Security and Bank Feeds

Bank feeds are secure. For direct feeds, Xero has formal partnerships with banks and data is encrypted in transit. For Yodlee feeds, your credentials are stored by Yodlee (a major financial data provider used by thousands of institutions) with bank-grade encryption.

Xero uses read-only access - it can only view your transactions. It cannot make payments, transfers, or any changes to your bank account.

Getting the Most from Bank Feeds

The combination of bank feeds, bank rules, and AI categorisation means that a large percentage of your bookkeeping can happen automatically. Here is the ideal workflow:

1. Transactions import automatically via bank feeds
2. Bank rules categorise recurring transactions automatically
3. AI tools categorise the remaining transactions based on learned patterns
4. You review and approve the categorised transactions during weekly reconciliation
5. Any exceptions or unusual transactions get your direct attention

This workflow transforms bookkeeping from hours of manual data entry into minutes of review and approval. It is not just faster - it is more accurate, because the automation is consistent in a way that manual entry is not.