What the allowance for doubtful accounts is
The allowance for doubtful accounts is a contra-asset account that sits directly beneath accounts receivable and reduces it to the amount you actually expect to collect. Gross receivables of $500,000 with a $16,300 allowance are reported at a net realizable value of $483,700, and that net figure is what a reader of your balance sheet treats as a claim on future cash.
The account exists because of timing. You recognise revenue and a receivable when you ship, but you do not learn which customers will default until months later. Waiting for that news — the direct write-off method — puts the loss in the wrong period and overstates receivables in the meantime, which is why US GAAP only tolerates it for immaterial amounts. The allowance method instead estimates the loss in the same period as the sale, so the cost of extending credit sits next to the revenue it produced.
Under ASC 326 the estimate is explicitly forward-looking: you record expected credit losses over the life of the receivable, using historical loss experience adjusted for current conditions and reasonable and supportable forecasts. A rate ladder applied to an aging schedule — a provision matrix — is the standard way small and mid-sized reporters do this, and it is the method this calculator implements.
How the aging method builds the number
You split receivables by how far past due each invoice is, then apply a loss rate to each bucket and add the results. The rates climb steeply with age because the probability of collection falls steeply: an invoice thirty days late is usually just slow paperwork, while one ninety days late means the customer has a reason not to pay.
The rates must come from your own experience, not from a template. Take three to five years of receivables by bucket, trace what each bucket eventually paid, and compute the loss rate per bucket. Then adjust for anything the history cannot know — a recession in your customers' industry, a shift toward smaller accounts, the loss of credit insurance, a change in your own collection staffing. Documenting that adjustment is what ASC 326 requires and what your auditor will ask to see.
Two variations matter. This method sets the balance of the allowance directly, so the expense falls out as the plug: whatever is needed to move the existing balance to the required one. The percentage-of-credit-sales method instead sets the expense as a percentage of the period's credit sales and lets the balance accumulate, which is faster to run monthly but drifts away from the aging over time. Most companies use sales percentages during the year and true the balance up to an aging at year end. The bad debt expense calculator works the entry from either direction.
Large balances are the exception to pooling. ASC 326 requires you to pool receivables that share risk characteristics; a single customer whose receivable is a tenth of the ledger, or one already in bankruptcy, does not share risk with anyone and should be evaluated on its own and removed from the pool before the rates are applied.
Worked example: a $500,000 ledger with a $9,500 existing allowance
Your aging report at 31 December shows $320,000 current, $105,000 one to thirty days past due, $45,000 thirty-one to sixty, $18,000 sixty-one to ninety, and $12,000 over ninety. Your loss history, adjusted upward slightly for a weakening customer sector, gives rates of 0.5%, 2%, 8%, 20% and 45%. The allowance already carries a $9,500 credit balance after this year's write-offs.
- Current. $320,000 × 0.5% = $1,600
- 1–30 days. $105,000 × 2% = $2,100
- 31–60 days. $45,000 × 8% = $3,600
- 61–90 days. $18,000 × 20% = $3,600
- Over 90 days. $12,000 × 45% = $5,400
- Required allowance. $1,600 + $2,100 + $3,600 + $3,600 + $5,400 = $16,300
- Adjusting entry. $16,300 − $9,500 already on the books = $6,800: debit Bad Debt Expense $6,800, credit Allowance for Doubtful Accounts $6,800.
- Balance sheet presentation. $500,000 gross less $16,300 allowance = $483,700 net realizable value.
The blended rate is $16,300 ÷ $500,000 = 3.26%, and 36% of the ledger is past due. Notice that the $12,000 over-90 bucket is only 2.4% of receivables but supplies a third of the reserve — which is exactly why the mix matters more than the total.
How to read the result
Judge the blended rate against your own write-off history first, not against an industry figure. If the allowance has run at 3% of receivables for three years while actual write-offs have run at 0.4% of receivables, you are carrying an excess reserve: it depressed earnings in the years it was built and will lift earnings in whatever year it is released. If write-offs consistently exceed the allowance you set, the estimate is too thin and every year opens with a catch-up charge. A useful check is coverage: the allowance divided by trailing twelve-month write-offs tells you how many years of normal losses the reserve would absorb.
For diversified business-to-business ledgers with functioning credit control, allowances of roughly 1% to 3% of gross receivables are common, and consumer or subprime portfolios run far higher. Treat those as orientation, not benchmarks — a construction subcontractor with retentions and a software vendor billing annual subscriptions in advance have genuinely different loss profiles.
Then read the aging itself, because it moves before the loss does. A past-due share drifting from 25% to 40%, or an over-90 bucket doubling, tells you about collection performance months before anything is written off. Pair this with days sales outstanding and receivables turnover: rising DSO plus a thickening tail is the classic signature of a ledger going bad, and it flows through to the cash conversion cycle as a real financing cost.
The allowance also moves your ratios: it cuts receivables, so it cuts the numerator of the quick ratio and working capital, while the offsetting charge reduces retained earnings by the same amount.
How the required allowance changes with the aging mix
| Aging profile | Current | 1–30 | 31–60 | 61–90 | 90+ | Required allowance | Blended rate |
|---|---|---|---|---|---|---|---|
| Tight collections | $400,000 | $70,000 | $20,000 | $7,000 | $3,000 | $7,750 | 1.55% |
| Typical | $320,000 | $105,000 | $45,000 | $18,000 | $12,000 | $16,300 | 3.26% |
| Slipping | $240,000 | $120,000 | $70,000 | $40,000 | $30,000 | $30,700 | 6.14% |
| Distressed | $150,000 | $100,000 | $90,000 | $80,000 | $80,000 | $61,950 | 12.39% |
Gross receivables are identical in all four rows, yet the required reserve varies eightfold. This is why a ratio of allowance to total receivables is meaningless without the aging behind it.
Mistakes that produce the wrong allowance
- Forgetting the balance already on the books. The aging method gives you the required balance. Posting that full amount as expense double-counts every reserve you carried forward.
- Writing an account off to bad debt expense. A write-off debits the allowance and credits receivables. It never touches expense, because the expense was recorded when the allowance was set up.
- Aging from the invoice date instead of the due date. On net-60 terms, an invoice 45 days old is not past due at all. Aging by invoice date inflates every late bucket.
- Using generic loss percentages. Rates borrowed from a textbook are not "reasonable and supportable" evidence. Derive them from your own collection history and document the adjustments.
- Leaving out forward-looking information. ASC 326 requires expectations about the future, not just the past. A pure historical average during a downturn understates the reserve.
- Pooling a dominant customer. Individually significant or already-distressed balances must be assessed separately and removed from the pooled buckets.
- Assuming the reserve is tax deductible. For US federal tax the deduction generally comes only when a specific debt becomes worthless under IRC §166. The book allowance creates a deferred tax asset instead.
- Netting a credit balance into the aging. Customer overpayments and unapplied credits belong in a separate liability line, not as a negative in an aging bucket where they hide real exposure.
Related methods and how the standards differ
The aging method is one of several acceptable routes to an expected-loss estimate. A roll-rate model tracks the historical probability that a balance migrates from one bucket to the next and chains those probabilities into a lifetime loss; it is more sensitive than a static ladder and suits high, homogeneous volumes. A discounted cash flow approach fits individually significant receivables on extended payment plans. Percentage of credit sales remains the practical choice for monthly closes.
US GAAP and IFRS arrive at nearly the same place by different routes. ASC 326 replaced the old "probable" incurred-loss threshold with current expected credit losses, so a loss is reserved from day one of the receivable's life. IFRS 9 uses a three-stage model in general, but for trade receivables without a significant financing component it mandates the simplified approach — lifetime expected losses, measured in practice with exactly this kind of provision matrix.
None of it affects your tax return. The allowance is a book estimate; the US deduction under IRC §166 waits for a specific debt to be established as worthless, which is why the allowance shows up as a deferred tax asset.
Which standard applies, and from when
The governing US guidance is FASB ASC 326, Financial Instruments — Credit Losses, introduced by ASU 2016-13. It became effective for SEC filers other than smaller reporting companies in fiscal years beginning after 15 December 2019, and for all other entities — private companies, not-for-profits and smaller reporting companies — in fiscal years beginning after 15 December 2022. Trade receivables are in scope. Under IFRS the equivalent is IFRS 9, Financial Instruments, whose simplified approach for trade receivables requires lifetime expected credit losses. Both frameworks require the loss-rate assumptions to reflect current conditions and forecasts, and both require you to document how you got them.
Key terms
- Contra-asset account
- An account with a credit balance that is presented as a deduction from a related asset. The allowance reduces accounts receivable without touching individual customer balances.
- Net realizable value
- Gross receivables less the allowance — the cash you expect the ledger to produce, and the amount presented on the balance sheet.
- Aging schedule
- A report splitting each customer balance by how long it has been outstanding past its due date, normally in thirty-day bands.
- Write-off
- Removing a specific uncollectible balance: debit the allowance, credit accounts receivable. Net receivables and expense are both unchanged.
- Recovery
- Cash arriving on a balance already written off. You reinstate the receivable and the allowance, then record the collection normally.
- Provision matrix
- The grid of aging buckets and loss rates used to measure expected credit losses on trade receivables under ASC 326 and IFRS 9.
- CECL
- Current expected credit losses — the ASC 326 model requiring lifetime expected losses to be recognised when the receivable arises, not when default becomes probable.