How to do bank reconciliation: a step-by-step guide

Published Tuesday 9 June 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• Types of bank reconciliation
• How to do bank reconciliation step by step
• Bank reconciliation example
• Common bank reconciliation problems and mistakes
• Bank reconciliation frequency and best practices
• Key bank reconciliation terms to know
• How to make bank reconciliation easier
• Simplify bank reconciliation with Xero
• FAQs on bank reconciliation

Key takeaways

• Bank reconciliation is the process of comparing your internal financial records (book balance) against your bank statement (bank balance) to confirm they match, catching errors, fraud, and missing transactions before they become bigger problems.
• Reconciling regularly, whether daily, weekly, or monthly, keeps your cash flow accurate, simplifies tax preparation, and ensures you're ready for audits or financial reviews.
• Following a consistent step-by-step process, from gathering documents to adjusting entries, helps you identify discrepancies quickly and maintain reliable financial records.
• Accounting software like Xero can automate much of the reconciliation process through bank feeds, suggested matches, and real-time updates, saving you significant time each month.

What is bank reconciliation?

Bank reconciliation is the process of matching the transactions in your accounting records to the corresponding entries on your bank statement, confirming that your book balance and bank balance agree. It's a core part of accurate financial management for any small business.

When you reconcile, you're comparing 2 sets of records. Your book balance reflects every transaction you've recorded in your accounting system. Your bank balance shows what the bank has processed during the same period. Any differences between them are called reconciling items, and they need to be investigated and resolved.

A bank reconciliation statement is the document that lists both balances side by side, identifies discrepancies, and shows the adjusting entries needed to bring them into alignment. Under Generally Accepted Accounting Principles (GAAP), accurate financial reporting requires that your records reflect the true state of your finances.

Common reconciling items include outstanding checks, deposits in transit, bank fees, and errors in data entry. Once you identify these items, you record adjusting entries to correct your books so they match the bank's records.

Why bank reconciliation matters

Regular bank reconciliation protects your business by catching errors, preventing fraud, and keeping your financial records accurate. It's one of the most effective ways to stay in control of your money.

Catches errors early. Mistakes happen, whether it's a duplicate entry, a transposed number, or a payment recorded in the wrong amount. Reconciling helps you spot these errors before they snowball into larger problems. When you compare your records to your bank statement regularly, you can correct issues while the details are still fresh.

Prevents and detects fraud. Unauthorized transactions, forged checks, and suspicious withdrawals are easier to catch when you're reviewing every transaction against your records. The sooner you identify fraudulent activity, the faster you can take action to limit losses.

Keeps your records accurate. Accurate books give you a clear picture of where your business stands financially. If your records don't match reality, every decision you make based on those numbers, from hiring to inventory purchases, rests on unreliable data. Learn more about what bank reconciliation is and how it supports your overall financial accuracy.

Makes tax time easier. Clean, reconciled records mean you're not scrambling to find missing transactions when tax season arrives. If your estimated tax liability is $1,000 or more, the IRS requires you to make estimated tax payments throughout the year, and accurate records make those calculations straightforward.

Supports cash flow management. Knowing exactly how much money is in your account, not just what your books say, helps you plan for upcoming expenses, payroll, and growth investments. Reconciliation confirms your available cash so you can make confident decisions.

Ensures audit readiness. If you're ever audited or need to provide financial statements to a lender or investor, reconciled records demonstrate that your books are reliable and well-maintained. It shows that your business follows sound financial practices.

Types of bank reconciliation

There are several approaches to bank reconciliation, and the right one depends on your business size, complexity, and how often you process transactions.

• Periodic reconciliation is the most common approach for small businesses. You compare your records to your bank statement at a set interval, typically monthly, to identify and resolve discrepancies.
• Continuous reconciliation involves matching transactions in real time or near-real time, often with the help of accounting software that automatically imports bank data. This approach reduces the risk of errors piling up and is ideal for businesses with high transaction volumes.
• Intercompany reconciliation applies when you operate multiple business entities. It involves matching transactions between those entities to confirm internal transfers, loans, and payments are accurately recorded on both sides.
• Accounts receivable reconciliation focuses specifically on matching incoming payments from customers against the invoices in your records. It helps you identify unpaid invoices, duplicate payments, and posting errors.
• Accounts payable reconciliation compares what you owe to vendors and suppliers against the payments recorded in your bank statement. It confirms that all outgoing payments match the amounts and dates in your books.

How to do bank reconciliation step by step

Reconciling your bank account follows a clear process. Here's how to work through it efficiently, whether you're doing it manually or using bank reconciliation features in your accounting software.

1. Gather your documents

Start by collecting your bank statement for the period you're reconciling and your internal accounting records for the same period. If you use accounting software like Xero, your recorded accounting transactions are already organized and accessible. Make sure both sets of records cover the same date range.

2. Compare your balances

