Deferred revenue recognition by service days · Calculation guide

One prepaid stand-ready service with an even daily transfer pattern, no refunds or changing consideration.

Calculation guide

Count delivered days to the reporting date.

period = amount*served/days-prior · liability = amount*(1-served/days) · cumulative = amount*served/days

Inputs

Prepaid contract consideration

Example entry 9000 (in the selected currency).

Total service days

Example entry 90. Use whole numbers.

Delivered days to date

Example entry 36. Use whole numbers.

Revenue in earlier periods

Example entry 2100 (in the selected currency).

Worked example

InputValue
Prepaid contract consideration9,000
Total service days90
Delivered days to date36
Revenue in earlier periods2,100
ResultValue
Current-period recognized revenue1,500
Closing deferred revenue5,400
Cumulative earned revenue3,600

Calculation steps

Current-period recognized revenue = (((Prepaid contract consideration × Delivered days to date) ÷ Total service days) − Revenue in earlier periods)

(((9,000 × 36) ÷ 90) − 2,100) = 1,500

Closing deferred revenue = (Prepaid contract consideration × (1 − (Delivered days to date ÷ Total service days)))

(9,000 × (1 − (36 ÷ 90))) = 5,400

Cumulative earned revenue = ((Prepaid contract consideration × Delivered days to date) ÷ Total service days)

((9,000 × 36) ÷ 90) = 3,600

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Prepaid contract consideration9,0009,900Current-period recognized revenue1,5001,860
Total service days9099Current-period recognized revenue1,5001,172.727273
Delivered days to date3640Current-period recognized revenue1,5001,900
Revenue in earlier periods2,1002,310Current-period recognized revenue1,5001,290
Deferred revenue recognition by service days →

Sources