IFRS 9 hedge accounting template
An Excel template that takes up to 10 hedging relationships from designation to the IFRS 7 disclosures. It tests each relationship against the IFRS 9 qualifying criteria, measures the effective and ineffective portions of cash flow, fair value and net investment hedges, tracks the cash flow hedge, cost of hedging and translation reserves, and produces the journals, the disclosure tables and a draft note. It comes with a fully worked example for a fictitious Irish engineering group.
What it does
Records each relationship – type of hedge, risk, hedged item, instrument, designation date and hedge ratio – and tests the qualifying criteria in IFRS 9.6.4.1, including whether a forecast transaction is highly probable (6.3.3).
Measures cash flow and net investment hedges with the lower-of test on cumulative changes since designation (IFRS 9.6.5.11), and fair value hedges with the adjustment to the hedged item (6.5.8), splitting effective amounts from ineffectiveness.
Handles excluded forward elements, option time value and currency basis spreads, with or without the cost of hedging reserve (6.5.15–16).
Tracks each reserve through reclassifications, transfers to the cost of non-financial items (6.5.11(d)(i)) and discontinuation, including forecast transactions no longer expected (6.5.12).
Reconciles each reserve by risk category (IFRS 7.24E–24F), reconciles the carrying amounts of the hedging instruments including cash settlements, summarises the amounts in profit or loss and produces balanced journals.
Prepares the IFRS 7 tables – hedging instruments, hedged items, ineffectiveness and the maturity profile of nominal amounts (7.23B–24C) – and drafts the note with a 14-point checklist and 23 automatic checks.
What it does not do
It does not value derivatives or hypothetical derivatives: enter the fair value changes from your valuations.
Rebalancing, macro hedges, fair value hedges of equity investments at FVOCI and the amortisation of fair value hedge adjustments are not modelled.
What you get
One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Kilkenny Precision Engineering Ltd, with an FX cash flow hedge using the cost of hedging approach, an interest rate swap on a term loan, a fair value hedge of fixed-rate notes, an aluminium hedge with a basis adjustment, a net investment hedge with a US dollar borrowing and a discontinued hedge.
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 9 Financial Instruments, chapter 6 (hedge accounting), and IFRS 7.21A–24G as issued by the IASB at October 2026, for one entity in one currency. The full scope and limitations are set out in the Instructions tab.
Need the rest of the financial instruments note? Use the IFRS 7 financial instruments disclosures template. Hedging a foreign operation? See the IAS 21 foreign exchange 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.



