How to do bank reconciliation: 8 steps for your business

Published Thursday 2 April 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• Bank reconciliation steps
• Common bank reconciliation problems
• How to fix bank reconciliation discrepancies
• How to do bank reconciliation the easy way
• How to use bank reconciliation software
• How often should you reconcile your accounts?
• Simplify bank reconciliation with Xero
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank accounts weekly or daily to catch errors early, detect fraud quickly, and make troubleshooting faster since you'll remember recent transactions more clearly.
• Follow a systematic eight-step process starting with gathering your bank statement and business records, then methodically checking deposits and withdrawals in both directions to ensure every transaction matches.
• Use accounting software with automatic bank feeds to reduce manual work from hours to minutes, as it imports transactions automatically and matches them for you while flagging discrepancies.
• Address common discrepancies by checking for timing differences, missing transactions, data entry errors, and payments made from different accounts or with cash that may not appear on your main bank statement.

What is bank reconciliation?

Bank reconciliation is the process of comparing your business records with your bank statement to make sure they match. It's how you verify that every transaction in your books appears correctly in your bank account.

When you reconcile, you're checking two sets of records:

• Your business books: the income and expenses you've recorded
• Your bank statement: the deposits and withdrawals your bank has processed

Most businesses reconcile monthly, but you can do it weekly or even daily. You can complete bank reconciliation manually or use accounting software to speed up the process.

Why bank reconciliation matters

Regular bank reconciliation protects your business finances and improves your decision-making. Here's why it's worth the effort:

• Catches errors early: Spot data entry mistakes, duplicate transactions, or missing records before they become bigger problems
• Detects fraud: Identify unauthorised charges or suspicious withdrawals quickly. This is crucial, as the Association of Certified Fraud Examiners (ACFE) notes that financial statement fraud made up 9% of all reported cases in 2022.
• Improves cash flow visibility: Know exactly how much money you have available to spend, invest, or save
• Prepares you for tax time: Maintain accurate records that make filing easier and reduce audit risk
• Prevents overdrafts: Avoid bounced payments and the fees that come with them
• Supports better decisions: Base your business choices on numbers you can trust

Skipping reconciliation means working with unreliable data. The longer you wait, the harder it becomes to track down discrepancies.

Bank reconciliation steps

Follow these eight steps to reconcile your bank account.

Common bank reconciliation problems

Discrepancies between your books and bank statement are normal. Here are the most common issues and what they typically mean.

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

This usually happens when:

• you received cash or a cheque that you haven't deposited yet
• you paid from a different account or with cash
• you entered a transaction with the wrong date

Check your records and update them with the correct details.

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

This usually happens when:

• you forgot to record a transaction
• you made a data entry error with the amount or date
• the bank processed a fee or automatic payment you weren't expecting

Add the missing transaction or correct the error in your books.

How to fix bank reconciliation discrepancies

When your balances don't match, work through these steps to find the issue:

• Recheck your maths: verify that you've added and subtracted correctly
• Review recent transactions: look at invoices, receipts, and emails from the period you're reconciling
• Check for timing differences: some transactions may be pending or dated differently than expected
• Look at the previous period: the error may have carried forward from an earlier reconciliation

Reconciling weekly or daily makes troubleshooting faster because you'll remember recent transactions more clearly.

How to do bank reconciliation the easy way

Accounting software automates most of the reconciliation process, saving you hours of manual work. This use of proactive data analytics can significantly reduce risk; according to the ACFE, organisations using such tools experience fraud losses 50% lower than those that don't. Instead of switching between documents and comparing numbers line by line, software matches transactions for you and flags anything that needs attention.

How to use bank reconciliation software

Bank reconciliation software connects directly to your bank and imports transactions automatically. This eliminates manual data entry and reduces errors.

When you reconcile in software like Xero, the system:

• matches bank transactions with entries in your accounts automatically
• suggests likely matches for transactions it can't confirm
• prompts you to categorise any unmatched transactions

Check out Xero's bank reconciliation features.

How often should you reconcile your accounts?

Reconcile weekly or daily for best results. The more frequently you reconcile, the faster each session takes because you'll remember recent transactions clearly.

Here's how to make reconciliation easier:

• Set a recurring schedule: block time weekly or daily so it becomes routine
• Keep records organised: store invoices, receipts, and statements where you can access them quickly
• Use software with bank feeds: automatic transaction imports reduce manual work significantly

The longer you wait between reconciliations, the more transactions you'll need to review and the harder it becomes to track down discrepancies.

Simplify bank reconciliation with Xero

Bank reconciliation keeps your financial records accurate and helps you make confident business decisions. Whether you reconcile manually or use software, doing it regularly prevents small errors from becoming big problems.

Xero automates bank reconciliation with direct bank feeds and smart transaction matching. Instead of spending hours comparing numbers, you can reconcile in minutes. See how much time you could save. Get one month free.

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

What is the formula for bank reconciliation?

The basic formula is: Adjusted bank balance = Bank statement balance + Deposits in transit - Outstanding cheques +/- Bank errors. Your adjusted bank balance should equal your adjusted book balance when reconciliation is complete.

How long does bank reconciliation take?

Manual reconciliation can take 30 minutes to several hours depending on your transaction volume. With accounting software like Xero, most small businesses complete reconciliation in under 15 minutes.

What should I do if I can't find the source of a discrepancy?

Recheck your calculations, review the previous reconciliation period, and contact your bank if needed. If you still can't find the error, document the discrepancy and consult your accountant.

What is a three-way bank reconciliation?

A three-way reconciliation matches three records: your bank statement, your book balance, and a third source such as a client trust ledger. This method is common for businesses that manage funds on behalf of others, such as law firms.

Can I reconcile without bank statements?

Yes, if you have access to online banking. Download your transaction history directly or connect your bank to accounting software. If you're missing historical statements, contact your bank to request copies.