Deferred Revenue Roll-Forward
Opening balance, billings, recognition, closing balance — twelve months of it.
Replaces: Enterprise rev-rec platforms and month-end controller spreadsheets
How to use it
Enter your opening deferred balance and how quickly it unwinds, then your bookings, growth, contract length and billing terms. The roll-forward walks twelve months: opening plus billings minus revenue recognised equals closing, every month.
Where the number comes from
- Each month of bookings is treated as a cohort, recognised evenly across the contract term.
- Revenue in any month is the sum of every cohort still inside its term, plus the slice of the opening balance unwinding that month.
- Billings are the up-front percentage taken at signing, plus the spread portion of every cohort still being invoiced.
- The opening balance releases evenly across the months of service still owed on it.
- Closing equals opening plus billings minus recognised — the identity every roll-forward has to satisfy, and the one an auditor will check first.
What goes wrong
The part most calculators leave out.
- Bookings growing at a steady monthly rate for a full year is a modelling convenience, not a forecast. Enterprise sales are lumpy, and one large deal slipping a quarter reshapes the whole schedule.
- A single average contract length hides the mix. Twelve-month and thirty-six-month deals unwinding together behave nothing like the blended average of the two.
- Churn and mid-term cancellations are not modelled. Real cohorts shrink, so recognition in later months is lower than shown.
- Contract modifications — upgrades, downgrades, early renewals — can require the remaining balance to be re-spread. None of that appears here.
- The opening balance is assumed to unwind evenly. If it is concentrated in contracts all renewing in one month, the early months of this schedule will be wrong.
Why growing companies look less profitable than they are
A company signs 400,000 of annual contracts a month, growing 4% monthly, and invoices everything up front. Cash arrives immediately; revenue arrives one twelfth at a time. In month one it collects 400,000 and recognises 33,000 from that cohort. Because bookings keep growing, the deferred balance keeps building - the faster it grows, the wider the gap. An acquirer looking only at recognised revenue sees a smaller company than the one whose contracts are already signed and paid for. That gap is precisely what the roll-forward makes visible.
Questions
- What is a deferred revenue roll-forward?
- A month-by-month statement proving the movement in the deferred revenue balance: opening plus new billings minus revenue recognised equals closing. Auditors ask for it because it ties the balance sheet to the income statement.
- Is a rising deferred revenue balance good or bad?
- Generally good - it means contracted, invoiced business you have not yet delivered, which is cash in hand and revenue still to come. It becomes a problem only if you cannot deliver the service you have already been paid for.
- How is this different from the ASC 606 schedule?
- That one takes a single contract and shows its recognition. This takes the whole book - an opening balance plus a stream of new bookings - and shows the balance moving in aggregate. Use that one to price a deal, this one to close a month.
- Does anything I type get sent anywhere?
- No. The whole calculation runs in your browser. Nothing is transmitted, stored, or logged, and there is no account to create.
Last updated .
Put this calculator on your site
Free to embed, on any site, commercial or not. No sign-up and no tracking script — the calculator runs in your reader’s browser exactly as it does here. All we ask is that you keep the credit line.
The small script resizes the frame as the reader changes inputs. Drop it if your CMS strips scripts — the calculator still works, it will just stay at a fixed height.