Books with Adil

BLOG

How to Reconcile a Business Bank Account

Hands reconciling a bank statement against accounting records

"Reconciling" sounds technical, but the idea is simple: you are checking that the transactions in your accounting software match what your bank says actually happened. Every month, your bank produces a statement — a definitive record of money in and money out. Your books should agree with it. When they don't, something needs attention.

Many owners skip reconciliation because the bank feed "handles it." But the feed only imports transactions — it doesn't verify them. Reconciliation is the verification step: it catches the double-charged subscription, the check that never cleared, the charge you don't recognize. Skip it and small errors compound until your reports can't be trusted.

What You Need Before You Start

Gather these first — starting unprepared turns a 20-minute job into a two-hour one.

The Step-by-Step Process in QuickBooks Online

In QuickBooks Online, go to Accounting in the left navigation, then select Reconcile. Choose the bank account you want to reconcile, and QuickBooks will ask for two numbers from your statement.

1. Enter the statement date and ending balance

The statement date is the ending date of the period — June 30, not today. Pull the date and ending balance from the same statement; mixing July's balance with June's date is a classic mistake that surfaces much later.

2. Verify the beginning balance

QuickBooks auto-fills the beginning balance from your last reconciliation — it must match your statement exactly. If it doesn't, stop: something changed a previously reconciled transaction (edited amount, moved date, deleted entry). Resolve this first (see discrepancies below).

3. Match and clear each transaction

The Reconcile window lists payments on one side, deposits on the other. Working down your statement line by line, click each transaction that appears on it — clicking marks it cleared.

Leave anything not on the statement unchecked. Those are outstanding items, and outstanding items are completely normal. At the top of the window, QuickBooks shows the difference between your statement ending balance and the cleared balance in your books. As you check off transactions, that difference shrinks. Your goal is to bring it to exactly $0.00.

4. Finish the reconciliation

When the difference reads $0.00, select Finish now. QuickBooks marks the period reconciled. If the difference is anything other than zero, do not finish — find the cause first. The next section covers the usual suspects.

Handling Common Discrepancies

A difference that won't reach zero is a clue, not a catastrophe. Work through these in order, from most to least common.

Outstanding checks and deposits in transit

The most common "discrepancy" isn't an error at all. An outstanding check is a payment you've recorded in QuickBooks that hasn't cleared the bank yet. A deposit in transit is money you've recorded as received that the bank hasn't posted yet. Both are supposed to be outstanding — leave them unchecked and finish the reconciliation.

Example: your June statement ends at $12,437.19. After clearing everything on the statement, QuickBooks shows a $315.00 difference — your books are $315 lower. Check #1042 for $315, written June 28, hasn't cleared yet. That's your $315. Leave it unchecked, confirm the rest matches, and finish — it'll be on July's statement.

Duplicate transactions

Feeds occasionally import a transaction twice, or a manual entry duplicates a feed import. The telltale: a difference equal to exactly one transaction's amount.

Your difference is $89.99 — oddly specific. The $89.99 subscription sits in the register twice: once manual, once imported. Delete the duplicate and the difference hits zero. This is why the For Review tab deserves care — blanket-accepting everything is how duplicates sneak in.

Bank errors and unrecognized charges

Rare, but real: a wrong amount posted, or a charge you don't recognize. If a statement transaction matches nothing and you can't explain it, contact the bank before recording anything — don't invent a category to force it in. Catching these early is exactly what reconciliation is for.

Beginning balance doesn't match

If the beginning balance doesn't match, someone altered a previously reconciled transaction. Check the reconciliation history (Accounting → Reconcile → History by account) to see what changed, and restore it rather than adjusting around it. If prior periods are deeply tangled, clean up the QuickBooks file before reconciling the current month.

The forced reconciliation (don't do this)

When a difference won't resolve, QuickBooks may offer to post the difference to an account called Reconciliation Discrepancies so you can finish. This is the single most damaging shortcut in bookkeeping, and it's worth understanding why.

Say you're off by $45 and let QuickBooks post it to Reconciliation Discrepancies. Next month your beginning balance is wrong by $45 — the real error (a transposed amount, a missed fee) is still in your books, and every future reconciliation inherits it. If you're stuck, leave the month unreconciled and get help finding the real cause instead of burying it.

How Often Should You Reconcile?

Monthly, for every bank and credit card account — ideally within days of the statement closing, while transactions are fresh. Very high-volume businesses may reconcile key accounts more often, but monthly is the standard.

Skipped months don't save time; they accumulate it. Three unreconciled months means untangling three months of duplicates, missing transactions, and feed errors at once — and until then, your P&L rests on unverified numbers.

What "Reconciled" Actually Proves (and What It Doesn't)

A reconciled month proves something specific and valuable: your books agree with the bank statement at the statement date, after accounting for outstanding items. That's how you catch missing or doubled transactions, bank errors, and charges you don't recognize.

It doesn't check categorization — a $500 supply purchase filed under meals reconciles perfectly. It doesn't catch income that never hit the bank. The numbers still need to make sense when you're reading your P&L — reconciliation verifies the raw material; the analysis comes after.

Key Takeaways

If monthly reconciliation keeps sliding to the bottom of your to-do list, you don't have to do it alone. I handle monthly bookkeeping and reconciliations for U.S. small businesses: categorized transactions, reconciled accounts, and reports you can actually use. To talk through what your books need, book a free consultation.

Want books like these?

Monthly bookkeeping, catch-up and cleanup, and financial reports you can actually use — for U.S. small businesses.

Book a free consultation
WhatsApp