IFRS 18 Transition Kit (Excel + Google Sheets) | 5-Category P&L · Category Mapping Engine · Main Business Activity Matri

Description
The IFRS 18 Transition Kit is a self-contained working model for technical accountants, controllers and audit teams at IFRS reporters who must restate the income statement for IFRS 18 — effective for annual reporting periods beginning on or after 1 January 2027, with comparatives restated — and evidence every classification judgement. Enter your existing income statement or trial-balance lines, select an IFRS 18 item type for each and choose your entity archetype, and the model classifies every line into the five categories and builds the restated statement with both required subtotals. It ships pre-filled with a complete, tied-out worked transition for a manufacturer and a second for a retail bank.
The differentiator is that classification is computed and cited, not assumed. IFRS 18.49 makes entities with a specified main business activity classify the same item differently from everyone else. In the shipped sample the same sixteen lines produce the same profit for the period — 38,300 — for all three of the archetypes below, while Operating Profit reads 49,050 for a manufacturer, 49,940 with customer financing and 52,040 for a bank that also invests in financial assets. Every one of the 126 matrix cells is tied to a paragraph, and the mapping engine reproduces the hand-built statement independently.

What you get
- A five-category IFRS 18 income statement with both required subtotals — Operating Profit 18.69(a) and Profit before financing and income taxes 18.69(b)
- An 18 item type × 7 entity archetype classification matrix, each cell paragraph-cited, with eight accounting-policy footnotes
- An IAS 1 to IFRS 18 mapping engine with a tie check and a policy-election consistency check
- A second fully worked statement for an entity with a specified main business activity
- Three worked management-defined performance measures, reconciled, with 123(d) tax and NCI effect lines
- A 20-point gap analysis, a 45-point disclosure checklist, an 18-month 32-task timeline, a readiness dashboard and a board memo template
- A Google Sheets edition and a 4-page practitioner's guide

Model structure — Excel (11 tabs)
1. Start Here — what changes, responsibilities, 7-step quick start, disclaimer
2. Dashboard — completion %, RAG status, days to 1 January 2027, tasks-by-phase chart
3. Transition Timeline — 18-month, 6-phase, 32 tasks with owners and target dates
4. Gap Analysis — 20 paragraph-referenced requirement points, scored for gap and impact
5. Entity Classifier — main-business-activity determination and the 18 × 7 matrix
6. Category Mapping — the engine: classification, roll-ups, subtotals, tie check, election check
7. IFRS 18 P&L — worked manufacturer statement, annotated line by line
8. Bank P&L Example — parallel statement for a specified-main-business-activity entity
9. MPM Register — three reconciled measures
10. Disclosure Checklist — 45 points with status roll-up
11. Board Memo Template — briefing for the board or audit committee

See it working
"Meridian Industrial Holdings Ltd" (fictional): revenue 245,800 (prior year 218,400); gross profit 103,700; Operating Profit 49,050 (42,380), including a 450 PPE disposal gain retained in operating; investing 6,390, including the 3,400 associates share moved out of operating; Profit before financing and income taxes 55,440 (47,720); profit before tax 47,100; profit for the period 38,300 (30,100). MPMs: Adjusted EBITDA 72,650, Adjusted Operating Profit 53,350, Adjusted Profit Before Tax 51,400. "Northgate Retail Bank plc" (fictional): net interest income 312,600; Operating Profit 125,100; Profit before financing and income taxes 132,900; profit before tax 122,300; profit for the period 93,000. Replace the inputs with your own and every output re-prices.

Scope
A presentation and disclosure tool for the income statement and its notes. No measurement or recognition — no IFRS 9, IFRS 16 or IFRS 17 mechanics, no consolidation or translation, no balance sheet, cash flow or equity statement, no XBRL, no filing-ready output.

Technical specifications
- Format: .xlsx (Excel) + .xlsx (Google Sheets) + .pdf (guide)
- Compatibility: Excel 2019, 2021, Microsoft 365 (Windows and Mac) and Google Sheets
- No macros, no VBA, no add-ins, no XLOOKUP, no dynamic arrays
- 11 tabs · 205 formulas · 13 input-validation rules over 393 input cells
- Pre-filled worked transition; replace with your own
- Delivery: instant digital download · single-user license

ABOUT THE AUTHOR
Built by Hoda Elmorshidy — Financial Controller & Fractional CFO, in senior finance since 2017: IFRS reporting, FP&A, finance automation, Quantitative Analysis, Financial Modeling, and UAE VAT & Corporate Tax.

DISCLAIMER
Not accounting advice. This template is an analytical and educational tool, not professional financial, investment, tax, accounting, or legal advice, and its use creates no professional relationship. All assumptions and figures are illustrative. Verify every IFRS 18 paragraph reference against the current standard text, and confirm your jurisdiction's endorsement status, as of your reporting date, before relying on any output. The sample entities and all of their figures are fictional. Liability is limited as set out in the licence terms below.

LICENSE & LIABILITY
LICENSE GRANT: Single-user license for your own or your organization's internal use. No resale, redistribution, sublicensing, or repackaging of the file or its templates.
AS IS: Provided "as is" without warranty of any kind, express or implied, including merchantability or fitness for a particular purpose.
LIMITATION OF LIABILITY: To the maximum extent permitted by law, total liability for any claim arising from this product is limited to the amount you paid for it. Not liable for indirect, incidental, or consequential losses.
NON-WAIVABLE RIGHTS: Nothing here limits rights that cannot be excluded under the consumer-protection law of your jurisdiction.
GOVERNING LAW: This purchase is governed by the terms of the platform you bought it on (e.g. Etsy, Gumroad) and by the consumer-protection law of your own country of residence. Where those permit, the limitations above apply to the maximum extent allowed.
Past or sample results are not indicative.
REFUNDS: Digital download — refunds are handled per the refund policy of the platform you purchased on for digital/instant-download items.
TRADEMARKS & NON-AFFILIATION: "IFRS", "IAS", "IASB", "International Financial Reporting Standards" and "International Accounting Standards" are trade marks of the IFRS Foundation. This product is an independent analytical template and is NOT affiliated with, endorsed by, sponsored by, or approved by the IFRS Foundation or the International Accounting Standards Board, and it does not reproduce the standard's text. Microsoft Excel and Google Sheets are trademarks of Microsoft Corporation and Google LLC respectively; this product is not affiliated with, endorsed by, or sponsored by either.