Beancount.io LogoBeancount.io

Bank Reconciliation Done Right: The Monthly Process That Catches Errors and Fraud Early

13 min readMike ThriftMike Thrift
Bank Reconciliation Done Right: The Monthly Process That Catches Errors and Fraud Early

Open your accounting software. Look at the cash balance for your operating account. Now open your online banking. Look at that balance.

They almost certainly disagree — and that's normal. The question is whether you can explain why they disagree, line by line, in five minutes. If you can, your books are reconciled. If you can't, your cash balance is a guess, and a guess is not something you should be making payroll, tax, or borrowing decisions on.

Bank reconciliation is the monthly ritual that turns a guess into a number you can defend. It's also, by a wide margin, the most cost-effective fraud control a small business has. Check fraud at U.S. banks rose roughly 385 percent between 2021 and 2023, and the typical occupational fraud case runs about 12 months before anyone notices. The reason it runs that long is almost always the same: nobody was reconciling the bank account, or someone was reconciling it badly.

This guide walks through what reconciliation actually is, the step-by-step monthly process, the recurring items that throw people off, and the controls that turn the exercise into real fraud protection rather than a checkbox.

What Bank Reconciliation Really Is

A bank reconciliation is a written explanation of the difference between two numbers as of a single date:

  1. The cash balance shown on your bank statement at month end.
  2. The cash balance shown in your general ledger for that same account on the same date.

These two numbers will never be identical in the real world, because your books and the bank are recording the same transactions on different days. You write a check on March 28; the vendor cashes it on April 4. You record a customer deposit on March 31; the bank posts it on April 1. The bank charges a wire fee on March 30; you don't see it until you read the statement. None of these are errors — they are timing differences, and reconciliation is the document that lists them.

The point of the document is to prove that once you adjust both sides for legitimate timing differences and missed entries, the two numbers come out exactly equal. Not "close." Not "off by $43.27." Equal. A zero-tolerance difference is the only standard that works, because the moment you accept "small" variances, you lose the ability to tell a small variance from the early stage of a real problem.

The Two-Column Worksheet

Every bank reconciliation, no matter what software you use, follows the same structure. You build two columns and adjust each toward the same final number.

Bank side

  • Start: ending balance per the bank statement.
  • Add: deposits in transit (recorded on your books, not yet on the bank statement).
  • Subtract: outstanding checks and other unpresented disbursements.
  • Adjust for: any bank errors you've identified.
  • Equals: the adjusted bank balance.

Book side

  • Start: ending cash balance in your general ledger.
  • Add: items the bank has credited that you haven't booked yet (interest, EFT receipts, lockbox collections).
  • Subtract: items the bank has debited that you haven't booked yet (service charges, NSF returns, automatic withdrawals, wire fees).
  • Adjust for: any bookkeeping errors you've identified.
  • Equals: the adjusted book balance.

The reconciliation is finished only when adjusted bank balance = adjusted book balance. Anything that adjusts the book side becomes a journal entry; anything that adjusts the bank side simply waits to clear next month.

The Recurring Items That Trip People Up

A handful of items appear on almost every reconciliation. Knowing how to handle each one keeps the close moving.

Outstanding Checks

A check you've written and recorded that hasn't yet hit the bank. It already reduced your book cash balance, so it must reduce the bank balance to match. Track these in a running list with check number, payee, amount, and date issued. A check that's been outstanding for more than 90 days deserves a phone call — the payee may have lost it, in which case you'll need to issue a stop-payment and reissue. After six months most banks will refuse to honor the original anyway, and stale uncashed checks may trigger state unclaimed-property reporting obligations.

Deposits in Transit

A deposit you recorded on the last day of the month that the bank didn't post until the first day of the next. Add to the bank balance. If a "deposit in transit" persists into the following month's statement and never appears, you have a problem — either the deposit never made it to the bank or it was diverted.

Bank Service Charges, Wire Fees, and Account Analysis Charges

The bank takes these out automatically; you didn't book them. Subtract from the book side and record a journal entry that debits the appropriate expense account and credits cash.

Interest Earned

