How to Reconcile Bank Statements: A Step-by-Step Guide

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing your accounting records with your bank statements to ensure they match. Every transaction in your bank account should have a corresponding entry in your books, and vice versa. When they match, your books are reconciled. When they do not, you need to investigate and fix the discrepancy.

This is one of the most important bookkeeping tasks because it validates the accuracy of your financial records. If your books and your bank do not agree, your financial reports cannot be trusted.

Why Regular Reconciliation Matters

Catches Errors Early

The sooner you reconcile, the sooner you catch mistakes. A miscategorised transaction, a duplicated entry, or a missing payment is much easier to investigate and fix when it is recent rather than months old.

Detects Fraud

Reconciliation can reveal unauthorised transactions - payments you did not make, withdrawals you did not authorise, or suspicious activity that needs investigation.

Ensures Accurate Reports

Your profit and loss statement, balance sheet, and cash flow report are only as accurate as your underlying data. Reconciliation validates that data.

Simplifies Tax Filing

When your books are reconciled throughout the year, preparing your BAS, VAT return, or tax return is straightforward. There are no surprises and no scrambling to figure out unexplained discrepancies.

Step-by-Step Reconciliation in Xero

Step 1: Check Your Bank Feed

Log into Xero and go to Accounting then Bank Accounts. Click on the bank account you want to reconcile. You will see a list of transactions imported through your bank feed.

Check that transactions are coming through regularly. If there is a gap of more than a day or two, your bank feed may need attention.

Step 2: Review Suggested Matches

Xero automatically suggests matches for bank feed transactions. For incoming payments, it will try to match against outstanding invoices. For outgoing payments, it will match against outstanding bills.

Review each suggested match:

• Does the amount match exactly?
• Does the date make sense?
• Is the description consistent with the suggested match?

If the match looks correct, click OK to reconcile it. If not, reject the suggestion and categorise it manually.

Step 3: Categorise Unmatched Transactions

Transactions that do not match an existing invoice or bill need to be categorised. For each one:

1. Review the bank description and amount
2. Determine the correct account code (e.g., "Office Supplies" or "Telecommunications")
3. Apply the correct tax rate (GST, VAT, or exempt)
4. Add any relevant tracking categories
5. Click OK to reconcile

This is where bank rules save time. If you have set up rules for recurring transactions, many of these will be categorised automatically.

Step 4: Handle Split Transactions

Some bank transactions need to be split across multiple categories. For example, a payment to a supplier might include both materials and freight, which should go to different accounts.

In Xero, click "Split" on the transaction, then allocate each portion to the correct account with the correct tax rate.

Step 5: Investigate Discrepancies

If your Xero balance does not match your bank balance after reconciling all visible transactions, investigate:

Missing transactions - Check whether any transactions are missing from your bank feed. Compare your bank statement directly with the transactions in Xero.

Timing differences - A payment you made today might not appear in your bank until tomorrow. Check for transactions that are in transit.

Duplicate transactions - If your balance in Xero is higher than the bank, you might have duplicate entries. Search for transactions with the same amount.

Adjustments - Bank fees, interest charges, and automatic payments sometimes appear in the bank before they are recorded in your books. Create entries for these as needed.

Step 6: Confirm the Reconciliation

Once all transactions are matched and your Xero balance matches your bank balance, the account is reconciled. Note the date and the reconciled balance for your records.

Reconciliation Frequency

Weekly is the ideal frequency for most businesses. It keeps the workload manageable and ensures issues are caught quickly.

Monthly is the minimum. Any less frequent than monthly and issues compound, making reconciliation much harder and less useful.

Daily is appropriate for high-volume businesses or those with strict cash management requirements.

Common Reconciliation Problems

The Balance Does Not Match

If your Xero balance is different from your bank balance after reconciling all transactions, the most common causes are:

• An opening balance that was entered incorrectly
• A transaction that was deleted or modified after being reconciled
• A bank feed that imported transactions from the wrong date range
• A manual journal entry that affected the bank account

Duplicate Bank Feed Transactions

This happens when a bank feed is disconnected and reconnected, or when you manually import a statement that overlaps with the feed period. Delete the duplicates carefully - make sure you are deleting the feed duplicate, not the original entry.

Unreconciled Items From Previous Periods

If old transactions were never reconciled, they accumulate as a discrepancy. Work through them chronologically, starting with the oldest, to clean up your records.

Automating Bank Reconciliation

SortBooks automates much of the reconciliation process by:

• Automatically categorising bank feed transactions using AI
• Matching payments against outstanding invoices and bills
• Applying correct tax rates consistently
• Flagging exceptions that need human review

With SortBooks handling the routine categorisation, your reconciliation sessions become quick review sessions rather than lengthy data entry marathons. Most businesses can complete their weekly reconciliation in 10-15 minutes instead of hours.