QuickBooks says reconciled, but the numbers feel wrong: signs your books are off

A checkmark is not the same as correct

Your books can be wrong even when every account shows as reconciled. Reconciliation only proves that the cash in QuickBooks matches the bank statement; it says nothing about whether each transaction landed in the right category, whether loans and payroll were split correctly, or whether someone forced the reconciliation through with an adjustment. The quickest tells are a balance sheet that does not match your bank and loan statements, profit that cannot be explained by the change in cash, and catch-all accounts that keep growing.

I review a lot of QuickBooks files that owners believed were fine. Usually the owner sensed something was off long before anyone confirmed it: the profit looked too high for how tight cash felt, or the tax preparer asked the same questions every spring. That instinct is worth trusting.

Below are the signs I look for first, a self-check you can run in about twenty minutes, and what a proper correction involves.

What reconciliation proves, and what it does not

A bank reconciliation compares the transactions in your books with the bank's statement for the same period and confirms that the ending balances agree. It catches missing deposits, duplicated payments and bank fees nobody recorded. That is valuable, and it should happen every month for every bank account, credit card and loan.

But reconciliation only looks at one side of each entry. If a monthly loan payment was booked entirely as an expense, the cash side still matches the bank and the account reconciles cleanly. Your expenses are overstated, your loan balance is wrong, and the checkmark is green. The same is true of a customer payment recorded as new income instead of applied to an invoice, or an owner draw recorded as a business expense. Reconciliation confirms that the money moved. It cannot tell you whether the books describe why.

Ten signs the file needs attention

None of these alone proves the books are wrong, but each is worth a closer look, and three or more together usually mean a cleanup is due. The catch-all accounts are the easiest to spot: QuickBooks parks transactions it cannot place in accounts such as Uncategorized Income, Uncategorized Expense or Ask My Accountant, and old opening entries often sit in Opening Balance Equity. A small balance is normal mid-month. A large or growing one means work was skipped.

• The cash balance on your balance sheet does not match the bank statement for the same date
• Loan balances in QuickBooks differ from what the lender says you owe
• Uncategorized, Ask My Accountant or Opening Balance Equity balances keep growing
• Undeposited funds holds payments from months ago
• Accounts receivable lists invoices that customers paid long ago
• Payroll liability accounts do not return to zero after taxes are deposited
• Sales tax payable does not match the returns you filed
• A Reconciliation Discrepancies account or similar adjustment entries appear
• Profit for the year looks far higher or lower than the change in your cash
• The tax preparer makes large adjustments every year that never make it back into the books

Why it happens even with careful owners

Most errors come from the bank feed, not from carelessness. Bank feeds are a great tool, but they invite you to accept a suggested category with one click. Accept the wrong rule once and it repeats for months. Feeds also create duplicates when a transaction is both downloaded and entered by hand, such as an invoice payment recorded in QuickBooks and then accepted again from the feed as a new deposit.

The other common source is the chart of accounts itself. A file set up years ago with dozens of overlapping categories invites inconsistency: the same kind of expense lands in three places depending on who entered it. Over time, nobody trusts the profit and loss statement, so nobody reads it, and errors that would be obvious to a regular reader go unnoticed.

Finally, there is the forced reconciliation. When the numbers do not tie and the deadline is close, it is tempting to let the software post an adjustment and move on. That clears the screen, but the underlying difference is still there, now buried in an account few people open.

What wrong books quietly cost

The cost of inaccurate books rarely shows up as one big bill. It shows up as decisions made on bad numbers. If expenses are overstated, the business looks less profitable than it is and you may hold back on hiring or pricing. If income is double-counted, you may pay estimated taxes on money you never earned, or spend cash you thought was profit.

It also shows up at tax time and at the bank. A tax preparer working from unreliable books has to spend hours reconstructing them, and someone pays for those hours. A lender who sees a balance sheet that does not match your statements will ask questions, slow the loan down or decline it. And a return filed from wrong books can mean either missed deductions or an amended return later. For many Dallas owners I meet, the cleanup turns out to cost less than one year of those quiet losses.

A 20-minute self-check you can run today

You do not need accounting training for this. Pull your balance sheet as of the last day of the most recent month, and gather the statements for every bank account, credit card and loan for that same date. Then work through these steps and note anything that does not match. If most of them pass, your books are probably in reasonable shape. If several fail, you have found where to start.

• Compare each bank and credit card balance on the balance sheet with its statement
• Compare each loan balance with the lender's statement
• Open the uncategorized and Ask My Accountant accounts and note the totals
• Run an accounts receivable aging report and check the oldest invoices with your memory
• Check that payroll liabilities are near zero after the last tax deposit
• Compare the year's profit with the change in cash, and see whether loans, equipment purchases or owner draws explain the gap

When to fix it yourself and when to hand it over

If the problem is narrow, such as a handful of transactions in the wrong category last month or one duplicate deposit, you can usually correct it yourself. Edit the transaction, fix the bank rule that caused it, and re-run the report.

Hand it over when the problem spans many months, when reconciliations have to be undone and redone, when balance sheet accounts like loans, payroll liabilities or equity are off, or when the books feed a tax return that has already been filed. Fixing a closed year can change numbers your tax return relied on, and that needs someone who understands both sides. It is also worth bringing in help if a lender, buyer or landlord is about to see your statements. If you are choosing someone for that work, these questions to ask an outsourced bookkeeper will help.

What a proper correction looks like

When we take on a file like this, we start with the balance sheet, not the profit and loss. If the assets, loans and liabilities are right, most of the profit and loss follows. We tie each account to an outside document: bank statements, loan statements, payroll reports and filed tax returns. Where reconciliations were forced, we undo them and reconcile month by month until we find the real differences.

Then we deal with the causes: bank rules that misfile transactions, duplicate entries from the feed, and a chart of accounts with too many overlapping categories. Simplifying the chart of accounts so each kind of transaction has one clear home is often the single most useful change. Where the corrections touch years already filed, we coordinate with the tax return so the books and the return agree. If the file is many months behind as well as wrong, the process looks like the one I describe for books that are months behind a deadline.

Keeping the numbers honest after the cleanup

Clean books stay clean through routine, not heroics. Reconcile every account every month, including credit cards and loans. Review the bank rules a few times a year. Clear the uncategorized accounts before you close the month. Read your profit and loss and balance sheet each month, even briefly, because you are the person most likely to notice a number that does not fit your business.

A good monthly close does all of this in a fixed order; I walk through it in what happens during a monthly bookkeeping close. And if your profit never seems to match your bank balance even after everything ties, the issue may be timing rather than error, which is the difference explained in cash versus accrual accounting.

If you want a second pair of eyes

We start with a free 30-minute consultation, by phone or at our offices in Plano, Garland and Flower Mound, and we work with businesses across the Dallas area and remotely. Bring your balance sheet, your most recent statements and a sense of what feels wrong. We will tell you whether it looks like a quick correction or a larger cleanup, and you will receive a written flat-fee proposal before any work starts.

If we take it on, onboarding typically runs one to two weeks, and then monthly service keeps the file honest, with reconciled accounts and reports every month and a bookkeeper you can call when a number does not look right.

Questions people ask me