QuickBooks Says One Thing, Your Bank Says Another: Fixing Reconciliation Drift Before Tax Season

You open QuickBooks to check your cash balance. It says one number. You open your bank app. It says a different number. Not off by a few dollars, off by hundreds or thousands. And you have a sinking feeling this has been true for a while and you have just been ignoring it. If that is you, you are not alone, and the problem has a name. It is reconciliation drift, and it is one of the most common things we clean up for Houston business owners, especially in the weeks before a return is due.

This post explains what causes QuickBooks to drift away from your actual bank balance, why the gap quietly compounds, how to find what is wrong, and how to fix it before tax season turns it into a real problem. It is written by Thuy Nguyen, JD, CPA, CTC, CTRS at Nguyen Accounting Group in Sugar Land, drawing on 24 years of cleaning up Houston business books and preparing returns from them.

Here is the encouraging part. Reconciliation drift always has specific, findable causes. It is not random and it is not unfixable. Once you know the handful of things that cause it, you can usually trace your gap back to its source.

One thing worth saying before we get into the causes. A lot of Houston business owners feel a quiet embarrassment about this, like the gap means they did something wrong or are bad at running their business. They are not. QuickBooks makes it genuinely easy to create drift, bank feeds make it easier, and almost every business that does its own books hits this at some point. The gap is a normal byproduct of doing your own bookkeeping without a reconciliation discipline, not a character flaw. What matters is catching it and fixing it before it sits on the return.

What bank reconciliation is and why it matters

Bank reconciliation is the process of matching what QuickBooks says happened in your account against what your bank statement says happened, line by line, until the two agree for a given period. When they agree, your books are tied to reality. When they do not, your books are telling you a story that is partly fiction.

This matters because every number that comes out of QuickBooks is built on the assumption that the bank account is reconciled. Your profit and loss statement, your balance sheet, your sales tax filings, and most importantly the tax return prepared from your books, all of it rests on reconciled accounts. If the books are not reconciled, the return is built on sand. You could be overstating income and overpaying tax, or understating income and setting up an IRS problem later. Neither is good, and you cannot know which one you are doing until the account is reconciled.

Why drift compounds quietly

The dangerous thing about reconciliation drift is not that it happens. It is that it hides. A small error in January does not announce itself. It just sits there, and February gets reconciled on top of it, and March on top of that. Each month the starting balance is already wrong, so each month inherits the error and may add its own. By the time you notice in November, you are not looking at one mistake. You are looking at eleven months of compounded mistakes layered on each other.

This is why drift is a tax season problem specifically. It can be ignored most of the year because nothing forces the issue. Then a return deadline arrives, the books have to be right, and a year of accumulated drift has to be untangled all at once under time pressure. The same cleanup that takes a few hours in February takes days in March. Catching it early is not just tidier, it is dramatically cheaper.

The real causes of reconciliation drift

Your gap is caused by one or more of these. This is the list to check yourself against.

1. Duplicate transactions

The most common cause by far, and bank feeds make it worse. A transaction gets entered manually, then the bank feed imports the same transaction, and now it is in QuickBooks twice. Or a transaction gets matched to the wrong existing entry and a duplicate is left behind. Every duplicate throws your QuickBooks balance off by that amount, and they accumulate.

2. Deleted or voided transactions in already-reconciled periods

Someone goes back and deletes or voids a transaction that was part of a prior reconciliation. QuickBooks lets you do this, but it silently breaks the reconciliation that transaction belonged to. The prior period no longer ties out, and every period after it inherits the break. This is one of the sneakiest causes because the damage is done in the past, not the present.

3. Transactions entered in the wrong account

A business expense paid from a personal card but entered against the business checking account. A transfer between two accounts recorded as an expense. A payment posted to the wrong bank account entirely. The total might even look close, but the specific account you are trying to reconcile is off.

4. Uncleared transactions piling up

