Subscription Management, Revenue Recognition, and Reporting
Subscription management is where time enters the data model. A subscription binds a customer to a product for a term at a quantity and price, and it drives renewal, amendment, cancellation, and recognition. Reporting then has to reconcile three numbers that rarely agree: booked (contract value signed), billed (invoiced), and recognized (earned).
What to understand
Subscription terms and quantities; the difference between a subscription and the asset representing delivery; the renewal, amendment, and cancellation lifecycles; and co-termination of mixed-term deals. On recognition, apply the five-step model: identify the contract, identify distinct performance obligations, determine the transaction price, allocate it to the obligations, and recognize revenue as each obligation is satisfied, over time for subscriptions and services and at a point in time for delivered goods. Recognition schedules hold deferred amounts and release them by straight-line, percent complete, or usage. Reports should be filterable by period, product family, and account.
Traps
- Billed is not recognized is not booked. A question asking how much revenue was earned this quarter wants recognized, not invoiced.
- Renewal versus amendment versus cancellation. Renewal extends the term with unchanged scope; amendment changes scope; cancellation ends early, possibly with a credit.
- Straight-line is not universal. Usage-based or milestone obligations need another method. Look for "evenly" in the stem before assuming.
- Date and currency basis. Fiscal periods and conversion can change the answer without changing the underlying data.
Rule of thumb
Before computing anything, label which number is being requested (booked, billed, or recognized), then label the date basis. Most wrong answers are correct arithmetic on the wrong measure.
Worked example
A $24,000 two-year subscription billed annually. Booked at signature is $24,000; billed on each anniversary is $12,000; recognized monthly is $1,000. At month 15 the three figures are $24,000, $12,000, and $15,000 respectively.