Skip to main content

Bank Reconciliation Explained: How to Catch Missing Transactions, Fraud, and Errors Before They Snowball Into Tax Problems

Published 13 min readMike ThriftMike Thrift
Bank Reconciliation Explained: How to Catch Missing Transactions, Fraud, and Errors Before They Snowball Into Tax Problems
On this page

Your books say $18,400. The bank says $16,910. One of those numbers is lying to you — and every month you skip the half hour it takes to find out which, the lie compounds. A small gap today becomes misstated profit this quarter, a scramble at tax time, or money walking out the door that nobody notices for months.

The stakes are not theoretical. More than three-quarters of organizations faced attempted or actual payment fraud in 2025, with paper checks the most-targeted payment method, and most businesses discover fraud only after the money has already settled. A bank reconciliation is the cheapest detective control a small business owns: a monthly comparison of your cash records against the bank's that surfaces missing transactions, bank errors, your own bookkeeping mistakes, and unauthorized activity while there is still time to act. This guide covers what the process is, why the two balances never agree, the exact steps, and the mistakes that keep books wrong.

What Bank Reconciliation Actually Is​

Bank reconciliation compares your internal cash records — your books, your ledger, your software's bank account — against the bank statement for the same period, and explains every difference between the two. When you finish, you arrive at one agreed number from both directions: the adjusted bank balance equals the adjusted book balance, and that number is your true cash position.

It is not making the two balances match by force, and it is not a once-a-year formality for the accountant. It is a control. The bank can make mistakes. You can make mistakes. Timing alone guarantees the raw balances will differ. Reconciliation is how you prove, every month, that you know exactly why your number and the bank's number differ — and that nothing in the gap is fraud, an omission, or an error that will distort your profit and your tax return.

Apply it to every account that holds or moves cash — savings, payroll, petty cash, merchant clearing accounts — not just main checking. An account you never reconcile is one where errors accumulate silently.

Why Your Two Balances Never Agree​

Almost every reconciling item falls into one of three buckets. Learning the buckets is learning the whole process.

Timing differences​

Some items are recorded on one side but have not reached the other side yet.

  • Outstanding checks — checks you wrote and recorded that the payee has not cashed. Your books are lower than the bank by this amount.
  • Deposits in transit — money you received and recorded near month-end that had not posted to the bank by the statement date. Your books are higher than the bank by this amount.

Timing differences need no journal entry: both sides agree in principle and disagree only about the date. They clear on their own — which is why last month's outstanding items must be carried forward and checked off against this month's statement rather than forgotten.

Bank-only items: things the bank knows that you have not recorded yet​

The bank adjusts your account for events you only learn about when the statement arrives (or the feed syncs):

  • Bank service charges and fees — monthly maintenance, wire fees, overdraft fees, the cost of printed checks.
  • Interest earned — usually small on a business checking account, but still income that belongs on your books.
  • NSF (non-sufficient funds) checks — a customer's check bounced. The bank claws back the deposit, and you must too, while re-establishing what the customer owes you.
  • Automatic debits and EFT payments — loan payments, equipment leases, and subscriptions drafted directly from the account.
  • Bank collections and EFT receipts — customer payments collected straight into your account that you have not recorded yet.

Every one of these needs a journal entry on your side, because your books are missing a real event. This is the step most behind-on-the-books businesses skip, and it is exactly how cash balances drift into fiction.

Errors on either side​

  • Book errors — transposed digits, duplicate entries, a deposit recorded to the wrong account, a payment entered for the wrong amount. These are common and always your entry to fix.
  • Bank errors — a deposit credited to the wrong account, an incorrect charge. Rare, but real, and the reason you never assume the bank is right. A bank error is corrected by contacting the bank, not by journal entry.

The standard layout puts each item on its proper side:

Bank balance sideBook balance side
Ending balance per bank statementEnding balance per books
Add: deposits in transitAdd: interest earned, bank collections, EFT receipts
Subtract: outstanding checksSubtract: service charges, NSF checks, automatic payments
Add or subtract: bank errorsAdd or subtract: book errors
= Adjusted bank balance= Adjusted book balance

