top of page

IFRS 8 operating segments template

€99.00Price

An Excel template that takes the operating segments reported to your chief operating decision maker and turns them into the IFRS 8 note. It applies the aggregation criteria, the 10% quantitative thresholds and the 75% test to identify the reportable segments, builds the segment tables for the current and prior year, reconciles them to the financial statements and prepares the entity-wide disclosures. It comes with a fully worked example for a fictitious Irish food group.

What it does

  • Takes up to 10 operating segments with the revenue, profit and assets reported to the CODM, aggregates segments that meet the criteria in IFRS 8.12 (or 8.14 for segments below the thresholds) and tests the reported segments against the revenue, profit and assets thresholds (8.13), including the profit test base of the greater of combined profits and combined losses.

  • Applies the 75% test (IFRS 8.15), lets management report a segment below the thresholds, and places the rest in “All other segments” (8.16).

  • Builds the segment table for up to six reportable segments, current and prior year, with the specified amounts reviewed by the CODM – interest, depreciation and amortisation, equity-accounted results, impairment (IAS 36.129), tax and material items – and segment assets, additions and liabilities (8.23–24).

  • Reconciles segment revenue, profit, assets, liabilities and other material items to the financial statements (8.28), showing any difference.

  • Prepares the entity-wide disclosures: revenue by product or service, revenue and non-current assets by country, and customers with 10% or more of revenue (8.32–34).

  • Drafts the note – basis of segmentation and aggregation judgements, measurement, the segment table, major customers and geographical information – with an 18-point checklist and 23 automatic checks.

What it does not do

  • It does not cover interim segment disclosures (IAS 34.16A(g)).

  • Thresholds are tested on the current year: continuing significance (8.17) and restated comparatives (8.18, 8.29) need your judgement.

What you get

  • One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Corrib Foods plc, with two dairy segments aggregated, a loss-making segment reported by choice, two small segments in all other segments, unallocated corporate costs and exceptional items in the reconciliation, and two major customers.

  • 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 8 Operating Segments as issued by the IASB at October 2026, for one reporting entity in one currency, with IAS 1 or IFRS 18 presentation. The full scope and limitations are set out in the Instructions tab.

Presenting under IFRS 18 from 2027? See the IFRS 18 transition pack. Need the group totals first? Use the free Consolidation 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