Checks written but never cashed, deposits recorded but never actually made, payments stuck in transit. A few uncleared items are normal. A long list of stale uncleared transactions, some of them months old, means the books are recording money movement that never actually happened.

5. Bank fees, interest, and auto-charges never entered

Monthly service fees, merchant processing fees, interest, and recurring auto-charges that the bank applied but no one entered into QuickBooks. Each one is small. Twelve months of small ones is not.

6. The opening balance was wrong from the start

When the QuickBooks account was first set up, the opening balance was entered incorrectly, or a generic opening balance equity entry was made and never corrected. If the foundation is off, everything built on it is off, and no amount of careful monthly work will make it tie out until the opening balance is fixed.

7. Reconciliations forced to balance with a fake adjustment

This is the one that does the most long-term damage. QuickBooks offers to make a reconciliation adjustment when you cannot find the difference. Someone clicks it to make the screen say zero and move on. Now there is a plug entry in the books that hides a real error instead of fixing it. The reconciliation looks done but the books are now actively lying.

How to find your gap

Here is the practical sequence to trace reconciliation drift back to its source.

• Find the last month that actually reconciled correctly, with no forced adjustment. That is your clean starting point. The drift began after it.

• Run the Reconciliation Discrepancy report in QuickBooks. It flags transactions that were changed, deleted, or voided after a reconciliation. This catches cause number two directly.

• Pull the reconciliation reports for each month after your clean point and look for any reconciliation adjustment or plug entries. Those are cause number seven, and each one is hiding a real error.

• Scan for duplicates. Sort the register by amount and look for matching pairs on or near the same date. Bank feed duplicates usually show up this way.

• Review the uncleared transactions list. Anything stale, months old and still uncleared, needs to be investigated, corrected, or removed.

• Check the opening balance and the opening balance equity account. A nonzero opening balance equity balance that nobody can explain is often the original sin.

Work month by month from your last clean reconciliation forward. Do not try to fix the current month in isolation, because it inherited everything below it. The drift has to be unwound in order.

How to fix it, in the right order

Fixing drift is methodical, not heroic. The order matters.

First, fix the foundation. If the opening balance is wrong, correct that before anything else, because every later month sits on top of it. Second, remove the fake plug entries. Delete the forced reconciliation adjustments so you are looking at the real gap instead of a gap that has been papered over. Third, work forward month by month. Re-reconcile each month against the actual bank statement, fixing duplicates, missing fees, misposted transactions, and stale uncleared items as you reach them. Fourth, when you genuinely cannot find a small difference after real effort, then and only then make a documented adjustment, with a note explaining what it is, rather than an anonymous plug.

The goal is not a screen that says zero. The goal is books where every number can be traced to a real bank transaction. That is the version of clean books that produces a tax return you can stand behind.

Why this matters most right before a return is due

A tax return is only as accurate as the books it is built from. If we are preparing a return from QuickBooks that has not truly been reconciled, we are either going to find the drift and have to clean it first, which takes time and costs money under deadline pressure, or we are going to prepare a return from numbers that are wrong, which is not something we are willing to do. Reconciliation drift caught in the fall is a manageable cleanup. The same drift discovered in March is a scramble.

There is also a downstream risk. Books that overstate income mean you overpay tax. Books that understate income mean the return understates income, and if that is ever examined, the gap becomes an IRS problem with penalties and interest attached. Clean reconciliation is not bookkeeping housekeeping. It is the difference between a defensible return and a problem waiting to surface. If your books are far enough gone that this feels overwhelming, that is exactly the situation a cleanup engagement is built for.

What QuickBooks cleanup costs in Houston

A focused reconciliation cleanup, untangling a few months of drift on one or two accounts, typically runs $400 to $1,200 in the Houston market. A full-year cleanup across multiple accounts, especially with forced adjustments and opening balance problems to unwind, generally runs $1,200 to $4,000 depending on transaction volume and how tangled it is. Ongoing monthly bookkeeping that keeps reconciliations current usually runs $200 to $800 per month for a small Houston business. At Nguyen Accounting Group the cleanup fee is flat and quoted after we look at the file in the free consult. For the broader picture of CPA and bookkeeping pricing in Houston, see our pricing guide at myhoustoncpa.com/post/how-much-does-a-cpa-cost-in-houston-a-2026-pricing-guide.

