How to Fix Bank Reconciliation Errors in Xero
What Is the Quick Summary?
Bank reconciliation errors in Xero Accounting Software usually come from a handful of causes: duplicate transactions, wrong opening balances, mismatched dates, missing bank feed lines, or payments coded twice. You can fix most of them in minutes by comparing the Statement Balance with the Balance in Xero, finding the gap, and correcting the transactions behind it.
This guide shows you how to spot the error, trace its cause, and fix it. It also explains how to stop the same problem from returning.
Key takeaways:
- Start with the Reconciliation Report to see exactly where Xero and your bank disagree.
- Fix duplicates, wrong amounts, and misdated entries before you touch anything else.
- Use bank rules and regular reconciliation to prevent repeat errors.
Why Do Bank Reconciliation Errors Happen in Xero?
Bank reconciliation compares the transactions in your bank account with the transactions recorded in your books. When the two do not agree, you have an error. Xero Accounting Software imports bank statement lines through a bank feed or a file upload, then asks you to match each line to a transaction you already recorded or to create a new one.
Because the process involves both automated imports and manual decisions, mistakes can enter at several points. Understanding where they originate makes the fix much faster.
What Are the Most Common Causes?
The table below lists the causes you will meet most often and the symptom each one creates.
| Cause | Typical symptom | How often it appears |
|---|---|---|
| Duplicate bank statement lines | Balance in Xero is higher or lower than the bank by a repeated amount | Very common |
| Payment recorded twice (once as a bill payment, once as a spend money transaction) | Unreconciled items that look identical | Common |
| Wrong opening balance or conversion balance | Constant difference that never changes | Common |
| Missing statement lines after a feed outage | Bank shows transactions that Xero lacks | Occasional |
| Incorrect date or amount on a manual entry | Transaction will not match its statement line | Common |
| Reconciled transaction later edited or deleted | Balance suddenly changes after a period was closed | Occasional |
Why Does the Difference Between Balances Matter?
A reconciliation difference is more than a cosmetic problem. It means your cash position, profit and loss report, and tax figures may all be wrong. Accountants and bookkeepers also rely on a clean reconciliation before they prepare year-end accounts. So treat any difference as a signal to investigate right away, not a number to ignore.
How Do You Identify a Reconciliation Error in Xero?
Before you fix anything, confirm what is wrong. Xero gives you several built-in views that make this simple.
How Do You Compare the Statement Balance and the Balance in Xero?
Open the Reconcile tab for the bank account. At the top, you will see two figures: the Statement Balance (the balance reported by your bank) and the Balance in Xero (the balance in your books). If they do not match, the difference is your error amount.
Note that unreconciled statement lines can explain a gap legitimately. Finish reconciling those lines first. If a difference remains after every line is reconciled, a real error exists.
How Do You Run the Bank Reconciliation Report?
The Bank Reconciliation Summary report shows, for any date, the bank statement balance, the outstanding payments and receipts, and the resulting balance in Xero. Follow these steps:
- Go to Reporting, then All reports.
- Open Bank Reconciliation Summary.
- Choose the bank account and the date you want to check.
- Compare the balance on the bank statement with the balance in Xero.
If the report shows a difference at the end of a given month, you know the error occurred on or before that date. As a result, you can narrow your search to a single period instead of reviewing the whole year.
How Do You Find the Exact Transaction Causing the Problem?
Use a simple divide-and-conquer approach. Check the difference at month-end, then at mid-month, and keep narrowing until you find the date where the gap first appears. After that, review every transaction on that date in Account Transactions and compare it with your bank statement.
Look for these clues:
- A difference equal to a single transaction amount often means a duplicate or a missing line.
- A difference divisible by nine often points to a transposition error, such as typing 540 instead of 450.
- A difference that stays constant across months usually points to an opening balance problem.
How Do You Fix the Most Common Bank Reconciliation Errors?
Once you know the cause, apply the matching fix. Each method below uses standard tools inside Xero Accounting Software.
How Do You Fix Duplicate Bank Statement Lines?
Duplicates often appear when you import a statement file that overlaps with transactions already delivered by the bank feed. To remove them:
- Open the bank account and select the Bank statements option, or use Account Transactions and switch to statement lines.
- Locate the duplicate line.
- Delete the statement line. Xero lets you delete lines that are not yet reconciled.
- Return to the Reconcile tab and confirm the Statement Balance still matches your bank.
If the duplicate is already reconciled, first use Unreconcile on the matched transaction. Then delete the extra statement line and reconcile again. Always compare the result with the actual bank statement so you do not delete a genuine repeat payment.
How Do You Fix a Payment Recorded Twice?
This error happens when you record an invoice payment manually and then create a second Spend Money or Receive Money transaction from the bank line. Both entries reduce or increase cash, so the balance drifts.
To correct it, search for the amount in Account Transactions. When you find two entries for one bank line, delete or void the one that does not belong. In most cases, keep the payment linked to the invoice or bill and remove the standalone cash entry. Afterwards, reconcile the statement line against the remaining payment.
How Do You Fix Incorrect Dates or Amounts?
When the amount or date on a manual entry differs from the bank line, Xero cannot suggest a match. You can solve this in two ways:
- Edit the original transaction. Change the date or amount to match the bank line, then use Find & Match to link them.
- Use Find & Match with a wider search. Select the statement line, choose Find & Match, and adjust the filters to include a broader date range or amount tolerance.
If the transaction is part of a locked period, you may need to ask an adviser to change the lock date before you edit it.
How Do You Fix a Wrong Opening Balance?
A constant difference that never changes usually points to the opening balance. Check the conversion balance in Settings, then Conversion balances. Compare it with the closing balance on your last statement before the conversion date.
If the numbers disagree, update the conversion balance for the bank account. Because this change affects every report from the conversion date onward, confirm the correct figure with your accountant before you save it.
How Do You Fix Missing Bank Feed Transactions?
Sometimes the feed drops lines after an outage or after you reconnect it. You have two practical options:
- Reconnect the feed. Go to Bank accounts, open the account, and review the Manage Account settings and feed status. Xero will usually backfill missing lines when the connection restores.
- Import a statement file. Download a CSV or OFX file from your bank covering the missing dates, then import it through Manage Account, then Import a Statement.
Before you import, check the date range carefully. Overlapping dates are the main reason duplicates appear in the first place.
How Do You Undo a Reconciliation That Went Wrong?
Sometimes you matched a statement line to the wrong transaction. Xero lets you reverse that decision without losing your data.
How Do You Unreconcile a Transaction?
On the Reconcile tab, open the Reconciled view or use Account Transactions to find the matched item. Select Unreconcile (or use the Remove & Redo option on the line). The statement line returns to the unreconciled list, and you can match it again correctly.
This option is safe because it does not delete the underlying transaction. It only breaks the link between the two records.
What Should You Know About Locked Periods?
If your organisation has set a lock date, Xero blocks changes to transactions before that date for most users. Advisers can override the lock date, but you should do so only for good reason. Changing a locked period affects previously filed reports and tax returns. Consequently, always document why you made the change.
How Can You Prevent Bank Reconciliation Errors in Xero?
Fixing errors is useful, but preventing them saves far more time. A few habits make a big difference.
Which Best Practices Reduce Errors?
- Reconcile often. Weekly reconciliation keeps the list short and the details fresh. Many bookkeepers reconcile daily for busy accounts.
- Use one source of truth. Choose either the bank feed or manual statement imports for each account. Mixing both invites duplicates.
- Create bank rules. Rules auto-code repeating transactions such as subscriptions, rent, and bank fees, so you make fewer manual decisions.
- Review before you click OK. Check the contact, account code, and tax rate on every line.
- Check the report at month-end. Run the Bank Reconciliation Summary and confirm the difference is zero.
- Restrict who can edit reconciled items. Limit user roles and set lock dates so accidental edits cannot change closed periods.
How Do Bank Rules Help?
Bank rules in Xero Accounting Software let you set conditions, such as payee text or amount, and apply a coding automatically. For example, you can create a rule that codes every line containing “Monthly bank fee” to your bank charges account. This approach removes repetitive work and reduces typing mistakes. However, review your rules every quarter, because outdated rules can code transactions incorrectly.
How Often Should You Reconcile?
The right frequency depends on your transaction volume.
| Business type | Suggested reconciliation frequency |
|---|---|
| Freelancer or sole trader (under 50 transactions a month) | Weekly |
| Small business (50 to 300 transactions a month) | Two to three times a week |
| Retail, ecommerce, or hospitality (over 300 transactions a month) | Daily |
How Do You Troubleshoot When the Difference Still Will Not Clear?
Occasionally, you will fix an obvious error and still see a gap. In that case, follow a structured checklist rather than guessing.
What Is a Step-by-Step Checklist?
- Confirm that the statement balance you entered or imported matches the bank’s closing balance for the same date.
- Check that every statement line is either reconciled or intentionally left unreconciled.
- Look for transactions dated after the statement date that Xero counts in the balance.
- Search for deleted or voided payments that were previously reconciled.
- Review transfers between your own accounts, because a transfer entered on only one side creates a lasting gap.
- Check foreign currency accounts for exchange rate differences.
- Compare opening balances one more time.
When Should You Contact Xero Support or an Adviser?
Contact Xero support through Xero Central if you suspect a feed fault or a technical issue that you cannot resolve. Contact your accountant or a certified Xero adviser when the error involves a locked period, a conversion balance, or large sums. An adviser can review the audit trail and correct entries without disturbing your filed returns.
What Should You Remember About Fixing Bank Reconciliation Errors in Xero?
Bank reconciliation errors look intimidating, yet they almost always trace back to a small set of causes. First, compare the Statement Balance with the Balance in Xero. Next, run the Bank Reconciliation Summary to find the date where the gap begins. Then correct the specific problem, whether it is a duplicate, a double entry, a wrong amount, a missing feed line, or an opening balance issue.
After you fix the error, protect your books by reconciling regularly, using bank rules, and setting lock dates. Xero Accounting Software gives you the tools to find and resolve discrepancies quickly, so you can keep accurate records and trust your financial reports. For official, up-to-date instructions, consult Xero Central, the platform’s own help centre.
Frequently Asked Questions
Not directly. First, unreconcile the transaction, then delete or void it. This extra step protects you from removing a transaction that still matches a bank line. If the date falls in a locked period, an adviser must change the lock date first.
A mismatch after full reconciliation usually means one of three things: an incorrect opening or conversion balance, a transaction dated after the statement date, or a transfer recorded on only one side. Run the Bank Reconciliation Summary for the statement date and work through the troubleshooting checklist above.
Check the date range before you import. Start the file on the day after your last imported statement line, and avoid importing when the bank feed already covers those dates. If you use a bank feed, do not also import files for the same period unless you are filling a confirmed gap.
