Your balance sheet is out of balance

Assets should equal liabilities plus equity. That is not a convention — it is what double-entry bookkeeping is. So when QuickBooks shows a balance sheet where they don't match, it is not telling you that someone posted something to the wrong account. It is telling you that something in the file has stopped holding together at the data level.

Which is actually good news, in a narrow way. A posting error could be anywhere. A structural break can be found.

First: which basis is it out on?

This single question splits the problem in half, and most guides skip straight past it.

Run the balance sheet on accrual, then on cash. Note which one is out.

• Out on accrual only. Often a damaged or corrupted transaction. Running the file's rebuild utility genuinely does resolve a good proportion of these. Back up first, without exception.
• Out on cash basis only. This is a different animal. It usually means a transaction whose linkage broke — a payment whose connection to its invoice, or a credit to its bill, no longer resolves cleanly when the report converts to cash. Rebuilding will not find it. It has to be located.
• Out on both. Treat it as the cash-basis case and find the transaction.

Doing this first stops you rebuilding the file four times for a problem a rebuild was never going to fix.

Then narrow it to a single day

This is the part worth doing properly, because it converts an unbounded search into a short list. Four passes:

1. Set the balance sheet date range to All, and display columns by Year. Compare total assets against total liabilities and equity down the row. Find the first year they diverge.
2. Re-run for that year, columns by Quarter. Find the quarter.
3. Re-run for that quarter, columns by Month.
4. Re-run for that month, columns by Day.

You now have a date. Whatever broke, broke on that day, and the transactions dated that day are usually a handful rather than a haystack.

Then find the transaction

With the date in hand, run a transaction detail report for that day. To make the culprit visible, strip the report down: remove the Account, Split, Cleared and Class columns, and show Amount.

What you are looking for is a transaction — or a small set of them — that sums to exactly the amount you are out by. That equality is the confirmation. If nothing on that date sums to your discrepancy, you have narrowed to the wrong day; go back a step.

Fixing it once you've found it

Three options, in ascending order of disruption:

• Re-date the transaction. Moving it out and back can re-link and repair it. Sounds like superstition; it works often enough to try first, because it is the least destructive thing available.
• Delete and re-enter it. Reliable, and you lose the original audit trail — so record what it was before you delete it.
• Rebuild the data file. Appropriate for accrual-only imbalance. Always after a backup.

The question to answer before you change anything

Does the date you found fall inside a year that has already been filed from?

If it does, correcting it will change the comparative figures your CPA used. That is not a reason to leave it broken — it is a reason to raise it with them before the correction rather than discovering it at the next year-end. The bookkeeping fix and its tax consequence are separate decisions, and the second one isn't yours to make alone.

While the file is out of balance, treat every report from it as provisional. Not because QuickBooks is lying, but because the underlying arithmetic doesn't close, and anything derived from it inherits that.

When this stops being a DIY job

Handle it yourself when a rebuild fixes it, or when the four-pass narrowing lands on one obvious transaction on one date.

Get help when:

• The imbalance is cash-basis only and the narrowing doesn't land cleanly.
• It survives a rebuild.
• The date falls in a year already filed from.
• There is more than one date where the file goes out — that points at a pattern rather than an incident, often an import or a conversion.
• You find yourself considering starting a new file. That decision is worth a second opinion, because your history has real value for trends, lender questions and tax, and abandoning it creates its own problems.

That work is a QuickBooks cleanup: finding the structural break, correcting it, and verifying the file balances across every period afterwards rather than just today. It is quoted as a one-time fixed fee in writing before any work starts, after a free file review.

TechBrot does the operational bookkeeping and hands your CPA a file they can file from. If the answer turns out to be "run a rebuild, you're fine," we'll say that.