Relative SSP allocation, variable consideration by the expected value and the most likely amount, the monthly revenue schedule with contract assets and liabilities, a contract modification two ways, commission amortization under ASC 340-40 and a significant financing component: eight tabs, one fictional company, no macros.
Enter a bundle's prices and standalone selling prices. The workbook allocates the $310,000 contract of the case ($95,667.66 to sensors, $32,195.85 to installation, $178,536.49 to a subscription net of $3,600 of expected credits), builds 2025 revenue month by month ($177,457.01 against $190,000 billed), shows a contract asset of $14,985.17 in January and a contract liability of $12,542.99 at year-end, and amortizes a $24,800 commission. A Checks tab ties 32 figures to the book.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
ASC_606_Revenue_Workbook.xlsx (21 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind the workbook: The Revenue Recognition Handbook, PDF and paperback, with the full case, the IFRS 15 notes and the checklists.
Every assumption is shaded in a light color, on the Inputs tab (billing dates and amounts sit on the Schedule tab); every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own contract; the Checks tab will then show differences from the book by design.
From The Revenue Recognition Handbook. To read: how to allocate the transaction price under ASC 606 · expected value or most likely amount · contract asset or contract liability.