IFRS 9 Provision Matrix: Calculating ECL on Trade Receivables

An **IFRS 9 provision matrix** lets you calculate the expected credit loss (ECL) on trade receivables by applying a loss rate to each ageing bucket. You build those rates from your own **historical default experience**, then **adjust them for forward-looking information**. Under IFRS 9's simplified approach, trade receivables without a significant financing component always carry a **lifetime ECL allowance**, and the provision matrix is the most common way to measure it. This guide works through a full expected credit loss calculation, from raw payment data to the year-end journal entries, in clear, plain language. It follows on from our guide to the [journal entry for a provision for doubtful debts](https://www.learnsignal.com/blog/journal-entry-of-provision-for-doubtful-debts/) and is useful for ACCA Financial Reporting and SBR students as well as practising accountants. (Always check the current version of IFRS 9 and any local equivalent, as standards and guidance are updated from time to time.) ## What the IFRS 9 simplified approach requires Under the general model, which our guide to [the ECL three-stage model](https://www.learnsignal.com/blog/expected-credit-loss-ifrs-9-three-stage-model) explains, entities track whether credit risk has increased significantly. The simplified approach removes that tracking. For trade receivables and contract assets with no significant financing component, Deloitte notes that [an entity "must always apply the 'simplified approach'"](https://iasplus.com/content/a3cc19fb-0b66-41bf-999c-96070c9873e8). Where receivables _do_ contain a significant financing component, the simplified approach is an accounting policy choice. IFRS 9 doesn't make the matrix compulsory. PwC describes it as [a suggested method that "is not mandatory"](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf). Whatever method you use, the estimate still has to reflect [an unbiased, probability-weighted amount, the time value of money, and reasonable and supportable information](https://iasplus.com/content/a3cc19fb-0b66-41bf-999c-96070c9873e8) about past events, current conditions and forecasts. The IASB's own illustration is **Example 12 in the IFRS 9 Illustrative Examples**. A manufacturer with [CU30 million of trade receivables applies default rates from 0.3% (current) to 10.6% (more than 90 days past due)](https://www.ifrs.org/content/dam/ifrs/publications/html-standards/english/2024/issued/ifrs9-ie.html), giving a total allowance of CU580,000. It's worth reading. It shows the final matrix but not how the rates were derived, and that derivation is what the steps below cover. ## What you need before you start Gather these before you open a spreadsheet: - **An aged receivables listing at the reporting date**: balances split by days past due, using the same buckets you'll use for the rates. - **Historical sales and cash receipts data**: enough to trace how invoices raised in a past period were paid, and how much was never collected. - **Write-off records**: amounts written off, linked back to the sales they came from. - **Forward-looking indicators**: the economic or sector data that moves your customers' ability to pay. - **The opening loss allowance and in-year write-offs**: these are needed for the journal entry. ## How to build an IFRS 9 provision matrix: a worked example Consider **Harlow Components Ltd**, a hypothetical UK wholesaler with a 31 December 2026 year end. Its customers are mostly small trade businesses on 30-day terms. Its gross trade receivables are **£1,450,000**. ### Step 1: Group receivables by shared credit risk A single matrix only works if the customers in it behave alike. Deloitte suggests [groupings such as geographical region, product type, customer rating, collateral or trade credit insurance, and type of customer](https://iasplus.com/content/a3cc19fb-0b66-41bf-999c-96070c9873e8). Harlow's customers share one region and one customer type, so it uses one matrix. **How to tell it worked:** loss patterns within each group should look broadly similar. If one segment's history is clearly different, give it its own matrix. ### Step 2: Choose the historical period and trace payments Pick a period long enough to be representative. PwC says it [could be "one year, three years or even longer"](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf), depending on the business cycle, and Deloitte notes that [in practice it "could span two to five years"](https://iasplus.com/content/a3cc19fb-0b66-41bf-999c-96070c9873e8). Then trace how much of the sales from that period was still unpaid as it passed through each bucket. For Harlow (hypothetical figures), **£2,000,000** of credit sales passed through "current". Of that, £640,000 reached 1–30 days past due, £200,000 reached 31–60 days, £80,000 reached 61–90 days and £40,000 went beyond 90 days. In the end, **£16,000 was written off**. ### Step 3: Calculate historical loss rates for each bucket Divide the **total eventual loss by the amount that reached each bucket**. This follows the method in [PwC's worked example, where the loss of CU300 is divided by the amount outstanding in each time bucket](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf). The logic is that every pound eventually written off once sat in every earlier bucket. That's why older debts carry higher rates. | Bucket | Amount reaching bucket | Loss | Historical rate | | --- | --- | --- | --- | | Current | £2,000,000 | £16,000 | 0.8% | | 1–30 days | £640,000 | £16,000 | 2.5% | | 31–60 days | £200,000 | £16,000 | 8.0% | | 61–90 days | £80,000 | £16,000 | 20.0% | | Over 90 days | £40,000 | £16,000 | 40.0% | **How to tell it worked:** the rates should rise steadily with age. If they don't, check the data before going further. ### Step 4: Adjust the rates for forward-looking information Historical rates reflect the economy of the past, not the economy at the reporting date. PwC lists indicators such as [inflation or growth rates, unemployment rates, interest rates or FX rates](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf), along with industry- and geography-specific signals. Harlow's customers are mainly construction trades, and sector forecasts point to weaker conditions. Based on how its losses moved in past downturns, management applies a **20% uplift** to every rate (a hypothetical judgement, and the one that needs the most careful documentation). Adjusted rates: **0.96%, 3.0%, 9.6%, 24% and 48%**. ### Step 5: Pull out debtors that need individual assessment A customer known to be in difficulty may need a specific estimate. PwC warns that you then need to [avoid "double counting of losses"](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf) by keeping that balance out of the general matrix. Harlow's over-90-day bucket of £30,000 includes **£20,000 owed by a customer in administration**. The administrator indicates about 10% recovery, so Harlow sets an individual ECL of **£18,000** and runs only the remaining £10,000 through the matrix. ### Step 6: Apply the rates to the year-end ageing Multiply each bucket's balance by its adjusted rate and add up the results: | Bucket | Balance at 31 Dec 2026 | Adjusted rate | ECL | | --- | --- | --- | --- | | Current | £900,000 | 0.96% | £8,640 | | 1–30 days | £350,000 | 3.0% | £10,500 | | 31–60 days | £120,000 | 9.6% | £11,520 | | 61–90 days | £50,000 | 24% | £12,000 | | Over 90 days (matrix) | £10,000 | 48% | £4,800 | | Matrix total | £1,430,000 | | £47,460 | | Individually assessed | £20,000 | | £18,000 | | Total loss allowance | £1,450,000 | | £65,460 | **How to tell it worked:** the balances should agree to the aged listing and the ledger. The overall allowance, here about 4.5% of gross receivables, should also make sense against recent write-off experience. ## Journal entries for the expected credit loss The allowance is a **closing balance**, so the profit or loss charge is whatever movement brings the account to £65,460. Harlow's opening allowance was **£52,000**, and **£9,000** of debts were written off against it during the year. **1\. In-year write-offs** (recorded as they happened): - Dr Loss allowance £9,000 - Cr Trade receivables £9,000 **2\. Year-end adjustment.** The allowance stands at £43,000 (£52,000 − £9,000) and needs to be £65,460, so the charge is £22,460: - Dr Impairment loss on trade receivables (profit or loss) £22,460 - Cr Loss allowance £22,460 Trade receivables appear in the statement of financial position at **£1,384,540** net (£1,450,000 − £65,460). If the required allowance had fallen, the entry would reverse and give a credit to profit or loss. The mechanics are the same as the old doubtful debt provision. The difference is how the closing figure is measured. ## Common mistakes to avoid Most errors in a provision matrix come from a handful of shortcuts: - **Using one flat rate for every bucket**: PwC's guide points out that [older receivables have "a higher loss rate"](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf), so a single percentage rarely satisfies IFRS 9. - **Skipping the forward-looking step**: an unadjusted historical rate assumes the future will match the past. That needs its own justification. - **Assuming no history means no allowance**: even with no past defaults, PwC says [a provision "will still be required"](https://www.pwc.ch/en/publications/2020/IFRS%209%20-%20Impairment%20-%20Provision%20Matrix%20-%20Practical%20Guide.pdf), using external data such as credit ratings or industry loss information. - **Treating credit insurance as zero risk**: credit enhancements can reduce the size of a loss, but they don't remove the need to calculate an allowance. - **Never updating the rates**: in the IASB's example, [historical observed default rates are updated at every reporting date](https://www.ifrs.org/content/dam/ifrs/publications/html-standards/english/2024/issued/ifrs9-ie.html). For the wider picture, covering classification, measurement and hedge accounting, see our [complete guide to IFRS 9 Financial Instruments](https://www.learnsignal.com/blog/ifrs-9-financial-instruments-guide/). ## Build your financial reporting skills with Learnsignal A provision matrix is simple arithmetic built on a lot of **judgement**: how to group customers, which period to use and how far to adjust for the outlook. Your first practical step is to pull last year's aged debtor reports and trace one cohort of sales through to cash or write-off, so you can see your own loss rates. Learnsignal's tutor-led ACCA courses and our [IFRS 9 Financial Instruments CPD guide](https://www.learnsignal.com/blog/ifrs-9-financial-instruments-cpd) build that foundation, with flexible, supported online study that fits around work.