Bookkeeping · Cleanups & Fixes · Guide · Working level
Diagnosing balance sheet problems: reading the report for wrongness
How to spot the twelve most common balance sheet errors — negative liabilities, frozen assets, loans that don't match statements, equity that jumped — and the first test to run on each.
A profit and loss statement can look plausible while being wrong; a balance sheet cannot hide as easily, because every line is a running total that must answer to something outside the books — a bank statement, a loan schedule, a filed return, a customer's reality. That makes the balance sheet the diagnostic instrument of choice for a suspect ledger: read it line by line, ask "what should this number equal, and can I check?", and the errors identify themselves.
This guide catalogs the twelve patterns that account for most balance sheet wrongness in small-business books, gives each a first test, and works through full diagnostics for the three you will meet most often.
How to read a balance sheet for wrongness
Three passes, ten minutes:
- Sign check. Scan for anything with the wrong sign: negative assets (other than accumulated depreciation and contra accounts), negative liabilities, negative equity components that don't have a story.
- Motion check. Run the report by month for the trailing year. Any line that never moves despite real-world activity — a truck that never depreciates, a loan that never shrinks — is frozen, meaning entries are missing.
- Anchor check. For each material line, name the external document it should equal and compare. Cash to reconciled statements, loans to lender schedules, payroll liabilities to Form 941 filings, AR and AP to their agings, which must themselves contain believable items.
Anything that fails a pass goes on the list. Then use the table.
The symptom table
Twelve patterns, their usual cause, and the first test to run.
| # | Symptom | Likely cause | First test |
|---|---|---|---|
| 1 | Negative cash | Duplicated expenses or missed deposits | Reconcile; see /bookkeeping/cleanups-fixes/negative-cash-balance-fix |
| 2 | Large Undeposited Funds balance | Payments received but never grouped into deposits | Age the account; match against bank deposits |
| 3 | Negative accounts receivable | Unapplied customer payments or double-invoicing | Open-item AR report filtered to credits |
| 4 | Negative accounts payable | Payments recorded without bills, or double payments | Vendor balance detail for negative vendors |
| 5 | Fixed assets never move | No depreciation being posted | Compare to the tax return's depreciation schedule |
| 6 | Loan balance ≠ lender statement | Payments not split between principal and interest | Amortization schedule vs. book register |
| 7 | Negative payroll liability | Remittances posted without accruing the liability | Tie to filed 941s, quarter by quarter |
| 8 | Sales tax liability drifts from filings | Rate changes, refunds, manual adjustments | Filed returns vs. account activity by period |
| 9 | Opening Balance Equity has a balance | Setup shortcuts and feed-created balances | Trace each posting to what it should have been |
| 10 | Retained earnings changed | Closed-period transactions added, edited, or deleted | Closing-date exception report / audit log |
| 11 | Inventory negative or implausible | Timing of sales vs. receipts, assembly builds | Quantity-on-hand report for negative items |
| 12 | Suspense / "Ask my accountant" balance | Deferred categorization decisions | Age and batch the contents |
Rows 2, 3, 4, 9, and 11 each have a dedicated brief in this desk — /bookkeeping/cleanups-fixes/undeposited-funds-pileup, /bookkeeping/cleanups-fixes/negative-accounts-receivable, /bookkeeping/cleanups-fixes/negative-accounts-payable, and /bookkeeping/cleanups-fixes/opening-balance-equity-cleanup among them. Below, the three patterns that show up most often get the full treatment.
Illustrative frequencies from typical cleanup work; most files exhibit several patterns at once.
Worked diagnostic 1: the loan that doesn't match the lender
Symptom. The books show a vehicle loan at 31,400; the lender's statement shows principal of 28,750.
Diagnosis. Pull the amortization schedule and the account register side by side. The classic finding: every monthly payment of 620 was posted entirely against the loan in some months and entirely to "auto expense" in others, depending on who categorized the feed that week. The book balance is a random walk around the truth.
The fix. Compute the correct split for the year to date from the schedule — say 5,580 of principal and 1,860 of interest across nine payments — compare to what was actually posted, and true up with one entry:
| Account | Debit | Credit |
|---|---|---|
| Interest expense | 1,860 | |
| Note payable — vehicle | 790 | |
| Auto expense (misposted payments) | 2,650 |
Amounts reclassify nine misposted payments so the note balance equals the lender's 28,750. Derive figures from the amortization schedule, never by plugging.
Going forward, memorize the split as a recurring transaction and re-tie to the lender statement quarterly. If the loan funded during the year, also confirm the original deposit was booked to the liability and not to income — the far more dangerous cousin of this error, covered in /bookkeeping/cleanups-fixes/loan-misposted-to-income.
Worked diagnostic 2: the fixed asset that never moves
Symptom. "Machinery & equipment 84,000" has read exactly 84,000 for twenty-six months, with no accumulated depreciation account in sight.
Diagnosis. Nothing has been posted since purchase: no depreciation, and possibly no additions or disposals either. Get the fixed asset schedule from the last tax return — the preparer has been depreciating these assets on Form 4562 whether or not the books noticed. The books-to-return gap is your missing entry, and the return is authoritative.
The fix. For open years, post the catch-up:
| Account | Debit | Credit |
|---|---|---|
| Depreciation expense | 12,000 | |
| Accumulated depreciation — machinery | 12,000 |
Amount comes from the tax return's depreciation schedule. Prior filed years are usually trued up through an equity-dated entry the preparer approves, not by reopening those years.
Going forward, post depreciation at least annually from the preparer's schedule, and record disposals when they happen. How the schedules themselves work — lives, conventions, bonus depreciation — is the tax desk's territory: see /fundamentals/depreciation-basics and IRS Publication 946.
Worked diagnostic 3: equity that jumped
Symptom. The prior-year column of this year's balance sheet shows retained earnings 9,300 higher than the balance sheet the preparer used for the filed return.
Diagnosis. Someone posted, edited, or deleted transactions dated in the closed year. Run the software's closing-date exception report or audit log filtered to the closed period; the culprits are usually a deleted duplicate (legitimate but mis-dated), a late-arriving bill someone backdated, or a bank feed re-sync that re-imported old transactions.
The fix and the protection habit — including the entry that moves a genuinely late expense into the current year and the closing-date discipline that prevents recurrence — are worked in full in /bookkeeping/cleanups-fixes/retained-earnings-changed. The short version: identify every closed-period change, reverse or re-date each into the open year, reconcile the equity rollforward back to the return, and set a closing-date password.
When the balance sheet is fine and the problem is elsewhere
Two limits on this method. A balance sheet can pass every anchor test and the profit and loss can still be misclassified — expenses in the wrong categories, revenue in the wrong period on an accrual ledger. Anchor testing finds errors that misstate totals, not errors that mislabel them; those need a category-by-category P&L review. And on a pure cash-basis ledger with no AR, AP, loans, or fixed assets tracked, the balance sheet is nearly empty and offers little diagnostic surface — reconciliation of the cash accounts is the whole test.
Turning diagnosis into a work plan
Once the list is built, sequence it: cash and clearing accounts first, then liabilities that tie to government filings (penalty risk), then loans and fixed assets, then equity, then cosmetics. That ordering — and the rebuild-versus-repair decision when the list is long — is the subject of the pillar guide, /bookkeeping/cleanups-fixes/books-cleanup-playbook. A balance sheet where every line has a named anchor and a recent tie-out is the definition of clean books; the monthly habit of re-running the three passes is what keeps them that way.
Frequently asked questions
- What does a negative liability on a balance sheet mean?
- A negative liability usually means payments exceeded the recorded obligation: payroll taxes remitted without recording the liability, a loan paid down faster than the books accrued it, or a credit card that carries a refund. It is almost never a real asset — it is a sign one side of the entry was posted and the other was missed.
- Why does an account on my balance sheet never change?
- A frozen balance — identical for many months — means nothing is posting to the account. Common cases: a fixed asset with no depreciation being recorded, an old loan nobody is booking payments against, or a clearing account holding a stranded amount. Compare the account's register to the real-world activity you know exists; the gap is the diagnosis.
- How do I check whether the loan balance in my books is right?
- Pull the lender's most recent statement or amortization schedule and compare its principal balance to the book balance on the same date. If the book balance is higher, payments were likely posted entirely to the liability with no interest expense split — or expensed entirely, if lower. The amortization schedule is the source of truth.
- Why did retained earnings change from what last year's balance sheet showed?
- Retained earnings changes when someone posts, edits, or deletes a transaction dated in a closed year. Run a comparison of the current prior-year balance sheet against the one issued at filing time, then use the audit log or a closing-date exception report to find the transactions dated in the closed period. Reverse them into the current year unless the preparer directs otherwise.
- Which balance sheet accounts should I check first during a cleanup?
- Cash first — it must tie to reconciled bank statements. Then the accounts most likely to accumulate silent errors: Undeposited Funds, Opening Balance Equity, payroll and sales tax liabilities, and loans. These five categories account for most balance sheet wrongness in small-business ledgers and each has a fast external test.