IFRS 18 Transition Workbook

Available now

Restate profit or loss under IFRS 18, with the transition reconciliation for both years.

Map every profit or loss line once. The workbook restates the current and comparative year into the five IFRS 18 categories with the new subtotals, reconciles each IAS 1 caption to the new presentation and reconciles your management-defined performance measures. Every check shows PASS or FAIL.

Both years classified with one mapping into operating, investing, financing, income taxes and discontinued operations, with every required subtotal.
The IAS 1 to IFRS 18 reconciliation for every caption and both years, and a subtotal bridge from profit before tax to operating profit.
An MPM note with the tax and NCI effect of each reconciling item, disaggregation flags and the IAS 7 cash flow effects. No macros.

From USD 149, one-time payment.

Choose a licence Sample output (PDF)

13 tabs
11 visible checks
No macros
14-day refund, any reason

Fit

Who it is for

Preparers of IFRS financial statements adopting IFRS 18, which applies to annual periods beginning on or after 1 January 2027 and restates the comparative year.
Group reporting teams that must reconcile each line of the restated comparative statement of profit or loss.
Companies that publish measures such as adjusted EBITDA and now reconcile them to an IFRS subtotal in a note.
Accounting and audit firms preparing or reviewing the transition for clients, under the Practice licence.

Who it is not for

The statement of financial position, OCI, the statement of changes in equity and the full cash flow statement: this file covers profit or loss, with the IAS 7 consequences as a note.
Groups whose segments have different main business activities: the elections apply to the whole entity.
Allocating expenses presented by function to their nature: you tag the nature of each line where you know it.
Interim reports, segment reporting and XBRL tagging.
Anyone looking for the main business activity judgement to be made for them: the workbook records your elections and shows their effect.

Tabs

Tab by tab

13 tabs, from inputs to the Checks tab.

Settings: Year end, currency, tolerance, statutory tax rate, NCI share, materiality threshold and the entity profile elections, each with the effect it has.
Lines: Paste the profit or loss lines for both years as Debit and Credit, then give each its IAS 1 caption, IFRS 18 item type and, where known, its nature.
MPM Register: Up to 10 management-defined performance measures: why each is useful, how it is calculated, its nearest IFRS subtotal and the amount as published.
MPM Items: Up to 60 reconciling items, each with its tax effect (statutory rate or a specified amount) and its NCI effect.
Cash Flow Items: Interest paid and received, dividends received and paid, with the classification used before IFRS 18.
Checklist: 20 transition steps with the paragraph each follows, an owner, a status and a note.
Rules: Every item type with its classification rule, the paragraph it applies and the category it resolves to for your entity.
IFRS 18 P&L: The restated statement for both years: operating profit, profit before financing and income taxes, profit before income taxes, profit from continuing operations and profit or loss.
Reconciliation: The IAS 1 statement as previously presented, caption by category matrices for both years and the subtotal bridge.
MPM Note: Each measure reconciled from its nearest subtotal, with tax and NCI effects and the amount attributable to owners.
Disaggregation: Lines labelled 'other' above your materiality threshold, captions split across categories, specified expenses by nature and mixed-nature lines.
IAS 7 Note: The new starting point for the indirect method and the reclassification of interest and dividends, with the effect on each activity.
Checks: Every check visible, PASS or FAIL, with one cell that tells you whether everything passes.

Checks

The checks

Every check is visible on the Checks tab and shows PASS or FAIL.

Checks tab· 11 checksAll checks: PASS

Every check on the Checks tab, with its result on the sample data
ID	Check	On the sample data
C01	Profit or loss for both years is unchanged by the reclassification: the IFRS 18 statement equals the IAS 1 statement and the sum of every line.	PASS
C02	Every line is categorised exactly once, including foreign exchange and derivative lines through their related item type.	PASS
C03	The IAS 1 to IFRS 18 reconciliation foots for both years, caption by caption, and the subtotal bridge lands on operating profit.	PASS
C04	Every subtotal agrees with the category totals computed directly from the lines, for both years.	PASS
C05	Every MPM reconciles from its nearest subtotal to the amount as published, and every reconciling item names a registered measure.	PASS
C06	Every MPM reconciling item has a tax basis and an NCI basis, and the tax rate and NCI share are between 0 and 1.	PASS
C07	The entity profile elections are valid and consistent with each other.	PASS
C08	The IAS 7 reclassification of interest and dividends nets to zero for both years, and every amount has its previous classification.	PASS
C09	Line inputs are valid: codes present and unique, captions and nature tags from the lists, amounts of zero or more, checklist statuses valid.	PASS
C10	Settings are valid: tolerance, materiality threshold and reporting date.	PASS
C11	Income tax and discontinued operations lines carry the matching IAS 1 caption, and the other way round.	PASS

How we test each release

Compare

