ProAdvisor checklist · What we look for
Your QuickBooks is running. That doesn’t mean your books are right.
QuickBooks validates format, not truth — which is why a file can look healthy and still be wrong. This is the checklist a QuickBooks ProAdvisor works through when assessing a file: the six problems that turn up most often in messy books, what each one costs you, and how to spot it. It ends with the ten-minute diagnostic you can run on your own file right now. No email, no gate.
QuickBooks will never tell you your books are wrong. It validates format, not truth — a wrong entry and a right entry are both just a posted transaction, and the reports render with the same confident precision either way. Six problems account for most of what we find inside a messy file: unreconciled months, misclassified and uncategorized transactions, incorrect opening balances, duplicate transactions, Undeposited Funds pile-up, and bank-feed discrepancies. This page explains each one, the mechanism that lets broken books look healthy, and gives you a free diagnostic to test your own file.
A practitioner checklist from TechBrot — not a survey, not an industry study, and not a statistical sample. It describes what we look for, not how often it occurs.
A messy file is usually a file that stopped being checked.
There is a comfortable assumption that a messy QuickBooks file is a cosmetic problem — a few things in the wrong category, a chart of accounts that grew wild. That is rarely the real problem. When a file arrives in a genuinely bad state, the dominant issue is not untidiness. It is that the books had stopped being checked against reality, often a long time ago.
This page carries no frequency statistics. It is a description of what we look for and why each item matters — not a measured study, and it does not claim to be one. When we have published a benchmark built from enough anonymised engagement data to stand behind, the numbers will appear here with their sample size stated.
The six problems worth checking first.
These are ordered by how consequential they are, not by measured frequency: we do not publish a per-problem count, because we have not counted one. We would rather give you six problems we can explain than six percentages we invented. Each one below is what it is, why it happens, and what it costs you.
Unreconciled months — often many of them.
Unreconciled accounts are the single strongest predictor of what a cleanup will cost, which is why this sits first. We do not publish how often it occurs — that figure belongs to the benchmark dataset, which has not reached its publishing threshold.
Reconciliation is the only step in QuickBooks that tests your books against an outside authority — the bank. It is also optional, skippable, and silently ignorable. Nothing in the software blocks you, warns you, or degrades if you never do it. So in a busy month it is the first thing to slip, and because nothing breaks, it slips again the next month. Owners rarely decide to stop reconciling; they just stop, and the file never mentions it.
Every month you do not reconcile is a month where an error can enter and never be caught. The errors do not sit still — they compound. A missed transaction in March quietly distorts every report from March onward, and by the time anyone looks, the fix is no longer “check one month”, it is rebuilding a year. This single item is the strongest predictor of what a cleanup will cost.
Misclassified and uncategorized transactions.
Bank feeds import transactions; they do not understand them. QuickBooks guesses a category from a payee string, the owner accepts the guess to clear the queue, and anything genuinely ambiguous gets parked in Uncategorized Expense or Ask My Accountant — an account whose name is a promise that someone, later, will deal with it. Very often nobody does. It is a parking lot that quietly becomes a landfill.
A P&L still totals perfectly with a five-figure balance sitting in Ask My Accountant. Nothing looks broken. But every margin, every category, and every year-over-year comparison built on that file is wrong — and so is the tax position, because expenses in the wrong bucket are either overstated, understated, or not deductible where they landed.
Incorrect opening balances.
The opening balance is what the file asserts was true on day one. Get it wrong at setup — a typo, a wrong start date, a migration that carried history badly — and every single transaction posted afterwards is stacked on a foundation that was never right. The tell is usually a balance sitting in Opening Balance Equity, an account that should be empty in a healthy file.
This is the most expensive item on the list to fix, because you cannot repair it at the top. The error is underneath everything, so correcting it means working back through the file rather than adjusting the current month. It is also the one owners find hardest to believe, since the file has “worked” for years.
Duplicate transactions.
Duplicates arrive from the seams between systems: a bank feed re-imports a range, a payment is entered manually and then matched again from the feed, a CSV is uploaded twice, an integration double-posts. QuickBooks does not flag duplicates. It has no reason to — two identical postings are simply two postings, both perfectly valid.
Duplicated income inflates revenue and the tax you owe on it. Duplicated expenses do the reverse. Either way the books look plausible — the numbers are the right shape, just the wrong size — which is precisely why duplicates survive so long. They are usually found during reconciliation, which is the reason a file that is never reconciled is also a file where duplicates accumulate freely.
Undeposited Funds piling up.
Undeposited Funds is a holding account: payments land there when received and are supposed to clear out when you record the actual bank deposit. If you receive a payment and separately record the deposit — instead of clearing the payment into it — the money is counted once in the holding account and once in the bank. The workflow is genuinely unintuitive, so this happens constantly, and to careful people.
Income gets double-counted and the balance sheet carries an asset that does not exist. The account grows quietly, month after month, and nothing about the file complains. We have opened files where Undeposited Funds held years of accumulated phantom money, all of it taxable on paper.
Bank-feed discrepancies.
The feed is a convenience, not a source of truth. Connections drop and silently backfill or miss a window; a rule mis-matches a transaction; a manual entry and a fed entry describe the same event and never get married up. The feed keeps flowing, so nothing announces the gap — the file simply drifts away from the bank, one small disagreement at a time.
The end state is a QuickBooks balance that does not equal the real bank balance, which is the plainest possible evidence that the books are wrong — and the single fastest check any owner can run. Most of the owners we have worked with had never compared the two.
Wrong books look exactly like right books.
Here is the part almost nobody says out loud, and it is the reason owners are so often surprised by what a file review finds.
QuickBooks has no concept of “correct”. It validates format, not truth. When you post a transaction, the software checks that it is structurally well-formed — it has a date, it has an amount, it hits an account, the debits equal the credits. That is the entire test. It has no way to know whether the amount is right, whether that was the correct account, whether the transaction is a duplicate of one three rows up, or whether it ever happened at all. A wrong entry and a right entry are, to the software, the same object: a valid posting.
Which means the reports cannot warn you. Your profit and loss is not an assessment of your books — it is a rendering of them. It takes whatever is in the file and lays it out in clean columns, right-aligned, correct to the cent, in the same confident typography whether the underlying data is immaculate or garbage. The totals foot perfectly either way, because they are totals of what is there, not of what is true.
QuickBooks will never tell you your books are wrong. It has no way to know. The only thing in the product that can tell you is reconciliation — and it’s optional.
Reconciliation is the only correctness test in the product — and it is optional.
Reconciliation is the one step that compares your books against an authority outside the file: the bank statement. Everything else in QuickBooks is internally consistent by construction — of course the balance sheet balances, it was built to. Only reconciliation asks the question that actually matters: does this file agree with what really happened?
And it is optional. You can run a company on QuickBooks for years and never reconcile a single account. Nothing blocks you. Nothing degrades. No banner appears. The invoices still send, the reports still generate, the dashboard still draws its cheerful little chart. The software will let you drive indefinitely without ever checking the mirrors, and it will never mention that you haven’t.
The silence is what owners read as confirmation.
This is the psychological trap, and it is a completely reasonable mistake to make. Every other piece of software in an owner’s life complains when something is wrong. The card is declined. The form won’t submit. The file won’t save. Red text appears. So when QuickBooks says nothing — month after month, year after year — the absence of a complaint gets read as a passing grade.
It isn’t one. It is the absence of an opinion. And several things conspire to make that silence feel like reassurance:
The four things that make broken books feel trustworthy.
It looks precise. Numbers to the cent, in a monospaced column, add up. Precision is not accuracy — a number can be exactly wrong — but it reads as authority, and it is very hard to distrust a total that foots.
It looks automated. The bank feed is flowing, transactions are arriving on their own, and rules are categorising them without being asked. Automation feels like verification. It is not: the feed imports transactions, it does not understand them.
It never complains. Covered above, and it is the strongest signal of the four, because it operates continuously and invisibly.
The tax return got filed. This is the one that costs owners the most, so it deserves saying plainly: a filed return is not a verified set of books. When the file doesn’t tie, a preparer will very often make the adjustments they need in their own workpapers — get a defensible return out of the door — and leave the QuickBooks file exactly as they found it. The return is clean. The books were never fixed. They were worked around, and the owner now has documentary evidence, in their mind, that everything is fine.
Why this compounds instead of sitting still.
An error in a file that is never reconciled does not wait patiently to be found. It propagates. A missed transaction in March is inside every report from March onward; a wrong opening balance is underneath every transaction ever posted; a duplicate in a period you have already filed against is now woven into a return. Each month that passes, the same fix gets more expensive — not because the error grew, but because everything built on top of it has to be unpicked too.
That is the real cost of the silence. Not that the books are wrong — books can be fixed — but that nothing ever interrupts the owner to say so, and so the cheapest moment to fix it passes, quietly, every single month.
The ten-minute diagnostic.
Eight checks. They need no accounting knowledge, no export, and nobody’s help — just your QuickBooks file and your bank’s website open side by side. This is the same set of tests I run first on any file that reaches me. It is free, it is not gated behind an email address, and you are welcome to print it, copy it, or hand it to your bookkeeper.
How to read the result: one red flag is worth investigating. Two or more, and the file is very unlikely to be reliable — not because you’ve done anything careless, but because these problems feed each other.
- Find the last reconciled date. In QuickBooks Online: Settings → Reconcile; in Desktop: Banking → Reconcile. Look at when each bank and credit-card account was last reconciled — not when it was last used. Red flag: anything older than last month, on any account.
- Compare the QuickBooks balance to the real bank balance. Open your bank’s website in one tab and the QuickBooks bank account in another, on the same date. Red flag: they do not match. This is the single most direct evidence that the books are wrong, and it takes ninety seconds.
- Look at Undeposited Funds. Open the balance sheet and find the account. Red flag: a balance that is large, or that only ever grows. In a healthy file it clears to zero regularly — money passes through it, it does not live there.
- Check Uncategorized Expense and Ask My Accountant. Both should be at or near zero. Red flag: a meaningful balance, or one that has been carried forward for months. Whatever is in there is not in your numbers.
- Read the balance sheet before the P&L. Most owners only ever look at the profit and loss, because that is where the story is. Red flag: the balance sheet does not balance, carries negative asset balances, or shows an Opening Balance Equity figure that never went away.
- Look at retained earnings. It should roll forward sensibly from last year’s closing position. Red flag: it moves in ways nobody can explain, or it changed for a year you already filed.
- Compare the books to your last filed tax return. Pull the return and put the same year’s P&L next to it. Red flag: they disagree. A filed return is not proof the books are right — your preparer may simply have made adjustments outside QuickBooks to file something defensible, leaving the file itself untouched and still wrong.
- Confirm every account is actually in the file. List every bank account, credit card, loan, and payment processor the business uses, and check each one is connected and reconciling. Red flag: a real account that the books have never heard of. It is more common than it sounds.
If checks 1, 2, and 4 all came back clean, your file is in reasonable shape on the checks that matter most. If check 7 came back dirty — the books disagree with a return you have already filed — that is the one to act on first.
Found something you can’t explain?
A QuickBooks ProAdvisor reads your actual file and tells you which of the six problems you have — and whether it’s a self-fix, a catch-up, or a cleanup. Free, no obligation, and if the file is fine we’ll say so.
What this is — and what it isn’t.
What it is. A practitioner checklist: the six problems TechBrot looks for when assessing a QuickBooks file, why each one happens, what it costs, and how you can check for it yourself. It is a description of professional practice, not a study.
What it isn’t — and this page carries no statistics at all. It is not a survey, not a study, and not a statistic about QuickBooks users in general. It publishes no client count, no percentages, and no frequency claims, and nothing here should be cited as data. An earlier version of this page did carry figures drawn from one practitioner’s caseload; they were removed because the sample behind them was too small to support them, and a number that cannot be defended does not belong on this site.
Where we did not count, we do not claim. We do not log per-problem frequencies, so this page does not give you any. The six items are ordered by how consequential they are, which is a judgment, not a measurement.
The benchmark that will carry numbers. Statistics on this topic belong to the US QuickBooks Cleanup Benchmarks — a separate, structured dataset in which one anonymised row is logged at the close of every completed cleanup, bound by a public rule: nothing publishes on any breakdown until it reaches at least 20 records, and the sample size is always shown. That dataset is still collecting and reports nothing yet. When it does, its figures will appear there, with their sample size attached. Nothing on this page is drawn from it.
Who wrote it. TechBrot Inc., led by its founder, who holds the QuickBooks Online Level 2 and QuickBooks Payroll certifications. Last updated 2026-10-01.
What owners ask once they’ve run the diagnostic.
How can I tell if my QuickBooks books are accurate?
Why doesn’t QuickBooks tell me my books are wrong?
My accountant filed my tax return. Doesn’t that mean my books are right?
How far behind is a QuickBooks file usually when it needs a cleanup?
Does a messy QuickBooks file always need a paid cleanup?
You’ve run the checks. Now what?
Find out which of the six you actually have.
If the diagnostic surfaced something, the honest next step is to have someone read the actual file. A QuickBooks ProAdvisor looks at your real QuickBooks file and tells you plainly what’s wrong and what it would take to fix — free, no obligation. If it needs work, you get a written fixed-fee scope. If it doesn’t, we’ll tell you that too.