Guide

How to Do a Bank Reconciliation: 8 Simple Steps for Your Business

Learn how bank reconciliation saves time, spots errors, and keeps your cash flow accurate.

A small business owner looking at a spreadsheet and doing bank reconciliation

Written by Jotika Teli—Certified Public Accountant with 24 years of experience. Read Jotika's full bio

Published Wednesday 11 February 2026

Table of contents

Key takeaways

  • Perform bank reconciliation regularly (weekly or daily) to catch errors and fraud quickly while transaction details remain fresh in your memory.
  • Use bank reconciliation software with automated feeds to reduce manual work, prevent human errors, and complete the process in minutes rather than hours.
  • Follow a systematic approach by comparing deposits and withdrawals between your bank statements and business records, then investigate and resolve any discrepancies immediately.
  • Establish a consistent reconciliation routine by scheduling dedicated time and keeping all financial records organised to maintain accurate cash flow visibility for better business decisions.

What is bank reconciliation?

Bank reconciliation is the process of matching the transactions in your business's accounting records with the corresponding transactions on your bank statement.

Think of it as double-checking your work to make sure the numbers you have are the same as what the bank has. This helps you spot any differences, catch potential errors, and get a true picture of your cash position.

Why bank reconciliation matters for small businesses

Regularly reconciling your bank account is crucial for your business's financial health. It helps you:

  • Track your cash flow accurately: Know exactly how much money is coming in and going out, so you can make smarter spending decisions.
  • Spot errors quickly: Catch bank errors, incorrect charges, or even fraudulent activity before they grow into bigger problems; issues in the reconciliation process were behind the majority of qualified reports received by the Solicitors Regulation Authority (SRA) over a 12 month period
  • Maintain accurate records: Keep your books clean and up-to-date, which makes tax time far less stressful.
  • Gain financial clarity: Feel confident that you have a precise understanding of your business's financial standing.

Bank reconciliation steps

Follow these eight steps to reconcile your bank account.

Step 1: Get bank records

Gather your transaction data from these sources:

  • Bank statements: Download from online banking or request paper copies
  • Direct feed: Connect bank accounts to accounting software for automatic updates
  • Multiple accounts: Collect statements for all business accounts (current account, credit cards, savings)

Step 2: Get business records

Access your internal financial records:

  • Accounting software: Use your digital ledger of income and expenses
  • Spreadsheets: Open your manual tracking documents
  • Physical records: Gather logbooks, receipts, and invoices
  • Automated systems: Let software capture and extract data from receipts

Step 3: Find your starting point

Find the last time the balance on your business books was the same as the balance in your bank account. Start the reconciliation from there.

Step 4: Run through bank deposits

Make sure each deposit appears as income in your accounts. If something is missing, enter it. You'll need to figure out if it was a sale, interest, a refund, or something else.

Step 5: Check the income on your books

Each entry should match a deposit on your bank statement. If something is missing, find out why. A customer payment might have bounced, for example.

Step 6: Run through bank withdrawals

Record all bank withdrawals in your books, including how to record accounting transactions. This includes things like bank fees, which you might not have accounted for yet.

Step 7: Check the expenses on your books

Each entry should match a withdrawal on your bank statement. If not, find out why. One of your payments may not have cleared yet, or maybe you paid using cash or a different account.

Step 8: End balance

After you've checked all the deposits and withdrawals, your business bank balance should match the totals in your business accounts. This will be the starting point for your next reconciliation.

Check out Xero's bank reconciliation features.

How often should you reconcile your accounts?

The best frequency depends on your business’s transaction volume. Some businesses reconcile monthly, but doing it weekly or even daily can save you time in the long run. Some regulated firms are required to perform reconciliations as often as every five business days under Financial Conduct Authority (FCA) rules.

More frequent reconciliation means you deal with fewer transactions at once, and the details stay fresh in your mind. This makes it much easier to spot and fix any discrepancies quickly.

How to use bank reconciliation software

