The aging method under CECL
ASC 326-20 (current expected credit losses, CECL) replaced the incurred-loss model. An entity estimates lifetime expected credit losses on trade receivables and records them as an allowance. An aging schedule with loss rates per bucket is one of the methods the standard illustrates for trade receivables, and it is a common choice for private companies.
The calculation is Σ (bucket balance × historical loss rate × (1 + adjustment)) + specific reserves. ASC 326-20-30-9 requires historical loss information to be adjusted for current conditions and reasonable and supportable forecasts that differ from the conditions in the historical period. Here that is one relative adjustment: +10% lifts a 2.0% loss rate to 2.2%. Customers in bankruptcy or with disputes are taken out of the pools and reserved individually.
For the auditor, the allowance is an accounting estimate under AU-C 540. A difference between your recalculation and the recorded allowance is a judgmental misstatement: post it to the summary of uncorrected misstatements if it is above your clearly trivial threshold. DSO and the share of balances over 90 days, shown in the working, help judge whether the rates still fit.
Common questions
How do you calculate the allowance from an accounts receivable aging?
Group receivables by days past due, multiply each bucket by its loss rate, and add the results. Under CECL the historical loss rates must be adjusted for current conditions and reasonable and supportable forecasts, and customers that do not share the pool’s risk are assessed separately.
Does CECL apply to trade receivables?
Yes. ASC 326-20 applies to financial assets measured at amortized cost, including trade receivables. It has been effective for all US GAAP entities, including private companies, since fiscal years beginning after December 15, 2022.
Do current receivables need an allowance under CECL?
Generally yes. CECL measures expected losses over the contractual life of the asset, so a balance that is not yet past due still carries some expected loss, usually a small rate. A zero allowance is acceptable only where the expectation of nonpayment is zero, which is rare for trade receivables.
How do I develop historical loss rates by aging bucket?
Track how balances move through the aging over past periods and what share is ultimately written off (net of recoveries) from each bucket, a roll-rate or migration analysis. Use enough history to cover a full collection cycle and be consistent from period to period.
How should an auditor test the allowance?
Test the aging report’s accuracy (invoice dates, buckets), recompute the loss rates from write-off history, evaluate management’s adjustment for current conditions and forecasts, review subsequent cash receipts, and compare the result with the recorded allowance. AU-C 540 governs auditing accounting estimates.
Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.