Name cross‑sheet linking patterns, explain parts, teach common failure modes
How Cross-Sheet Links Work
Cross-sheet references are the glue that holds a three-statement model together. Learn the syntax, the three critical links, and the traps that break models.
Link 1: Net Income → Retained Earnings
='Income Statement'!B12
Net Income from the Income Statement becomes the “Net Income added” line in Retained Earnings on the Balance Sheet. This is how profit grows equity.
Link 2: Ending Cash ↔ Cash Flow Statement
='Cash Flow'!B20
The ending cash on the Balance Sheet must equal the ending cash on the Cash Flow Statement. If these don't match, something is wrong.
Link 3: Integrity Checks
=IF(ABS(TotalAssets - (TotalLiab + TotalEquity)) < 0.01, "OK", "CHECK")
A formula that verifies the balance sheet equation still holds. Place this check where anyone reviewing the model can see it.
- Bare cell references: =Sheet1!B12 breaks silently when someone inserts a row above row 12. Always use named ranges or labeled cells.
- Wrong sheet name: ='Income Stmnt'!B12 returns a #REF! error if the tab is actually named “Income Statement.” Double-check tab names.
- Hard-coded values instead of links: Typing “10,800” instead of linking to Net Income means the Balance Sheet never updates when revenue changes.
- Circular references: If Sheet A references Sheet B and Sheet B references Sheet A, Excel shows a circular reference warning. Plan your link direction: Income Statement → Balance Sheet → Cash Flow.