What Is Balance Sheet Not Balancing?

If assets do not equal liabilities plus equity, something is recorded incorrectly. This is always a bookkeeping error rather than a business problem, and it is always findable.

Work through the causes in order of likelihood rather than searching randomly.

1. A one-sided journal entry

The most common cause. A journal posted with debits not equal to credits, which some systems permit and some prevent. Run a list of journal entries for the period and check each one totals.

2. An opening balance error

If the balance sheet balanced last period and not this one, the error is in this period. If it has never balanced, the opening balances were entered incorrectly when the file was set up. That is common in migrated files and it is worth fixing properly rather than plugging.

3. Something posted directly to a control account

Accounts receivable and accounts payable control accounts should only be affected by invoices and payments flowing through the subsidiary ledgers. A journal posted straight to the control account breaks the link between the control total and the detail.

4. A transaction dated outside the period

An entry dated in a future period, or in a period already closed, can produce a mismatch depending on how the report is run. Check for transactions with unusual dates, particularly year offsets caused by typing errors.

5. Multi-currency movement

If you hold balances in more than one currency, unrealised exchange differences need recording. Where they are not, the statement will not balance and the gap will move with the exchange rate.

6. Damaged or partially posted data

Rare, and it does happen: an interrupted import, a partially completed transaction, or a corrupted record. Most accounting systems offer a data verification or rebuild function that identifies these.

A method for finding it

• Note the exact amount of the difference. It is frequently recognisable in itself
• If the difference is divisible by nine, suspect a transposition error such as 540 typed as 450
• If the difference equals a transaction you recognise, that transaction is posted once rather than twice
• Narrow by period: run the balance sheet at successive dates until it stops balancing, isolating the day
• Run the general ledger detail for that day and inspect each entry
• Check journals first, then anything posted to a control account

Do not plug it

Posting a balancing entry to a suspense account makes the statement balance and leaves the error in place. It will surface again, usually at year end, and by then the original transaction is much harder to identify. Find the cause.

Confirm what is out of balance

Calculate assets minus liabilities minus equity by period. Determine whether the ledger trial balance itself is unequal, a report mapping is wrong, or a financial model fails to link. Do not insert a plug.

Find the first bad period

Start with the last period that balanced and the first that does not. The change in the imbalance often reveals a missing amount, reversed sign, one-sided formula, omitted account, or incorrect rollforward.

Check retained earnings

Opening retained earnings plus the applicable profit or loss, owner or shareholder activity, and approved adjustments should reconcile to closing retained earnings under the reporting structure. Avoid linking only the current period’s income.

Check cash and working capital

Opening cash plus the statement’s net change should equal closing cash. Verify receivables, inventory, payables, accruals, taxes, and deferred balances use changes with the correct signs and connect to both profit and cash.

Check long-term schedules

Reconcile fixed assets, accumulated depreciation, debt, leases, equity, and acquisitions. Each schedule needs an opening balance, movements, closing balance, and corresponding statement entries.

Troubleshooting checklist

• First unequal period is identified
• Trial balance and report mapping are separated
• Signs, units, dates, and scenario switches are checked
• Retained earnings rolls forward
• Cash movement agrees to closing cash
• Supporting schedules tie to the balance sheet
• No hard-coded balancing amount remains

Use temporary diagnostic checks to isolate the error. Set forecast growth to zero, freeze new financing, and hold working-capital days constant to see whether the imbalance disappears. Trace formula patterns across adjacent periods and search for a hard-coded cell, wrong row, mixed unit, or link to a different scenario. Compare each supporting schedule’s closing balance with the mapped statement line. If the issue arises in accounting software rather than a model, preserve a backup, identify the first affected transaction or import, and correct it through the approved workflow. Document the root cause and preventive control before closing the issue.

After correction, rerun the trial balance, balance sheet, income statement, cash flow statement, and affected schedules for all impacted periods. Confirm the difference is zero for the right reason and that the fix did not create a new inconsistency elsewhere. Retain the before-and-after evidence and reviewer approval.