Ind AS 109 expected credit loss on trade receivables: building a provision matrix

Under Ind AS 109, impairment of financial assets is based on expected credit losses, not on losses that have already been incurred. For trade receivables most companies use the simplified approach: the loss allowance is always measured at lifetime expected credit losses (para 5.5.15), and a provision matrix is an accepted practical expedient for estimating it (para B5.5.35). This article explains how to build one that stands up to review.

1. When the simplified approach applies

The simplified approach is required for trade receivables and contract assets that do not contain a significant financing component, and is a policy choice for those that do and for lease receivables. You do not need to track whether credit risk has increased significantly since initial recognition, which is what makes it practical for large receivable books.

2. Segment the receivables

A single matrix for the whole book only works if customers share similar credit risk. Typical segments are government and PSU customers, large corporates, dealers or distributors, retail, and related parties. Segment on characteristics that actually drive collection behaviour, and keep the basis consistent from year to year.

3. Choose the ageing buckets

Use days past due, not days since invoice, so that credit terms do not distort the picture. A common set is: not due, 1–30, 31–90, 91–180, 181–365, and more than 365 days past due. Ind AS 109 has a rebuttable presumption that default does not occur later than 90 days past due (para B5.5.37), so make sure your buckets and default definition are consistent with your credit policy.

4. Calculate historical loss rates

Two methods are common.

Roll rates: for each bucket, what share of the balance moved to the next bucket in the following period. Multiplying the roll rates from a bucket through to write-off gives its loss rate.
Cohort / vintage: follow each period's invoices to final collection and measure the share eventually written off.

Use at least two to three years of data where you have it. Exclude amounts that were settled by credit notes for commercial reasons, because those are not credit losses. Treat recoveries after write-off as reductions of losses.

5. Add forward-looking information

History has to be adjusted for current conditions and reasonable, supportable forecasts (para 5.5.17). In practice this is an overlay: for example increase loss rates by a percentage when industry stress, a slowdown in the customer segment, or an increase in GDP-linked default indicators is expected. The overlay must be explained, approved and back-tested next year. A forward-looking factor of zero is acceptable only if you can show why.

6. A worked provision matrix

Bucket (days past due)	Balance (₹ lakh)	Historical loss rate	Forward-looking factor	ECL rate	Allowance (₹ lakh)
Not due	400.0	0.5%	+10%	0.55%	2.2
1–30	150.0	1.5%	+10%	1.65%	2.5
31–90	80.0	5.0%	+10%	5.50%	4.4
91–180	40.0	20.0%	+10%	22.00%	8.8
181–365	20.0	50.0%	+10%	55.00%	11.0
> 365	10.0	100.0%	n/a	100.00%	10.0
Total	700.0				38.9

If the opening allowance was ₹30.0 lakh and ₹4.0 lakh was written off during the year, the charge for the year is 38.9 − (30.0 − 4.0) = ₹12.9 lakh.

Impairment loss on trade receivables (P&L)   Dr  12.9
    To Allowance for expected credit loss         12.9

The Template E workbook builds this matrix from your own history and produces the movement schedule.

7. Specific provisions and write-offs

Customers in insolvency proceedings, under dispute, or otherwise known to be credit-impaired should be assessed individually and taken out of the matrix to avoid double counting. Write off a receivable when there is no reasonable expectation of recovery (para 5.4.4); enforcement activity can continue after write-off.

8. What to document

The segmentation logic and why it reflects shared credit risk.
The data used for loss rates, the period covered and any exclusions.
The forward-looking overlay: indicators considered, the number chosen and who approved it.
A back-test of last year's allowance against actual losses.
Reconciliation of the ageing to the trade receivables ledger and the balance sheet.

Disclosures under Ind AS 107 include the credit risk management policy, the inputs and assumptions used, and the reconciliation of the loss allowance from opening to closing balance.