How to Reconcile a Bank Statement (Without Losing an Evening)

Somewhere between your ledger and your bank account, the numbers disagree — and only one of them can be telling the truth. Figuring out which is the whole point of learning how to reconcile a bank statement. It's the checkup that proves your books describe reality, and it's far less painful than its reputation suggests.

You don't need an accounting background to do it. Reconciliation is a comparison done in a deliberate order, so that every difference between your records and the bank's gets explained instead of shrugged at. Below: the process from start to finish, the handful of culprits behind nearly every mismatch, and the detective tricks bookkeepers use when a balance stubbornly refuses to agree.

What Reconciling Actually Proves

Think of your books as testimony and the bank statement as the security footage. Reconciling is cross-examining one against the other, line by line, until every transaction is accounted for on both sides and the two balances agree to the penny.

Skip it and small errors compound quietly: a bank fee here, a doubled entry there, a deposit categorized as who-knows-what. Within a few months your reported profit and your actual profit are different numbers, and you won't know by how much. Reconciliation is also the earliest tripwire for fraud — a charge you never authorized surfaces as an unmatched line the first time you reconcile after it posts. It's why the reconciliation step sits at the heart of any solid monthly close routine: everything downstream assumes the cash is right.

Books that haven't been reconciled aren't wrong, exactly — they're unproven. And unproven cash turns every report built on it into an estimate.

Gather These First

• The statement for the month you're reconciling — PDF, paper, or the feed inside your software.
• The matching account register in your books for the same date range.
• Last month's finished reconciliation, which gives you a trusted starting balance.
• A half hour of quiet. The first attempt runs long; a routine one with software often wraps in ten minutes.

How to Reconcile a Bank Statement, Start to Finish

Start by verifying the opening balance

