- Compare the statement balance to your books on the same date, not today's online balance.
- Most differences come from timing, duplicates, missing transactions, transfers or a disconnected bank feed.
- Reconcile one month at a time, starting from the last month that matched.
- Never force a match with a plug entry; it hides the problem instead of fixing it.
What should I do if my bank balance doesn't match my accounting records?
Start by reconciling: compare your books to the bank statement one month at a time, beginning with the last month that matched, and identify each difference. Most gaps come from timing (uncleared checks and deposits), duplicate or missing transactions, transfers recorded wrong, or a disconnected bank feed. If the difference goes back months, SmartGrowth Bookkeeping can reconcile the history and correct the entries in QuickBooks or Xero.
First, make sure you are comparing the right two numbers. The ending balance on a bank statement should match your books as of that same statement date. Today's online bank balance and today's book balance will often differ for perfectly normal reasons.
| Cause | What it looks like | Fix |
|---|---|---|
| Uncleared checks or deposits in transit | A difference that clears in the next statement | Normal; confirm each item clears |
| Duplicate transactions | The same amount recorded twice | Remove one copy |
| Missing transactions | A bank charge that is not in the books | Add or import it |
| Disconnected bank feed | Books stop on a certain date | Reconnect and import the gap carefully |
| Transfers recorded wrong | Money moved between your own accounts shows as income or expense | Record it as a transfer |
| Processor deposits recorded net | Deposits do not match recorded sales | Record sales, fees and refunds separately |
| Changed past transactions | A previously reconciled month no longer balances | Find and reverse the change |
| Wrong opening balance | The books have been off since day one | Correct the opening balance entry |
Why a mismatch matters more than it seems
A difference between the bank and the books is not just a cosmetic problem with one account. Every unexplained gap is a transaction that was missed, doubled or put in the wrong place, and most of those also change your profit and loss.
A missing expense makes profit look higher than it is. A duplicated deposit makes revenue look higher. A transfer recorded as income inflates sales. So when the cash account is off, the reports you use to price work, pay yourself and file taxes are usually off too.
That is why reconciling first, before reading any report, is standard practice. It is the step that tells you whether the rest of the numbers can be trusted.
What to have on hand before you start
- Bank and credit card statements for every month since the last clean reconciliation, downloaded as PDFs
- Access to your accounting file with permission to edit and reconcile
- Payout reports from card processors or online sales platforms, if you use them
- Loan statements, if loan payments come out of the account
- A note of any cash you deposited or spent outside the bank
Step by step: finding the difference
- Find the last month that reconciled cleanly. Everything after it is suspect; everything before it can be left alone.
- Gather the bank statements for every month since then.
- Reconcile one month at a time, oldest first. Do not try to fix a whole year in one pass.
- Tick off each transaction that appears in both the books and the statement.
- List what is left on each side: items in the bank but not the books, and items in the books but not the bank.
- Look for patterns. The same amount twice suggests a duplicate. A difference equal to one transaction suggests a missing item; a difference of exactly twice a transaction suggests one recorded in the wrong direction. A difference evenly divisible by 9 often means two digits were swapped.
- Correct each cause, then confirm the ending balance in the books matches the statement exactly.
It is tempting to post an adjustment for the leftover amount and call the account reconciled. That hides the real problem, which may be a missing expense, unrecorded income or a duplicate that also distorts your profit.
Special cases that cause most of the trouble
Credit cards
Card accounts get reconciled to their statements the same way bank accounts do. The common mistake is recording the payment from checking as an expense, on top of the individual charges already recorded. The payment is a transfer that reduces the card balance.
Online sales and card processors
A Shopify store or a business using a card processor receives deposits after fees and refunds have been taken out. If only the deposit is recorded, sales are understated and fees vanish. Record gross sales, then the fees and refunds, so the net matches the deposit.
Several accounts and transfers
With multiple checking, savings and card accounts, a single transfer appears in two feeds. If both sides are categorized as income or expense, the books are wrong twice. Bank and credit card reconciliation covers how to handle many accounts at once.
Cash
Cash sales or cash expenses that never touch the bank still need to be recorded, and cash deposited later should match the sales it came from.
When the gap goes back months or years
If nothing has been reconciled for a long time, the differences stack up and become hard to separate. At that point it is usually faster to have the accounts reconciled from the last good point forward, with corrections recorded as they are found.
When the books are current but wrong, that is bookkeeping cleanup. When months are simply missing, it is catch-up bookkeeping. Many businesses need some of both.
Keeping the bank and the books matched
- Reconcile every bank and card account every month, as soon as the statement is available.
- Do not edit or delete transactions in months that are already reconciled.
- Check that bank feeds are still connected; a quiet feed is a missing month.
- Use one person, or one clear system, for categorizing so entries are not made twice.
- Record transfers between your own accounts as transfers.
Software helps with all of this but will not do it alone, as covered in do I need a bookkeeper if I use QuickBooks or Xero.
How SmartGrowth helps
SmartGrowth Bookkeeping reconciles every bank and credit card account monthly in QuickBooks or Xero, investigates the differences and fixes the causes rather than plugging the gap. If the books are already months off, SmartGrowth can reconcile the history first, then keep it matched from there.
More questions
Is it normal for my bank balance and books to differ on a given day?
Yes. Checks that have not cleared, deposits still in transit and card charges still pending all create temporary differences. What should match is the statement's ending balance and your books as of the same date, after accounting for those items.
How often should I reconcile my accounts?
At least monthly for every bank and credit card account. Businesses with heavy transaction volume, or tight cash, often reconcile more frequently so problems surface sooner.
Can I just start over from today's balance?
It is tempting, but it buries the errors instead of correcting them. Missing income or expenses still affect your profit and your tax return. Your CPA will need the whole year to be right, not just the ending balance.
What if a reconciled month suddenly stops balancing?
Someone likely edited, deleted or added a transaction in that month after it was reconciled. Both QuickBooks Online and Xero keep a history of changes, which makes it possible to find and reverse the edit.
Do I need my paper statements, or is the bank feed enough?
You need the statements. The bank feed brings in transactions, but the statement is the official record of the ending balance. Reconciliation compares the books to that statement, not to the feed.