IFRS 7 financial instruments disclosures template
An Excel template that builds the IFRS 7 financial instruments note from a register of your financial instruments. It analyses carrying amounts by IFRS 9 category, compares fair values with carrying amounts, builds the fair value hierarchy and the Level 3 reconciliation, reconciles the expected credit loss allowance by stage, prepares the liquidity maturity analysis and the market risk sensitivities, and drafts the note. It comes with a fully worked example for a fictitious Irish shipping and logistics company.
What it does
Analyses up to 25 classes of financial instruments by IFRS 9 category, current and prior year (IFRS 7.8), with totals of financial assets and liabilities.
Compares fair value with carrying amount for each class (IFRS 7.25–29), applying the exemptions for items whose carrying amount approximates fair value and for lease liabilities, and builds the fair value hierarchy table for recurring measurements (IFRS 13.93).
Reconciles up to five Level 3 classes from opening to closing balance, with unrealised gains, valuation techniques, unobservable inputs and the effect of reasonably possible changes (IFRS 13.93(d)–(h)).
Reconciles the loss allowance by stage – 12-month, lifetime not credit-impaired, credit-impaired and the simplified approach (IFRS 7.35H) – with the allowance by class, gross carrying amounts by credit grade (7.35M), a provision matrix for trade receivables (7.35N), the allowance on debt at FVOCI and loan commitments (7.16A) and the maximum exposure to credit risk (7.35K).
Prepares the maturity analysis of financial liabilities on contractual undiscounted cash flows (IFRS 7.39, B11), with a calculator that builds principal and interest by time band for bullet and amortising loans.
Calculates interest rate, currency, equity and commodity price sensitivities on profit and other comprehensive income (IFRS 7.40).
Drafts the note – fair value, credit, liquidity and market risk – with a 35-point checklist and 23 automatic checks.
What it does not do
It does not calculate expected credit losses or value financial instruments: enter the ECL movements and fair values from your models and valuations.
Hedge accounting disclosures are covered by the IFRS 9 hedge accounting template; offsetting, transfers of financial assets and capital management are in the checklist but not built.
What you get
One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Shannon Marine Logistics DAC, with cash, trade receivables under a provision matrix, customer financing loans in all three stages, a listed bond portfolio, an unlisted equity investment and contingent consideration in Level 3, derivatives, senior notes, a term loan and lease liabilities.
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 7 Financial Instruments: Disclosures and IFRS 13.93–99 as issued by the IASB at October 2026, with IFRS 9 categories, for one entity in one presentation currency. The full scope and limitations are set out in the Instructions tab.
Need the loss allowance itself? Use the ECL calculator. Working out interest income on loans? See the free Amortised cost 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.



