Templates

ASC 606 Revenue Workbook

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.

Get the template

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.

What is in the workbook

Inputs
the Corvane contract lines and prices, the standalone selling prices, the uptime credit outcomes and probabilities, installation hours by month, the subscription start and term, the commission rate, the Brightline prices, units, rebate and return rate, and the Delmar installments and discount rate.
Allocation
the sum of standalone selling prices, the bundle discount, the relative allocation of the fixed price, the expected uptime credits and the subscription total and monthly amount.
Schedule
revenue by month for 2025 by performance obligation, billing by month, cumulative revenue and billing, and the net contract position at each month-end; remaining performance obligations at year-end.
Variable
the expected value of the uptime credits; the Brightline rebate under the most likely amount and the expected value methods; the third-quarter catch-up; the first quarter with returns, the refund liability and the return asset.
Modification
the add-on order test against SSP; the prospective treatment of the March 2026 price reduction; the cumulative catch-up it would have produced.
Costs
the commission capitalized, its amortization in proportion to revenue and on a straight line, and the year-end balance; the add-on commission under the practical expedient.
Financing
the present value of the Delmar installments, the interest income for 2025 and the receivable at year-end.
Checks
a list of controls that compare the workbook's results with the figures printed in this book, ending in a single cell that reads ALL CHECKS OK when every one passes.

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.