When both columns land on the same number, the account is reconciled.

The Step-by-Step Monthly Process​

Run this once a month at minimum; weekly if you move a high volume of transactions. The whole routine takes about thirty minutes for a typical small business once the habit is in place.

1. Gather the two sides for the same period. Pull the bank statement and your cash account activity for the identical date range. Reconciling November books against an October statement is the most common beginner failure — match the periods first.

2. Compare deposits. Check off every deposit on the statement against your books. Whatever remains in your books without a matching bank credit is a deposit in transit; whatever the bank shows that you never recorded (EFT receipts, bank collections) goes on your list of book-side additions.

3. Compare withdrawals and checks. Check off every cleared check and debit against your books. Checks you recorded that never cleared are outstanding checks — including any carried forward from prior months. Bank debits you never recorded (fees, automatic payments) go on your list of book-side subtractions.

4. Record the bank-only items. Post journal entries for every fee, interest amount, NSF check, automatic payment, and collection you found in steps 2 and 3. Details on the entries are in the next section.

5. Correct any errors. Fix your transpositions and duplicates with correcting entries now. For a suspected bank error, call the bank with the statement, the check image, and the amount in hand — and keep the item on your reconciling list until the correction posts.

6. Compute both adjusted balances and compare. Add and subtract per the table above. If they agree, you are done. If they differ, do not plug the difference with a fudge entry — that buries the error and guarantees a bigger one later. Recheck your arithmetic, re-scan for a missed item, and verify the beginning balances tie to last month's ending balances.

7. File the reconciliation. Save the statement and your reconciling-item list together, signed and dated. That packet is your audit trail when the IRS or a lender asks how you know your cash number is right.

A worked example​

Say your October 31 statement shows $24,350 and your books show $22,915, and comparison turns up:

  • A $3,200 customer deposit recorded October 31 that posted November 1 (deposit in transit).
  • Two vendor checks totaling $4,100 that have not cleared (outstanding checks).
  • A $35 monthly service charge you had not recorded.
  • $12 of interest earned.
  • A $512 customer check that bounced (NSF).
  • A $1,070 customer payment collected by EFT that you had not recorded.

Bank side: $24,350 + $3,200 − $4,100 = $23,450. Book side: $22,915 + $12 + $1,070 − $35 − $512 = $23,450. Both sides agree at $23,450 — reconciled. You post journal entries only for the book-side items — the fee, interest, NSF check, and EFT receipt. The outstanding checks and deposit in transit need no entry.

The Journal Entries You Actually Post​

