Guide

Bank reconciliation: what it is and how to do it right

Learn how to do bank reconciliation step by step to match records and catch errors fast.

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 1 April 2026

Table of contents

Key takeaways

  • Reconcile your bank account weekly or daily to catch errors early, prevent fraud, and maintain accurate cash flow records before discrepancies become bigger problems.
  • Use automated bank reconciliation software instead of manual processes to reduce error rates by over 70% and turn hours of work into minutes of review.
  • Follow the eight-step process systematically by gathering bank and business records, checking deposits and withdrawals match on both sides, and investigating any discrepancies until balances align.
  • Address unmatched transactions immediately by adding missing entries, correcting data entry errors, or noting timing differences to prevent backlogs from accumulating.

What is bank reconciliation?

Bank reconciliation is the process of comparing your business records against your bank statement to make sure they match. It helps you verify that every transaction in your books appears correctly in your bank account, and vice versa.

When you reconcile, you're checking that:

  • deposits in your records match deposits on your bank statement
  • withdrawals and payments align across both records
  • your ending balance matches what the bank shows

Reconciling regularly catches errors early, prevents fraud, and gives you an accurate picture of your cash position. The stakes are high, as one survey found that financial statement fraud constituted 9% of all reported fraud cases in 2022.

Why bank reconciliation is important

Reconciling your bank account protects your business by catching errors, preventing fraud, and ensuring your financial records are accurate. Without it, you could be making decisions based on incorrect numbers.

Here's why it matters:

  • Catch errors early: Spot data entry mistakes, duplicate transactions, or missing records before they become bigger problems
  • Prevent fraud: Identify unauthorised transactions or suspicious activity quickly
  • Maintain accurate cash flow: Know exactly how much money you have available at any time
  • Simplify tax time: Clean records make tax preparation faster and reduce the risk of compliance issues
  • Build confidence: Make business decisions based on numbers you can trust

How to do bank reconciliation

Reconciling your bank account compares your business records against your bank statement to verify every transaction matches. Follow these eight steps to complete the process.

1. Get bank records

Gather a complete list of transactions from your bank for the period you're reconciling. You can get this from:

  • a printed or PDF bank statement
  • your online banking portal
  • a direct bank feed to your accounting software

If you use multiple accounts, such as a current account and a credit card, collect statements for each one.

2. Get business records

Open your record of income and expenses for the same period. This might be in:

  • a physical logbook
  • a spreadsheet
  • accounting software like Xero

Some accounting software pulls in bills and receipts automatically using data capture tools. This reflects a broader industry trend that saves time when entering data manually. In 2024, businesses manually entered only 60% of invoices into ERP accounting systems, a significant drop from 85% the previous year.

3. Find your starting point

Identify the last date when your business records and bank balance matched exactly. This becomes your starting point for reconciling.

If you've never reconciled before, start from the beginning of the current month or accounting period.

4. Run through bank deposits

Check that each deposit on your bank statement appears as income in your business records. If something is missing, add it and categorise it correctly.

Common deposit types include:

  • customer payments
  • bank interest
  • refunds from suppliers
  • loan deposits

5. Check the income on your books

Verify that each income entry in your records matches a deposit on your bank statement. If an entry doesn't appear on your statement, investigate why.

Common reasons include:

  • a customer payment that bounced
  • a deposit you recorded but haven't banked yet
  • a timing difference between recording and clearing

6. Run through bank withdrawals

Check that every withdrawal on your bank statement appears in your business records. Add any missing transactions.

Commonly missed withdrawals include:

  • bank fees and charges
  • direct debits
  • automatic subscription payments
  • interest charges

7. Check the expenses on your books

Verify that each expense entry in your records matches a withdrawal on your bank statement. If an entry doesn't appear, investigate the cause.

Common reasons include:

  • a payment that hasn't cleared yet
  • a payment made from a different account
  • a cash payment not linked to your bank account

8. End balance

After checking all deposits and withdrawals, your business records should match your bank statement balance. This final balance becomes the starting point for when you next reconcile.

