Three Statement Model: How the P&L, Balance Sheet and Cash Flow Link

A three statement model is a linked forecast of the income statement, balance sheet and cash flow statement. Net income flows into retained earnings and starts the cash flow statement, every balance sheet change appears as a cash flow, and ending cash becomes balance sheet cash. When every link is right, the balance sheet balances in every period.

Most pages that rank for this term are course pitches, a forum thread or a LinkedIn essay. They name the links and stop there: no numbers, no file, and nothing about subscription businesses. A SaaS company is the case where the three statements disagree the most. A growing company that invoices annual contracts up front collects cash before it earns revenue, capitalizes the commissions it pays, and can report a loss while cash holds steady. This guide shows every link, the SaaS lines that generic models leave out, one month worked through all three statements, and a free template that balances every month.

What is a three statement model?

It is one model in which three financial statements share the same assumptions and update together. Change a renewal rate or a hiring plan, and revenue, profit, every balance and the cash position move with it. Each statement answers a different question. A three statement model is the base for most other finance models. A discounted cash flow valuation takes its free cash flow. A debt model adds a revolver and covenant tests to it. A budget is a three statement model with a board's approval on the inputs. In FP&A, it is where the revenue forecast, the hiring plan and the cash plan meet.

How do the three statements link?

Three links do most of the work: net income goes to retained earnings, net income starts the cash flow statement, and ending cash on the cash flow statement becomes cash on the balance sheet. The other links follow one rule: every balance sheet line except cash rolls forward with its own schedule, and its change appears once on the cash flow statement.

The balance check

Total assets minus total liabilities and equity must equal zero in every period. Because cash is the only balance sheet line that comes from the cash flow statement, the check tests whether every other movement was captured on the cash flow statement exactly once, with the right sign. A model that balances in the opening month and drifts later has a broken link, and the month where the gap first appears tells you which one. The template's Checks tab runs this test every month, then rebuilds cash a second way, line by line from collections and payments, and compares the two.

Which SaaS lines do most three statement models leave out?

Deferred revenue, capitalized commissions, and the path from billings to cash. Generic models built for manufacturers drive working capital from inventory and days sales outstanding. A subscription company has little inventory, and its largest working capital items come from how it invoices contracts and pays the people who sell them.

Deferred revenue, and why billings are not revenue

When a customer signs a $120,000 annual contract and is invoiced up front, the company records a $120,000 billing and a $120,000 deferred revenue liability. Each month it recognizes $10,000 of revenue and lowers deferred revenue by the same amount. The P&L sees $10,000 a month. The cash flow statement sees $120,000 in the month the customer pays. Deferred revenue is the bridge, and billings vs revenue covers the difference in detail.

In the model, two identities hold every month:

• Revenue = billings minus the increase in deferred revenue.
• Cash collected = billings minus the increase in accounts receivable.

Put together, revenue equals cash collected plus the increase in receivables minus the increase in deferred revenue. The same identity lets you rebuild revenue from cash and the balance sheet. The template checks it every month.

A real example of the size of this effect: Salesforce says "We generally invoice our customers in advance, in annual installments," and that unearned revenue "primarily consists of billings to customers for our subscription service." In fiscal 2026 it reported net income of $7.5 billion and operating cash flow of $15.0 billion. Unearned revenue added $2.9 billion to operating cash flow, while higher receivables used $2.2 billion and costs capitalized to obtain revenue contracts used $2.8 billion (Salesforce FY2026 Form 10-K).

Capitalized commissions: ASC 340-40

US GAAP treats sales commissions that are incremental to winning a contract as an asset, recorded as deferred commissions and amortized over the period the related service is delivered. The expense on the P&L is the amortization, not the payment.

That creates three moving pieces in the model:

• Accrued commissions (liability): commissions earned and not yet paid. In the template they are paid the month after the deal closes.
• Deferred commissions (asset): goes up by what is capitalized, down by amortization.
• Commission expense (P&L): amortization of the asset plus any commissions expensed immediately.

Illustrative example from the template: in January the company books $150,000 of new ARR at a 10% commission rate. It owes $15,000, pays it in February, and capitalizes it. Amortized over 48 months, that deal adds $312.50 a month to sales and marketing expense. The cash leaves in February; the expense is spread over four years. The amortization period is a policy choice your auditors review, and it is not accounting advice.

Billings to cash: receivables and the collection curve

An invoice is not cash. The template moves billings into accounts receivable and collects them on a curve you set: in the example, 40% in the month billed, 50% the month after and 10% the month after that. The opening receivables balance is collected in the first two months. This is where a growing company's cash gets lumpy. A December full of annual renewals produces a large billing month, much of which is collected in January and February.

Renewal timing deserves its own row. Renewal amounts and dates are known in advance, which makes them the most predictable cash a SaaS company has. In ORM's data, a renewal usually closes within 30 days either side of its renewal date. So the template asks for the ARR coming up for renewal each month from your contract list, and applies a renewal rate, instead of spreading renewals evenly.

How do you build a three statement model, step by step?

Start from the last closed balance sheet, build the schedules, then the three statements in a fixed order, and finish with the check. The order matters because each step uses the one before it.

1. Enter the opening balance sheet. Use your last closed month. It has to balance before anything else; the template shows a check next to it.
2. Set the drivers. ARR by billing term, renewal rate, monthly churn, the share of new ARR billed annually, collection curve, gross margins, commission rate and amortization period, useful life of equipment, interest rates.
3. Enter the monthly plans. Renewals due from your contract list, new ARR from your bookings plan, services revenue, operating expenses by department, stock-based compensation, capex, debt repayments and any equity raised.
4. Build the revenue and billings schedule. ARR roll-forward by billing term, revenue recognized, billings, deferred revenue and receivables.
5. Build the cost schedules. Commissions under ASC 340-40, cost of revenue, payables, equipment and depreciation, debt and interest.
6. Assemble the income statement. Every line is a reference to a schedule; no typed numbers.
7. Build the balance sheet without cash. Each line is the ending balance of its schedule. Retained earnings is last month's balance plus net income.
8. Build the cash flow statement. Net income, non-cash items, the change in each balance sheet line, then investing and financing. Its ending cash goes into the balance sheet.
9. Check. Assets minus liabilities and equity equals zero every month, and cash built line by line matches the cash flow statement.

One design rule saves hours: calculate interest on the opening balance of each month. Interest on the average balance makes interest depend on cash, which depends on interest, and creates a circular reference. On a monthly model the difference is small, and the model stays stable in both Excel and Google Sheets.

Worked example: one month through all three statements

Illustrative example, from the template's sample data: a SaaS company starts January 2027 with $8 million of ARR, $6 million on annual contracts billed up front and $2 million billed monthly, plus $9 million of cash. These are invented numbers to show the mechanics, not a benchmark. January loses money and still adds cash, because it collects $980,000 of the receivables it started the year with. Over the full year the same pattern holds at a smaller scale. The bridge from a $1.56 million loss to positive operating cash flow: Read the bridge before you read the P&L. Two of its lines will not repeat on their own: receivables fell because the opening balance was high, and deferred commissions fell because older commissions were still amortizing faster than new ones were capitalized. Deferred revenue rose $667,583 because ARR grew and December renewals were invoiced up front. If growth slows, that source of cash shrinks with it, while the loss does not. That is the reason a SaaS company needs all three statements and not only a P&L.

What is in the free template?

Nine tabs: two to read, one to fill in, six that calculate. Yellow cells are inputs; every other number is a formula. The example and the blank use the same formulas. The blank keeps example rates and periods as defaults to replace. We tested the formulas against an independent Python version of the same model: 622 checks passed, including three runs with random inputs, a 21% tax rate and partial capitalization, where the balance sheet still balanced every month. The workbook uses only functions that Excel and Google Sheets share.

Why doesn't a three statement model balance?

Almost always because a balance sheet movement is missing from the cash flow statement, or is there with the wrong sign. Find the first month where the check is not zero, then compare the size of the gap with the movements in that month.

How is it different from the other models finance teams use?

The three statement model covers everything at a monthly or annual grain. The others go deeper on one question. If you already run the financial forecast template, the three statement model is the next step when an investor, lender or auditor asks for a balance sheet and cash flow statement that tie to the plan.

Where the model is only as good as its revenue line

The statements are arithmetic. Once the links are right, the model will balance whatever you type into it. The judgment sits in the inputs, and in a SaaS company the input that moves everything else is new ARR and renewals.

Three habits make a model a board trusts. First, consistency: the number on one slide shows up on the next, or there is a clear reason it changed. Second, traceability: you can drill from total revenue to the ARR roll-forward to the deals and renewals behind it. The roll-forward should reconcile month by month, with beginning ARR equal to last month's ending ARR, as in the ARR waterfall that reconciles. Third, a range: a low case, an on-target case and an upper bound, instead of one number that pretends to be certain.

Seasonality belongs in the inputs too. Across ORM's customers, Q4 is usually the largest quarter, followed by Q2, Q3 and Q1, and the third month of a quarter is the largest. A model that spreads new ARR evenly across twelve months will show a cash shortfall in the wrong month. The example's renewal schedule is weighted to December for that reason.

ORM builds the revenue side of this model: a forecast of new business, expansion and renewals by week, with a range, that targets 95% accuracy. The template above is the place to put that number to work across the P&L, the balance sheet and cash.