Why Your Bank Balance Doesn't Match Your Bookkeeping Records
A bank balance that does not match your bookkeeping records is one of the most common and frustrating problems small business owners face. This guide walks through the most common causes of bank balance reconciliation problems and how to find and fix each one.
A bank balance that does not match your bookkeeping records is one of the most common and frustrating problems a small business owner faces. You look at your bank account, you look at your books, and the numbers are different. The gap might be small or it might be thousands of dollars. Either way, you cannot trust your books until you find and fix the cause.
This guide walks through the most common causes of bank balance reconciliation problems and how to find and fix each one. If you are newer to the reconciliation process itself, start with our guide on what bank reconciliation is and why it matters before working through these steps.
What a Mismatch Means
Your bank balance is the actual amount of money in your bank account according to your bank. Your book balance is the amount your bookkeeping records show you have. In a perfectly reconciled set of books, those two numbers agree after you account for outstanding checks, pending deposits, and other timing differences. When they do not agree and you cannot explain the difference, something in your books is wrong.
A mismatch is not just a number problem. It means your profit and loss statement, your balance sheet, and your cash flow reports are all potentially wrong, because they all build on the transactions in your books. If a transaction is missing, duplicated, or recorded in the wrong account, every report that depends on it is off too.
Common Causes of a Bank Balance Mismatch
- Outstanding checks and payments. Checks you wrote or payments you sent that have not cleared the bank yet. These are normal timing differences, not errors.
- Unrecorded deposits. Money that came into your bank account but was never entered in your books, so your book balance is lower than it should be.
- Duplicate transactions. A transaction imported twice or entered manually and again by a bank feed, inflating your book balance.
- Bank fees and interest. Monthly fees, overdraft charges, or interest payments that hit your bank account but were never recorded in your books.
- Transfers between accounts. Money moved between business accounts that was recorded in one account but not the other, or recorded in the wrong direction.
- Transactions in the wrong account. A transaction recorded against the wrong bank account, so one account is off and the other is off by the same amount in the opposite direction.
- Deleted or voided transactions. A transaction you deleted or voided in your books that still cleared the bank, or vice versa.
How to Find the Difference
Finding the difference is a process of elimination. Work through these steps in order, starting from the last month your books reconciled cleanly. Do not try to fix everything at once. Find one discrepancy, correct it, confirm the balance moves closer, then move to the next.
1. Confirm You Are Comparing the Same Date and Account
Before you dig in, make sure you are comparing the right numbers. Confirm you are looking at the same bank account, the same statement date, and the same ending balance. Comparing a live online balance on one date to a book balance on a different date is the most common false alarm.
Why it matters. You cannot find a real difference if you are comparing the wrong numbers. Half of all mismatches disappear when you compare the same date and account.
Common mistake. Comparing today's live bank balance to last month's book balance instead of using the bank statement ending balance for the same period.
2. Start From the Last Reconciled Balance
Find the last month your books reconciled cleanly and the balance agreed. That is your known good starting point. Work forward from there, month by month, until you find the first month that does not reconcile. The difference started in that month, and finding it there is far easier than searching a whole year at once.
Why it matters. A difference that started in March is invisible if you start looking in October. You have to trace it back to the month it began.
Common mistake. Starting from the current month and guessing. If the error is older, you will never find it that way.
3. Check for Outstanding Checks and Payments
List every check you wrote and every payment you sent that has not cleared the bank yet. These reduce your book balance but do not reduce your bank balance until they clear. Subtract them from your bank balance to get your adjusted bank balance. If that adjusted balance matches your book balance, you have no real problem, just normal timing.
Why it matters. Outstanding items are the most common and harmless reason for a difference. Confirming them first rules out the easy explanation.
Common mistake. Forgetting to list outstanding checks and assuming every difference is an error. Some differences are just timing.
4. Look for Unrecorded Deposits
Compare every deposit on your bank statement to your books. If a deposit appears on the bank statement but not in your books, your book balance is too low. Record the missing deposit in the correct account and confirm the balance moves closer. Missing deposits are common when a bank feed stops syncing or when a payment arrives outside your normal process.
Why it matters. A missing deposit means your revenue is understated and your book balance is wrong. Every unrecorded dollar is a dollar your reports do not show.
Common mistake. Assuming every deposit was recorded because it came through the bank feed. Feeds drop transactions, and manual deposits are easy to forget.
5. Search for Duplicate Transactions
Search your books for transactions with the same amount and date. A duplicate inflates your book balance and is one of the most common causes of a mismatch. Remove the duplicate entry, keeping the original, and confirm the balance adjusts. Duplicates happen when a transaction is imported twice, entered manually and again by a bank feed, or recorded by two people. For more on this problem, see our guide on how to fix messy bookkeeping records.
Why it matters. A single duplicate can throw your book balance off by hundreds or thousands of dollars. Finding it is usually quick once you know to look.
Common mistake. Deleting both entries instead of just the duplicate. Always keep the original and remove only the copy.
6. Check for Bank Fees and Interest
Review your bank statement for monthly maintenance fees, overdraft charges, wire fees, and interest credits. These hit your bank account automatically but are easy to miss in your books. Record each one in the correct expense or income account and confirm the balance adjusts.
Why it matters. Bank fees and interest are small but they accumulate. Every unrecorded fee is a small difference that keeps your reconciliation from agreeing.
Common mistake. Ignoring bank fees because they are small. Small fees add up and keep your balance from reconciling.
7. Review Transfers Between Accounts
If you moved money between business accounts, confirm the transfer was recorded in both accounts. A transfer recorded in one account but not the other leaves one balance too high and the other too low. Check that the direction is correct too. A transfer recorded in the wrong direction moves both balances the wrong way.
Why it matters. Transfers affect two accounts at once, so a single error creates two mismatches. Fixing the transfer fixes both.
Common mistake. Recording the transfer in the receiving account but forgetting the sending account, or vice versa.
8. Look for Transactions in the Wrong Account
If you have multiple bank accounts, check whether a transaction was recorded against the wrong account. A payment that cleared account A but was recorded in account B makes account B too low and account A too high. The total might look right, but each account is wrong. Move the transaction to the correct account and confirm both balances adjust.
Why it matters. Wrong account errors are invisible if you only look at one account at a time. You have to reconcile every account to catch them.
Common mistake. Reconciling only the checking account and ignoring the savings or credit card account where the error actually sits.
9. Check for Deleted or Voided Transactions
If you deleted or voided a transaction in your books but it still cleared the bank, your book balance and your bank balance will disagree. The reverse is also true. If a transaction cleared the bank but you voided it in your books, the bank shows it and your books do not. Match every transaction on your bank statement to your books and find the ones that exist in only one place.
Why it matters. Voided transactions are easy to forget about because they feel like they never happened. But if the bank processed them, they still affect your balance.
Common mistake. Voiding a check in your books but never confirming it was actually voided at the bank, or vice versa.
10. Review Automatic Payments and Direct Debits
List every automatic payment and direct debit that hits your account each month, such as software subscriptions, insurance, loan payments, and utility bills. Confirm each one is recorded in your books. Automatic payments are easy to miss because they happen without you touching them.
Why it matters. Automatic payments are silent. If one is not recorded, your book balance is too high and your expenses are understated.
Common mistake. Assuming the bank feed caught every automatic payment. Feeds drop transactions, and new automatic payments are easy to miss.
11. Verify Card Deposits Match Gross Sales
If you accept card payments, confirm that the deposit in your bank account matches the gross sale in your books. Card processors often batch deposits and deduct processing fees, so the deposit amount may differ from the sale amount. Make sure the fee is recorded separately so your revenue and your bank deposit both reconcile correctly.
Why it matters. Card processing fees and batched deposits are a frequent source of small differences that keep your reconciliation from agreeing.
Common mistake. Recording the gross sale but not the processing fee, so the deposit in your bank never matches the sale in your books.
12. Look for Timing Differences and Pending Deposits
Some differences are pure timing. A deposit you recorded on the last day of the month may not appear on your bank statement until the first day of the next month. A payment you sent may still be in transit. List every item that is in your books but not yet on your bank statement, and every item that is on your bank statement but not yet in your books, and confirm the adjusted balances agree.
Why it matters. Timing differences are normal and harmless. Identifying them separates the real errors from the normal delays.
Common mistake. Treating a timing difference as an error and recording a correction that creates a real error in the next month.
13. Reconcile Month by Month
Work through each month from your last clean reconciliation to the current period. For each month, match every transaction in your books to the corresponding transaction on your bank statement. When you find a discrepancy, fix it before moving to the next month. If your books are months behind, this process is the same as catch up bookkeeping. For a full walkthrough, see our guide on catch up bookkeeping.
Why it matters. You cannot find a difference that started months ago by only looking at the current month. You have to trace it back to where it began.
Common mistake. Trying to reconcile the current month without fixing the older months first. The old error carries forward and keeps the current month from agreeing.
14. Document and Fix Each Discrepancy
As you find each discrepancy, write down what it was, what caused it, and how you fixed it. This record helps you spot patterns, prevents the same error from recurring, and gives your bookkeeper or tax preparer a clear trail. Fix each one by recording the missing transaction, removing the duplicate, reclassifying to the correct account, or adjusting the balance with a documented correction.
Why it matters. A documented fix is a fix you can trust and repeat. An undocumented adjustment is a mystery that will haunt you later.
Common mistake. Making a balance adjustment without recording what caused it. That hides the problem instead of solving it.
15. Build a Monthly Reconciliation Routine
The best way to prevent bank balance mismatches is to reconcile every account every month, without fail. A short scheduled session each month catches errors while they are small and easy to find, before they compound into a frustrating search through months of records. For a ready to use template, see our guide on the monthly bookkeeping checklist for small businesses.
Why it matters. A monthly routine turns reconciliation from a crisis into a habit. Errors stay small, differences stay explainable, and your books stay trustworthy.
Common mistake. Fixing the current mismatch and then going back to the old habits that caused it. Without a routine, the mismatch returns.
Two Real Small Business Examples
Example: A small retail store. A store owner noticed her book balance was about two thousand dollars higher than her bank balance. She compared the same date and account, ruled out outstanding checks, and then searched for duplicate transactions. She found a credit card deposit that had been imported twice, once from the card processor and again from the bank feed. Removing the duplicate brought the balances back together. A monthly reconciliation routine prevented it from happening again.
Example: A growing service business. A consulting firm with five employees could not get its checking account to reconcile for three months. The owner kept adjusting the balance to make it agree, but the difference returned every month. A bookkeeper traced it back to a transfer between the checking and savings accounts that was recorded in the savings account but not the checking account. Recording the transfer in both accounts fixed the difference permanently, and the documented fix gave the owner a clear trail to hand to his tax preparer.
Printable Bank Balance Reconciliation Checklist
Use this checklist to find and fix a bank balance mismatch one step at a time. Print it, save it, or share it with whoever handles your books.
- Confirm you are comparing the same bank account, the same statement date, and the same ending balance.
- Start from the last month your books reconciled cleanly and work forward.
- List every outstanding check and payment that has not cleared the bank.
- Compare every deposit on your bank statement to your books and record any missing.
- Search your books for duplicate transactions with the same amount and date.
- Review your bank statement for fees, charges, and interest not yet recorded.
- Confirm every transfer between accounts is recorded in both accounts and in the right direction.
- Check for transactions recorded against the wrong bank account.
- Match every transaction on your bank statement to your books and find voided or deleted items.
- List every automatic payment and direct debit and confirm each is recorded.
- Verify card deposits match gross sales and record processing fees separately.
- Identify timing differences and pending deposits that are normal, not errors.
- Reconcile each month from the last clean balance to the current period.
- Document each discrepancy, what caused it, and how you fixed it.
- Build a monthly reconciliation routine so mismatches do not return.
Getting Started
A bank balance that does not match your books is almost always caused by a transaction that is missing, duplicated, or recorded in the wrong place. Work through the steps above, one month at a time, and the difference will narrow until it disappears. If the gap is too large or too old to trace alone, or if you would rather spend your time running your business, the best next step is a conversation about where your books stand today.
Want books that match your bank without the headache? Explore our bookkeeping services and let us reconcile your accounts and keep them accurate. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so you can run your business and your tax preparer can do their part efficiently.
Frequently Asked Questions
Is it normal for my bank balance and my book balance to be different?
Yes, a small difference is normal at any given moment because of outstanding checks, pending deposits, and automatic payments that have not cleared yet. What is not normal is a difference you cannot explain after a reconciliation. If your reconciled book balance and your bank balance do not agree at the end of the month, something is wrong and you need to find it.
How do I know if the problem is in my books or at the bank?
Start by confirming the bank balance is correct using your actual bank statement, not the balance you see online on a random day. Then reconcile month by month from the last month your books matched. If the bank statement is correct and your books do not reconcile, the problem is in your books. Most mismatches are caused by missing, duplicate, or misclassified transactions in the bookkeeping records.
What is the most common cause of a bank balance mismatch?
The most common cause is transactions that appear in one place but not the other. A check you wrote that has not cleared, a deposit you received but never recorded, a bank fee that imported but was not categorized, or a duplicate import that inflated your book balance. Reconciliation is the process of matching every transaction in both places so the difference is zero.
Should I just delete the difference and move on?
No. Adjusting the balance without finding the cause hides the error instead of fixing it. A missing transaction or a duplicate affects your profit, your expenses, and your tax records. Find the actual transaction that caused the difference, record it or remove it correctly, and confirm the reconciliation agrees to zero before you move on.
How far back should I look if I cannot find the difference?
Go back to the last month your books reconciled cleanly and work forward from there. The difference started in the first month that did not reconcile. If you cannot find that month, you may need to go back further or get help from a professional bookkeeper who can trace it methodically. The longer the gap, the harder it is to find.
Can a bank error cause the mismatch?
Occasionally, yes, but it is rare. Bank errors do happen, and your bank can research and correct them. Before you assume it is a bank error, rule out every common cause on your side first. Missing transactions, duplicates, and unrecorded fees are far more common than bank errors.
Can Chess Bookkeeping & Payroll help me find the difference?
Yes. Finding and fixing bank balance reconciliation problems is core to what we do. We reconcile your accounts, trace every difference to its cause, and deliver books that match your bank. We handle bookkeeping and payroll. We do not prepare income tax returns, offer tax planning, or perform audits, but we keep your books accurate and organized so your tax preparer can do their part efficiently.
Need help getting your books in order?
We focus exclusively on bookkeeping and payroll. Let's talk about where your books stand today.
Get StartedReady to simplify your books and payroll?
Schedule a consultation and let's talk about how precise bookkeeping and reliable payroll can give your business the clarity it deserves.