Your Bookkeeping Balance Doesn't Match. Here's What to Check First.

Small-business owner comparing a bank statement with a bookkeeping account balance to find a discrepancy.

You've entered the transactions. The bank feed is up to date. But the amount in your bookkeeping system isn't the same as the amount you're seeing at the bank.

It's tempting to assume something is wrong with the software. Or to keep clicking until the numbers agree.

Neither is a good first move.

I made a free, one-page Bookkeeping Balance Troubleshooter for exactly this moment. If you want the checks in one place while you work, it's at the end of Tuesday's Substack article, where a free subscription unlocks the PDF.

A difference is a question to investigate. It is not automatically an error.

Here's the order I'd use for a small-business bank or credit-card account.

First, make sure you're comparing the same account and date

A bookkeeping account balance from September 30 shouldn't be compared with the bank's live October 21 balance.

Open the actual statement for the period you're reviewing. Confirm the account number's last four digits and the closing date. Then review the bookkeeping activity through that same date.

Your accounting software may show a current register balance, a cleared balance, and a statement reconciliation balance. These aren't interchangeable.

If the dates don't match, correct the comparison before changing transactions.

Next, look for payments or deposits that haven't cleared

Suppose the September statement ends at $8,420, while the September 30 bookkeeping register balance is $8,150.

That is a $270 difference.

You find a check for $270 that was recorded in the books before September 30 but didn't clear the bank until October.

That may explain the difference without any incorrect transaction. Proper reconciliation takes legitimate outstanding items into account.

Do this: Review outstanding checks and deposits in transit. Compare when each was recorded and when it cleared. Don't delete or redate a valid transaction just to make the totals match.

Diagram comparing an $8,420 bank statement balance and $8,150 bookkeeping register balance, with a $270 outstanding check identified.

Then look for missing, duplicate, or misdated transactions

If outstanding items don't explain it, check whether a transaction appears on one side but not the other.

Work through the statement systematically. Watch for duplicated imported deposits, bank fees missing from the books, checks recorded twice, and transactions on the wrong dates.

If you have a connected bank feed, remember that imported data still needs review. The weekly bookkeeping checklist explains a simple process for catching duplicates and unclear entries while they're fresh.

Do this: Find the source record for each mismatch. Correct the actual entry where appropriate, rather than creating a separate adjusting transaction simply to erase the difference.

Check whether a transfer was recorded correctly

If money moved between your business checking and savings accounts, or from checking to pay a business credit card, both sides of that movement matter.

A credit-card payment is not automatically a fresh operating expense. The purchases on the card may have already been recorded. Recording the card payment as another expense can distort the P&L.

If this sounds familiar, the seven-point financial organization check explains why transfers, loans, card payments, and other money movements deserve a closer look.

Do this: Trace the transfer in both accounts and confirm its bookkeeping treatment. Then check whether the underlying accounts reconcile.

Diagram showing a business checking payment reducing a credit-card balance separately from the original expense recorded for a card purchase.

Check the beginning balance if the difference will not go away

If you've checked the period and still cannot account for the discrepancy, look at the prior month's completed reconciliation.

Was the opening balance changed later? Was an earlier cleared transaction deleted or edited? Did an old outstanding item remain unresolved?

An error carried forward from last month can make this month difficult to reconcile.

Do this: Compare the previous reconciliation report with what is currently in the books. If old reconciled activity has changed, determine why before correcting it.

What you should not do

Don't enter an unsupported adjustment just to force the difference to zero. Don't mark everything cleared to make the screen turn green. Don't assume the live bank balance should match an older statement date.

And don't feel pressured to upgrade your software to solve a question that might come down to one missing or outstanding item.

If you can't find the cause, keep the question visible and get help with the specific account and period. A working bookkeeper can review the evidence without rebuilding the entire business.

The quick troubleshooting order

  1. Confirm the right account and statement date.

  2. Identify uncleared checks and deposits in transit.

  3. Look for missing, duplicated, or misdated activity.

  4. Verify transfers and credit-card payments.

  5. Review the previous reconciliation and opening balance.

  6. Correct supported errors, then reconcile again.

The goal is not matching numbers at any cost. It's being able to explain the difference.

For another related decision that often causes confusion, bank balance and profit answer different questions. A correct bank balance alone does not tell you whether the business earned a profit.

Frequently asked questions about bookkeeping balance differences

Free one-page tool: The Bookkeeping Balance Troubleshooter puts this order on a single page, with room to record a discrepancy and what you checked. It's included at the end of this week's Substack article about why you can still be unsure of your numbers after finishing the bookkeeping.

 
New Posts

Get the next post in your inbox.

When a new post goes up, you'll get an email with the link. Nothing else.

Something went wrong. Please try again.

No spam. Unsubscribe anytime.

✓

You're in!

You'll get new Own Your Bookkeeping posts and updates in your inbox.

Previous
Previous

Why Keep Business Receipts? 4 Reasons Beyond Taxes

Next
Next

How Often Should You Update Your Bookkeeping?