Deferred revenue schedule: straight-line recognition by month
Build a deferred revenue schedule that splits an upfront billing into recognized revenue and a remaining liability, with monthly formulas and a worked example.
Deferred revenue is cash billed before the service is delivered. It sits on the balance sheet as a liability and moves to the income statement as the service period passes. For a service delivered evenly, straight-line recognition is a division and a multiplication.
How do you calculate monthly recognition?
Divide the billed amount by the number of service months. A fictional $12,000 annual plan over 12 months recognizes $1,000 a month. After three elapsed months:
| Item | Formula | Result |
|---|---|---|
| Monthly rate | =IF(C11<=0,"",B11/C11) |
$1,000 |
| Recognized | =E11*MIN(C11,MAX(0,D11)) |
$3,000 |
| Deferred balance | =B11-F11 |
$9,000 |
The MIN caps recognition at the contract term, so entering 15 elapsed months on a 12-month plan still recognizes $12,000, not $15,000. MAX(0,...) stops a future start date from producing negative revenue.
What do other contracts look like?
| Contract | Billed | Months | Elapsed | Recognized | Deferred |
|---|---|---|---|---|---|
| Annual plan | $12,000 | 12 | 3 | $3,000 | $9,000 |
| Semi-annual | $6,000 | 6 | 4 | $4,000 | $2,000 |
| Multi-year | $24,000 | 24 | 6 | $6,000 | $18,000 |
Total deferred revenue is $29,000, the number that belongs in the liability line at that date. The deferred revenue schedule keeps one contract per row.
When is straight-line the wrong method?
Straight-line fits services consumed evenly. Milestone work, usage-based billing and contracts with several performance obligations need a different pattern, and accounting standards decide which applies. The workbook does not make that judgment, and it does not handle partial months or contract modifications.
The same mechanics work in reverse for costs paid ahead of time; see how to amortize a prepaid expense and the prepaid and accrual schedule.