IFRS Tutor

IFRS library › Calc Series

Build an ECL Provision Matrix — IFRS 9 Worked Example | CALC SERIES #04

Your company has six hundred and ninety thousand euros of trade receivables spread across customers in different payment states.

Explained by Maya, your IFRS Tutor presenter · Calc Series

Build an ECL Provision Matrix — IFRS 9 Worked Example | CALC SERIES #04

Subscribe for every IFRS standard explained Watch the full IFRS course

In this video

  1. 0:00 The scenario — €690,000 receivables
  2. 0:12 Simplified approach — who qualifies
  3. 0:38 Provision matrix method — grouping and rates
  4. 1:05 Five aging buckets and loss rates
  5. 1:35 ECL calculation table — €23,800
  6. 2:00 Journal entry and net receivables
  7. 2:25 The forward-looking mistake
  8. 2:50 Summary

Key terms in plain English

Contract asset
Revenue you have earned but are not yet allowed to bill for.
Amortised cost
Measuring a loan or bond at what you paid, adjusted over time using its effective interest rate, rather than at market value.
Expected credit loss
An estimate of how much of what you're owed you probably won't collect, booked before anyone actually defaults.
Provision
A liability where the amount or the timing is uncertain, like a likely legal settlement.

Full explanation

Overview

Your company has six hundred and ninety thousand euros of trade receivables spread across customers in different payment states. IFRS 9 requires a loss allowance on day one — here is exactly how to build the provision matrix and record the journal entry.

Trade receivables: lifetime ECL from day one

These are trade receivables without a significant financing component — goods and services billed on normal credit terms. Under IFRS 9 paragraph 5.5.15, you are permitted to use the simplified approach: instead of tracking whether each receivable has had a significant increase in credit risk, you calculate a lifetime expected credit loss straight away, for every receivable, from day one.

Group by shared credit risk → apply a loss rate

IFRS 9 paragraph 5.5.17 tells you how: group the receivables by shared credit-risk characteristics — age is the most common basis — then apply a loss rate to each group. The loss rate is derived from your own historical data on customer defaults and adjusted for forward-looking macroeconomic factors. Historical default rates alone are not enough.

Loss rates: calibrated to portfolio, adjusted for outlook

Five aging buckets from the six hundred and ninety thousand euro portfolio. Current: zero to thirty days, loss rate nought point five percent. Thirty-one to sixty days: two percent. Sixty-one to ninety days: six percent. Ninety-one to one hundred twenty days: fifteen percent. Over one hundred twenty days: forty percent. Each rate was derived from five years of historical write-off data, then adjusted upward slightly to reflect the current economic outlook.

Gross receivable × loss rate = ECL per bucket

Apply the rate to each bucket. Current, four hundred thousand at nought point five percent: two thousand. Thirty-one to sixty, one hundred fifty thousand at two percent: three thousand. Sixty-one to ninety, eighty thousand at six percent: four thousand eight hundred. Ninety-one to one hundred twenty, forty thousand at fifteen percent: six thousand. Over one hundred twenty, twenty thousand at forty percent: eight thousand. Total expected credit loss: twenty-three thousand eight hundred euros.

Dr Credit loss expense · Cr Loss allowance

The journal entry on day one: debit credit loss expense twenty-three thousand eight hundred, credit loss allowance twenty-three thousand eight hundred. The allowance sits on the balance sheet as a contra to trade receivables — net receivables presented at six hundred sixty-six thousand two hundred euros.

Using historical rates only — without forward-looking adjustment

The most common mistake: using industry-average loss rates without adjusting for your own customer base and the current outlook. A manufacturing company selling to large retailers has a very different loss profile from one selling to small traders. IFRS 9 paragraph 5.5.17 explicitly requires forward-looking adjustment — past write-off data calibrated to today's conditions, not simply pasted in.

Do all financial assets use this provision matrix?

Do all financial assets use this provision matrix? No. The provision matrix is the simplified approach, and it is only available for trade receivables without a significant financing component, contract assets under Eye-fers 15, and lease receivables. If your portfolio does not qualify — loans, bonds, or other financial assets measured at amortised cost — you use the general model instead. The general model uses three stages. Stage one: no significant increase in credit risk since origination — twelve months of expected credit loss. Stage two: there has been a significant increase in credit risk but the asset is not yet credit-impaired — lifetime expected credit loss. Stage three: the asset is credit-impaired — also lifetime expected credit loss. Same concept, different trigger.

How often must the loss allowance be refreshed ?

How often must the loss allowance be updated, and what happens if conditions improve? At every reporting date. The aging profile, loss rates, and forward-looking adjustments must be refreshed every period — not just when things get worse. If economic conditions improve, the allowance can decrease. Eye-fers 9 requires both upward and downward adjustments — it is not a one-way ratchet. The credit loss expense line in profit or loss reflects the movement: if the allowance falls, you recognise a credit, not a charge. Companies rebuilding after a recession can release provisions as forward-looking data improves. If your loss rates are unchanged from three years ago without documented evidence, that is an Eye-fers 9 compliance issue.

Official sources & references

Sources

Interpretations, amendments & paragraphs covered

Primary text: IFRS Foundation, issued standards. Educational summary only, always read the standard.

Keep going: related standards

Subscribe on YouTube