Only book-side adjustments become journal entries. Timing items and bank errors never do.

  • Bank service charges: debit Bank Service Charges (expense), credit Cash. Fees are a deductible business expense, so recording them also keeps your deductions complete.
  • NSF check: debit Accounts Receivable (re-establishing the customer's balance), credit Cash. The sale did not un-happen; the payment did. Follow up on collection, plus any returned-check fee your terms allow.
  • Interest earned: debit Cash, credit Interest Income. Small, but the IRS receives its own copy of the information return, so the income must appear on your books and your return whether or not you noticed it.
  • Automatic payments you missed: debit the appropriate expense or liability account (Loan Payable, Insurance Expense), credit Cash.
  • Bank collections and EFT receipts: debit Cash, credit Accounts Receivable or the revenue account, depending on what the receipt was for.
  • Book errors: a correcting entry that reverses the mistake — if you recorded a $540 check as $450, debit the expense for $90 and credit Cash for $90.

Never post a plug: an unsupported adjustment to Retained Earnings, Miscellaneous Expense, or a suspense account whose only purpose is to force the balance. A plug converts an identified unknown into a hidden one. If a difference resists explanation after a genuine search, park it as a clearly labeled reconciling item and resolve it next month — visibly, not silently.

How Reconciliation Catches Fraud​

Fraud hides in the gap between what you think happened and what the bank says happened — precisely the gap reconciliation inspects:

  • Altered or forged checks. A check that cleared for a different amount or payee than your books show is visible the moment you compare check images against issued checks. With well over half of organizations reporting check fraud attempts, this is not an exotic risk.
  • Unauthorized electronic debits. A duplicate ACH, a vendor drafting twice, or a debit you never authorized appears as a bank-side item with no book entry — exactly the class of item step 3 of the process forces you to investigate.
  • Skimming and lapping. Cash or checks received but never deposited show up as book deposits with no matching bank credit that never become deposits in transit. A deposit in transit that is still "in transit" next month is not a timing difference; it is a missing deposit.
  • Test transactions. Fraudsters often probe with small amounts before moving big ones. The discipline of investigating every difference, however small, is what catches the probe instead of the payout.

Two structural habits multiply the effect. First, separate duties: the person who signs checks or sends wires should not be the person who reconciles the account. Solo owners should at least eyeball the statement and cleared-check images before the books close. Second, ask your bank about Positive Pay and ACH filters — services that only honor checks and debits matching what you authorized — so the bank rejects the suspicious item before your reconciliation ever has to find it.

Common Mistakes That Keep the Books Wrong​

Letting outstanding checks age. A check outstanding for a month is timing. A check outstanding for six months is a problem: the payee lost it, the vendor closed, or the obligation is in dispute. Review aging outstanding checks every month, follow up with payees, and reissue or void-and-rebook stale checks through proper entries. Unclaimed amounts can eventually fall under your state's unclaimed-property (escheatment) rules — not paperwork to defer forever.

Ignoring small differences. A $9 gap is never "just $9" — it is an unidentified error of unknown direction. Small differences are how transposed digits, missed fees, and test transactions present. Clear them by finding them, not by writing them off.

Mixing personal spending into the business account. Every personal transaction is a reconciling item that should not exist, and a stack of them makes the real discrepancies impossible to see. Run personal money through a separate account, always.

Starting from the wrong beginning balance. If this month's starting book balance does not equal last month's reconciled ending balance, something changed a closed period — a deleted transaction, a backdated edit, an altered beginning balance. Stop and find it before reconciling forward; building on a moved foundation reconciles nothing.

Reconciling only when something looks wrong. By the time cash "looks wrong," months of errors have compounded, the paper trail has gone cold, and the bank's window for disputing unauthorized items may have narrowed. The monthly cadence is the control; sporadic reconciliation is archaeology.

A Monthly Rhythm That Keeps Cash Honest​

A small business can hold cash accurate all year on a simple rhythm:

  • Fix the cadence. Monthly at a minimum, on the same day each month, before any other close task. Weekly if you clear dozens of transactions a day.
  • Close the prior month first. Lock the period once reconciled so nothing edits history under you, and confirm the new month opens at last month's reconciled balance.
  • Age your outstanding items. Anything uncleared past 30 days gets a follow-up; past 90 days gets resolved — reissued, voided and rebooked, or escheated per your state's rules.
  • Reconcile all cash accounts. Checking, savings, payroll, and any merchant clearing account each get their own monthly pass.
  • Keep the packet. Statement plus reconciling-item list, filed by month. Seven years of these packets weigh nothing and answer every cash question an auditor, lender, or buyer will ever ask.

Businesses that keep their books in plain-text accounting get a quiet advantage here: every fee, NSF check, and correcting entry is an explicit, dated transaction in a version-controlled ledger, so tracing how the book balance moved from one reconciliation to the next is a matter of reading the file. Pair that ledger with solid documentation habits, and review the trend on your Fava dashboard each month — a cash balance drifting the wrong way is visible long before it becomes a crisis.

Keep Your Cash Picture Sharp All Year​

Bank reconciliation is thirty minutes a month that buys you a true cash balance, complete expense records, fraud caught while it is still reversible, and a tax return built on numbers you can defend. The businesses that get surprised — by overdrafts, by missing money, by an IRS notice about income they never recorded — almost always share one trait: nobody was comparing the books to the bank.

Keeping that monthly comparison current is exactly the kind of steady bookkeeping that compounds over time. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.

Source: https://beancount.io/blog/2026/10/11/bank-reconciliation-explained-catch-errors-fraud-tax-problems-guide

Published: October 11, 2026