Provision Matrix
Define aging buckets, enter gross carrying amounts and historical loss rates. Per IFRS 9.B5.5.35.
Forward-Looking Adjustment
Required by IFRS 9.5.5.17. Purely historical rates are not IFRS 9 compliant.
Advanced Features
Optional: probability-weighted scenarios, movement schedule, specific assessment, and entity details.
IFRS 9 ECL Audit Working Paper Template — free PDF
Practical audit guide covering the simplified approach provision matrix methodology, forward-looking adjustment documentation template, probability-weighted scenario framework, IFRS 7.35H movement schedule template, common ISA 540 findings on ECL estimates, and industry benchmark loss rates for 12 sectors.
No spam. Unsubscribe anytime.
IFRS 9 Simplified Approach — Complete Methodology
IFRS 9 Financial Instruments replaced IAS 39 with a forward-looking expected credit loss model that fundamentally changed how entities recognise impairment on financial assets. For trade receivables without a significant financing component — which covers the vast majority of commercial receivables — the standard mandates the simplified approach under IFRS 9.5.5.15. This calculator implements that approach using the provision matrix methodology described in IFRS 9.B5.5.35 and illustrated in the standard's Illustrative Example 12 (IE74–IE77).
Unlike the general model (which requires a three-stage assessment of whether credit risk has increased significantly since initial recognition), the simplified approach always measures the loss allowance at lifetime expected credit losses. This eliminates the complexity of staging but does not reduce the need for robust estimation. The auditor's role, per ISA 540 (Revised), is to evaluate whether management's ECL estimate — including all underlying assumptions — falls within a reasonable range.
Step 1: Define Aging Buckets
The provision matrix groups trade receivables by shared credit risk characteristics. The most common and practical grouping is by days past due. Standard buckets are: not yet due, 1–30 days, 31–60 days, 61–90 days, 91–180 days, and 180+ days past due. However, IFRS 9 does not prescribe specific aging categories — entities should use buckets that reflect their actual credit risk patterns. For example, a construction company might use longer buckets to accommodate contractual retention periods, while a retail business with high-volume, low-value receivables might use shorter periods.
Step 2: Calculate Historical Loss Rates
For each aging bucket, calculate the historical loss rate as: Historical Credit Losses ÷ Historical Gross Receivables in that bucket. A critical concept that many preparers misunderstand: the same credit loss amount appears in every bucket's numerator because a receivable that ultimately defaults passes through each aging stage before write-off. If €100,000 in receivables was eventually written off, that €100,000 contributes to the numerator for every bucket — from "not yet due" through to the final bucket. The denominator (total gross receivables in each bucket) decreases as receivables age, which naturally produces increasing loss rates across aging buckets.
Historical data should cover a sufficient period to capture a representative credit cycle — typically 3 to 5 years. IFRS 9.B5.5.52 notes that entities should consider whether current observable data is appropriately weighted relative to historical experience. If the entity has limited historical data (for example, a newly established entity), it may use external industry benchmarks as a proxy, but this must be clearly documented.
Step 3: Adjust for Forward-Looking Information
This is the step that distinguishes IFRS 9 from the old IAS 39 incurred-loss model. IFRS 9.5.5.17 requires that expected credit losses reflect reasonable and supportable information about past events, current conditions, and forecasts of future economic conditions. Purely historical loss rates are explicitly NOT IFRS 9 compliant. The forward-looking adjustment is typically applied as a multiplier to historical loss rates: a factor above 1.0 reflects deteriorating economic conditions (increasing expected losses), while a factor below 1.0 reflects improving conditions.
Acceptable forward-looking indicators include GDP growth forecasts, unemployment rate projections, inflation expectations, central bank interest rate paths, industry-specific indices, commodity prices (for relevant sectors), and property market indices. IFRS 9.B5.5.49–B5.5.54 provides guidance on what constitutes reasonable and supportable information. The standard acknowledges that longer-term forecasts become less reliable, and entities may revert to historical averages beyond the reasonable and supportable forecast horizon.
Step 4: Apply Adjusted Rates and Calculate ECL
The ECL for each bucket is calculated as: Gross Carrying Amount × Adjusted Loss Rate (Historical Rate × Forward-Looking Multiplier). The total ECL is the sum across all buckets. The effective overall ECL rate is the total ECL divided by the total gross carrying amount, expressed as a percentage. This single rate provides a useful benchmark for comparing ECL levels across periods and entities.
Probability-Weighted Scenarios (IFRS 9.5.5.18)
IFRS 9.5.5.18 requires that ECL measurements reflect an unbiased, probability-weighted amount. In practice, entities run the ECL calculation under multiple macroeconomic scenarios — typically a base case, a downside scenario, and an upside scenario — and weight the results by their assessed probability. A common weighting is 60% base, 25% downside, 15% upside, but these should reflect the entity's specific circumstances. The probability-weighted ECL is the sum of each scenario's ECL multiplied by its probability. Probabilities must sum to 100%.
Movement Schedule — IFRS 7.35H Disclosure
IFRS 7.35H requires a reconciliation of the loss allowance from opening to closing balance. This reconciliation must show: the opening loss allowance at the start of the period, new provisions charged to profit or loss, reversals credited to profit or loss, amounts written off against the allowance, foreign exchange adjustments, and the closing balance. This disclosure is a mandatory requirement in the financial statements and serves as a key audit working paper. The charge or release to profit or loss is the balancing figure: Closing − Opening + Write-offs − FX adjustments.
ISA 540 Audit Context
ISA 540 (Revised) — Auditing Accounting Estimates and Related Disclosures — is the primary standard governing the audit of ECL estimates. The standard requires auditors to understand management's estimation process, evaluate the reasonableness of significant assumptions, and test the accuracy and completeness of underlying data. For ECL estimates, the most effective approach is often developing an independent auditor's estimate (using this calculator) and comparing it to management's recorded provision. Differences are evaluated against performance materiality. Common ISA 540 findings on ECL estimates include: insufficient historical data periods, absent or superficial forward-looking adjustments, failure to apply probability-weighted scenarios, and inadequate documentation of the basis for key assumptions.
Worked Example — Manufacturing Entity
Consider EuroParts GmbH, a mid-size automotive components manufacturer with €2,400,000 in trade receivables at 31 December 2025. The entity's receivable aging and historical loss rates are as follows:
| Aging Bucket | Gross Amount | Hist. Rate | FL Adj. | Adj. Rate | ECL |
|---|---|---|---|---|---|
| Not yet due | €1,200,000 | 0.30% | 1.05× | 0.32% | €3,780 |
| 1–30 days | €520,000 | 0.80% | 1.05× | 0.84% | €4,368 |
| 31–60 days | €340,000 | 2.50% | 1.05× | 2.63% | €8,925 |
| 61–90 days | €180,000 | 8.00% | 1.05× | 8.40% | €15,120 |
| 91–180 days | €110,000 | 15.00% | 1.05× | 15.75% | €17,325 |
| 180+ days | €50,000 | 40.00% | 1.05× | 42.00% | €21,000 |
| Total | €2,400,000 | €70,518 | |||
The forward-looking adjustment factor of 1.05× reflects moderately softening economic conditions in the automotive sector, with supply chain disruptions and rising input costs expected to marginally increase customer default risk. The effective overall ECL rate is 2.94% (€70,518 / €2,400,000).
With probability-weighted scenarios: Base case (60%, FL factor 1.05×) yields ECL of €70,518. Downside (25%, FL factor 1.30×) yields ECL of €87,360. Upside (15%, FL factor 0.85×) yields ECL of €57,120. Probability-weighted ECL = (0.60 × €70,518) + (0.25 × €87,360) + (0.15 × €57,120) = €42,311 + €21,840 + €8,568 = €72,719.
The difference between the single-scenario and probability-weighted approach is €2,201 — small in this case because the scenario weightings are relatively symmetric. In practice, the difference becomes more significant when downside scenarios carry higher weight (for example, during economic downturns) or when the loss rates in the downside scenario are substantially elevated.