The simplified approach: a provision matrix for receivables

If you are looking for how to calculate a bad debt provision under IFRS 9, this is it. The simplified approach replaced the old practice of providing only for doubtful invoices with a forward-looking provision on every receivable, including current ones. This guide builds a provision matrix step by step, with an Excel model you can use on your own ageing report.

By Awais Jameel, Chartered Accountant. Reviewed by Muhammad Bilal, Chartered Accountant. Checked against official sources on . 3 minute read.

Short answer

A provision matrix is the most common way to measure expected credit losses on trade receivables under IFRS 9's simplified approach. It groups receivables by ageing, applies a historical loss rate to each bucket, adjusts the rates for current and forecast conditions, and multiplies them by the balances at the reporting date. For CU 500,000 of receivables in this guide's example, the loss allowance, often still called the bad debt provision, is CU 12,430.

At a glance

Applies to
Trade receivables and contract assets
Approach
Simplified: lifetime ECL from day one
Method
Provision matrix by ageing
Rates from
Historical losses, adjusted forward
Example allowance
CU 12,430
Excel
ECL provision matrix
The simplified approach: a provision matrix for receivablesSteps: 1. Group the receivables; 2. Choose the ageing buckets; 3. Calculate historical loss rates; 4. Adjust for forward-looking information; 5. Apply the rates to today's balances.THE PROCESS AT A GLANCEThe simplified approach: a provision matrix forreceivables1Group thereceivablesSegment by sharedcredit riskcharacteristics, suchas customer type,geography or product2Choose the ageingbucketsCurrent, then bands ofdays past due, such as1 to 30, 31 to 60, 61to 90 and over 903Calculatehistorical lossratesFor each bucket,compare the balances atpast year ends with…4Adjust forforward-lookinginformationRaise or lower therates for how currentand forecast conditions5Apply the ratesto today'sbalancesMultiply each bucket'sbalance by its adjustedrateChecked against official sourcesTax BakersThe simplified approach: a provision matrix for receivablesSteps: 1. Group the receivables; 2. Choose the ageing buckets; 3. Calculate historical loss rates; 4. Adjust for forward-looking information; 5. Apply the rates to today's balances.THE PROCESS AT A GLANCEThe simplified approach: aprovision matrix for receivables1Group the receivablesSegment by shared credit riskcharacteristics, such as customer type,geography or product2Choose the ageing bucketsCurrent, then bands of days past due, suchas 1 to 30, 31 to 60, 61 to 90 and over 903Calculate historical loss ratesFor each bucket, compare the balances atpast year ends with the amounts laterwritten off4Adjust for forward-lookinginformationRaise or lower the rates for how current andforecast conditions, such as unemployment,interest rates5Apply the rates to today'sbalancesMultiply each bucket's balance by itsadjusted rate and add up the resultsChecked against official sourcesTax Bakers
The process at a glance: 1. Group the receivables; 2. Choose the ageing buckets; 3. Calculate historical loss rates; 4. Adjust for forward-looking information; 5. Apply the rates to today's balances.

What is the simplified approach?

For trade receivables and contract assets that do not contain a significant financing component, IFRS 9 requires the loss allowance to equal lifetime expected credit losses from the day the receivable is recognised. There is no need to track whether credit risk has increased, which is what makes it simple. Companies may also choose the simplified approach as a policy for receivables with a financing component and for lease receivables. A provision matrix is a practical way of applying it, explicitly mentioned in IFRS 9.

How do you build a provision matrix?

  1. Group the receivables

    Segment by shared credit risk characteristics, such as customer type, geography or product. Retail customers and large corporates usually need separate matrices.

  2. Choose the ageing buckets

    Current, then bands of days past due, such as 1 to 30, 31 to 60, 61 to 90 and over 90.

  3. Calculate historical loss rates

    For each bucket, compare the balances at past year ends with the amounts later written off. Use a period long enough to be representative.

  4. Adjust for forward-looking information

    Raise or lower the rates for how current and forecast conditions, such as unemployment, interest rates or the customer sector's health, differ from the historical period.

  5. Apply the rates to today's balances

    Multiply each bucket's balance by its adjusted rate and add up the results.

A provision matrix example

A distributor's history shows the loss rates below. Because economic forecasts are weaker than in the historical period, it increases every rate by 10%.

AgeingReceivables (CU)Historical loss rateForward-looking rateExpected credit loss (CU)
Current400,0000.8%0.88%3,520
1 to 30 days60,0002.5%2.75%1,650
31 to 60 days20,0006.0%6.60%1,320
61 to 90 days12,00015.0%16.50%1,980
Over 90 days8,00045.0%49.50%3,960
Total500,0002.49%12,430
Expected credit loss by ageing bucketExpected credit loss by ageing bucket3,520Current1,6501 to 30 days1,32031 to 60 days1,98061 to 90 days3,960Over 90 daysExpected credit loss (CU)
The oldest balances are small but carry most of the loss rate; current balances still carry an allowance.

The allowance at the start of the year was CU 10,000, so the year's impairment charge is CU 2,430: Dr Impairment loss, Cr Loss allowance. Notice that current receivables, which nobody would have provided for under the old rules, carry CU 3,520 of the allowance.

Can you build it in Excel?

Yes. The ECL provision matrix (Excel) derives the historical loss rates from three years of balances and write-offs, applies your forward-looking adjustment to the current ageing, and produces the charge for the year and the journal entry. It also includes a three-stage calculator for loans.

What do auditors look for?

  • Evidence for the forward-looking adjustment, linked to specific economic indicators, not a round number added by habit.
  • Segments that reflect real differences in credit risk.
  • Specific provisions for individual customers known to be in difficulty, on top of the matrix, without double counting.
  • Consistent treatment of credit insurance and collateral.

How does this differ from the old bad debt provision?

Under IAS 39, companies provided only for receivables with objective evidence of impairment, such as a customer in liquidation. The IFRS 9 provision matrix covers every receivable, including those not yet due, and looks forward. The allowance is usually higher and moves earlier when the economy weakens. For the general approach used for loans, see expected credit losses: the three stages.

Need help applying the standards?

Our Chartered Accountants help finance teams and students apply IFRS and US GAAP to real transactions.

Questions people ask

What is a provision matrix under IFRS 9?

A table of loss rates by ageing bucket, based on historical losses adjusted for forward-looking information, applied to current receivables to measure lifetime expected credit losses.

How do you calculate a bad debt provision under IFRS 9?

Group receivables, calculate historical loss rates by ageing bucket, adjust them for current and forecast conditions, and multiply by the balances at the reporting date.

Is the simplified approach mandatory for trade receivables?

Yes, for trade receivables and contract assets without a significant financing component.

Do current receivables need a provision under IFRS 9?

Yes. Expected credit losses apply to all receivables, including those not yet due.

Sources

Every fee, date and rule on this page was taken from these official and primary sources.

  1. IFRS Foundation: IFRS 9 Financial Instruments

Rules and fees change. If you are reading this long after October 4, 2026, confirm the figures with the source before you rely on them.

More in IFRS 9

This guide is general information. It is not tax or legal advice for your situation.