Bank reconciliation software connects directly to your bank through secure feeds. The software automates the comparison process and reduces manual work, a trend reflected by the fact that 43% of accounting firms classified as digital leaders see digital data and analytics as a high-demand area.

Modern tools offer:

  • Time savings: Complete reconciliation in minutes instead of hours
  • Error reduction: Automated matching prevents human mistakes
  • Real-time updates: Bank feeds provide instant transaction data
  • Simplified workflow: One-click matching for common transactions

The bank reconciliation software process works like this:

  • Automatic import: Transaction data flows directly into your accounting software
  • Smart matching: Software suggests matches between bank transactions and existing entries
  • Quick categorisation: Unmatched transactions prompt you to assign categories
  • Instant updates: Your accounts reflect real-time bank activity

Bank reconciliation problems

Discrepancies between bank statements and business records are common and usually have simple explanations:

  • Timing differences: Cheques issued but not yet cleared
  • Bank fees: Charges not yet recorded in your books
  • Deposits in transit: Money banked but not yet processed
  • Data entry errors: Incorrect amounts or missing transactions

Business books show something that's not on your bank statement?

If a transaction isn't showing on your bank statement, it's most likely because you got income that you didn't bank, or you paid for something out of a different account or with cash. Get to the bottom of it and make the necessary notes.

Bank statement shows something that's not in your business books?

If a transaction isn't showing in your business books, it could be from a keystroke error when you entered a transaction. Or it could be a transaction that you forgot to enter.

Make the required corrections or updates promptly; some regulated firms are even required to correct discrepancies before the end of the business day following their discovery.

Fixing bank reconciliation problems

Regular reconciliation frequency prevents time-consuming detective work:

  • Daily reconciliation: Best for high-transaction businesses, keeps discrepancies minimal
  • Weekly reconciliation: Suitable for most small businesses, maintains fresh transaction memory
  • Monthly reconciliation: Minimum frequency, but increases time spent resolving issues
  • Immediate benefits: Recent transactions are easier to remember and verify

Make bank reconciliation part of your routine

Make bank reconciliation routine with these efficiency strategies:

  • Set a schedule: Block time weekly or daily for reconciliation
  • Organise records: Keep receipts, invoices, and statements easily accessible
  • Use technology: Automate data entry with bank feeds and receipt scanning
  • Track progress: Monitor how long reconciliation takes to identify improvements

Keep your business finances organised

Bank reconciliation can be a straightforward part of running your business. With the right tools and a consistent routine, you can turn it into a simple task that gives you confidence in your numbers. By keeping your accounts reconciled, you're not just doing bookkeeping, you're empowering yourself to make better business decisions.

Ready to see how simple it can be? Get one month of Xero for free and discover how automated bank reconciliation can transform the way you manage your finances.

FAQs on bank reconciliation

Here are answers to some frequently asked questions about bank reconciliation.

What is the formula for bank reconciliation?

There isn't one single formula, but a common formula you can use is:

adjusted bank balance = bank statement balance – outstanding cheques + deposits in transit

The goal is to make this adjusted balance match the cash balance in your accounting records after accounting for things like bank fees or interest.

What is a bank reconciliation journal entry?

You create a journal entry in your accounting records to add any items you find during reconciliation that are not already recorded. For example, you would create a journal entry for bank service fees or interest earned so that your book balance matches the adjusted bank balance.

What are the main steps of bank reconciliation?

The core steps involve gathering your bank statements and business records, comparing deposits and withdrawals between the two, identifying any discrepancies like outstanding checks or deposits in transit, and making adjustments in your books to ensure they match.

Disclaimer

Xero does not provide accounting, tax, business or legal advice. This guide has been provided for information purposes only. You should consult your own professional advisors for advice directly relating to your business or before taking action in relation to any of the content provided.

Download the guide on how to do bookkeeping

Learn about the eight core bookkeeping jobs, from data entry to reporting and tax prep. Fill out the form to receive the guide as a PDF.

Start using Xero for free

Access Xero features for 30 days, then decide which plan best suits your business.