The bank credits interest you haven't booked. Add to the book side and record a journal entry crediting interest income.

NSF (Non-Sufficient Funds) Returns

A customer's check that you deposited bounces. The bank reverses the original credit, often charging you an additional fee. You need to subtract the original deposit from your book balance, subtract the bank's NSF fee, and re-establish the receivable from the customer. Don't forget the second part — many small businesses write off the bounced check but never re-bill the customer.

EFT and ACH Activity

Subscriptions, merchant processor fees, payroll tax debits, automatic loan payments. These hit the bank without any check or paper trail to prompt a journal entry. Reconciliation is often the only time these get recorded properly. Build a recurring journal entry template for the predictable ones.

Bank and Book Errors

Real bank errors are rare but they exist — transposed digits, deposits credited to the wrong account, duplicate postings. When you find one, document it clearly, contact the bank in writing, and adjust the bank side until it's corrected. Bookkeeping errors are far more common: amounts entered as $1,234.50 instead of $1,243.50, deposits doubled because both the bank feed and a manual entry hit the system, checks recorded to the wrong month. Fix book errors with journal entries, not with by editing the original transaction (you want an audit trail).

The Step-by-Step Monthly Process

Here is a concrete sequence that works whether you have one bank account or twenty.

1. Wait for the Statement, Then Lock the Period

Don't reconcile against a mid-cycle balance. Wait for the official statement that closes on the last day of the month (or whatever your cycle date is). Lock the prior month in your accounting system so no one can backdate transactions into it after you've signed off.

2. Confirm the Beginning Balance

The first sanity check is whether the beginning balance on this month's bank statement matches the ending adjusted bank balance from last month's reconciliation. If it doesn't, last month wasn't really reconciled, and the rest of this month's work will be built on sand. Stop and find the break.

3. Tick Every Bank Transaction

Go through the bank statement line by line and find the matching entry in your books. Check off (or "tick") each match. Use the statement order, not the book order — that way unmatched bank items stick out at the end, and you'll catch missing journal entries faster.

4. List the Unmatched Items

Anything on the bank statement with no book entry needs one — usually fees, interest, EFTs, or NSF returns. Anything on your books with no bank entry is either a deposit in transit, an outstanding check, or an error.

5. Build the Reconciliation

Use the two-column worksheet above. Most accounting systems generate it automatically once you mark items as cleared, but don't trust the software's "auto-match" blindly — review the matches it proposed before accepting them, because matching by amount alone is exactly how duplicate transactions get hidden.

6. Drive the Difference to Zero

If the adjusted balances don't match, work the difference systematically. A few quick tests:

  • Divisible by 9? Almost always a transposition error (you wrote $135 instead of $153, etc.).
  • Equal to twice some transaction? A duplicate entry — one side has it, the other has it backwards (a check posted as a deposit, for example).
  • Round number? Often a missing fee, transfer, or deposit.

7. Record the Adjusting Journal Entries

Every adjustment to the book side becomes a journal entry dated the last day of the period. Be specific in the memo line: "April bank service charges per statement," not "bank charges."

8. Sign, Date, and File

Print or export the final reconciliation, the bank statement, and the journal entries together. Sign and date them. This package is what an auditor, a banker, or a future you will look at when a question arises about the cash balance two years from now.

Reconcile More Than Just the Operating Account

Bank reconciliation is the most familiar version, but the same discipline needs to apply to every account where money moves on someone else's books:

  • Every checking and savings account, even ones with low activity.
  • Every credit card account. Many fraud schemes target cards specifically because owners assume the card company will catch problems.
  • Merchant processor accounts (Stripe, Square, PayPal). Reconcile the gross deposits, fees, refunds, and chargebacks separately — it's the only way to see your real revenue and effective processing rate.
  • Loan and line-of-credit accounts. Reconcile the principal balance against the lender's statement and split each payment between principal and interest.
  • Petty cash. A surprise count, not just a paper reconciliation.

Each one is a place money flows in and out of your business; each one needs an independent ledger that ties to a third-party statement.

The Internal Controls That Make Reconciliation Actually Catch Fraud

