Your QBO balance doesn’t match your bank statement — don’t panic. Here are the 6 most common reasons it happens and exactly what to check first.
You open QuickBooks Online to reconcile your account, and there it is — the QBO balance and your bank statement are showing two completely different numbers. Maybe it’s off by $23. Maybe it’s off by $2,300. Either way, your stomach drops.
Here’s the good news: a QBO balance that doesn’t match your bank statement is one of the most common issues small business owners run into, and in almost every case, it comes down to one of six fixable causes. You don’t need to blow up your books or start from scratch. You just need to know where to look.
In this post, I’ll walk you through exactly what causes the mismatch, how to track it down inside QBO, and what to do once you find it — step by step.
QBO Balance vs. Bank Balance — They’re Not the Same Thing
Before you start troubleshooting, it helps to understand what these two numbers actually mean inside QuickBooks Online, because they’re calculated very differently.
What “Bank Balance” Means in QBO
The Bank Balance you see in QBO is pulled directly from your bank’s feed. It reflects the real-time (or most recently synced) balance sitting in your actual bank account. Think of it as what your bank is telling QBO.
What “QuickBooks Balance” Means
The QuickBooks Balance is calculated differently. It’s the sum of every transaction you’ve added, categorized, or matched inside QBO — regardless of whether those transactions have actually cleared your bank yet. Think of it as what QBO thinks your balance should be, based on what’s been entered.
Why They’re Allowed to Be Different (Sometimes)
Here’s something that trips up a lot of people: these two numbers are supposed to differ sometimes, and that’s completely normal.
If you wrote a check last week that the vendor hasn’t cashed yet, QBO has recorded it but your bank hasn’t processed it. That creates a legitimate timing difference. The same goes for deposits in transit — money you’ve recorded in QBO that hasn’t landed in your account yet.
The difference becomes a problem when it can’t be explained by timing. If you can’t point to specific outstanding transactions that account for the gap, something is off in your books and it needs to be found.
The 6 Most Common Reasons Your QBO Balance Doesn’t Match
Most mismatches trace back to one of these six causes. Read through each one and ask yourself whether it might be what’s happening in your account.
1. Duplicate Transactions
This is the single most common culprit. Duplicate transactions happen when the same transaction gets recorded twice — usually because it was manually entered and also imported through the bank feed.
It’s easy for this to happen without realizing it. You enter a bill payment manually, and then a few days later the bank feed imports it again. Or a bank rule auto-adds a transaction that you already categorized by hand. The result: your QBO balance is inflated by the amount of the duplicate.
Where to look: Go to your bank register in QBO and filter by “Not Reconciled.” Scan for entries that appear twice with the same date and amount.
2. Missing Transactions
The flip side of duplicates is missing transactions — things that appear on your bank statement but never made it into QBO at all. This can happen when:
- Your bank feed disconnects and transactions from that period don’t import
- A transaction lands in the “For Review” tab and gets dismissed instead of accepted
- You switched banks or accounts and there’s a date gap in the feed
- Manual entries were skipped
Where to look: Open your “For Review” tab in the Banking menu and check whether anything is sitting there unprocessed. Then compare your bank statement line by line against your QBO register for the same period.
3. Edited or Deleted Reconciled Transactions
This one is sneaky and causes a lot of confusion because the damage isn’t always visible at first glance.
When you reconcile an account in QBO, those transactions get marked with an “R.” But QBO doesn’t lock them — they can still be edited or deleted after the fact, either by you, a team member, or accidentally through a bank rule. When a reconciled transaction changes, QBO recalculates your beginning balance, and suddenly a reconciliation that was perfectly balanced is no longer accurate.
Where to look: Go to Settings → Audit Log. Filter by date and look for any transactions that were modified or deleted around the time the discrepancy appeared. This is your paper trail.
4. Timing Differences (Outstanding Transactions)
As mentioned above, timing differences are normal — but they need to be tracked, not ignored.
Outstanding checks (written but not yet cashed), deposits in transit (recorded but not yet cleared), and pending card transactions all create a natural gap between your QBO balance and your bank balance. The key is being able to account for the gap — meaning if you subtract your outstanding transactions from your QBO balance, you should land on your bank balance.
Where to look: In the Reconciliation screen, QBO lists uncleared transactions. Match these against your bank statement to confirm they’re legitimate timing items, not errors.
5. Incorrect Opening Balance
If your QBO account was set up with the wrong opening balance — either when you first connected your bank or when you started a new fiscal year — every reconciliation you’ve done since then has been building on a faulty foundation.
This is a setup issue, not a monthly data entry mistake, which means fixing it requires a bit more care. You’ll need to trace back to when the balance first went wrong and post a correcting entry.
Where to look: Go back to your very first bank statement after your QBO setup date. Does that opening balance match what QBO shows as the starting balance for that account? If not, that’s your root cause.
6. Bank Fees, Interest, or Charges Not Recorded
This one is easy to miss precisely because it’s so small. Bank service charges, NSF fees, interest earned, wire transfer fees — your bank posts these automatically, but they don’t always get recorded in QBO, especially if you’re not in the habit of checking for them during reconciliation.
Over time, these small unrecorded amounts accumulate and create a persistent low-level discrepancy that never quite goes away.
Where to look: Review your bank statement for any bank-generated charges or credits. Compare them against your QBO register to see if they’ve been entered.
How to Find the Discrepancy — Step by Step
Now that you know what you’re looking for, here’s the actual process I follow when a client’s QBO balance doesn’t match their bank statement.
Step 1 — Calculate the Exact Difference
Before you go hunting, write down the exact dollar difference between your QBO balance and your bank statement. This number is your guide.
A round number (like $500 or $1,200) usually points to a missing or duplicate transaction. A strange decimal (like $47.83) often points to a bank fee or a data entry error. This small observation can save you a lot of time.
Step 2 — Check the “For Review” Tab
Go to Banking → For Review. Any transaction sitting here has been imported from your bank feed but not yet accepted into your books. It’s in limbo — your bank knows about it, but QBO doesn’t count it yet.
Review everything in this tab. Accept, categorize, or exclude each transaction appropriately.
Step 3 — Open the Register and Filter by “Not Reconciled”
Click into your bank account register. Use the filter icon in the upper left corner and set:
- Reconcile status: Not Reconciled
- Date range: Start from a long time ago (I usually go back to the account’s opening date, or at minimum two years)
Look through the unreconciled transactions. Ask yourself: is this a legitimate timing difference (a check that hasn’t cleared yet), or does it look like a mistake?
Step 4 — Run the Reconciliation Report
Go to Reports → Reconciliation Reports and pull the most recent reconciliation. Compare it against your bank statement line by line. Every transaction on the bank statement should appear on the reconciliation report, and every uncleared item on the report should have a valid explanation.
If you find transactions on your bank statement that don’t appear anywhere in QBO, those are missing entries. If you find transactions in QBO that don’t appear on the bank statement and aren’t legitimate outstanding items, those are likely duplicates or errors.
Step 5 — Check the Audit Log
Go to Settings → Audit Log. This is QBO’s record of every change made to your books — who did what and when.
Filter by the date range when you think the discrepancy appeared. Look for any deleted or modified transactions. If a reconciled entry was changed or removed, the Audit Log will show it. This is especially important if you have multiple users accessing your QBO account.
What NOT to Do When Your Balances Don’t Match
I’ve seen these mistakes make a bad situation significantly worse — so before you start fixing things, make sure you’re not doing any of the following.
Don’t force the reconciliation with an adjusting entry. It’s tempting to just post a small “reconciliation adjustment” to make the numbers match and move on. Resist. That adjustment hides the real problem without fixing it, and it will compound over time. The next month’s reconciliation will be harder, not easier.
Don’t delete transactions without checking if they’re reconciled. Deleting a reconciled transaction changes your beginning balance and throws off every reconciliation that followed it. Always check the “R” status before deleting anything.
Don’t ignore a small difference. A $3 discrepancy feels harmless. But it usually means something is wrong in your process, and unresolved discrepancies have a way of growing. Clean it up when it’s small.
Don’t panic and start re-entering everything. That’s how you create duplicates. Take a methodical approach — find the cause first, then fix it.
When to Call a Bookkeeper
Most single-month discrepancies can be resolved by following the steps above. But there are situations where it makes sense to bring in a professional rather than spend hours troubleshooting on your own.
Consider getting help if:
- The discrepancy spans multiple months and you’re not sure when it started
- Reconciled transactions were altered and you can’t trace the source through the Audit Log
- Your opening balance was wrong from day one and you’ve been reconciling on top of it for years
- You’ve inherited someone else’s QBO file and the books were already messy when you got them
- You’re approaching tax season and need clean, accurate books quickly
A bookkeeper who works in QBO regularly can usually identify the root cause within an hour and fix it cleanly — without disrupting your reconciliation history or creating new errors in the process.
This is one of the core cleanup services I offer through Profitick. If your books are out of balance and you’re not sure where to start, [book a free 20-minute consult here] and I’ll take a look.
Frequently Asked Questions
Why does QBO show a different balance than my bank?
QBO shows two separate figures: the Bank Balance (pulled from your live bank feed) and the QuickBooks Balance (calculated from transactions entered in QBO). They differ because of timing — uncleared checks, pending deposits, or unprocessed bank feed transactions. When the difference can’t be explained by timing, it usually means there’s a duplicate entry, a missing transaction, or a reconciled entry that was changed or deleted.
What is the difference between “Bank Balance” and “QuickBooks Balance” in QBO?
Bank Balance is what your bank is currently reporting via the feed — it reflects cleared, posted transactions. QuickBooks Balance is the sum of everything entered in QBO, including transactions that haven’t cleared yet. The two should reconcile to the same figure once all outstanding items are accounted for.
How do I find a discrepancy in QuickBooks Online?
Start by calculating the exact dollar difference. Then check the “For Review” tab for unprocessed transactions, filter your register by “Not Reconciled” to spot timing issues or duplicates, run the Reconciliation Report and compare it to your bank statement, and check the Audit Log for any deleted or modified reconciled entries.
Can I fix a reconciliation discrepancy myself?
Yes — most single-period discrepancies caused by duplicates, missing entries, or unrecorded bank fees can be fixed without professional help if you follow a methodical process. Multi-period discrepancies or issues involving altered reconciled transactions are more complex and often benefit from professional cleanup.
Why does my beginning balance keep changing in QBO?
QBO recalculates your beginning balance every time you open the Reconcile screen. It adds up all transactions marked “R” (reconciled) in your register. If any of those reconciled transactions were edited or deleted after the fact — even accidentally — the beginning balance will shift. The Audit Log is the fastest way to identify what changed.
Final Thoughts
A QBO balance that doesn’t match your bank statement isn’t a crisis — it’s a signal. Something in your books needs attention, and now you know exactly where to look. Start with the “For Review” tab, check your register for duplicates, and if anything looks off, let the Audit Log do the detective work for you.
Work through the six causes methodically, and in most cases you’ll find the answer within 30 minutes.
Anam Gul is an accountant and bookkeeper with experience across QuickBooks Online, and Tally ERP. She runs Profitick.com, a resource hub for small business owners navigating bookkeeping and personal finance.
Give them a Read: