Blog · Territory, capacity and quota planning · Software
A SaaS financial model workbook connects subscribers, subscription revenue, delivery costs, spending and cash. Use this layout and worked formulas to build checks and compare supplied model outputs with actual results.
A SaaS financial model XLS workbook connects subscribers to revenue, costs and cash through explicit formulas and reconciliations. Keep the original plan separate from actual results, then compare the two using the same monthly calendar and account definitions.
The layout below is a worked spreadsheet specification you can enter in your own workbook. It covers the links between schedules; detailed choices about growth, retention and pricing belong in SaaS financial projections.
Use a workbook structure that lets another finance team member trace a result back to its source. Start with the exports you already have, including the closed ledger, customer movements, recognized revenue, expense detail and bank-reconciled cash.
| Tab | Columns or contents | Purpose and check |
|---|---|---|
| Sources | Source name, export date, period, account or customer, amount | Preserve imported records and control totals |
| Assumptions | Driver, unit, month, value, owner | Keep inputs separate from formulas |
| Subscribers | Opening, added, lost, closing, average active | Tie each month's opening to the prior closing |
| Revenue | Month, product, active subscribers, price, recognized revenue | Reconcile actual revenue to the ledger |
| Expenses | Month, account, department, delivery cost, operating expense | Check classification and source totals |
| Cash | Opening cash, receipts, payments, investing, financing, closing cash | Tie actual closing cash to the reconciliation |
| Comparison | Month, measure, original plan, actual, variance | Use one variance convention |
| Checks | Check name, calculated difference, explanation | Resolve unexplained nonzero differences |
For raw exports, Excel tables can make references easier to follow. Microsoft's structured-reference guide explains how table and column names adjust when rows are added or removed. Give each input table a meaningful name, preserve its headers and exclude subtotal rows that would duplicate detail.
Covirage is not affiliated with Microsoft.
Keep actual periods closed. A forecast assumption should never overwrite a historical revenue number. Stamp the plan with its approval date and retain that version when updating the outlook.
Consider an illustrative US software company with one monthly subscription product. Put January 2026 in column B, February in C and March in D. Column A contains the labels shown below; the row numbers make the formulas reproducible.
For this simplified business, additions and losses occur evenly through each month, the average active count estimates service delivered, and every active subscription has the same monthly price. There are no discounts, usage charges or separate implementation services.
| Row | Schedule line | January | February | March | Formula in B, or input |
|---|---|---|---|---|---|
| 3 | Opening subscribers | 1,000 | 1,040 | 1,080 | Input; C3 equals B6 |
| 4 | Added subscribers | 60 | 65 | 70 | Input |
| 5 | Lost subscribers | 20 | 25 | 30 | Input as a positive count |
| 6 | Closing subscribers | 1,040 | 1,080 | 1,120 | =B3+B4-B5 |
| 7 | Average active subscribers | 1,020 | 1,060 | 1,100 | =(B3+B6)/2 |
| 8 | Monthly subscription price (USD) | 200 | 200 | 200 | Input |
| 9 | Subscription revenue (USD) | 204,000 | 212,000 | 220,000 | =B7*B8 |
| 10 | Delivery cost per active subscriber (USD) | 50 | 50 | 50 | Input |
| 11 | Delivery costs (USD) | 51,000 | 53,000 | 55,000 | =B7*B10 |
| 12 | Operating expenses (USD) | 130,000 | 130,000 | 130,000 | Input from expense schedule |
| 13 | Operating profit (USD) | 23,000 | 29,000 | 35,000 | =B9-B11-B12 |
Copy the calculation formulas across. Set C3 to =B6 and D3 to =C6, so customer continuity is a formula rather than a repeated assumption.
Average subscribers multiplied by price is a planning shortcut under the stated assumptions. Actual recognition follows the contract's service obligations: FASB's Topic 606 update describes recognizing revenue when or as those obligations are satisfied. Use an approved recognition schedule when actual contract terms require it.
In this example all customer revenue is collected in the same month, all expenses are paid in the same month, and expenses contain no noncash charges. There are no taxes, interest, financing movements or other working-capital changes. These assumptions make operating cash equal operating profit; a business with annual prepayments needs additional schedules.
Continue on the same worksheet:
| Row | Cash line | January (USD) | February (USD) | March (USD) | Formula in B, or input |
|---|---|---|---|---|---|
| 14 | Operating cash | 23,000 | 29,000 | 35,000 | =B13 under these assumptions |
| 15 | Equipment purchases | 10,000 | 10,000 | 10,000 | Input as positive spending |
| 16 | Opening cash | 500,000 | 513,000 | 532,000 | Input; C16 equals B17 |
| 17 | Closing cash | 513,000 | 532,000 | 557,000 | =B16+B14-B15 |
Across the quarter, revenue is $636,000, delivery costs $159,000 and operating expenses $390,000. Profit is therefore $87,000. Subtract equipment purchases of $30,000 to obtain the $57,000 cash increase, which agrees with $557,000 closing cash less $500,000 opening cash. All amounts are exact; no rounding is needed.
Suppose January actually adds 50 subscribers and loses 30. Price and unit delivery cost remain unchanged, but operating expenses are $132,000. Keep the same collection and payment assumptions for this comparison.
| January output | Original plan | Actual | Actual minus plan |
|---|---|---|---|
| Closing subscribers | 1,040 | 1,020 | -20 |
| Average active subscribers | 1,020 | 1,010 | -10 |
| Revenue (USD) | 204,000 | 202,000 | -2,000 |
| Delivery costs (USD) | 51,000 | 50,500 | -500 |
| Operating expenses (USD) | 130,000 | 132,000 | 2,000 |
| Operating profit (USD) | 23,000 | 19,500 | -3,500 |
| Closing cash (USD) | 513,000 | 509,500 | -3,500 |
Actual revenue is 1,010 times $200; delivery costs are 1,010 times $50. The profit variance reconciles as -2,000 - (-500) - 2,000 = -3,500. Because equipment purchases and opening cash matched plan, closing cash has the same variance.
Use the comparison in SaaS financial management to assign actions. For a business earning transaction fees rather than subscriptions, the marketplace financial workbook needs different revenue drivers.
Upload the prepared workbook outputs and actual finance exports to Covirage; it maps the columns, and its tools compute and check the comparisons. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for FP&A reporting for the supporting use case.
Use separate tabs for source exports, assumptions, subscriber movements, revenue, expenses, cash and actual-versus-plan comparisons. A checks tab collects reconciliation differences. Keep one consistent monthly calendar across the workbook so the same column always represents the same reporting period.
It can estimate revenue for a simple monthly subscription business, but it is not a universal accounting rule. Midmonth starts, usage charges, discounts, service obligations and contract changes can require more detail. Tie actual recognized revenue to the controller's approved revenue schedule.
Annual subscriptions need separate billing, receipt and revenue schedules. A payment can arrive before the related revenue is earned. Include accounts receivable and deferred revenue movements so a strong collection month does not incorrectly increase the income statement.
This layout is a method for preparing your own workbook. Bring its prepared outputs and actual exports to Covirage for comparison. Covirage maps columns, its tools compute and check figures, and the external AI model explains results with figures traced to their rows.