top of page

IFRS 15 revenue template

€99.00Price

An Excel template for revenue from a portfolio of customer contracts under IFRS 15 – the full version. It measures revenue over time by the cost-to-cost method or an output method, or at a point in time, estimates variable consideration and applies the constraint, recognises changes in estimates as cumulative catch-up adjustments, provides for onerous contracts, nets each contract into a contract asset or contract liability and rolls the balances forward, and produces the disaggregation of revenue, the remaining performance obligations, the journals and a draft note. It comes with a fully worked example for a fictitious Irish building services contractor.

What it does

  • Records up to 15 performance obligations with their customer, product line, market, customer type, dates and pattern of transfer, checks that over-time revenue rests on one of the IFRS 15.35 criteria, and groups obligations of the same contract so that its balances are netted (105).

  • Builds each transaction price from the fixed price, approved modifications, variable consideration estimated by the expected value or the most likely amount (IFRS 15.53) and limited by the constraint (56–58), consideration payable to the customer and any financing adjustment.

  • Measures progress by cost-to-cost – excluding wasted costs and recognising revenue at cost on uninstalled materials, as in the IASB's Illustrative Example 19 (B19) – by an output method, or at the point control passes, with costs before delivery held as inventory.

  • Works out revenue for the year as cumulative revenue less revenue recognised before, with the catch-up from changes in the transaction price, revenue from obligations satisfied in earlier periods (116(c)), IAS 37 onerous provisions with their movement, and the amortisation and impairment of costs to obtain a contract (91–104).

  • Rolls forward trade receivables, contract assets and contract liabilities – invoicing, cash, transfers to receivables, revenue from the opening contract liabilities and the IFRS 9 loss allowances (116–118) – and checks the opening balances against last year's accounts.

  • Produces the disaggregation of revenue by product line, market, customer type, timing and duration, the remaining performance obligations by time band with the 121 expedients, the journals, a draft note, a 20-point disclosure checklist and 20 automatic checks.

What it does not do

  • It does not allocate a bundled price between performance obligations – use the Bundled revenue template first and enter each obligation as its own row.

  • Licences of intellectual property, principal-versus-agent, warranties, modifications accounted for as separate contracts or prospectively, and costs to fulfil a contract (15.95) need your judgement before you enter the figures. Loss allowances come from your own IFRS 9 calculation, and comparatives from last year's workbook.

What you get

  • One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Liffey Building Services Limited, with installation projects measured cost-to-cost (one loss-making with wasted costs, one with uninstalled materials, a change order and a constrained performance bonus), a software implementation by milestones, a two-year maintenance contract, equipment supplied at a point in time, a deposit on undelivered equipment with a customer rebate, and price changes on contracts finished last year and this year.

  • Clearly marked input cells, protected formulas and built-in checks, with a status line on every tab.

  • Works in Microsoft Excel 2010 or later (Windows or Mac). No macros.

Scope

IFRS 15 Revenue from Contracts with Customers as issued by the IASB at November 2026, with IAS 37 for onerous contracts and IFRS 9 for loss allowances, for one entity in one currency. The full scope and limitations are set out in the Instructions tab.

Pricing a bundle of goods and services? Start with the Bundled revenue template. Reporting revenue by segment? See the IFRS 8 operating segments template.

Designed for finance teams, auditors and advisers preparing or reviewing IFRS financial statements. It is a working aid: it does not replace the Standards or professional judgement, and its scope and limitations are set out in the Instructions tab. The worked example is fictitious.

    bottom of page