Bank Reconciliation: What It Is and How to Do It Right

What Is Bank Reconciliation?

Bank reconciliation is the process of comparing your accounting records against your actual bank statements to make sure they match. It is one of the most important bookkeeping tasks you can do, and yet it is one of the most commonly neglected.

When you reconcile, you are essentially asking: does the amount I think is in my bank account actually match what the bank says is there? And if not, why not?

Why Bank Reconciliation Matters

Catching Errors

Mistakes happen. You might enter a transaction amount incorrectly, double-count a payment, or miss a transaction entirely. Reconciliation catches these errors before they compound.

Detecting Fraud

Unauthorised transactions, duplicate charges, or suspicious payments show up during reconciliation. If someone makes a fraudulent charge on your business account, regular reconciliation means you catch it quickly.

Accurate Financial Reporting

Your profit and loss statement and balance sheet are only accurate if the underlying data is correct. If your books do not match your bank, your reports are misleading - and you could be making decisions based on wrong information.

Tax Compliance

Tax authorities expect your financial records to be accurate. Discrepancies between your books and bank statements can raise red flags during an audit.

Cash Flow Clarity

You need to know exactly how much cash you have available. Unreconciled books can make you think you have more (or less) money than you actually do.

How Bank Reconciliation Works

The basic process involves matching each transaction in your accounting software with the corresponding transaction on your bank statement. Here is the step-by-step process:

Step 1: Get Your Bank Statement

Download or access your bank statement for the period you are reconciling (usually monthly, but weekly is better for busy businesses).

Step 2: Compare Opening Balances

Check that the opening balance in your accounting software matches the opening balance on your bank statement. If these do not match, you have a problem from a previous period that needs fixing first.

Step 3: Match Transactions

Go through each transaction on your bank statement and find the matching entry in your accounting records. Mark each matched pair as reconciled.

Step 4: Investigate Differences

You will likely find some items that do not match. Common reasons include:

Timing differences - A cheque you wrote has not been cashed yet, or a deposit you made has not cleared. These are normal and resolve themselves.

Missing transactions - A bank fee, interest payment, or direct debit that was not recorded in your books. Add these to your records.

Errors - A transaction recorded with the wrong amount or date. Correct these in your accounting records.

Unidentified transactions - Payments or deposits you do not recognise. Investigate these carefully.

Step 5: Adjust and Balance

After investigating all differences, make the necessary adjustments in your accounting records so that your ending balance matches the bank statement ending balance.

How Often Should You Reconcile?

Ideally: weekly. The more frequently you reconcile, the easier it is. With only a week's worth of transactions to review, errors and discrepancies are quick to spot and fix.

Minimum: monthly. At the very least, reconcile all your accounts at the end of each month. Leaving it longer makes the process much harder and increases the risk of errors going undetected.

Never: annually. Trying to reconcile a full year of transactions at tax time is a nightmare. Transactions are hard to remember, documents get lost, and errors multiply. Do not do this to yourself (or your accountant).

Bank Reconciliation in Xero

If you use Xero, bank reconciliation is significantly streamlined:

1. Bank feeds import your transactions automatically from your bank.
2. Matching rules suggest how to categorise recurring transactions.
3. The reconciliation screen shows your bank transactions alongside your accounting records, making it easy to match them.
4. Discrepancies are highlighted so you can investigate and resolve them quickly.

With AI-powered tools like SortBooks working on top of Xero, much of the matching and categorisation happens automatically. The AI learns your patterns and handles routine transactions, leaving you to focus only on the exceptions that need human attention.

Common Reconciliation Problems and Solutions

Problem: Bank balance does not match accounting records.

Solution: Check for timing differences (outstanding cheques, pending deposits), missing transactions (bank fees, interest), or data entry errors.

Problem: Duplicate transactions.

Solution: Sometimes bank feeds import a transaction that was also manually entered. Delete the duplicate and set up rules to prevent it happening again.

Problem: Foreign currency transactions.

Solution: Exchange rate differences can cause small discrepancies. Record these as foreign exchange gains or losses.

Problem: Credit card reconciliation.

Solution: Treat your credit card like a separate bank account. Reconcile it against the credit card statement, not your main bank statement.

Tips for Easier Reconciliation

• Do it regularly - weekly is ideal, monthly at minimum
• Use bank feeds - automate transaction imports wherever possible
• Set up bank rules - create rules for recurring transactions so they are categorised automatically
• Keep receipts - digital receipt management makes it easier to verify transactions
• Separate personal and business - mixing personal and business transactions makes reconciliation exponentially harder
• Reconcile all accounts - do not forget credit cards, PayPal, Stripe, and other payment platforms

Bank reconciliation is not glamorous, but it is non-negotiable. It is the single best way to ensure your books are accurate and your business finances are under control.