CECL loss-rate calculator for trade receivables.

What do the numbers come to once the work is shown?

Calculate the allowance with the historical loss-rate method or the roll-rate method, add a qualitative adjustment, and compare it to the amount recorded. The working is shown.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Method
Historical net write-offs
PeriodReceivables originated (credit sales)Net write-offs (after recoveries)Loss rate
0.676%
0.868%
0.808%
Qualitative adjustment and recorded allowance

An entity does not rely solely on past events: when it uses historical loss information it considers whether to adjust it for current conditions and reasonable and supportable forecasts (ASC 326-20-30-9). Document the evidence for each factor, such as unemployment, customer concentration or changes in credit terms.

Calculated allowance
$18,015
0.864% of the $2,084,000 balance
Base allowance
$16,378
Before the qualitative adjustment (+$1,638)
Calculated less recorded
-$33,985
Negative: recorded allowance may be too high
Watch
Recorded allowance may be $33,985 too high
An over-reserve can be a cushion. Ask why the rate or the adjustment supports a lower number, and consider the direction of the bias across estimates.
How this was worked out
Work shownrecomputed as you type
Weighted loss rate = Σ net write-offs ÷ Σ originations = 0.7859%
Simple average = mean of 3 period rates = 0.7839%
Base allowance = $2,084,000 × 0.7859% = $16,377.68
Adjusted = base × (1 + 10.00%) = $18,015.44

ASC 326-20 requires the allowance to reflect expected credit losses over the contractual life of the receivable, so a loss rate drawn from a stable history is a starting point, not the answer. Use net write-offs after recoveries, and make sure the originations or balances in the denominator match the pool the write-offs came from.

CECL for trade receivables in the audit file

ASC 326-20 requires an allowance for expected credit losses over the contractual life of a financial asset, measured on a collective basis when assets share risk characteristics (ASC 326-20-30-2), using relevant information about past events, current conditions and reasonable and supportable forecasts (ASC 326-20-30-7 and 30-9). The standard does not prescribe a method for trade receivables. A loss-rate method divides net write-offs by the receivables that produced them and applies the rate to the pool. A roll-rate method follows balances from one aging bucket to the next and multiplies the chances of rolling all the way to write-off. Both start from history, and both need an adjustment where today's conditions or the forecast differ from that history.

The qualitative adjustment can be entered as a percent of the base allowance or as percentage points of the balance. Either way, the auditor tests the reasonableness of the factors and the data behind them: completeness and accuracy of the write-off history, whether the pool is homogeneous, and whether the adjustment moves with the economic evidence. Compare the result with the recorded allowance and evaluate any difference against performance materiality, with the other estimates in mind for management bias (AU-C 540).

Common questions

What is the CECL historical loss-rate method?

Net write-offs (after recoveries) for a period divided by the receivables originated or outstanding in the same period gives a loss rate. Averaging that over several periods and applying it to the current pool gives the base allowance, which is then adjusted for current conditions and forecasts.

What is the roll-rate method?

It tracks the share of balances that move from one aging bucket to the next, for example current to 1-30 days past due, up to final write-off. The lifetime loss rate for a bucket is the product of the roll rates from that bucket onward, applied to the balance now in the bucket.

Weighted or simple average loss rate?

The weighted rate (all write-offs over all originations) gives larger periods more weight and is steadier when volumes vary. A simple average treats each period equally. Choose one, document why, and apply it consistently.

How do I support the qualitative adjustment?

Tie each factor to evidence: changes in credit policy, customer concentrations, delinquency trends, economic indicators and the reasonable and supportable forecast period. An adjustment with no evidence behind it is hard to defend.

Is there a simplification for current receivables?

ASU 2025-05 added an optional practical expedient for current accounts receivable and current contract assets that lets an entity assume conditions at the balance sheet date continue for the life of the asset. It is effective for fiscal years beginning after December 15, 2025, and interim periods within, with early adoption permitted. Check whether it has been elected before relying on it; this tool does not apply it.

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.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required