IFRS 18 Excel Model — from General Ledger to IAS 1 and IFRS 18 Statements

What this model does

IFRS 18 Presentation and Disclosure in Financial Statements replaces IAS 1. It does not change recognition or measurement — profit stays the same — but it changes how the statement of profit or loss is built: every income and expense line is classified into the operating, investing or financing category, operating profit and profit before financing and income taxes become mandatory subtotals, and measures such as EBITDA that a company uses in public must be disclosed and reconciled in a single note.

This model shows the change on a full year of real-looking data. 41,120 journal lines from Mizan Retail, a fictional grocery chain, build a trial balance with SUMIFS — nothing is typed in. Every account is mapped to a statement caption and an IFRS 18 category, and both presentations sit side by side. Profit is identical; operating profit is not, because bank and card charges move from finance costs into the operating category. Note 7 reconciles the two.

Three things to watch for

• The ledger never closes the year: retained earnings on the balance sheet must add the accumulated profit to the GL balance.
• Dividends are posted straight to retained earnings — find them on GL Data and follow them into the cash flow.
• The tax account flips sign: a liability when in credit, tax recoverable when the year was overpaid.

Inside the workbook

1. Cover — What the model does, how to use it, and the links.
2. GL Data — 41,120 journal lines for FY2024–FY2025, the model's only input.
3. TB & Mapping — A live trial balance; each account mapped to an IAS 1 caption and an IFRS 18 category.
4. P&L — IAS 1 and IFRS 18 side by side, with the two new mandatory subtotals.
5. Balance Sheet — Two years, with a balance check.
6. Cash Flow — Indirect method, starting from operating profit as IFRS 18 requires; ties to the trial balance.
7. Notes — Operating expenses, PPE roll-forward, borrowings, dividends, EBITDA as a management-defined performance measure, and the IAS 1 → IFRS 18 reconciliation.

Who this model is for

• Financial reporting teams planning their IFRS 18 transition before 1 January 2027
• Auditors and advisors who need a working example to walk clients through the change
• Students and finance professionals studying presentation and disclosure under IFRS 18

Frequently asked questions

Keep going on findi360

• DATA DARE Mizan Retail: Sales Up, Profit Down — Journals, Trial Balance and Budget DD-GLT-001 · L1 — XLSX / ~10,000 rows
• DATA DRILL Test yourself — Power BI practice questions One question at a time, or a 50-question timed simulation.
• COURSE IFRS 18 Adjustments in Power BI Learn to build this kind of model yourself.

Related models

• Leveraged Buyout (LBO) Model

  A private-equity buyout end to end — sources and uses, a senior loan with cash sweep, subordinated notes, a five-year plan, and the sponsor's IRR, MOIC and where the return came from.

• Manufacturing Financial Model & Feasibility Study

  A four-product manufacturer planned from the factory floor up for ten years — production cost build-up, seven sensitivity cases, the three statements and four valuation methods.