What a books health check actually is
A books health check is a quick, structured scan of a QuickBooks file that flags data-quality problems before you rely on the numbers. It is not a full reconciliation, not a forensic audit, and not month-end close. Think of it as triage: a fast read on whether the books are in good shape, lightly messy, or genuinely broken, plus a punch list of what to fix first.
Intuit built a version of this idea into QuickBooks Online Accountant. Their Books Review tool (formerly "Month-End Review") focuses on three areas every clean file needs to get right: incomplete transactions, reconciliations, and account balances. The Transaction Review tab surfaces transactions with missing or incorrect information and flags uncategorized transactions and unapplied payments; the Final Review tab lists unusual or unexpected balances worth a second look (Intuit's Books Review docs). A good health check covers the same ground whether or not you're working inside QBOA.
The reason to do this deliberately, rather than by feel, is consistency. When you check the same signals in the same order every time, you stop missing the boring problems that quietly distort financials, and you can tell a client "your books are clean" and mean something specific by it.
Clean vs. dirty books: the signals that matter
Most data-quality problems in QuickBooks fall into a short list. Learn these and you can size up almost any file quickly.
1. Opening Balance Equity (OBE)
Opening Balance Equity is the single clearest tell. QuickBooks creates this account automatically to keep debits and credits balanced when you set up accounts or enter opening balances. It's supposed to net to zero once setup is finished. A lingering balance means someone entered an opening balance for an asset or liability without entering the offsetting equity, or imported only part of a prior chart of accounts.
On a properly set-up file, OBE should be $0. Per Fit Small Business, any amount sitting in OBE indicates recent data-entry errors or incomplete transactions that need correction — and a balance carrying into a later year can throw off the profit and loss statement, not just the balance sheet. If you see a number in OBE, the file has not been finished. Full stop. We go deeper on this one in our guide to Opening Balance Equity in QuickBooks.
2. Uncategorized transactions and "Ask My Accountant"
When QuickBooks doesn't know where to put a transaction, it dumps it into Uncategorized Income, Uncategorized Expense, Uncategorized Asset, or the catch-all "Ask My Accountant" account. A few stragglers are normal. Large balances mean nobody actually knows what the business spent money on or earned it from.
This isn't cosmetic. As Steph's Books points out, uncategorized transactions actively mislead decision-makers — if $12,000 of software subscriptions sits uncategorized, the company's technology spend looks artificially low and operating costs are understated. To check it manually, run Reports → Transaction List by Account, filter for the uncategorized accounts plus Ask My Accountant, and look at the totals. Big balances here are an instant fail.
3. Duplicate transactions
Duplicates show up when a transaction gets entered manually and also imported from the bank feed, or when multiple people touch the file and re-enter the same bill or deposit. They inflate both income and expenses, so the P&L can look plausible while every number is slightly wrong. Watch for two transactions with the same date, amount, and payee, and for vendor totals that look higher than the business's actual activity.
4. Missing payees
A transaction without a payee (the name/vendor field) is a transaction you can't audit. QuickBooks itself flags transactions without payees as incomplete, alongside uncategorized transactions and unapplied payments. Missing payees make 1099 prep painful, break vendor reporting, and make it impossible to spot the duplicates above. On a clean file, expense and bill transactions almost always carry a name.
5. Reconciliation status
If the bank and credit-card accounts aren't reconciled — or are months behind — nothing else can be trusted, because the books haven't been tied back to reality. Reconciliation months behind (or never done) is one of the most reliable signs a file needs cleanup. Check the last reconciled date on each bank and card account and compare it to today. A clean file is reconciled through the most recent closed month.
6. Balance-sheet sanity
The balance sheet is where deep problems surface. A quick sanity pass catches a lot:
- Negative balances where they shouldn't be — a negative bank balance that isn't a real overdraft, a negative accounts payable, or negative inventory.
- Undeposited Funds piling up — payments recorded but never grouped into a deposit, so cash looks lower than it is.
- Accounts Receivable / Accounts Payable that don't make sense — A/R or A/P balances that have been static for ages, or that contain credits and stale items nobody is collecting or paying.
- A balance sheet that doesn't balance in a way the prior period explains — often a downstream symptom of the OBE problem above.
QuickBooks Online Accountant's Final Review tab exists precisely to surface "unusual or unexpected balances," which is exactly the instinct to bring to any file.
How to run a books health check (the one-minute version)
You can do all of this by hand. Here's the fast manual sequence:
- Pull the Balance Sheet (all dates) and scan for Opening Balance Equity, negatives, and odd Undeposited Funds / A/R / A/P balances.
- Run Transaction List by Account filtered to Uncategorized Income/Expense/Asset and Ask My Accountant. Note the totals and the count.
- Check reconciliation status on every bank and credit-card account — last reconciled date vs. today.
- Skim for duplicates and missing payees in the largest expense accounts and the bank registers.
- Write the punch list: what's broken, roughly how much work it is, and what you'll tackle first.
Done deliberately, that's a few minutes of clicking — and it turns "the books feel messy" into a concrete, defensible assessment you can hand a client or quote a cleanup from.
Don't want to click through five reports? You can run a books-health check on any QuickBooks Online export in about a minute — it flags Opening Balance Equity, uncategorized transactions, duplicates, and missing payees automatically. Run a free preview, no card, and get a clean punch list you can act on.
What a clean file looks like
When you've run enough of these, the profile of a healthy file becomes obvious:
- Opening Balance Equity is zero.
- Uncategorized and Ask My Accountant balances are zero or trivially small.
- No obvious duplicate income or expense entries.
- Expense and bill transactions have payees.
- Bank and card accounts are reconciled through the last closed month.
- The balance sheet has no surprise negatives, and Undeposited Funds clears regularly.
Hit those six and you can say "the books are clean" with confidence — and produce a report from them that the client will actually trust.
Where the health check fits in your workflow
Two moments make a books health check especially valuable. The first is onboarding: running it before you quote a cleanup or a monthly engagement means you price from reality instead of optimism. The second is monthly close: a quick scan before you generate client deliverables stops a categorization slip or a stray duplicate from landing in a report that goes to the client's inbox.
That second point is why a health check and a monthly report belong together. A polished report built on unchecked data is just a confident-looking version of wrong numbers. Run the check first, fix what it flags, then send the report — and you've got deliverables you can stand behind. If you're formalizing what you send clients each month, see our guide to monthly reports for bookkeeping clients.
From a one-time check to monthly monitoring
Running the check once, at onboarding, tells you what you're walking into. The harder part is that books don't stay clean. New uncategorized transactions pile up, a duplicate sneaks in from the feed, Opening Balance Equity creeps back after an import. If you carry recurring clients, the same handful of signals is worth watching every month, not just at the start. That's the idea behind Firm Monitor (currently in private beta): connect QuickBooks once and it re-runs this same cleanup-health scan across your clients on a schedule, so you see which files are drifting before the reports go out. The automatic checks today are the same four the diagnostic flags — uncategorized, Ask My Accountant, duplicates, missing payees, plus Opening Balance Equity; reconciliation status and A/R / A/P aging stay manual judgment calls (and are on the roadmap, not detected automatically yet).
However you run it — Intuit's Books Review, a manual report sequence, or an automated scan — the discipline is what matters. Check the same signals every time, fix what's broken before the numbers go anywhere, and "are the books clean?" stops being a feeling and becomes a question you can answer.
FAQ
What is a books health check in QuickBooks?
It's a quick, structured scan of a QuickBooks file that flags data-quality problems before you rely on the numbers. It checks for things like Opening Balance Equity, uncategorized transactions, duplicates, missing payees, reconciliation status, and odd balance-sheet items. It's triage, not a full reconciliation or audit.
How do I know if a QuickBooks file is clean?
On a clean file, Opening Balance Equity is zero, uncategorized and Ask My Accountant balances are zero or trivial, there are no obvious duplicates, expense transactions have payees, bank and card accounts are reconciled through the last closed month, and the balance sheet has no surprise negatives. If all six hold, the books are clean.
Why does Opening Balance Equity matter so much?
QuickBooks uses Opening Balance Equity to keep debits and credits balanced during setup, and it should net to zero once setup is done. A lingering balance signals incomplete data entry or a partial chart-of-accounts import, and if it carries into a later year it can distort the profit and loss statement, not just the balance sheet.
What's the fastest way to find uncategorized transactions?
Run Reports, then Transaction List by Account, and filter for Uncategorized Income, Uncategorized Expense, Uncategorized Asset, and Ask My Accountant. Check the totals and the transaction count. Large balances mean nobody actually knows what the business spent or earned, which understates real costs.
Is a books health check the same as month-end close?
No. A health check is fast triage that tells you whether the file can be trusted and what to fix first. Month-end close is the full process of categorizing, reconciling, and finalizing the period. A health check is best run before you quote a cleanup and before you generate client reports.