Explaining IFRS 9: Calculating Historical Loss Rates for Your Trade Receivables

IFRS 9's Expected Credit Loss (ECL) model often sounds complex, but for many businesses, particularly regarding their trade receivables, it's far more straightforward. If you're managing a portfolio of short-term invoices, the good news is that the 'Simplified Approach' under IFRS 9 applies, making the calculation less daunting. This post focuses on a practical, step-by-step guide to calculating historical loss rates, a cornerstone of your ECL provision for trade receivables.

Unlike complex financial instruments that require a detailed 'three-stage' model, IFRS 9 allows entities to use a simplified approach for trade receivables without a significant financing component. This means you don't need to track individual credit risk changes over time. Instead, you can rely on a 'provision matrix' based on historical data, which significantly streamlines the process. The heart of this matrix lies in accurately calculating your past credit losses.

To begin, you'll need robust historical data. We recommend looking back at least three to five years – enough time to capture various economic cycles without going too far back that the data becomes irrelevant to your current customer base and credit policies. For each period, you'll need two main sets of information: your total gross trade receivables by age bucket, and the actual write-offs or defaults that originated from those receivables.

The first practical step is to segment your trade receivables into 'aging buckets'. These are the familiar categories you likely already use:

* Current (not yet due)

* 1-30 days overdue

* 31-60 days overdue

* 61-90 days overdue

* 91+ days overdue (or more granular, e.g., 91-180 days, 180+ days)

Consistency is key here. Ensure your historical data uses the same aging categories.

For each reporting date in your historical look-back period (e.g., end of each month or quarter), identify the total gross value of trade receivables outstanding within each of these aging buckets. This gives you the 'exposure' at different stages of delinquency.

This is a critical step. For each aging bucket and each historical period, you need to track the actual amount of receivables that eventually defaulted or were written off. It's important to link these write-offs back to the aging bucket they were in at a specific point in time. For example, if a receivable was 31-60 days overdue in June 2021 and was eventually written off in December 2021, that write-off contributes to the loss rate for the '31-60 days overdue' bucket from June 2021. Don't just look at when the write-off occurred, but trace it back to its 'state' when you were measuring exposure.

Computing Your Historical Loss Rates

Now for the core calculation! For each aging bucket, you'll calculate a historical loss rate.

Historical Loss Rate (for a specific aging bucket) = (Total Value of Actual Write-offs Traced to that Bucket over the historical period) / (Total Gross Receivables that ever fell into that Bucket over the historical period)

Let's say over the last three years:

* Total gross receivables that were "31-60 days overdue" at any point: $10,000,000

* Total actual write-offs that originated from these "31-60 days overdue" receivables: $300,000

* Your historical loss rate for the "31-60 days overdue" bucket would be $300,000 / $10,000,000 = 3%.

Repeat this calculation for every aging bucket. You'll end up with a set of percentages, typically increasing as the receivables get older – reflecting higher credit risk.

Once you have these historical loss rates, you apply them to your current outstanding trade receivables in each respective aging bucket. The sum of these calculated expected losses across all buckets forms your IFRS 9 ECL provision for trade receivables.

While historical loss rates are a strong foundation, IFRS 9 also requires considering 'forward-looking information'. This means adjusting your historical rates if current or future economic conditions (e.g., a recession, industry downturn, changes in customer base) are expected to differ significantly from the historical period. This forward-looking adjustment adds robustness but starts after you've established your baseline historical rates.

Calculating historical loss rates for trade receivables under IFRS 9's Simplified Approach is a practical exercise that transforms complex accounting requirements into manageable steps. By meticulously gathering data, segmenting your receivables, and carefully tracing actual defaults, you can build a reliable provision matrix. This not only ensures compliance but also provides useful insights into your credit risk exposure. At Lux Actuaries, we help businesses navigate these calculations, turning complexity into clarity.