Note the ending balance on your bank statement and the ending balance in your accounting records. These 2 numbers are your starting point. If they match exactly, you may not have any reconciling items, but it's still worth checking individual transactions.

3. Match transactions one by one

Go through each transaction in your bank statement and find the corresponding entry in your books. Check that amounts, dates, and descriptions align. In Xero, bank feeds pull transactions directly from your bank, and the software suggests matches to speed up this step. Mark each matched transaction as reconciled.

4. Identify and investigate discrepancies

Any transaction that appears in one record but not the other is a reconciling item. Common examples include outstanding checks that haven't cleared the bank yet, deposits in transit, bank fees you haven't recorded, and interest payments. Note each discrepancy and determine whether it's a timing difference or an error that needs correcting.

5. Record adjusting entries

For each discrepancy that isn't simply a timing difference, record an adjusting entry in your books. This might include adding bank fees you missed, correcting a data entry error, or recording a transaction you forgot to enter. Once all adjustments are made, your book balance and bank balance should match.

6. Document and review

Save your completed bank reconciliation statement along with any supporting notes about the adjustments you made. This documentation creates an audit trail and makes future reconciliations easier. Review the final numbers to confirm everything ties out before closing the period.

Bank reconciliation example

Here's a practical example of how bank reconciliation works for a small business.

Imagine your company, Riverside Landscaping, is reconciling its checking account for the month of April. Your bank statement shows an ending balance of $12,450. Your accounting records show a book balance of $11,925. That's a difference of $525, and you need to find out why.

First, you compare transactions and find these reconciling items:

• A deposit of $1,200 from a customer payment was recorded in your books on April 30, but it hadn't cleared the bank by the statement date. This is a deposit in transit.
• 2 checks totaling $1,750 were written and recorded in your books but haven't been cashed yet. These are outstanding checks (check #1042 for $1,000 and check #1043 for $750).
• A $25 monthly bank service fee appears on the bank statement but wasn't recorded in your books.

Now apply the reconciliation formula:

Bank statement balance: $12,450

Plus deposits in transit: + $1,200

Minus outstanding checks: - $1,750

Adjusted bank balance: $11,900

Book balance: $11,925

Minus unrecorded bank fees: - $25

Adjusted book balance: $11,900

Both adjusted balances now equal $11,900. The reconciliation is complete. You'd then record an adjusting entry in your books for the $25 bank fee so your records stay current going forward.

Common bank reconciliation problems

Even with a clear process, bank reconciliation can hit snags. Understanding the most common issues helps you resolve them faster and avoid repeating them.

Transactions in your books but not on the bank statement. Outstanding checks and recent deposits that haven't cleared the bank yet are the most frequent cause. These are usually timing differences, not errors. Track them and confirm they clear in the next period.

Transactions on the bank statement but not in your books. Bank fees, interest charges, automatic payments, and direct debits can appear on your statement without a matching entry in your records. Review your statement carefully for any transactions you haven't recorded.

Data entry errors. Transposed numbers, incorrect amounts, and duplicate entries create discrepancies that are sometimes hard to spot. If your balances are off by a number divisible by 9, that's often a sign of a transposition error (for example, entering $540 instead of $450).

Not reconciling frequently enough. Waiting months between reconciliations makes it much harder to track down discrepancies. The longer you wait, the more transactions you have to sift through, and the more likely that errors compound.

Ignoring small discrepancies. A few cents off might seem harmless, but small discrepancies can signal larger underlying issues. Every difference should be investigated and resolved, no matter the amount.

Failing to account for bank fees. Monthly service charges, wire transfer fees, overdraft fees, and ATM charges add up. If you don't record them, your book balance will consistently be higher than your actual bank balance.

Not documenting adjustments. Every adjusting entry should include a note explaining what was corrected and why. Without documentation, you'll have trouble explaining discrepancies during an audit, and future reconciliations become harder. The IRS recordkeeping requirements specify that employment tax records must be kept for at least 4 years, so thorough documentation is essential.

Mixing personal and business transactions. Using one account for both personal and business expenses creates confusion and makes reconciliation significantly more difficult. Keep separate accounts for your business finances.

To resolve discrepancies efficiently, start with the largest differences first, check for timing issues before assuming errors, and verify that all automatic transactions are properly recorded.

Bank reconciliation frequency and best practices

How often you reconcile depends on your transaction volume and risk tolerance, but doing it regularly is what matters most.

Daily reconciliation works well for businesses with high transaction volumes, such as retail or e-commerce. Checking your accounts each day keeps discrepancies from piling up and gives you an accurate picture of your cash position.

Weekly reconciliation is a good middle ground for businesses with moderate activity. It catches issues before they become difficult to trace while keeping the workload manageable.

Monthly reconciliation is the minimum recommended frequency. It aligns with your bank statement cycle and is suitable for businesses with lower transaction volumes. Many small business owners reconcile monthly as part of their bookkeeping routine.