If the balances don't match, review each step to find where they differ. Common causes include missed transactions, data entry errors, or timing that differs.

Manual vs automated bank reconciliation

Automated bank reconciliation saves time by eliminating the need to enter data manually and matching transactions for you, freeing up staff to focus on high-value tasks instead of routinely collecting data. Here's how the two approaches compare.

Manual bank reconciliation

Reconciling manually involves comparing paper or PDF bank statements against your records line by line. This approach:

  • requires switching between documents repeatedly
  • takes longer as transaction volume grows
  • increases the risk of human error, with some manual processes generating error rates as high as 45%
  • works for businesses with few transactions

Automated bank reconciliation with software

Accounting software like Xero connects directly to your bank through a secure feed. When you reconcile, the software:

  • pulls in bank transactions automatically
  • suggests matches with entries in your records
  • asks you to categorise unmatched transactions
  • updates your books instantly

Automating turns hours of manual work into minutes of review, and studies show it can also improve accuracy, with one finding the process reduced errors by more than 70%.

Common bank reconciliation problems and solutions

It's normal when your records and bank statement don't match. They happen to every business. What matters is identifying and fixing them quickly.

Business books show something not on your bank statement

If a transaction appears in your records but not on your bank statement, common causes include:

  • Unbanked income: You recorded a sale but haven't deposited the funds yet
  • Different account used: You paid from a different bank account or used cash
  • Timing difference: The transaction hasn't cleared the bank yet

Solution: Check your deposit records and payment methods. Update your notes to explain the discrepancy.

Bank statement shows something not in your business books

If a transaction appears on your bank statement but not in your records, common causes include:

  • Forgotten entry: You made a payment but didn't record it
  • Data entry error: A keystroke mistake caused the transaction to be recorded incorrectly
  • Automatic payments: Direct debits or subscriptions you forgot to track

Solution: Add the missing transaction to your records or correct any errors.

How to troubleshoot bank reconciliation discrepancies

Finding transactions that don't match can take time, especially if you're reconciling a long period. To speed up the process:

  • Reconcile frequently: Reconciling weekly or daily means fewer transactions to review and fresher memories of each one
  • Keep organised records: Store invoices, receipts, and payment confirmations where you can find them quickly
  • Use software to match: Accounting software suggests matches automatically, reducing the need to search manually

Best practices for bank reconciliation

Reconciling regularly prevents problems from building up. The longer you wait, the more transactions you'll need to review. This can cause significant backlogs. Research shows that half of finance teams take six or more business days to close their books each month.

Follow these practices to keep reconciling manageable:

  • Reconcile weekly or daily: Shorter periods mean fewer transactions and fresher memories
  • Schedule dedicated time: Block time in your calendar so reconciling doesn't get pushed aside
  • Organise your records: Keep invoices, receipts, and payment confirmations easy to access
  • Use bank feeds: Connect your bank to accounting software to reduce manual data entry
  • Address issues immediately: Don't let unresolved items accumulate

FAQs on bank reconciliation

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 payments ± Bank errors. Your adjusted bank balance should equal your adjusted book balance after accounting for timing differences and correcting errors. The passage of the Sarbanes–Oxley Act (SOX) in 2002 emphasised this type of internal control, requiring companies to formalise their own reconciliation procedures.

How long does bank reconciliation take?

Reconciling manually can take several hours depending on transaction volume. With accounting software like Xero, most small businesses complete reconciling in 15 to 30 minutes.

What's the difference between bank reconciliation and bookkeeping?

Bookkeeping is the ongoing process of recording all financial transactions. Bank reconciliation is a specific check that compares your bookkeeping records against your bank statement to verify they're accurate.

Can I do bank reconciliation myself or do I need an accountant?

Most small business owners can do bank reconciliation themselves, especially with accounting software that automatically matches transactions. An accountant can help if you have complex transactions or persistent discrepancies you can't resolve.

What happens if my bank reconciliation doesn't balance?

If your records don't match your bank statement, review each transaction to find the discrepancy. Common causes include transactions you missed entering, data entry errors, timing that differs, or bank fees you haven't recorded. Address each issue until the balances 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.