QuickBooks Trial Balance Won't Foot? It's Likely File Damage

When a QuickBooks Desktop company file is healthy, its Trial Balance always foots — every account listed as of a chosen date, with debit and credit column totals that match exactly. So when month-end arrives and those two columns refuse to equal, or when the A/R Aging Summary won’t tie to Accounts Receivable on the Balance Sheet, the first question to ask is whether the file itself has sustained data damage.

What the reports should do

The Trial Balance is a fundamental accounting check. Because every transaction in QuickBooks posts in balance — every debit paired with a corresponding credit — the report’s two column totals must be equal at any date. A Trial Balance that does not foot is not a matter of report settings, display preferences, or bookkeeping interpretation. It is a structural problem inside the file.

The same principle governs the aging reports. The A/R Aging Summary groups each customer’s open invoices into time-based buckets, and the A/P Aging Summary does the same for unpaid vendor bills. As of any given date, the grand total on each aging report should match its corresponding control account on the Balance Sheet — Accounts Receivable and Accounts Payable, respectively. When those numbers drift apart, something has broken the link between individual transactions and the summary accounts that hold them.

Rule out the ordinary causes first

Before concluding that the file is damaged, it is worth checking two things that routinely produce apparent mismatches without any underlying corruption.

First, confirm that every report uses the same “as of” date. A Balance Sheet run through the 31st and an aging report run through the 30th will naturally show different totals, and the discrepancy has nothing to do with data integrity.

Second, make sure the reports are set to accrual basis. Accounts Receivable and Accounts Payable are accrual concepts by definition — they represent money owed to you or by you regardless of when cash actually moves. A cash-basis view will not tie to those accounts, and switching to accrual often clears the confusion immediately.

When the basics don’t fix it

If the dates match, the basis is set to accrual, and the numbers still will not reconcile — or the Trial Balance is genuinely out of balance — treat the file as potentially damaged and run QuickBooks’ built-in verification tool. The Verify Data utility, found under the File menu in the Utilities section, scans the company file for structural errors that manual review cannot detect.

If Verify reports problems, the next step is to create a backup of the file and then run Rebuild Data, located in the same Utilities menu. Rebuild attempts to repair the damage Verify identifies — typically minor corruption affecting individual transactions or list entries — and in many cases the rebuilt file will produce reports that tie cleanly once again. After running Rebuild, re-run the Trial Balance and both aging reports to check whether the problem has cleared.

When the built-in tools aren’t enough

There are situations where the damage exceeds what Verify and Rebuild can handle. Verify may keep reporting errors after multiple passes, Rebuild may fail to complete, or the file may rebuild without errors yet still produce a Trial Balance that will not foot and aging totals that refuse to match the Balance Sheet.

When that happens, the corruption has reached a level that the built-in utilities were not designed to repair. At that point the file needs more involved data recovery to repair the underlying structural damage and restore a company file whose Trial Balance foots correctly and whose aging reports reconcile to the Balance Sheet as they should. The good news is that even severe imbalance issues are generally recoverable — the transactions are usually still present in the file, and the damage lies in the connections between them rather than the data itself.