Why QuickBooks Can Look Current While the Books Are Not Reconciled

When a file looks current, what you are usually seeing is the result of three automated steps that run whether or not anyone is paying attention:

• The bank feed imported transactions.QuickBooks connects to the bank and pulls activity in on a rolling basis. That happens on the bank's schedule, not on yours.
• Rules assigned categories. Categorization rules match a description or amount and apply an account. A rule that was right in March keeps firing in July, correct or not.
• Someone accepted the queue. Accepting a bank feed transaction moves it into the register. It does not confirm the amount, the date, the account, or that it is the only copy.

None of those steps compare QuickBooks to a bank statement. They move data in and put it somewhere. A file where all three run reliably will look busy, tidy, and finished, and can still be wrong in ways that only surface at the balance sheet.

Reconciliation is a comparison against an outside source of truth. For a specific statement period, you confirm that every transaction QuickBooks shows for an account appears on the statement, that every transaction on the statement appears in QuickBooks, and that the ending balance in QuickBooks equals the ending balance on the statement. When that holds, QuickBooks marks the transactions cleared and saves a reconciliation report for the period.

That last part is what makes reconciliation useful. It produces a dated record that an account was verified through a point in time. It is the difference between "the numbers look plausible" and "the numbers were checked against the bank."

Three things that are commonly mistaken for reconciliation:

• Matched. The bank feed found a likely pairing between an imported transaction and one already in QuickBooks. Helpful, but it is a suggestion the software made.
• Categorized.The transaction has an account assigned. That affects which line of the P&L it lands on. It says nothing about whether the balance is right.
• Cleared. On its own, a cleared flag can be set manually. Cleared as the result of a completed reconciliation is meaningful. Cleared because someone checked a box is not.

A file drifts out of reconciliation through ordinary, well-intentioned activity. The common causes:

• Transactions edited after a period was reconciled. Someone corrects a date, changes an amount, or deletes a duplicate in a month that was already closed. The reconciliation report for that month still exists, but it no longer describes the file.
• Reconciliations finished with a forced adjustment. When the ending balance will not agree, QuickBooks offers to post an adjusting entry and close the gap. The reconciliation completes. The unexplained difference stays in the books.
• Duplicates from two entry paths.A transaction is entered manually and also arrives through the bank feed. Both sit in the register. The P&L overstates the expense and the bank balance no longer ties.
• Payments held in Undeposited Funds. Payments get recorded but never grouped into a deposit that matches what actually hit the bank. The balance grows quietly and revenue timing becomes unreliable.
• Accounts nobody reconciles. Operating checking gets attention. Credit cards, loans, merchant accounts, and secondary accounts often do not, and those are where the larger surprises usually sit.

You do not need to be an accountant to spot these. Any of them is enough to treat the current reports as provisional.

1. The last reconciliation is months old. For an operating account, anything beyond about two months means the recent picture has not been verified against the bank.
2. Opening Balance Equity has a balance. This account exists to hold starting balances during setup. In a finished file it should be zero. A balance means something was never resolved.
3. Undeposited Funds keeps growing. A small balance between a payment and a deposit is normal. A balance that only increases means deposits are not being grouped correctly.
4. Accounts receivable or payable is negative. A negative balance in either usually means payments were applied without invoices or bills, or applied to the wrong ones.
5. There are Uncategorized or Ask My Accountant balances. These are holding pens. Anything sitting in one is a decision that was deferred and not returned to.
6. The balance sheet has accounts nobody can explain. If you or your bookkeeper cannot say in one sentence what a line represents and why it is that size, it has not been reviewed.
7. Prior-period numbers change.You pull last quarter's P&L twice, a month apart, and it reads differently. Closed periods are being edited.

This is a review you can run on your own file without changing anything. You are gathering evidence, not fixing.

1. Open the reconciliation reports. In QuickBooks Online, go to Reports and find Reconciliation Reports. Write down each account and the statement ending date of its most recent completed reconciliation.
2. Compare those dates to today. Anything more than two months stale on an account you actually use is the first thing to raise.
3. Look for accounts with no reconciliation history. Credit cards and loans are the usual finds here.
4. Run a balance sheet as of today. Check Opening Balance Equity, Undeposited Funds, accounts receivable, accounts payable, and anything named Uncategorized or Ask My Accountant.
5. Open one reconciliation report and read the bottom. If it shows an adjusting entry, note the amount. That is an unexplained difference someone decided to absorb.

If that review comes back clean, your reports are probably fine and the problem is somewhere else, which is genuinely useful to know. If it does not, you now have a specific list rather than a vague sense that something is off.

Cleanup fixes the history. It does not, by itself, stop the file from drifting again. When the same problems return within a few months, the cause is almost always in the process rather than the software:

• No one owns the close. Several people touch the books and no one is accountable for declaring a month finished.
• Nobody reads the reconciliation report. Reconciliation gets run, and any adjustment it produced goes unreviewed.
• Closed periods stay open. Without a closing date set in QuickBooks, prior months remain editable indefinitely.
• Rules are never revisited. Categorization rules written for an earlier version of the business keep applying to a different one.
• The owner is the last line of review. If you are the one who notices the errors, the process has a gap in it that no amount of cleanup will close.

If those descriptions land, the underlying issue may be the level of support rather than the state of the file. That is the subject of Signs You Have Outgrown Your Bookkeeper.

The right next step depends on what the ten-minute review turned up.

If history is unreliable, start with cleanup

When accounts have not been reconciled for months, adjusting entries have accumulated, or the balance sheet holds unexplained balances, the history has to be rebuilt before anything built on it is worth reading. Cleanup and catch-up bookkeeping brings the file to a reconciled baseline through an agreed cutoff date. The QuickBooks Cleanup Guide covers what that work includes in detail, and the cleanup versus monthly comparison covers how to tell which one you need first.

If the same errors keep returning, fix the workflow

When the file is repaired and drifts again, the problem is in how transactions enter the books and who reviews them. Financial systems and workflow improvement addresses the handoffs, the chart of accounts, and the review points that let errors through in the first place.

If nobody owns the month, that is the actual gap

Reconciliation stays current when it is somebody's job on a schedule, with the reconciliation report reviewed rather than filed. That ownership is what monthly bookkeeping and finance operations is for. It matters most in businesses where reporting drives decisions throughout the year rather than only at tax time, which is why it comes up so often with professional services firms.

A current QuickBooks file tells you that data arrived. A reconciled QuickBooks file tells you the data was checked. Only the second one supports a decision.

If you are not sure which one you have, the reconciliation reports will tell you in a few minutes, and that answer is worth having before the next time you need to rely on a number.