How to build a 3-statement financial model
The income statement, balance sheet, and cash flow statement are one connected system. Here is how to link them so the model always balances.
Why all three statements must link
A three-statement model is the foundation of financial modeling because the three statements are not independent - net income flows to retained earnings and to the cash flow statement, working-capital changes move cash, and the ending cash balance ties the whole thing together. Build them as one linked system and the balance sheet balances by construction.
The links that connect the statements
| From | To | Link |
|---|---|---|
| Income statement | Balance sheet | Net income flows into retained earnings |
| Income statement | Cash flow | Net income is the top line of operating cash flow |
| Balance sheet | Cash flow | Changes in working capital adjust operating cash |
| Cash flow | Balance sheet | Ending cash becomes the cash line on the balance sheet |
The order to build it in
- 1Build the income statement from revenue and expense assumptions down to net income.
- 2Project the balance sheet - working capital, fixed assets, debt, and equity.
- 3Build the cash flow statement, starting from net income and adjusting for non-cash items and working-capital changes.
- 4Link ending cash from the cash flow statement back to the balance sheet cash line.
- 5Add a balance check - total assets minus liabilities and equity - that must read zero.
How Fintra keeps the model grounded
- Actuals flow from the general ledger, so the model builds on real numbers instead of a hand-keyed base.
- Driver-based budgeting lets you set assumptions once and flow them through all three statements.
- Scenario planning branches the model into upside and downside cases without breaking the links.
- Because planning sits on the live ledger, the model refreshes as new actuals close rather than going stale.
Frequently asked questions
What is a 3-statement model?
It is a financial model that links the income statement, balance sheet, and cash flow statement into one connected system. Net income flows to equity and cash flow, working-capital changes move cash, and ending cash ties back to the balance sheet, so the model stays internally consistent.
In what order should I build the three statements?
Build the income statement first, then the balance sheet, then the cash flow statement, and finally link ending cash back to the balance sheet. Add a balance check that must equal zero. Building in that order means each statement has the inputs it needs from the ones before it.
Why is my 3-statement model not balancing?
A change hit one statement but not its linked counterpart. Common culprits are depreciation, financing draws, or working-capital movements recorded on one statement only. Work backward from the balance-check line and find the item that moved on the P&L or cash flow but not the balance sheet.
Do I need Excel to build a 3-statement model?
Not necessarily. Spreadsheets are the classic tool, but planning software that sits on your ledger can drive all three statements from shared assumptions and refresh them as actuals close. That removes the manual export-and-reconcile cycle a standalone spreadsheet model requires each month.
Stay in the loop
One practical finance briefing a week - new guides, checklists, and benchmarks.
Model on live actuals, not a stale export
Fintra drives forecasts from your ledger so the model stays current. Free to start, no card required.
Talk to us