Apply a loss rate to each age bucket of the receivables, take the rates from your own write-off history, adjust them for current conditions, and reserve the troubled accounts one by one.
Multiply the balance in each aging bucket by a loss rate for that bucket and add the results. The loss rates come from a migration analysis: how much of each bucket was eventually written off at past year-ends. On receivables of $26,900,000 with rates from 0.5% (current) to 40% (over 90 days past due), the allowance is $780,000, or 2.90% of receivables.
Worked in full in The Commercial Credit Manager by Julian R. Sterling, with every figure reproduced in a free workbook.Get the PDF, $19.99 →or the paperback
The case is Brennick Industrial Supply, a fictional US distributor selling $168,000,000 a year on credit, mostly on net 30 terms. Its receivables at 31 December 2025 were $26,900,000, aged by due date. Under US GAAP, trade receivables fall under the expected credit loss model of ASC 326, and an aging-based loss-rate method is the usual way a company of this size applies it.
Take several past year-ends whose balances have fully run off. For each bucket, add up the balances, add up what was eventually written off from them (net of recoveries), and divide.
| Bucket | 2021 | 2022 | 2023 | Written off | Rate |
|---|---|---|---|---|---|
| Current | 14.9 | 15.8 | 16.2 | 235 | 0.5% |
| 1 to 30 days past due | 4.6 | 5.0 | 5.2 | 222 | 1.5% |
| 31 to 60 days past due | 1.8 | 2.0 | 2.1 | 295 | 5.0% |
| 61 to 90 days past due | 0.7 | 0.8 | 0.8 | 345 | 15.0% |
| Over 90 days past due | 0.6 | 0.7 | 0.8 | 756 | 36.0% |
Follow each invoice, not each bucket: a payment received later is credited to the bucket the invoice sat in at the year-end. That is what makes the rates comparable from one year to the next.
History is a starting point. At the end of 2025, 36.1% of the ledger was past due and a back-test showed that 38.0% of the $800,000 over 90 days past due at the end of 2024 had already been written off, above the three-year rate of 36%. The over 90 rate was raised to 40%, which added $36,000 to the reserve. The reason and the back-test went into a short memo for the auditor.
| Bucket | Balance | Rate | Reserve |
|---|---|---|---|
| Current | 17,200,000 | 0.5% | 86,000 |
| 1 to 30 days past due | 5,600,000 | 1.5% | 84,000 |
| 31 to 60 days past due | 2,300,000 | 5.0% | 115,000 |
| 61 to 90 days past due | 900,000 | 15.0% | 135,000 |
| Over 90 days past due | 900,000 | 40.0% | 360,000 |
| Total | 26,900,000 | 780,000 |
The two oldest buckets hold 6.7% of the receivables but $495,000 of the $780,000, more than three fifths of the reserve. Every dollar collected before it ages into them is worth more than its interest cost.
In March 2026 a customer owing $486,000 filed for Chapter 11. It left the pool and was reserved on its own:
$138,000 of goods received in the 20 days before the filing (priority claim) at 10% = 13,800
$348,000 general unsecured claim at 100% until the credit insurer accepted the claim = 348,000
Specific reserve = 361,800; after an insurance recovery of $313,200, recorded separately, the net charge was 48,600.
Using a single percentage of sales or of receivables, or rates copied from a peer. A flat rate cannot tell a ledger that is getting older from one that is getting younger, and rates that do not come from your own write-offs cannot be defended when the auditor asks where they came from. The second mistake is to judge the reserve by comparing one year's write-offs ($610,000 in the case) with the year-end allowance: write-offs come from earlier balances, so the bucket-by-bucket back-test is the real evidence.
The same aging drives DSO and its split in how to calculate best possible DSO and average days delinquent, and the limits that keep accounts out of the oldest buckets are set in how to set a customer credit limit.
Free Excel template: Credit Manager Workbook (DSO, CEI, credit limits and reserve).
Yes. ASC 326 does not prescribe a method, and an aging schedule with loss rates by bucket, drawn from the company's own history and adjusted for current conditions and reasonable forecasts, is a common way to apply it to trade receivables.
Issued by the FASB in July 2025, it lets companies assume that conditions at the balance sheet date do not change over the remaining life of current receivables, and gives private companies that use this expedient an election to consider collections after the balance sheet date. It applies to annual periods beginning after 15 December 2025, with earlier adoption permitted; confirm the treatment with your auditor.
Generally not. For US federal income tax, a business deducts a bad debt when it becomes worthless in whole or in part, under the specific charge-off method, so the write-off file matters to the tax return as well as to the audit.
This article is one calculation from The Commercial Credit Manager. The book follows one distributor's credit department through a year, from the first aging to a customer's Chapter 11 filing, and every figure it prints is a live formula in the free workbook.
Get the PDF edition, $19.99 Paperback · Free companion files