How it compares

Typical setups, not a review of any one product.

	Free template	Reporting software	This workbook
IAS 1 to IFRS 18 reconciliation, caption by caption	Varies by template	Varies, often inside the system	Yes, both years, with a subtotal bridge
MPM reconciliation with tax and NCI effects per item	Varies by template	Varies by product	Yes
Checks you can show a reviewer	Varies by template	Varies, often inside the system	Every check visible, PASS or FAIL
Where your data lives	Your machine	Usually cloud hosted	Your machine
Price	Free	Usually a subscription	From USD 149, once

IAS 1 to IFRS 18 reconciliation, caption by caption
This workbook
Yes, both years, with a subtotal bridge
Free template
Varies by template
Reporting software
Varies, often inside the system
MPM reconciliation with tax and NCI effects per item
This workbook
Yes
Free template
Varies by template
Reporting software
Varies by product
Checks you can show a reviewer
This workbook
Every check visible, PASS or FAIL
Free template
Varies by template
Reporting software
Varies, often inside the system
Where your data lives
This workbook
Your machine
Free template
Your machine
Reporting software
Usually cloud hosted
Price
This workbook
From USD 149, once
Free template
Free
Reporting software
Usually a subscription

Sample

Sample output

Sample output (PDF)

From the sample data: the Checks summary, the restated statement of profit or loss for both years, the caption reconciliation and the MPM reconciliations of the sample group.

Download the sample output (PDF)

Pricing

One-time payment. Choose the licence by how many people use the file and whose work it is for.

Founding offer: 25% off every licence below with FOUNDING25, applied automatically at checkout until 1 December 2026.

ProUSD 149USD 111.75withFOUNDING25

Excel
Up to 500 profit or loss lines and 10 MPMs
One named user

Choose this if you prepare the IFRS 18 transition for your own entity or group.

TeamUSD 299USD 224.25withFOUNDING25

Pro for up to 10 named users in one organisation

Choose this if up to 10 colleagues in one organisation work on the transition.

PracticeUSD 449USD 336.75withFOUNDING25

Pro for up to 5 named users in one accounting or audit firm
Any number of clients

Choose this if your firm prepares or reviews IFRS 18 transitions for clients.

Your licence

IFRS 18 Transition Workbook, ProUSD 149

USD 111.75 with FOUNDING25, applied automatically at checkout.

Paddle runs the checkout as merchant of record and shows the total before you pay.

With every licence

One-time price. Updates within the same major version are free for as long as we sell it.
You can ask for a full refund for any reason within 14 days of purchase. This is our own promise. The statutory withdrawal right you give up at checkout is a separate legal right.
Prices are in USD. Depending on your country, sales tax is either included in the price or added at checkout, and Paddle shows the total before you pay. Your checkout may show a local price.
After a purchase we may email you tips for your tool and about similar Hayatiq tools; every email has an unsubscribe link.
This is a tool, not tax, accounting or financial advice.

Questions

Does it need macros?

No. Every calculation is a formula you can trace. There is no VBA in the file.

Which Excel versions does it work in?

It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.

When does IFRS 18 apply?

To annual periods beginning on or after 1 January 2027, with earlier application permitted. The comparative year is restated, so the workbook classifies both years with the same mapping and reconciles each caption for both.

Does it decide our main business activity?

No. Whether the entity invests in assets or provides financing to customers as a main business activity is your judgement (IFRS 18.49 to 18.51). You record the elections in Settings, and the Rules tab shows what each one changes.

How are foreign exchange differences and derivatives classified?

Each one follows the item that gave rise to it, which you choose as its related item type. Where that would involve undue cost or effort, a separate code puts it in operating.

Which version of the standard does it follow?

IFRS 18 as issued in April 2024 and IAS 7 as amended by it. The Rules tab prints the paragraph behind each rule; the Appendix B guidance on derivatives is cited by topic.

Is my data uploaded anywhere?

No. The workbook runs on your computer. We never see your ledgers.

Why not ask an AI assistant to build the transition?

You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.

What does the licence allow?

Pro: one named user, for their own organisation. Team: up to 10 named users in one organisation, for its own work. Practice: up to 5 named users in one accounting or audit firm, for any number of clients. Every tier holds 500 profit or loss lines, 10 MPMs and 60 reconciling items. You may give completed files to your auditors and reviewers.

How do updates work?

When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.

What happens after I pay?

Paddle emails your receipt, and we email you a one-time link to Your downloads. If the link has expired, open Your downloads and enter the same email address for a fresh one. Updates appear in the same place.

What if it does not work for me?

Ask within 14 days of purchase for a full refund, for any reason.

Changelog

v1.0.0October 2026
First release.

Full changelog

How it is built

Every workbook is generated from source code written for Hayatiq and checked by an independent test suite before release.

How we test About