How to Do Bank Reconciliation Before Small Errors Grow Into Bigger Problems

Most accounting discrepancies we’ve seen don't announce themselves. They hide in the gap between what your books say the bank balance is and what the bank actually holds. Bank reconciliation closes that gap, finds every difference, and confirms both sides agree before small errors grow into something harder to explain.

In this guide, we explore what bank reconciliation is, its main types, a step-by-step walkthrough, and the challenges most finance teams face.

In brief:

• Bank reconciliation compares your internal financial records to the bank's statement to identify timing differences, errors, and unauthorized transactions. Most teams should reconcile at least monthly.
• The three main approaches are manual (spreadsheet-based), bank feed-assisted (software imports transactions automatically), and automated (rule-based matching). Each fits a different transaction volume.
• The process has seven steps: gather documents, record starting balances, match deposits, match withdrawals, review remaining bank items, calculate adjusted balances, and post adjusting entries.
• Regular reconciliation is one of the most reliable fraud detection controls for small and midsize businesses, catching unauthorized charges before losses grow.
• Companies processing high transaction volumes get the most value from automated platforms that surface exceptions rather than requiring line-by-line manual matching.

What is bank reconciliation?

Bank reconciliation is the process of comparing a company's internal financial records against the bank's records to confirm both sides match. The internal ledger tracks every payment and deposit from the company's perspective, and the bank statement tracks the same activity from the bank's side.

These two records rarely agree right away because timing differences, bank fees, and occasional errors all create gaps. Reconciliation finds and explains every difference until both sides agree.

Regular reconciliation is a core bookkeeping responsibility in a growing business, and in lean teams, it often falls to an operations lead or office manager who handles finance alongside other duties. If you're in that position, reconciliation is likely already on your plate, whether or not anyone formally assigned it to you.

Benefits of bank reconciliation

Regular reconciliation keeps the books clean while protecting cash, credibility, and your tax position.

The most tangible benefits show up in four areas:

• Fraud detection: Organizations lose an estimated 5% of annual revenue to fraud, according to the ACFE's 2024 Report to the Nations. Monthly reconciliation is one of the most reliable fraud controls for catching unauthorized transactions before losses grow.
• Cash flow accuracy: Outstanding checks, written but not yet cashed, can overstate a bank account balance and trigger overdrafts if working capital decisions are based on that inflated number.
• Tax compliance: Inaccurate books produce inaccurate tax filings in both directions, so monthly reconciliation helps catch cash flow errors before they flow into returns and supporting records.
• Lender and investor credibility: Cash accounts that aren't reconciled consistently raise questions about the reliability of the overall accounting records.

For teams where one person handles finance alongside other duties, reconciliation also surfaces smaller problems, such as subscription fees on corporate cards or vendor double charges buried in long statements that would otherwise go unnoticed for months.

The method your team uses often determines how much of this value you capture, and the options range from purely manual to largely automated.

3 types of bank reconciliation and how they work

Companies typically move along a spectrum as transaction volume and team capacity change. The three approaches below cover most configurations, from lean teams to high-volume operations.

1. Manual bank reconciliation

Manual bank reconciliation involves line-by-line comparison of your internal ledger against the bank statement, typically in a spreadsheet or on paper. Your team downloads or prints the bank statement, then matches each deposit and withdrawal against internal records one by one.

This method works for low transaction volume and simple banking relationships. The main advantage is that it costs nothing beyond your staff time and forces a review of every transaction.

The main drawback is that it scales poorly: as the company grows, more transactions mean more data entry, more matching, and greater room for error. If reconciliation is consuming significant time each month, your team may have outgrown this approach.

2. Bank feed-assisted reconciliation

Bank feed-assisted reconciliation uses an accounting software's direct connection to the bank to import transactions automatically. Instead of manually entering every transaction, your finance team reviews imported items and matches them against existing entries in the books.

