CECL Trade Receivables Estimator
The Current Expected Credit Loss (CECL) standard under ASC 326 requires entities to recognise an allowance for lifetime expected credit losses on financial assets measured at amortized cost, including trade receivables — replacing the prior incurred-loss model.
This estimator supports four calculation methods: the Aging Schedule (provision matrix) default, PD × LGD, Vintage / Cohort analysis, and Discounted Cash Flow. The Aging Schedule method — the most common approach for trade receivables — applies historical loss rates to each aging bucket and includes a forward-looking macroeconomic adjustment per ASC 326-20-30-9.
Applied as a multiplier: ACL = Σ(bucket ECL) × (1 + adj%). Reflects reasonable and supportable forecasts per ASC 326-20-30-9. Leave blank for no adjustment.
Enter the outstanding balance and the historical loss rate for each aging bucket. The estimator applies each rate to its bucket balance, sums the pooled ECL estimates, then applies the forward-looking macroeconomic adjustment as a multiplicative factor on the total — representing the qualitative adjustment required by ASC 326-20-30-9. A positive adjustment (e.g. +5%) increases the ACL to reflect deteriorating conditions; a negative value reduces it for improving conditions.