Financial model review

Balance sheet checks for financial models

Check whether a financial model's balance sheet balances. Follow a worked Excel example through cash, debt, fixed assets and retained earnings.

One asset block balances two funding blocks on an emerald beam above a worksheet

To check a forecast balance sheet, calculate the difference between assets and liabilities plus equity in every period, then trace the first unexplained difference to the supporting schedules. Verify the opening balances and movement formulas as well as the final totals. A balance sheet that balances can still contain wrong assumptions or offsetting errors.

Work on a separate review copy. The following invented example uses positive displayed asset, liability and equity balances in EUR thousands. It excludes taxes, foreign exchange, acquisitions, other comprehensive income and other movements. Real models need bridges that cover their actual scope.

Define a signed balance check

The SEC's guide to financial statements explains the relationship between assets, liabilities and shareholders' equity. For a model displaying those categories as positive balances, write:

Residual = Total assets - Total liabilities - Total equity
Expected residual = 0

Keep the sign visible during investigation. A residual of positive 8 means assets exceed liabilities plus equity by 8 under this convention. An absolute-value check can flag a difference but conceals its direction.

A signed trial balance may instead store credits as negative values. Do not subtract those negative credits again without first mapping the signs. Check whether figures are in currency units, thousands or millions, and confirm that all balances refer to the same reporting date and entity.

Verify the opening position first

Assume these opening balances:

  • Cash 35, receivables 45, inventory 40 and net fixed assets 80: total assets 200.
  • Payables 30 and debt 70: total liabilities 100.
  • Share capital 60 and retained earnings 40: total equity 100.

The opening residual is 200 - 100 - 100 = 0. Agree those amounts to the approved prior-period records. Copying an old forecast into the opening column can create a perfectly balanced but incorrect starting position.

Look for omitted rows, hidden subtotals and inconsistent consolidation scope. A total that excludes a new account can carry forward unnoticed if a matching balance is also missing elsewhere. Reconcile individual accounts rather than accepting only the grand total.

Follow a complete period through the schedules

For the next period, assume net income is 25, depreciation is 8 and cash-paid capital expenditure is 18. Receivables rise by 5, inventory rises by 3 and payables rise by 5. The business receives new borrowing of 10, repays principal of 5 and pays dividends of 5. There are no other movements.

Check the schedules independently:

Closing receivables = 45 + 5 = 50
Closing inventory = 40 + 3 = 43
Closing payables = 30 + 5 = 35
Closing net fixed assets = 80 + 18 - 8 = 90
Closing debt = 70 + 10 - 5 = 75
Closing retained earnings = 40 + 25 - 5 = 60

Share capital remains 60. The capex and depreciation guide explains the fixed-asset bridge, while the debt-schedule review separates new borrowing, principal repayment and interest.

Retained earnings use net income, not revenue or a profit subtotal before relevant expenses. Dividends reduce retained earnings in this simplified example; a new share contribution would affect a different equity movement. Additional equity transactions require additional lines.

Reconcile cash independently

Cash should come from a cash-flow schedule that reflects the same events. Under the example's simplified indirect approach:

Operating cash flow = 25 + 8 - 5 - 3 + 5 = 30
Investing cash flow = -18
Financing cash flow = 10 - 5 - 5 = 0
Closing cash = 35 + 30 - 18 + 0 = 47

The increases in receivables and inventory use cash relative to profit here, while the payables increase preserves it. These signs depend on the definitions used; see the working-capital checks before applying a template formula.

Now calculate the closing totals:

Assets = 47 + 50 + 43 + 90 = 230
Liabilities = 35 + 75 = 110
Equity = 60 + 60 = 120
Residual = 230 - 110 - 120 = 0

Check that the next period opens with these closing amounts. The cash-flow guide provides a separate opening-to-closing cash exercise.

Investigate the first difference instead of adding a plug

Suppose depreciation is omitted from the fixed-asset bridge, while every other line remains as above. Net fixed assets become 98 instead of 90, total assets become 238 and the residual becomes positive 8. The difference matches depreciation, providing a lead to investigate rather than proof of the cause.

Trace that period's source formulas and compare them with adjacent periods. Check newly added assets, payments, debt movements, dividends and copied ranges. Fix the underlying connection and rerun every period.

Typing an unexplained minus 8 into cash would restore equality while contradicting the independently calculated cash balance. A genuine funding requirement can be modeled as borrowing or another explicit transaction, but it needs its own assumptions, limits and effects. It should not exist merely to hide a residual.

Use a documented rounding tolerance appropriate to the workbook's units and precision. Test unrounded values before accepting a small displayed difference. A tolerance should explain legitimate rounding, not conceal persistent unexplained movements.

The rounding and reconciliation guide works through a one-cent aggregation difference, a fixed-total allocation and a unit-aware tolerance. Use it to distinguish presentation precision from a missing financial movement before changing the balance check.

Remember what a zero residual cannot prove

If cash and debt are both overstated by 10, the balance check still equals zero. Incorrect profit and an equal asset overstatement can also offset. Reconcile each schedule and inspect business assumptions even when every balance indicator is green.

FinModelCheck does not automatically identify, map or reconcile financial statements, and it does not recalculate Excel. Its supported checks inspect saved-file evidence such as Excel errors, broken references and external workbook dependencies. The provisional score is not a financial-statement audit opinion.

Use the checker alongside this manual workflow and view the example report. Online results show only the score and counts by Finding type, with no cell-level Findings. The complete PDF is free without registration in the current valid owning browser session. Review the revenue forecast checks when the profit feeding equity also needs investigation.

Frequently asked questions

Why does my model balance but still show the wrong cash?

Two errors can offset, or a balancing formula can conceal the cash difference. Rebuild cash from the underlying receipts, payments and financing movements rather than using the balance sheet as its only source.

Should I put every difference into retained earnings?

No. Retained earnings need their own supported movement bridge. An unexplained adjustment hides the cause and can distort later periods.

Does a high checker score mean my balance sheet balances?

No. The current score summarizes supported saved-file checks. The balance equation, account mapping and financial links require the separate review described here.

Keep reviewing

Continue with a related guide.

Browse all guides