How to do a bank reconciliation: steps to match balance

Published Thursday 26 February 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• Bank reconciliation steps
• Bank reconciliation problems
• How to make bank reconciliation easier
• Simplify bank reconciliation with Xero
• Download the guide on how to do bookkeeping
• Get one month free
• FAQs on bank reconciliation

Key takeaways

• Compare your business records against your bank statement regularly by checking that each deposit appears as income in your books and each withdrawal is recorded as an expense, then verify your ending balances match.
• Reconcile your accounts weekly or daily rather than monthly to catch errors and fraud quickly while transactions are still fresh in your memory.
• Use accounting software with automatic bank feeds to save time by letting the system suggest transaction matches and update your books automatically instead of doing manual comparisons.
• Investigate discrepancies systematically by checking for common causes like timing differences, undeposited payments, bank fees, or data entry errors rather than assuming your records are wrong.

What is bank reconciliation?

Bank reconciliation is when you compare your business financial records to your bank statement to confirm they match. You verify that every transaction you've recorded appears on your bank statement, and that every bank transaction appears in your books.

You're comparing:

• Your business records: The income and expenses you've logged in your ledger, spreadsheet, or accounting software
• Your bank statement: The official record of deposits, withdrawals, and fees from your bank

The goal is to catch errors and identify missing transactions to confirm your financial records are accurate. This process helps prevent what the SEC defines as a material misstatement. That's when a significant error in financial statements could go undetected. When both records match, you know your books reflect reality.

Why bank reconciliation matters

Regular bank reconciliation protects your business and keeps your finances on track. Learn more about what bank reconciliation is.

Catches errors before they become problems

Small mistakes add up. A missed decimal point or duplicate entry can throw off your entire financial picture. Reconciliation helps you spot and fix errors while they're still easy to correct.

Prevents and detects fraud

Unauthorized transactions can go unnoticed for months without regular reconciliation. Comparing your records to your bank statement helps you identify suspicious activity quickly. The SEC lists the ability to identify fraud as one of the primary indicators of a material weakness in a company's internal financial controls.

Keeps your financial records accurate

Accurate books give you a clear picture of your business performance. You can trust your reports, make better decisions, and avoid surprises.

Makes tax time easier

When your records match your bank statements, tax preparation is straightforward. Accurate books are crucial for ongoing obligations. The IRS requires many businesses to make estimated tax payments if they expect to owe $1,000 or more. With reconciled books, you won't scramble to explain discrepancies or hunt for missing documentation.

Bank reconciliation steps

Follow these steps to reconcile your bank account.

1. Get bank records

You need a list of transactions from the bank. Find them in:

• Bank statements: Download from online banking or request paper copies
• Credit card statements: Include these if you use a business credit card
• Automatic bank feeds: Connect your bank directly to accounting software like Xero for real-time data

1. Get business records

Open your ledger of income and expenses. Your records might be in:

• Logbook: Manual record of transactions
• Spreadsheet: Digital tracking in Excel or Google Sheets
• Accounting software: Platforms like Xero that automatically pull in bills and receipts

1. Find your starting point

Find the last time your business books and bank account showed the same balance. This is your starting point for reconciliation.

If you've never reconciled before, start with your most recent bank statement and work backward until you find a matching balance. Going forward, each reconciliation will pick up where the last one ended.

1. Run through bank deposits

Make sure each deposit appears as income in your accounts. If something is missing, determine the source and enter it. Common deposit types include:

• Customer payments: Sales revenue from products or services
• Interest: Earnings from your bank account
• Refunds: Returns from suppliers or overpayments
• Transfers: Funds from other accounts

1. 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.

1. Run through bank withdrawals

All bank withdrawals should be recorded in your books. Commonly missed withdrawals include:

• Bank fees: Monthly maintenance charges, wire transfer fees, or overdraft charges
• Automatic payments: Subscriptions, loan payments, or recurring bills
• Card transactions: Small or forgotten purchases

Review your statement carefully to catch these often-overlooked expenses.

1. 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 you may have paid with cash or a different account.

1. 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.

Bank reconciliation problems

Discrepancies between your books and bank statement are normal. Finding and fixing them is exactly why you do bank reconciliation. Most mismatches have straightforward explanations once you investigate.

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

If a transaction isn't showing on your bank statement, check for these common causes:

• Undeposited income: You received payment but haven't banked it yet
• Different payment method: You paid with cash or from another account
• Timing difference: You made the transaction but it hasn't cleared the bank yet

Note the reason and update your records accordingly.

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

If a transaction isn't showing in your business books, check for these common causes:

• Data entry error: You made a typo when recording the transaction amount or date
• Missing entry: You forgot to record the transaction entirely
• Bank fees: You haven't accounted for automatic charges yet

Make the required corrections to bring your records up to date.

Tips for resolving discrepancies

Resolving mismatches takes less time when you:

• Reconcile frequently: When you reconcile weekly or daily, transactions are fresh in your memory
• Keep organized records: Store invoices, receipts, and emails in one accessible place. This is also a legal requirement. The IRS mandates that businesses keep employment tax records for at least four years. See the IRS recordkeeping requirements.
• Note unusual transactions: Add comments when you record anything out of the ordinary

How to make bank reconciliation easier

Bank reconciliation software saves significant time by automatically comparing your books and bank statement. Instead of switching between documents manually, software pulls everything into one place and suggests matches for you.

Use bank reconciliation software

Most banks send transaction data directly to accounting software through a secure connection. When you reconcile in Xero, the software:

• Suggests matches: Automatically pairs bank transactions with entries in your accounts
• Prompts for details: Asks what unmatched transactions were for and records them
• Updates your books: Enters the information directly into your accounts

Do it regularly

Reconciling regularly takes less time per session than catching up after weeks or months. When transactions are fresh, you remember the details and spot issues faster.

Recommended frequency:

• Daily: Best for high-volume businesses or those using bank feeds
• Weekly: Best balance for most small businesses
• Monthly: Minimum to stay on top of your finances

Schedule a regular time in your calendar and stick to it.

Set up an organized system

Set up a system that makes it quick and easy to access the records you need.

Simplify bank reconciliation with Xero

Bank reconciliation can be simple and fast. Xero connects directly to your bank, suggests transaction matches, and keeps your books accurate with minimal manual work. Free up time to focus on running your business.

Get one month free when you sign up for any Xero plan.

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.

Get one month free

Sign up for any Xero plan and get the first month free.

• Get one month free
• See all features

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

How often should I do bank reconciliation?

Reconcile weekly for most small businesses, or daily if you process high transaction volumes. Monthly reconciliation is the minimum to maintain accurate records. See our bookkeeping for small business guide for more details.

What documents do I need for bank reconciliation?

You need your bank statement (or bank feed data) and your business records, including your ledger, receipts, and invoices for the reconciliation period.

How long does bank reconciliation typically take?

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

What's the formula for bank reconciliation?

The basic formula is: Bank Statement Balance + Deposits in Transit - Outstanding Checks = Adjusted Bank Balance. This should match your adjusted book balance after accounting for any timing differences. Learn more about bank reconciliation.

Can I do bank reconciliation without accounting software?

Yes, you can reconcile manually using spreadsheets or paper records. However, software significantly reduces time and errors by automatically matching transactions and keeping records.