CECL calculator for trade receivables
Bring your accounts receivable aging report — from QuickBooks, Xero or your ledger, exactly as it exported — and get the allowance for credit losses under ASC 326, the journal entry and a draft note with the roll-forward. Free, with nothing to sign up for.
Credit loss allowance
Bring a loan tape or a receivables ageing.
Get the allowance, the journal entry and a draft disclosure note.
Checked against the standard
These are the FASB’s own worked examples, run through the same calculation your file goes through — not copied from the published answer.
Example 5 — aging schedule, adjusted for an improving outlook ASC 326-20-55-37 to 55-40
| Days past due | Receivables | Loss rate | Allowance |
|---|---|---|---|
| Current | $5,984,698 | 0.27% | $16,158.68 |
| 1–30 days past due | $8,272 | 7.2% | $595.58 |
| 31–60 days past due | $2,882 | 23.4% | $674.39 |
| 61–90 days past due | $842 | 52.2% | $439.52 |
| More than 90 days past due | $1,100 | 73.8% | $811.80 |
| Total | $5,997,794 | $18,679.97 |
The example prints $18,681 — each category rounded to the whole dollar, then added. The engine carries cents and adds first, giving $18,679.97; rounded category by category it gives $18,681. Same measurement, a different order of rounding.
Example 5A, Case 1 — the ASU 2025-05 practical expedient ASC 326-20-55-40A onward
| Days past due | Receivables | Loss rate | Allowance |
|---|---|---|---|
| Current | $5,984,698 | 0.3% | $17,954.09 |
| 1–30 days past due | $8,272 | 8% | $661.76 |
| 31–60 days past due | $2,882 | 26% | $749.32 |
| 61–90 days past due | $841 | 58% | $487.78 |
| 91–120 days past due | $554 | 82% | $454.28 |
| More than 120 days past due | $342 | 99% | $338.58 |
| Total | $5,997,589 | $20,645.81 |
The example prints $20,646 — the sum, rounded to the whole dollar. The engine's $20,645.81 rounds to the same figure.
What it does
- Reads the aging as your system printed it: the title lines, the bands across the top, the report’s own total line — which it leaves out rather than counting the book twice.
- Measures each balance at the loss rate for its days-past-due category, over its whole remaining life. No stages, no twelve-month horizon.
- Posts the provision — the change in the allowance after write-offs and recoveries — to credit loss expense, and drafts the note: the method, the practical expedient if you elected it, and the roll-forward ASC 326-20-50-13 asks for.
What it will not do yet
- Measure loans, leases, unfunded commitments or available-for-sale debt under CECL.
- Apply the private-company election to count collections after year end.
- Produce the vintage disclosures that apply only to public business entities.
Each of these is refused or left as a placeholder in the note, never approximated. Under IFRS 9 instead? Start from the front page.
Questions
Is an aging schedule allowed under CECL?
- Yes. ASC 326-20-30-3 lists an aging schedule among the methods an entity may use to estimate expected credit losses, and Example 5 at ASC 326-20-55-37 works one through for trade receivables.
Does the current bucket need a loss rate?
- Yes. Expected credit losses are measured even where the risk of loss is remote (ASC 326-20-30-10). In Example 5 the current bucket carries 0.27%, and it is most of the allowance.
What does the ASU 2025-05 practical expedient do?
- For current receivables and contract assets from contracts with customers, it lets you assume that conditions at the balance sheet date do not change over the assets' remaining life, instead of building a forecast (ASC 326-20-30-10C). You still adjust historical loss rates for current conditions. It applies to annual periods beginning after 15 December 2025, and it can be adopted early.
Can a private company count cash collected after year end?
- If it elects the practical expedient, yes (ASC 326-20-30-10E): balances collected before the statements are available to be issued carry no allowance, and what is left is aged as at that later date. That can raise the allowance as well as lower it. This calculator does not apply that election yet.
Does it measure loans under CECL?
- Not yet. CECL measures a loan over its whole life from the day it is made, which is a different method from IFRS 9's, so a loan in a US GAAP assessment is refused rather than approximated.
Where does my file go?
- It is sent to be measured and stored nowhere once the answer comes back. Your work is kept in your own browser, and there is nothing to sign up for.