Beyond choosing a cadence, these best practices will help you maintain accurate records:

• Segregate duties. If possible, have someone other than the person who records transactions perform the reconciliation. This separation reduces the risk of errors going undetected and helps prevent fraud.
• Document everything. Keep a record of each reconciliation, including the date, the person who performed it, any discrepancies found, and the adjustments made. This creates an audit trail you can reference later.
• Set a regular schedule. Pick a specific day each week or month for reconciliation and stick to it. Consistency prevents backlog and keeps your records current.
• Use accounting software. Tools like Xero automate much of the process through bank feeds and suggested transaction matches. Automation reduces manual data entry and the errors that come with it.
• Review your . After reconciling, check your trial balance to confirm that debits and credits are in alignment across all accounts.
• Follow up on outstanding items. If a check hasn't cleared or a deposit hasn't posted after a reasonable period, investigate. Stale outstanding items may indicate lost payments or processing issues.

Key bank reconciliation terms to know

Understanding these terms makes the reconciliation process clearer and helps you communicate effectively with your accountant or bookkeeper.

• Outstanding checks: checks you've written and recorded in your books that haven't been cashed or cleared by the bank yet. They reduce your bank balance once they're processed.
• Deposits in transit: payments you've received and recorded in your books that haven't appeared on your bank statement yet. They increase your bank balance once the bank processes them.
• NSF (non-sufficient funds) checks: checks deposited into your account that bounced because the payer's account didn't have enough funds. Your bank reverses the deposit, so you need to adjust your records accordingly.
• Bank fees: charges from your bank for services like account maintenance, wire transfers, overdrafts, and ATM usage. These reduce your bank balance and need to be recorded in your books.
• Book balance vs. bank balance: your book balance is the running total in your accounting records, while your bank balance is the amount the bank shows in your account. The goal of reconciliation is to make these 2 numbers agree after accounting for timing differences and adjustments.
• Reconciling items: any transactions that cause a difference between your book balance and bank balance. These include outstanding checks, deposits in transit, bank fees, errors, and unauthorized transactions.
• Adjusting entries: journal entries you make in your accounting records to correct errors or record transactions (like bank fees) that were missing. These entries bring your book balance into agreement with the bank balance.

How to make bank reconciliation easier

The right tools and habits can turn bank reconciliation from a tedious chore into a quick, routine task.

Accounting software like Xero simplifies reconciliation by connecting directly to your bank through automatic bank feeds. Transactions flow into the software as they occur, so you don't have to manually enter every payment and deposit.

Xero's suggested matches compare imported bank transactions against the entries in your books and recommend likely matches. You review each suggestion and confirm it with a click, which cuts the time spent hunting for corresponding entries. When a transaction needs more detail, Xero prompts you to add the necessary information, such as the account category or a reference number. This keeps your records complete and reduces the chance of missing details during reconciliation. Every confirmed match updates your books in real time. Your balances stay current, and you always have an accurate view of your financial position.

The more frequently you reconcile, the fewer transactions you have to review each time. Daily or weekly reconciliation, combined with automatic bank feeds, keeps the process manageable and your records reliable.

Simplify bank reconciliation with Xero

Bank reconciliation doesn't have to be a time-consuming, manual process. With Xero's automatic bank feeds, suggested transaction matches, and real-time updates, you can reconcile your accounts faster and with greater accuracy. Spend less time on bookkeeping and more time running your business.

Get one month free

FAQs on bank reconciliation

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

What is a bank reconciliation statement?

A bank reconciliation statement is a document that compares your accounting records to your bank statement for the same period. It lists the starting balances, identifies reconciling items (like outstanding checks and deposits in transit), shows any adjusting entries, and confirms that the adjusted balances match.

How often should I do bank reconciliation?

At a minimum, reconcile monthly when you receive your bank statement. If your business processes a high volume of transactions, weekly or even daily reconciliation helps you catch discrepancies sooner and keeps your cash flow picture accurate.

What's the formula for bank reconciliation?

The standard formula is: Bank Statement Balance + Deposits in Transit - Outstanding Checks = Adjusted Bank Balance. On the books side: Book Balance + Credits Not Yet Recorded - Debits Not Yet Recorded = Adjusted Book Balance. Both adjusted balances should be equal when the reconciliation is complete.

What documents do I need for bank reconciliation?

You need your bank statement for the reconciliation period and your internal accounting records (general ledger or cash book) for the same period. Having access to check registers, deposit slips, and any previous reconciliation statements also helps you track down discrepancies.

Who should do bank reconciliation in a small business?

Ideally, someone other than the person who records daily transactions should handle reconciliation. This segregation of duties adds a layer of oversight that helps catch errors and prevent fraud. If you're a solopreneur, consider having your accountant or bookkeeper review your reconciliation periodically.

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.