Many platforms offer rule-based matching for recurring transactions, so a monthly rent payment or payroll withdrawal gets categorized with less manual work.

This approach works well for growing companies. It reduces manual data entry, one of the most time-consuming parts of the process, without adding cost beyond the existing software subscription.

The main risk is duplicate entries. If someone manually records a transaction and the bank feed imports it as well, the same item is recorded twice. Make sure everyone on your team understands how bank feeds interact with manual entries before relying on this method.

3. Automated reconciliation

Automated reconciliation uses rule-based or pattern-based matching to reconcile most transactions without human involvement. These systems import data via API, normalize it across formats and currencies, match transactions based on amount, date, and description, and surface only unmatched or anomalous items for human review.

This approach fits companies that process high transaction volumes or operate in complex environments, such as e-commerce or distribution. Automated systems still require human judgment on exceptions, and matching performance depends on how consistent the underlying transaction data is.

If your chart of accounts is fragmented or your banking relationships are spread across multiple institutions, expect higher exception rates. Regardless of which method fits best, the underlying reconciliation logic follows the same sequence.

How to do bank reconciliation step by step

Whether you're reconciling manually or reviewing automated matches, the underlying logic is the same. We walk through each step below: start by adjusting the bank's ending balance for items the bank doesn't know about yet, then adjust the book balance for items not yet reflected in the books, and confirm both adjusted numbers match.

1. Gather your documents

Before you start, collect the documents needed for the reconciliation period:

• Bank statement: The bank's record of all deposits and withdrawals for the period
• General ledger balance: The ending cash account balance from your accounting software
• Deposit records: Receipts and payment confirmations for the period
• Outstanding checks and invoices: Check stubs or records of payments not yet cleared

If you have multiple bank accounts, run a separate reconciliation for each one before combining results.

2. Record both starting balances

Write down two figures side by side: the ending balance per the bank statement and the ending balance per the books. These will almost always differ, and that's expected. The job is to explain every dollar of difference.

The size of the gap matters less than your ability to explain it. For instance, a $5,000 difference made up of a single outstanding check is a clean reconciliation; a $500 difference with three unexplained items is messier.

Keep both starting figures visible throughout the process, because every adjustment you make will move one side or both closer to a match.

3. Match deposits and credits

Compare every deposit on the bank statement to a corresponding entry in the books. Any deposits you've recorded internally that haven't appeared on the bank statement yet are "deposits in transit." Add these to the bank statement balance on the reconciliation worksheet.

Also watch for deposits that appear on both the bank statement and in the books but with different amounts, which can happen with payment processors that batch deposits or net fees before settling.

If a deposit recorded near the end of the period still hasn't cleared a few days into the next statement cycle, follow up to confirm it posted to the correct account, since a misdirected deposit won't surface in any other reconciliation.

4. Match checks and withdrawals

Compare every cleared check, ACH debit, and automatic payment against internal records. Checks written but not yet cashed are "outstanding checks." Subtract these from the bank statement balance.

Bank fees, wire transfer charges, and NSF fees that appear on the statement but aren't in the books yet get subtracted from the book balance.

5. Review remaining bank items

Look for anything not yet matched: interest earned, notes collected by the bank, or bounced customer checks. Interest earned gets added to the book balance. NSF checks get subtracted from the book balance and moved back to accounts receivable since the customer still owes the amount.

Items that can't be matched after this step deserve the most attention. Small recurring credits or debits under $100 are worth scrutinizing because they're the amounts most likely to be skipped over. When you encounter a transaction you genuinely can't identify from internal records, contact the bank directly for a description before posting any adjustment.

6. Calculate both adjusted balances

For the bank side: bank statement balance plus deposits in transit, minus outstanding checks, plus or minus any bank errors. For the books side: book cash balance plus credits not yet recorded, minus debits not yet recorded, plus or minus any recording errors.

Both adjusted balances must be equal. If a remaining difference is divisible by 9, that often signals a transposition error where digits were accidentally reversed.

