Inside Our Free Books Diagnostic Tool: What It Actually Checks in Your QuickBooks File

People search "free QuickBooks health check" or "is there a tool that checks my books" for a pretty specific reason: they don’t want to pay for a review just to find out nothing is wrong, and they don’t want to keep guessing either. We built the free diagnostic for that exact gap. No pitch here, just the plain mechanics of what the tool does when you upload a file, written by someone who has watched a lot of QuickBooks exports go through it.

If you’re the type who wants to know what a tool is doing before handing it a spreadsheet with your company’s entire financial history, this is for you.

What you actually upload

One file is required: your Trial Balance, exported from QuickBooks Online as Excel (Reports → Trial Balance → Excel). Everything else is optional: A/P aging, A/R aging, a general ledger detail for the last three months, balance sheet, profit and loss, chart of accounts. You can run the diagnostic on the trial balance alone. The optional reports don’t replace it. They sharpen what it can tell you, which is the part most people don’t expect.

In practice the upload takes about five minutes if your exports are already sitting in a folder, longer if you have to go dig them out of QuickBooks first. Files need to be .xlsx or .csv, capped at 100MB. That cap is generous enough that file size has never actually been the bottleneck for anyone we’ve talked to.

What the trial balance alone tells us

This is the part people underestimate. A trial balance looks like a boring list of accounts and balances, but it’s where most of the evidence lives if you know what to look for. From that one report, the diagnostic checks for:

• ✓Undeposited Funds sitting there instead of clearing to a real bank account
• ✓Opening Balance Equity that should have zeroed out years ago and never did
• ✓Reconciliation discrepancy postings, the tell-tale sign someone forced a reconciliation to balance
• ✓"Ask My Accountant" and other miscellaneous catch-all accounts, and how much is parked in them
• ✓Uncategorized income and expenses
• ✓Negative balances sitting where they operationally shouldn’t be
• ✓Duplicate chart-of-accounts names that split what should be one category into two
• ✓Bank or credit card accounts that look like they might actually be personal, not business

All of that rolls up into a single books health score, which is less about the number itself and more about giving you a fast answer to "how bad is it, roughly" before you read a single finding.

What the optional reports add

The trial balance gets you the core picture. Each additional report you upload adds its own specific checks:

• ✓A/P Aging Detail flags stale unpaid bills sitting past 90 days, and possible duplicate or missed vendor payments.
• ✓A/R Aging Detail surfaces overdue receivables you may have stopped chasing without noticing.
• ✓General Ledger (last 3 months) shows how long Undeposited Funds has actually been aging, journal entries posted with no memo explaining them, postings that landed in a period that should already be closed, and an overall signal for how recently the books were touched.
• ✓Balance Sheet and Profit & Loss act as supplementary validation, mainly useful when the trial balance itself is thin and needs a second source to cross-check against.
• ✓Chart of Accounts adds account hierarchy and detail-type context that a trial balance alone doesn’t carry.

None of these are required, and the tool won’t block you for skipping them. But if you’ve ever wondered why one company’s diagnostic report reads sharper than another’s, this is almost always the reason. More reports in, more specific findings out.

The hero copy on the diagnostic page says it plainly: patterns worth reviewing, not accusations. That’s the right way to read every finding it returns.

What happens to your data

Fair question, and usually the first one people ask. You’re uploading a full financial picture of your business to a tool you just found through a Google search. So, plainly: files are processed temporarily to generate the report, then deleted after 30 days, and you’re shown that exact consent language before anything runs. No sales call gate. You don’t connect QuickBooks live or hand over login credentials either, and the exports you send stay under your control the entire time.

If that still makes you uneasy, that’s a reasonable instinct about any tool touching your books. Ask the same question of anyone else offering a "free scan" of your financials before you upload anything.

What you get at the end

The output is a books health score plus findings written in plain English. Each one answers a question you’d actually ask, like "is this Undeposited Funds balance normal or a problem?" You won’t get "account 1499 variance detected." Report generation takes minutes, because there’s no person’s calendar queued up in front of it yet.

What it deliberately doesn’t do is fix anything. A diagnostic identifies what’s wrong and roughly how serious it is. Cleanup and catch-up bookkeeping is the separate step that reconciles the accounts, fixes the coding, and clears the balances the diagnostic flagged. Treating the diagnostic as the fix is the most common misunderstanding we see. It’s an easy mistake if you’ve never used a tool like this.

What a tool like this cannot tell you

Worth saying honestly: this is a diagnostic, not an audit, and no substitute for a person who knows your business. Pattern detection is what it’s good at. It catches the things that show up consistently across thousands of QuickBooks files, like Opening Balance Equity that never zeroed out, or a suspiciously round number parked in Undeposited Funds. Ask it whether a specific $40,000 charge was a legitimate business expense and it has nothing useful to say. That judgment call needs a person looking at the actual transaction, in context.

It also works best on a file with reasonably recent, reasonably complete data. If all you have is a thin profit and loss from eighteen months ago, the diagnostic will tell you what it can, but there’s only so much signal in a report that thin.

Who this is actually useful for

Three groups get the most out of it. Founders who suspect something is off but don’t want to pay for a review before knowing the scope. Anyone switching bookkeepers who wants an honest baseline before new work starts. And businesses heading into tax season or a financing round, who would rather know what will get challenged before someone else finds it.

If you already know your books are behind, skip the diagnostic. What you need is a cleanup quote. But if you’re in the "probably fine, right?" camp, this is built for exactly that uncertainty. Run the free diagnostic with your QuickBooks exports and see your books health score in minutes. Want the broader context first? Here’s what an accounting diagnostic review actually is, and here are seven warning signs that usually mean it’s worth running one.