Balance Sheet Out of Balance? What It Means and What to Do

A balance sheet out of balance is not a rounding quirk and it is not a display bug. Total assets must equal total liabilities plus equity, the software does that arithmetic for you, and when the two sides disagree it is reporting something real about the file. The amount tells you nothing about the severity. A few cents and six figures can have the same cause.

Which basis is out of balance?

Establish this before anything else, because it decides where you look. Run the balance sheet in cash basis, then run it again in accrual basis, and note which one fails.

Cash basis reporting depends on the links between transactions: the payment to the invoice, the credit memo to the invoice, the journal entry to the credit. When one of those links is broken or ambiguous, the amount cannot be assigned cleanly and the report shows it. Accrual reporting leans on those links far less. So an imbalance in cash basis alone usually points at a small set of transactions. One that persists in accrual basis after a rebuild usually points at damage in the file.

How do you find the date it broke?

An imbalance has a first day, and finding it removes most of the guesswork. Run the balance sheet with the date range set to all dates and the columns displayed by year. Compare total assets against total liabilities and equity, year by year, until they diverge. Then repeat on that year by month, by week, and finally by day.

Four passes take a few minutes and hand you one date. With that date you can run a transaction detail report and look for entries that add up to the amount you are out by. Without it you are reading the whole file.

Which entries cause this most often?

A short list covers most cash basis cases. An inventory return and a discount recorded on the same invoice is the classic. The sale and the discount belong on the invoice. The return belongs on a credit memo, linked when the payment is received. A discount taken at customer level but applied at job level causes the same break. So does a journal entry linked to a credit memo when receivables are not on the source line of the entry.

The other family is inventory. Quantities driven negative, pending assemblies, washing entries that add and remove the same item at the same price, and damaged item or name records all unbalance a cash basis report. If your file has negative inventory, treat that as the first suspect rather than the last.

When is it the file rather than the entries?

Three patterns say the problem is below the bookkeeping. The report is out of balance in accrual basis and stays that way after a clean rebuild. The transaction detail report for the date shows nothing that adds up to the amount. Or the correction works and the same imbalance returns a week later.

A fourth is timing. If the file balanced in an older version and stopped after conversion to a newer one, the upgrade exposed a fault that was already there. Keep the pre-upgrade copy in that case. It is evidence, and overwriting it costs you the only clean comparison you have.

What should you do before you touch anything?

Back up first, every time. You are editing posted history, and a correction made in the wrong place is harder to unwind than the original problem.

Then be clear about what is closed. Correcting the entries behind an imbalance can change totals in periods that have already been reported or filed. That is an accounting decision, not a technical one, and it belongs to you and whoever signs the statements. Decide it before the corrections start, not after.

Finally, know when to stop. Re-entering the same transactions for the third time is not diligence. If the imbalance keeps coming back, the file needs repair at the data level. That is the point to hand it to someone who works inside the file rather than inside the interface.