Balance sheet not balancing: find the difference

A balance sheet not balancing means assets differ from liabilities plus equity in the report you are reviewing. Find the first stage where the difference appears: source trial balance, account mapping, equity presentation, or opening-to-closing movement. Preserve the original export and calculate the gap before changing anything.

Define the difference and freeze the evidence

Balance-sheet difference = Assets − Liabilities − Equity

A complete statement returns zero. Keep that sign convention throughout the investigation: a positive difference means reported assets exceed reported liabilities plus equity. The SEC's financial statement guide sets out this accounting identity.

Save the reporting date, entity scope, currency, ledger version, and adjustment status with the export. Compare like with like: a preliminary trial balance cannot reliably reconcile to a statement containing later closing entries. For the statement's underlying layout, see the balance sheet guide.

Separate the original balances from your reporting mapping and correction log. The log should identify the affected account, the evidence, the approved correction, and the resulting difference. Use the spreadsheet total checks before trusting an export that may contain hidden rows, text amounts, or duplicated totals.

Check the trial balance before the report

IRS Publication 583 explains that double-entry records have equal total debits and credits after posting. Check that property on the complete export, including income and expense accounts when they have not been closed.

For debit balances in B and credit balances in C, the check is:

=SUM(B2:B10)-SUM(C2:C10)

If it fails, inspect the source extract for missing pages, filters, truncation, and incompatible debit or credit conventions. Confirm with accounting whether the original ledger also fails the check. A reporting formula cannot repair an incomplete source.

If it passes, continue into the mapping. Equality alone does not prove every posting is correct: OpenStax's trial-balance discussion explicitly distinguishes mathematical balance from the absence of accounting errors.

Work an omitted-profit example

A US distributor exports the following adjusted trial balance before closing income and expense accounts. There are no distributions, contributions, or other equity movements in this example. Columns A through E are shown, with spreadsheet row numbers at the left.

In E2 enter the signed-balance formula and fill down:

=B2-C2

The trial balance passes: $820,000 minus $820,000 is zero. But a report using only the posted asset, liability, and equity accounts shows assets of $580,000, liabilities of $300,000, and equity of $200,000. The difference is $80,000.

The missing amount is unclosed current-period profit: $320,000 revenue less $240,000 expenses. Derive the statement summary with labels in G and results in H:

Equity including current profit is $200,000 plus $80,000, or $280,000. Assets of $580,000 now equal liabilities of $300,000 plus equity of $280,000. All example amounts are whole dollars; no rounding adjustment is needed.

Include that profit once. If closing entries have already transferred it into equity, adding it again creates another error. Reconcile the profit to the income statement; the profit and loss example explains that separate statement.

Trace mappings, then opening balances and movements

If profit is accounted for, compare every source account with the approved reporting map. Check unmapped accounts, duplicates, and contra accounts whose credit or debit signs have been lost. Count blank classifications rather than merely summing them: offsetting unmapped balances can have a net total of zero.

=COUNTBLANK(D2:D10)

For this fully mapped example, the result is zero. Also verify that each account-period record appears only as often as the source structure requires.

Then compare opening balances with the previously approved closing statement. For each account, calculate:

=ClosingBalance-OpeningBalance-SignedMovement

Those are named spreadsheet ranges using the same debit-positive convention as column E. Every account should reconcile. If openings agree but closing balances do not, investigate current-period movements and adjustments. If the difference exists at opening, trace the carryforward or scope change first. The flux analysis method covers explaining those movements after the statement ties.

Where it goes wrong

• Adding a plug to equity. A zero difference obtained without evidence leaves the original error unresolved.
• Confusing reclassification with omission. Moving an included balance within assets or liabilities changes presentation, while leaving it out changes totals.
• Discarding contra-account signs. An allowance or accumulated depreciation is part of the net asset calculation, not an extra positive asset.
• Treating balance as complete validation. An omitted transaction with matching debit and credit entries can leave both sides equal and both wrong.

Check your own exports in Covirage

Bring the trial-balance exports, approved account mapping, and statement for the same reporting date. Covirage maps the columns, its tools compute and check the differences, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for finance teams for the reporting context.