IFRS 18 Financial Statements - Excel Template (2026)
July 21, 2026
This article provides:
Latest Excel template (2026) for the IFRS 18 primary financial statements
A clear, practical guide to the key differences between IFRS 18 and IAS 1
The template is intended to help accounting and financial reporting teams structure the new IFRS 18 primary statements in Excel ahead of the standard’s effective date — annual periods beginning on or after 1 January 2027.
Request the IFRS 18 Excel template and receive it by email.
Excel changes. Word updates. One click.
Automate your financial statement preparation with LedgerQ.
IFRS 18 vs IAS 1: key differences
Topic
IAS 1
IFRS 18
Income statement structure
No prescribed categories; entities choose how to present income and expenses with few required line items.
Income and expenses are classified into three defined categories: operating, investing and financing.
Required subtotals
‘Operating profit’ is not defined and few subtotals are mandated.
Two new mandatory subtotals: operating profit, and profit before financing and income taxes.
Presentation of expenses
By nature or by function, with limited disclosure of the split.
By nature or function; a function-based statement must also disclose specified nature-based expenses in the notes.
Management performance measures (MPMs)
No specific requirements for company-defined performance measures.
MPMs must be disclosed in a single note and reconciled to the most directly comparable IFRS subtotal.
Statement of cash flows
Indirect method can start from different figures; interest and dividends have classification choices.
Operating profit is the single starting point; the classification options for interest and dividends are removed.
Effective date
Currently in effect.
Annual periods beginning on or after 1 January 2027 (early adoption permitted).
IFRS 18 Presentation and Disclosure in Financial Statements replaces IAS 1 for annual reporting periods beginning on or after 1 January 2027, with early adoption permitted. It does not change recognition or measurement — it changes how the primary statements are structured and what companies must disclose about performance measures.
What does this mean in practice?
Re-map your chart of accounts to the new operating, investing and financing categories of the income statement.
Identify which of your alternative performance measures qualify as MPMs and prepare the reconciliation note.
Dry-run the new presentation on 2026 figures — they become the restated comparatives in your first IFRS 18 financial statements.
Disclaimer of Liability: This publication is intended to provide general information to our clients. It does not constitute accounting, tax, investment, or legal advice; nor is it intended to convey a thorough treatment of the subject matter.