7. Record adjusting entries and document

Only items that adjusted the book balance require journal entries. Bank-side items, such as deposits in transit and outstanding checks, are timing differences that clear on their own. Record entries for bank fees, interest earned, NSF checks, and any errors found in the books.

Then save the completed reconciliation with all supporting documents. You should retain these records for at least 3 years, though many companies keep them longer for audit protection. Even with a clean process, certain challenges recur.

Bank reconciliation challenges and how the right software helps

Even when your team understands the process, specific problems appear every close cycle, especially when finance isn't anyone's primary role. The right accounting software won't eliminate the need for human review, but it can reduce manual work and catch issues that might otherwise slip through.

Duplicate entries from bank feeds and manual entry overlapping

When someone records a transaction manually, and the bank feed also imports it, balances get inflated without any obvious red flag. Look for software that flags potential duplicates before posting and lets you set rules that prevent double-counting.

A platform with automated expense management that feeds directly into the ledger removes the manual entry step entirely, which reduces this risk at the source.

Unrecorded bank fees and service charges

Banks deduct fees, wire charges, and NSF penalties that many teams assume their software captures automatically, but it doesn't. These charges create a recurring balance gap that widens each month if no one records them.

Choose accounting platforms with bank feed integrations that surface these charges during the matching process and automatically alert you to new or unusual fees.

Month-end time crunch and investigation backlogs

When reconciliation occurs in a single compressed window at month-end, your team is racing to match transactions, make adjusting entries, and close the books all at once. Software that supports smaller, more frequent reconciliation batches throughout the month reduces the end-of-period spike.

More frequent reconciliation in smaller sessions often requires less total effort than one large monthly close.

Missing documentation and audit trail gaps

Reconciliations get completed, but supporting evidence for adjustments and reviewer sign-offs can get skipped under time pressure. When someone leaves the team, the institutional knowledge about prior adjustments goes with them.

Look for platforms with built-in workflows and approval permissions that enforce separation of duties between the person handling cash and the person reconciling it.

Automate your reconciliation process

From our experience, if reconciliation still feels like a monthly fire drill, the problem usually isn't the people doing the work. It's the process and tools underneath them. When bank feeds, expense categorization, and approval workflows are fragmented across multiple systems, month-end close becomes a manual matching exercise.

The right platform connects directly to your bank accounts, automatically categorizes transactions, and flags exceptions for review so the team isn't matching every line by hand.

Modern automation platforms like Ramp do exactly this, linking real-time spend data to your general ledger. Hence, reconciliation runs on clean, current information, and bookkeeping mistakes are easier to catch before they pile up.

Frequently asked questions about bank reconciliation

How often should a small business reconcile its bank accounts?

Monthly reconciliation is a practical minimum for most teams because it provides a regular opportunity to catch errors before they compound. Companies processing high transaction volumes in retail, e-commerce, or distribution may benefit from more frequent reconciliation, which surfaces discrepancies faster and can reduce the total effort required per session.

Who should perform bank reconciliation?

The person handling reconciliation should not be the only person with visibility into cash activity if your team can avoid it. Separation of duties reduces fraud risk. If the team is too small for full separation, have the owner or a supervisor review and sign off on each completed reconciliation.

What's the difference between bank-side and book-side adjustments?

Bank-side adjustments account for items the bank doesn't yet know about, such as deposits in transit and outstanding checks. These timing differences don't require journal entries. Book-side adjustments cover items that the records don't yet reflect, such as bank fees and NSF checks, and require journal entries.

Can bank reconciliation detect fraud?

Bank reconciliation is one of the most effective fraud detection controls for small and midsize companies. According to the ACFE's 2024 Report to the Nations, asset misappropriation was the most common fraud scheme with median losses well above $120,000 per case. Regular reconciliation catches unauthorized transactions that would otherwise go undetected for months.