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.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab and a list of every built-in check with its result. |
| Inputs | Period dates and the contract register: one row per performance obligation, with price, standalone selling price, service dates and billing frequency. |
| Schedule | Allocated 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 Entry | The monthly revenue entry by revenue account, and the contract asset entry. |
| Reconciliation | Deferred revenue roll-forward, comparison with the general ledger, and disclosure measures. |
| Lists | Revenue types with their recognition pattern and account. |
Features
- Allocates a bundled contract price to its performance obligations in proportion to standalone selling prices.
- Recognises revenue evenly by day over the service period, or in full at a delivery date.
- Billing up front, annually, quarterly or monthly in advance.
- Deferred revenue and contract assets are netted within each contract, as the standard requires.
- Revenue expected in each of the next 12 months, and remaining performance obligations split within and after 12 months.
- Monthly and annual recurring revenue at period end.
- Journal entries list only the lines that have an amount.
Instructions
- On the Lists tab, enter your revenue types and accounts.
- On the Inputs tab, enter the period dates and one row per performance obligation.
- Enter standalone selling prices where a contract bundles items.
- Review the Schedule tab.
- Post the entries on the Journal Entry tab.
- 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
- Present Value CalculatorCalculate what a future sum of money is worth today at a given discount rate and number of years.
- Days Sales Outstanding (DSO) CalculatorCalculate days sales outstanding and receivables turnover from accounts receivable and credit sales.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
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.