Rounding Robin

Home › Templates › ASC 606 Revenue Recognition Template

ASC 606 Revenue Recognition Template

A revenue recognition schedule under ASC 606 for software and subscription businesses, for up to 200 performance obligations. It allocates each contract's price, recognises revenue over time or at a point in time, and calculates deferred revenue, contract assets and remaining performance obligations.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab and a list of every built-in check with its result.
InputsPeriod dates and the contract register: one row per performance obligation, with price, standalone selling price, service dates and billing frequency.
ScheduleAllocated price, revenue to date, this month and year to date, billings, remaining performance obligation, and the next 12 months of revenue, with deferred revenue and contract assets by contract.
Journal EntryThe monthly revenue entry by revenue account, and the contract asset entry.
ReconciliationDeferred revenue roll-forward, comparison with the general ledger, and disclosure measures.
ListsRevenue types with their recognition pattern and account.

Features

Instructions

  1. On the Lists tab, enter your revenue types and accounts.
  2. On the Inputs tab, enter the period dates and one row per performance obligation.
  3. Enter standalone selling prices where a contract bundles items.
  4. Review the Schedule tab.
  5. Post the entries on the Journal Entry tab.
  6. Enter general ledger balances on the Reconciliation tab.

Notes

Covers fixed-price obligations billed in advance. Variable consideration, usage-based fees, contract modifications, financing components and costs to obtain a contract are not covered. Identifying performance obligations and standalone selling prices is an accounting judgment.

Guides

Related calculators

More accounting templates

Need a version built for your process? Request a custom template quote.

To report an error or request a calculator or template, send feedback.

Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.