Balance Sheet Not Balancing? The Four-Step Fix That Works Every Time
7 min read
- A balance sheet goes out of balance when a cash flow statement item is missing, double-counted, or has the wrong sign on the balance sheet
- Check the year-by-year pattern of the discrepancy first. A constant error means one missing link. A changing error means a formula problem.
- There are only three root causes: forgotten links, double-counted items, or inverted signs
- If the error is elusive after 15 minutes, simplify. Consolidate line items until the model balances, then add complexity back.
Why the Balance Sheet Breaks
Total Assets must equal Total Liabilities plus Total Equity. When they do not, the error is always in the linkage between the cash flow statement and the balance sheet. The income statement rarely causes the problem directly because net income flows to both retained earnings (BS) and the top of the CFS. If net income is wrong, the balance sheet still balances; the numbers are just wrong.
The three root causes, in order of frequency:
| Root Cause | What Happened | How to Spot It |
|---|---|---|
| Forgotten link | A cash flow item changes a balance sheet line item, but the BS line is not linked to the CFS | The discrepancy is constant across all forecast years (same amount every year) |
| Double-counting | One CFS line item feeds into two BS line items, or the same economic event is captured twice | The discrepancy is exactly double a known line item |
| Wrong sign | A CFS item is added to an asset when it should be subtracted, or vice versa for liabilities | The discrepancy equals exactly twice the value of a specific line item |
Step 1: Analyse the Pattern of the Discrepancy
Add a check row at the bottom of the balance sheet: Total Assets - Total Liabilities - Total Equity. Look at the value in each forecast year.
Discrepancy changes every year (e.g. £8M, £12M, £17M): a formula error in a recurring calculation. Working capital, capex, or D&A linkage is broken. The formula is being applied in each year but with the wrong logic.
Discrepancy in only one year: a one-off data entry error or a hardcoded value that should be a formula.
Step 2: Line-by-Line Balance Sheet Audit
Go through every balance sheet line item that changes between years. For each one, verify two things:
- The item appears on the cash flow statement exactly once
- The sign convention is correct: CFS outflows reduce assets or increase liabilities; CFS inflows increase assets or reduce liabilities
The sign convention is where most errors hide. The rule:
| CFS Item | Effect on BS | Formula Direction |
|---|---|---|
| Capex (investing outflow) | Increases PP&E (asset) | BS PP&E = Prior PP&E + Capex - D&A |
| Debt issuance (financing inflow) | Increases debt (liability) | BS Debt = Prior Debt + Issuance - Repayment |
| Increase in AR (operating outflow) | AR is higher on BS | AR calculated from DSO; change in AR flows to CFS as negative |
| Increase in AP (operating inflow) | AP is higher on BS | AP calculated from DPO; change in AP flows to CFS as positive |
Step 3: Check for Unlinked Cash Flow Items
Switch to the cash flow statement. Look for any non-zero line item that does not feed into a balance sheet change. In Excel, select the cell and press Ctrl+] (trace dependents) to see where it links.
Common culprits:
- Other long-term assets/liabilities: often modelled on the CFS but not linked back to the BS because the analyst forgot or treated them as immaterial
- Cash itself: ending cash on the CFS must equal the cash line on the BS. If historical cash was hardcoded on the BS but the forecast uses a different formula, the two diverge
- Deferred taxes: if the CFS includes a deferred tax adjustment but the BS does not have a deferred tax asset/liability line that changes, the model will break
- Stock-based compensation: added back on the CFS (non-cash) but sometimes missing from the equity section of the BS
Step 4: Simplify Until It Balances
If Steps 1-3 do not resolve the error within 15 minutes, the model is too complex for the time available. The fix is counterintuitive: reduce complexity.
Consolidate the balance sheet to 5-6 items per side:
| Assets | Liabilities + Equity |
|---|---|
| Cash | Accounts Payable |
| Accounts Receivable | Short-Term Debt |
| Inventory | Long-Term Debt |
| PP&E (net) | Other Liabilities |
| Other Assets | Shareholders' Equity |
Combine everything else into "Other Assets" or "Other Liabilities" and grow them at a flat percentage or keep them constant. This eliminates the line items that are most likely to contain the error (small, immaterial items with inconsistent historical patterns) and makes the remaining linkages easy to verify.
The Five-Minute Pre-Flight Check
Before submitting any model, run this checklist:
- Balance check row = 0 in every forecast year (conditional format to red if non-zero)
- Ending cash on CFS = cash on BS in every year
- Retained earnings = prior RE + net income - dividends in every year
- PP&E = prior PP&E + capex - D&A in every year
- No circular references (check Excel status bar; use beginning debt balances for interest to avoid)
If all five pass, the model is structurally sound. The assumptions might be debatable, but the mechanics are correct.
Take Your Preparation Further
Download our free Accounting Cheat Sheet for the complete three-statement linkage reference. For a hands-on model with all linkages built, see the 3-Statement Financial Model.
Ready for personalised feedback? Book a 1-on-1 mentoring session with an experienced IB/PE professional.