Download a template created by finance expert and Microsoft Excel MrExcel.com forum master Jason Yablinsky. Jason is known throughout the spreadsheet community as one of the best problem solvers for rookie and expert Excel users alike. 

To use this template, simply:

Step 1: Choose "Daily" or "Monthly" schedule

Step 2: Input your company's SKUs, products, subscriptions as LINE ITEM.

Step 3: Create a grey section for all your customers

Step 4: Let Excel compute your recognized revenue and deferred revenue schedules

VLOOKUP no more for a better recurring revenue schedule!