The cleanup pays for itself in two ways. It prevents overpaying tax on overstated income, and it removes the risk hiding in understated income. It also makes every future month cheaper, because monthly reconciliation on a clean file is fast, while monthly reconciliation on a drifting file is a recurring fight.

Where Nguyen Accounting Group fits

Accounting and QuickBooks is one of our five service pillars, alongside Tax Resolution, Strategic Tax Planning, Business Advisory and Fractional CFO work, and Tax Return Preparation. Reconciliation cleanup connects directly to the return, which is why having the same firm do both matters. We clean the file, we reconcile it to reality, and then we prepare the return from books we trust because we are the ones who tied them out. If clean books also reveal a cash flow problem underneath, which they often do, our advisory work picks that up. The picture stays connected.

FAQ

Why does QuickBooks show a different balance than my bank?

The most common causes are duplicate transactions from bank feeds, transactions deleted or voided in already-reconciled periods, transactions posted to the wrong account, stale uncleared items, bank fees never entered, a wrong opening balance, or forced reconciliation adjustments that papered over a real error. The gap almost always traces to one or more of these.

What is reconciliation drift?

Reconciliation drift is the growing gap between what QuickBooks says your account balance is and what the bank actually says. A small error in one month gets inherited by every month after it, so the gap compounds quietly until something, usually a tax deadline, forces the issue.

Why does reconciliation drift get worse over time?

Each month is reconciled on top of the previous month starting balance. If that starting balance is already wrong, the new month inherits the error and may add its own. By the end of the year you are not looking at one mistake but at many months of compounded mistakes layered together.

Can I fix QuickBooks reconciliation problems myself?

Sometimes, if the drift is recent and small. Find the last month that reconciled correctly, run the Reconciliation Discrepancy report, remove any forced adjustments, fix duplicates and missing fees, and work forward month by month. A full year of compounded drift with opening balance problems is usually faster and safer to hand to a professional.

What is a reconciliation adjustment and why is it a problem?

QuickBooks offers to create an adjustment when you cannot find a reconciliation difference. Clicking it makes the screen say zero, but it inserts a plug entry that hides a real error instead of fixing it. The reconciliation looks done while the books are actively wrong. These adjustments should be removed and the real error found.

Why does reconciliation matter for my tax return?

Your tax return is built from your books, and your books are only accurate if the accounts are reconciled. Unreconciled books can overstate income, which means you overpay tax, or understate income, which sets up an IRS problem later. A reconciled file is the foundation of a return you can stand behind.

What does QuickBooks cleanup cost in Houston?

A focused cleanup of a few months on one or two accounts typically runs $400 to $1,200. A full-year multi-account cleanup with forced adjustments and opening balance problems generally runs $1,200 to $4,000 depending on volume. Ongoing monthly bookkeeping runs $200 to $800 per month for a small business. Nguyen Accounting Group quotes a flat fee after a free consult.

Do you do QuickBooks cleanup for Vietnamese-speaking business owners?

Yes. Thuy is bilingual in English and Vietnamese. Bookkeeping involves a lot of specific terminology, and working through your file in your first language makes the cleanup clearer. We serve Vietnamese-speaking business owners across Sugar Land, Bellaire, southwest Houston, and the wider metro.

Ready to talk

If your QuickBooks and your bank have stopped agreeing, the free 30-minute consult is the place to start. We will look at the file, tell you roughly how far the drift goes, and quote a flat cleanup fee. Catching it now, before the next return is due, is far cheaper than catching it under deadline. Call (832) 500-4299 or book online. We are at 12440 Emily Ct Suite 303, Sugar Land, TX 77478, Monday through Friday 9 AM to 1 PM and 2 PM to 5 PM.