How to Reconcile Bank Transactions in Xero

Bank reconciliation might often feel like a routine bookkeeping task, but minute errors can still persist in BAS reporting and financial records. Australian businesses that use Xero reconciliation regularly can compare bank activity with the transactions recorded in the accounting system before these errors have a substantial impact. 

Xero makes the process easier by importing bank statement lines and suggesting possible matches. Before you proceed with matching transactions, let us know about the steps through which your Xero bank account can be prepared for reconciliation.

How Do You Prepare for Bank Reconciliation in Xero?

Before you match the transactions, make sure your Xero bank account is properly set up for bank reconciliation in Xero, and the relevant records are available. Here are a few checks that can prevent missing or duplicate entries during reconciliation:

• Bank feed: Confirm that your bank account is connected to Xero and transactions are importing correctly.
• Date range: Check that the bank activity and accounting records cover the same reconciliation period.
• Existing records: Make sure relevant invoices, bills and other transactions have already been entered in Xero.
• Bank-only transactions: Look for fees, interest and automatic payments that may need to be recorded in Xero.
• Business account: Use a dedicated business bank account when you reconcile bank account transactions. This makes transactions easier to identify and match.
• Opening balance: Check the opening balance carefully if the account was recently created or migrated, as an incorrect figure can create ongoing discrepancies.

How Do You Reconcile Bank Transactions in Xero Step by Step?

In Xero, you reconcile bank transactions by reviewing imported statement lines and matching them with existing transactions or creating new ones when no match is available. Every transaction has to be checked and correctly coded before you confirm the reconciliation. Let us quickly see the steps through which you can complete the procedure successfully:

1. Open the Bank Account and “Reconcile” Tab

• Go to Accounting > Bank Accounts in Xero.
• Find the bank account you want to reconcile.
• Select Reconcile [number] items to open the reconciliation screen.
• If there are no items waiting to be reconciled, select the name of the bank account and open the Reconcile tab.
• The reconciliation screen will show imported bank statement lines that are waiting for action.

2. Review Each Imported Bank Transaction

• Work through the statement lines individually.
• Review the transaction details, including the amount and information identifying the payment or receipt.
• Xero might suggest a match, apply a bank rule or provide another suggested treatment.
• Do not accept a suggestion without checking that it represents the actual transaction.

If Xero accounting software has not provided a suitable option, move on to finding an existing transaction or creating one.

3. Match the Transaction With an Existing Xero Record

• When the transaction has already been recorded in Xero, match the imported statement line with the existing transaction.
• This can apply to payments against invoices or bills.
• If Xero does not display the transaction you need, use Find & Match to search for the relevant record.
• Check the proposed match before confirming it.
• After you have confirmed that the bank statement line and Xero transaction represent the same activity, accept the match.

4. Create a New Transaction When No Match Exists

• If there is no existing Xero transaction, create one from the reconciliation screen.
• For a business expense, create the appropriate spend money transaction.
• For money received, create the appropriate receive money transaction.
• Select the correct account code and apply the appropriate GST or tax treatment.
• Check the details before confirming the transaction so the bank activity is not merely cleared with an incorrect accounting entry.

5. Handle Split Transactions

• Use Split when one bank transaction relates to more than one account or category. For example, a single supplier purchase may contain items that need different account codes.
• Enter the relevant portions separately and allocate each amount to the appropriate account.
• Check that the split amounts together equal the original bank transaction before confirming the reconciliation.

6. Reconcile Transfers Between Bank Accounts

• Identify transfers between accounts that belong to the same business.
• Treat the movement as a transfer, rather than recording it as income or an expense.
• Check the corresponding transaction in the other bank account so the movement is represented correctly on both sides.
• This prevents the same movement of money from being incorrectly counted as business income or expenditure.

7. Confirm the Reconciliation and Check the Balances

• After the statement lines have been matched, coded or created correctly, confirm each reconciliation.
• Xero displays the Statement Balance and Balance in Xero for comparison.
• When the relevant balances agree, the reconciliation is complete.
• If they do not agree, investigate the difference rather than making an unsupported adjustment simply to force the figures to match.

For further checking, review the Bank Reconciliation Summary to examine the reconciliation history and identify discrepancies. A lot of businesses might also need broader guidance when reviewing financial records, which is why seeking help from small business accounting services in Perth is a smart decision. 

What Should You Do When Bank Transactions Do Not Reconcile in Xero?

If bank transactions in Xero do not reconcile, review the unmatched items first and check whether the bank feed is complete. You may also need to investigate duplicates, opening balance differences or transactions that were reconciled incorrectly before making any adjustment.

• Unmatched Transactions

Use Find & Match to look for the relevant invoice, bill or existing transaction. If nothing matches, create the appropriate transaction and check its coding and GST treatment.

• Missing Bank Feed Transactions

Check whether the Xero bank feed has stopped updating or whether transactions are missing from the imported period. Missing activity may need to be imported manually before reconciliation can continue.

• Duplicate Transactions

Look for transactions imported more than once, particularly where manual imports overlap with an active feed. Remove or correct duplicates so they do not distort your records.

• Opening Balance Differences

If the opening balance is incorrect, particularly after migrating to Xero, the difference may continue through later reconciliations and require an appropriate accounting adjustment.

• Incorrectly Reconciled Transactions

During Xero bank feed reconciliation, the software might have matched the wrong transaction. In such cases, use the appropriate correction option, such as Remove & Redo or Unreconcile, before reconciling the statement line again.

Keeping reconciled transactions accurate also helps ensure the records used for BAS preparation are up to date. BAS Services in Perth can support your business with this part of their accounting process.

How Does Automatic Bank Reconciliation Work in Xero?

Xero’s automatic bank reconciliation uses JAX to review future imported bank statement lines and reconcile those that meet its high-confidence criteria. This feature can simplify Xero bank account reconciliation by recognising patterns and reducing the amount of manual matching required.

1. Turn On Automatic Bank Reconciliation

• Go to Accounting > Bank Accounts and select the relevant bank account.
• Open the Reconcile tab and select Auto-reconcile.
• Under the settings, select Turn on Auto Bank Reconciliation, then click Save.

2. Let Xero Review Future Bank Statement Lines

• After it has been enabled, JAX reviews future statement lines imported into that bank account.
• It does not automatically review historical statement lines.
• Only transactions that satisfy the mandatory high-confidence criteria are automatically reconciled.

3. Review Automatically Reconciled Transactions

• Open the relevant bank account and select Review reconciled.
• Use the available filters if you need to narrow down transactions by date, amount or reconciliation method.
• JAX-reconciled transactions show labels like Rule, Match, Memory or Prediction to highlight the method JAX used. 

4. Correct An Incorrectly Reconciled Transaction

• If JAX creates the wrong account transaction, edit the account code or tax rate, or use Remove & Redo wherever appropriate.
• If it matches the wrong invoice or bill, use Remove & Redo to return the statement line to the unreconciled list.
• If the payment was applied correctly but linked to the wrong statement line, use Unreconcile and reconcile the bank statement line correctly.

For businesses that need ongoing support with transaction coding and account reconciliation, bookkeeping services in Perth can help keep Xero records organised and up to date.

How Often Should You Reconcile Bank Transactions in Xero?

Xero bank reconciliation must be done regularly, with weekly or monthly reconciliation being suitable depending on your transaction volume. 

• Weekly reconciliation: A useful routine for businesses with regular transaction activity and frequent cash movements.
• Monthly reconciliation: A practical minimum for businesses with lower transaction volumes and fewer bank movements.
• Daily reconciliation: High-volume businesses may benefit from checking transactions more frequently to prevent a large backlog.
• Before reporting deadlines: Reconcile before BAS preparation or other financial reporting so that the figures are based on current records.
• Keep the schedule consistent: A recurring routine makes missing transactions, duplicate entries, and discrepancies easier to identify.

Businesses that need help keeping their reconciliation records up to date can also use Xero accounting services as part of their regular accounting workflow.

Also read: How to Track Fuel Expenses in Xero & MYOB

Conclusion

Regular reconciliation keeps your Xero records accurate and makes it easier to spot missing, duplicated or incorrectly coded transactions. Reviewing bank feeds regularly gives you clearer records for reporting and BAS preparation. However, if reconciliation becomes difficult to manage alongside daily business tasks, accounting services in Perth can support accurate and up-to-date accounting records. 

FAQs

1. How often should you reconcile bank transactions in Xero?

There is no single reconciliation schedule that works for every business. Many businesses find that reconciling their Xero bank account weekly or monthly keeps their records manageable. If your business has a large number of daily transactions, you may need to review them more frequently. It is particularly useful to make sure your records are reconciled before preparing a BAS or completing important financial reports.

2. What should I do if a bank transaction does not match in Xero?

When a transaction cannot be matched, first check whether the related invoice, bill, payment or other record already exists in Xero. The Find & Match option can help you locate the correct transaction. If there is no existing record, you may need to create one and confirm that the account, GST treatment and transaction details are correct. Avoid reconciling an unexplained transaction just to remove it from the list.

3. Why are my bank transactions not reconciling in Xero?

There are several reasons why transactions may not reconcile correctly. Common issues include missing bank-feed entries, duplicate transactions, incorrect opening balances or an earlier reconciliation error. Start by checking the unmatched transactions and confirming that the bank feed contains all relevant activity for the period. Finding the reason for the difference first is generally safer than making an adjustment without knowing what caused it.

4. Can Xero automatically reconcile bank transactions?

Yes. Xero can use JAX to automatically reconcile certain imported bank statement lines when they meet its high-confidence requirements. This feature is designed for eligible transactions and does not automatically go through historical statement lines. Any automatically reconciled transactions should still be checked to confirm that they have been allocated and recorded correctly.

5. How do I correct a transaction that was reconciled incorrectly in Xero?

The correction depends on the type of mistake. If a transaction was matched with the wrong invoice, bill or account, Remove & Redo may allow you to correct it and reconcile the statement line again. In other situations, such as when a payment has been associated with the wrong statement line, Unreconcile may be the appropriate option. Once the correction has been made, review the details before completing the reconciliation again.

6. What should I do if my Xero bank feed is missing transactions?

Check the bank feed first to determine whether the connection has stopped updating or whether transactions are missing from a particular date range. If required, the missing bank activity may need to be imported manually. Do not assume that the account is fully reconciled while transactions are missing, as incomplete bank-feed data can cause your Xero balance and actual bank balance to differ.

7. What is the difference between the Statement Balance and the Balance in Xero?

The Statement Balance is the amount reported by your bank for the relevant statement period. The Balance in Xero is the amount currently recorded in your Xero account. Comparing the two can help highlight missing transactions, duplicates or incorrectly recorded entries. If the figures differ, investigate the individual transactions and identify the cause rather than adding an unsupported adjustment simply to make the balances agree.

8. Why is bank reconciliation important for BAS preparation?

Regular bank reconciliation helps ensure that the financial information in Xero is complete and up to date before preparing a BAS. Reviewing and correctly allocating transactions makes it easier to spot missing entries, duplicates and coding errors that could affect GST reporting. Keeping the accounts reconciled throughout the year can also make BAS preparation more straightforward and reduce the need for last-minute corrections.