The statement's opening figure must equal the ending balance from your previous reconciliation. When it doesn't, don't push forward — a transaction in an already-closed month was edited, removed, or added later. Repair that first; otherwise you're reconciling on top of a moving target. (This is also the case for locking months once they're closed.)

Work through the statement line by line

Take each statement transaction and locate its twin in your books, marking both as you go. Inside reconciliation software, this is the core screen: bank lines on one side, your entries on the other, matches confirmed with a click. The majority pair off immediately. The value of the exercise lives entirely in the leftovers.

Book the items only the bank knew about

Certain charges show up on the statement before they ever reach your books: account service fees, wire and NSF charges, earned interest, and the autopay you forgot existed. They're all real. Enter them now, dated when the bank posted them. Of all the reasons books and bank disagree, this is the most frequent — and the quickest to fix.

List the items only your books know about

Here the difference is timing, not a mistake. The two regulars:

• Uncleared checks — payments you've written and recorded that nobody has cashed yet. Gone from your books, still sitting in the bank's total.
• Deposits in transit — money you've logged as deposited (a Friday-evening card batch, say) that the bank hasn't posted.

You don't correct these — you note them. They account for the legitimate gap between the two ending balances and should clear on the next statement. A check still uncleared after ninety days deserves a follow-up call.

Do the balancing math

Take the bank's closing balance, add deposits in transit, subtract uncleared checks. That adjusted figure should now equal your book balance (after the fees and interest you just entered). Match to the penny? Done — you're reconciled. Still apart? You've got a genuine discrepancy, and the next section is your field guide.

Save it and move on

Mark the reconciliation finished in your software, or file the marked-up statement if you work on paper. That recorded ending balance becomes next month's trusted opening figure — and the paper trail your accountant, your bank, or an auditor will someday be delighted you kept.

When the Numbers Won't Agree: The Usual Suspects

Nearly every stubborn reconciliation traces back to one of these, roughly in order of likelihood:

What does it mean if the difference equals one exact transaction?

Search both sides for that precise amount. You'll usually discover an entry recorded once that should appear twice, or twice when it should be once. And when the gap is exactly twice a transaction, suspect an entry posted to the wrong side — a deposit keyed as a payment, or the reverse.

Why does a difference divisible by 9 suggest a typo?

Because transposing two digits always produces an error divisible by 9: enter $81 as $18 and you're off by $63; enter $520 as $250 and you're off by $270. When the difference passes the divide-by-9 test, comb your hand-keyed amounts for flipped digits before investigating anything else.

Can I just force the balance with an adjustment?

Please don't make it a habit. A plug entry buries the error without removing it — the duplicate, missing deposit, or fraudulent charge is still in your books, still skewing every report. If you've truly chased every lead on a trivial difference, writing pennies off to a dedicated discrepancy account with an explanatory note is a defensible last resort. It should feel like breaking glass, not routine.

How Often Is Often Enough?

Once a month is the floor — statements arrive monthly, and the reconciliation slots straight into closing your books. Businesses with heavy card or register volume often go weekly: forty lines at a time beats four hundred. The pattern that matters is regularity. Twelve short monthly sessions cost far less time and sanity than one dreadful year-end excavation.

And don't stop at the checking account. Anything that issues a statement gets reconciled — savings, every credit card, PayPal, Stripe, credit lines. Card statements in particular are where zombie subscriptions and double charges like to hide.

Let the Software Carry the Load

Everything above works with a printout and a highlighter — that's how it was done for a century. But the mechanical parts are exactly what computers are for: bank feeds import the statement lines, matching logic pairs them with your entries, and a live difference counter tells you how close to balanced you are at every moment.

Kantivo builds this in. Its reconciliation screen sits on top of genuine double-entry bookkeeping: feed-imported lines match your register in a click, the genuine exceptions get flagged for the fee-and-timing treatment described above, and the finished reconciliation is stored with its verified ending balance — so next month's opening check passes before you've had a sip of coffee. Since Kantivo runs locally on your own machine with its own database, your banking data stays under your roof, and no subscription meter is running while you work.

The Takeaway

Reconciling comes down to a disciplined comparison: prove the starting point, match every line, book what the bank caught, note what hasn't cleared, and refuse to stop until the balances agree exactly. Run it monthly and each session stays small, errors get caught while they're cheap, and your cash balance graduates from "probably about right" to verified. Few bookkeeping habits pay back thirty minutes so reliably.

Frequently Asked Questions

What is bank reconciliation?

Bank reconciliation is checking your accounting records against the bank's official statement, transaction by transaction, until the two balances line up exactly. Whatever refuses to line up is a lead: a missed entry, a duplicate, a timing gap, or a mistake to correct.

How do you reconcile a bank statement step by step?

Verify the statement's opening balance equals your last reconciled ending balance, tick off every statement line against your books, enter the items only the bank knew about (fees, interest, autopays), list checks and deposits that haven't cleared yet, confirm the adjusted balances agree to the penny, and save the completed reconciliation as your new verified starting point.

Why is my book balance different from my bank balance?

Most often it's timing — uncleared checks or deposits the bank hasn't posted. After that come unbooked fees and interest, entries recorded twice, amounts with swapped digits, and transactions dated into the wrong month. Rarely, it's a bank mistake or unauthorized activity — which reconciling is designed to catch early.

How frequently should I reconcile my business bank account?

Every month, as part of closing your books. If your business runs hundreds of transactions, weekly sessions keep each one short. Waiting longer just multiplies the lines to match and buries the discrepancies deeper.

Is it OK to post an adjusting entry to make a reconciliation balance?

As a habit, no. A forced entry hides the error instead of fixing it, and the underlying problem keeps distorting your reports. Trace the difference first: an exact transaction amount suggests a missed or doubled entry, and a difference divisible by 9 suggests transposed digits.

Can software handle bank reconciliation automatically?

Largely, yes. Kantivo pairs bank feeds with a guided reconciliation screen, so imported statement lines match your entries in a click and only true exceptions need your attention — a monthly reconciliation typically takes minutes.

Related Articles

• How to Close Your Books Every Month: A Small Business Month-End Routine
• Double-Entry Bookkeeping Explained, Without the Jargon
• How to Read a Balance Sheet (Without an Accounting Degree)
• Building a Chart of Accounts for Your Small Business
• Cash Basis or Accrual Basis? A Small Business Owner's Guide to Picking the Right Method
• How to Read a Profit and Loss Statement (No Accounting Degree Needed)
• The Hidden Costs of Cloud Accounting Software