The mechanical reconciliation is necessary but not sufficient. The biggest reason occupational fraud hides for a year is that the same person who writes checks, approves vendors, or handles deposits is also the one reconciling. They're "reconciling" their own theft — which means the books always balance and the cash always disappears.

A few practical controls that survive in real small businesses:

Separate the Reconciler from the Cash Handler

If at all possible, the person who reconciles the bank statement should not be the same person who writes checks, approves payments, has access to signature stamps, or handles incoming cash. In a tiny shop where this is impossible, the owner should perform or review the reconciliation personally. This is one task you do not delegate to the same employee who already controls the cash.

Have the Statement Delivered Outside the Bookkeeping Function

The bank statement should arrive somewhere the bookkeeper can't intercept and edit before it's reconciled — a dedicated email address the owner can see, a paper copy mailed to the owner's home, or a read-only bank login the owner uses to download the official PDF directly. Any reconciliation done off a statement supplied by the person being controlled is theater.

Review Cleared Check Images

Pull the front-and-back image of every cleared check above a meaningful threshold. Confirm the payee matches the books, the endorsement looks legitimate, and the signature is yours. Check tampering — altering a payee or amount after the check was signed — is invisible on a reconciliation that only checks numbers.

Track Voids and Stop-Payments

A favorite scheme is to "void" a check in the accounting system but not at the bank, then cash it. Reconcile the list of voided checks in the books against the actual bank activity for the period, and make sure voided check numbers are physically destroyed.

Don't Skip a Month

The single best fraud control is consistency. A reconciliation done within five business days of statement delivery, every single month, with no gaps, makes most embezzlement schemes impossible to sustain. The Association of Certified Fraud Examiners' most recent Report to the Nations puts the median occupational fraud loss at roughly $145,000 — and small organizations with fewer than 100 employees suffer disproportionately because they have fewer controls. Monthly reconciliation is the cheapest control you can implement.

Common Mistakes That Quietly Wreck a Reconciliation

A reconciliation that looks balanced can still be wrong. Watch for these:

  • Trusting the bank feed. Bank feeds drop transactions, duplicate them, and miscategorize them. Always tie back to the official statement, not the feed.
  • Force-balancing with a "miscellaneous" entry. If you can't find a $54.18 difference and you book it to a clearing account "to be researched later," you have just hidden the very signal that reconciliation exists to surface. Find it.
  • Carrying outstanding checks forever. If a check has been outstanding for more than six months, it's almost never going to clear. Investigate, void, and reissue if needed.
  • Reconciling once a quarter. Quarterly reconciliation lets three months of mistakes pile up before anyone looks at them. The error trail goes cold and the fraud window stays open.
  • Skipping the credit card. Card statements need reconciliation too — and frequently more than the operating account, because cards are where employee expense fraud surfaces.
  • Not locking the period. If users can backdate transactions into a closed month, last month's "balanced" reconciliation will silently break overnight. Lock the period after sign-off.

How Long Should This Take?

For a small business with one or two operating accounts, a clean monthly reconciliation should take 30 to 90 minutes — including pulling the statement, ticking transactions, recording adjusting entries, and filing. If yours regularly takes a full day, the most likely culprits are: a chart of accounts with too many cash-equivalent accounts, manual data entry duplicating bank-feed activity, or an unresolved difference from prior months that you've stopped chasing. All three are fixable, and all three pay back the investment within a couple of cycles.

Keep Your Cash Position Honest from Day One

Reconciliation is one of those quiet practices that does not feel important until it is the only thing standing between you and a real problem — a missed payroll, a misstated tax return, a bank loan covenant breach, an embezzlement caught two months in instead of two years in. The mechanics are not difficult; the discipline of doing it on time, every time, with someone independent reviewing the work, is what matters.

Plain-text accounting makes the discipline easier. Every transaction lives in a readable file, every reconciliation produces a diff you can review, and every prior period stays version-controlled so you can see exactly when a number changed and who changed it. Beancount.io gives you that transparency by default — no black boxes, no vendor lock-in, and a file format your future accountant, auditor, or AI agent can actually read. Get started for free and see why developers and finance professionals are switching to plain-text accounting.