Percentage of Sales vs Aging Method: Bad Debt Estimation Worked Examples
A side-by-side walkthrough of the two GAAP-permitted approaches to estimating uncollectible accounts under the allowance method — income statement (percentage of sales) and balance sheet (aging of receivables) — with full journal entries and reconciliations.
A side-by-side walkthrough of the two GAAP-permitted approaches to estimating uncollectible accounts under the allowance method — income statement (percentage of sales) and balance sheet (aging of receivables) — with full journal entries and reconciliations.
Learning Objectives
- ✓Apply the percentage of sales method (income statement approach) to estimate bad debt expense.
- ✓Apply the aging method (balance sheet approach) to determine the required allowance.
- ✓Reconcile the existing allowance balance to the desired ending balance under each method.
1. Direct Answer: How the Two Methods Differ
The percentage of sales method estimates bad debt EXPENSE as a fixed percentage of net credit sales, debited directly to bad debt expense regardless of the current allowance balance. The aging method estimates the required ending ALLOWANCE balance by stratifying accounts receivable into age buckets (0-30 days, 31-60, 61-90, over 90), applying an estimated uncollectible percentage to each bucket, and adjusting the allowance to that target through a plug entry. The percentage-of-sales method emphasizes matching (expense recognized when revenue is recognized); the aging method emphasizes balance sheet accuracy (the receivable is reported at net realizable value). GAAP permits both but most large public companies favor aging because auditors can test the bucket percentages against historical write-offs.
Key Points
- •Percentage of sales = income statement focus (matches expense to revenue).
- •Aging = balance sheet focus (reports receivables at net realizable value).
- •Both are GAAP-permitted; aging tends to be auditor-preferred.
2. Worked Example 1: Percentage of Sales Method
Net credit sales for the year = $2,000,000. Historical bad debt rate = 1.5% of credit sales. Existing allowance for doubtful accounts balance = $4,000 credit. Bad debt expense = 1.5% × $2,000,000 = $30,000. Journal entry: Debit Bad Debt Expense $30,000, Credit Allowance for Doubtful Accounts $30,000. Note that the existing $4,000 balance is IGNORED — the expense is computed from sales activity, not from the current allowance balance. After the entry, allowance has a credit balance of $34,000. If next year actual write-offs come to $32,000, the allowance is debited by $32,000 across the year, leaving $2,000. The smoothness of the matching is the appeal — bad debt expense tracks the sales it relates to, not the balance sheet at year-end.
Key Points
- •Bad debt expense = % × credit sales (or net credit sales).
- •Existing allowance balance is ignored in the calculation.
- •Strong matching between expense and the revenue that generated it.
3. Worked Example 2: Aging of Receivables Method
Accounts receivable at year-end = $500,000, stratified as: 0-30 days $350,000 (1% uncollectible), 31-60 days $90,000 (5%), 61-90 days $40,000 (15%), over 90 days $20,000 (40%). Required allowance = $3,500 + $4,500 + $6,000 + $8,000 = $22,000. Existing allowance balance = $4,000 credit. Adjustment needed = $22,000 - $4,000 = $18,000 additional. Journal entry: Debit Bad Debt Expense $18,000, Credit Allowance for Doubtful Accounts $18,000. After entry, allowance is $22,000 — exactly the estimated uncollectible amount. Net realizable value of receivables on the balance sheet = $500,000 - $22,000 = $478,000. Now consider if the existing allowance had been a DEBIT balance of $2,000 (because write-offs exceeded prior estimates). Adjustment = $22,000 + $2,000 = $24,000 entry. Always plug to the target ending balance, never net just the difference.
Key Points
- •Build the required ending allowance from aging buckets.
- •Adjust = required ending balance - current balance (signed appropriately).
- •A debit balance in allowance increases the required adjustment, not decreases it.
4. Worked Example 3: Subsequent Write-Off and Recovery
Continuing the aging example: ABC Corp owes $1,200 in the over-90-days bucket and files bankruptcy. Write off the receivable: Debit Allowance for Doubtful Accounts $1,200, Credit Accounts Receivable $1,200. Note this entry has NO effect on bad debt expense or net realizable value — the allowance was already set aside for exactly this scenario. Six months later, ABC unexpectedly pays $500. Two journal entries: (1) Reinstate the receivable: Debit Accounts Receivable $500, Credit Allowance for Doubtful Accounts $500. (2) Record the cash collection: Debit Cash $500, Credit Accounts Receivable $500. The reinstatement step matters for audit trail — it documents that the original write-off was reversed for a legitimate recovery rather than the cash being misposted to a different period.
Key Points
- •Write-off: debit Allowance, credit AR. No expense impact.
- •Recovery: reinstate AR (reverse the write-off), then record cash receipt.
- •Two-step recovery preserves the audit trail of original write-off and reversal.
5. When the Two Methods Disagree (and What to Do)
In practice, the two methods produce different bad debt expense numbers in any given year because they ask different questions. The percentage of sales method overestimates in growing-receivables periods (when collections lag sales) and underestimates in shrinking-receivables periods. The aging method tracks the actual collection profile but ignores how sales activity drives future write-offs. Many companies use percentage of sales for interim (quarterly) financial statements and aging for year-end audit purposes. Some use a combined approach: percentage of sales for the monthly expense accrual, then a year-end aging analysis with a true-up plug entry. The IRS does not permit the allowance method for tax purposes — direct write-off only. This creates a permanent difference (or temporary difference depending on timing) between book and tax that the deferred tax workpaper must track.
Key Points
- •Percentage of sales and aging can produce materially different expense.
- •Common practice: percentage of sales for quarterly close, aging for year-end audit.
- •IRS requires direct write-off — creates book-tax differences.
6. Connection to Financial Statement Pillars
Bad debt sits at the intersection of the three pillar topics. On the income statement, bad debt expense reduces operating income — a small change in the estimation method can move EPS by several cents at large companies. On the balance sheet, the allowance reduces gross receivables to net realizable value, the relevant number for current ratio and quick ratio analysis. On the cash flow statement, bad debt is added back in the operating section under the indirect method because it is non-cash. The aging method ties directly to the ratio analysis cluster: rising days sales outstanding paired with low allowance percentages is a red flag auditors and analysts look for as a sign of receivables-quality deterioration.
Key Points
- •Touches all three primary financial statements.
- •Allowance affects current and quick ratios via NRV adjustment.
- •Bad debt is a non-cash add-back in the indirect cash flow statement.
7. Using AccountingIQ for Allowance Method Problems
Snap a photo of a bad debt problem — whether it gives you a percentage of sales, an aging schedule, or a mix — and AccountingIQ identifies the method, computes the required adjustment with full reconciliation to the existing allowance balance, and produces the journal entries with running T-accounts. The app handles edge cases like debit-balance allowances, multiple-period reconciliations, and the two-step recovery entry sequence.
Key Points
- •Method detection from the problem narrative.
- •Reconciliation handles debit-balance allowances correctly.
- •T-account walkthrough shows the post-entry balances.
High-Yield Facts
- ★Allowance method estimates uncollectibles in advance; required by GAAP.
- ★Percentage of sales: bad debt expense = % × net credit sales; ignores existing allowance.
- ★Aging method: build required ending allowance from age buckets; adjust to that target.
- ★Write-off: Dr Allowance, Cr AR (no expense impact).
- ★Recovery: Two-step entry (reinstate AR, then record cash receipt).
- ★IRS requires direct write-off (not allowance) for tax purposes.
Practice Questions
1. Net credit sales $3M, historical bad debt rate 2%, existing allowance $5,000 credit. Compute bad debt expense and the post-adjustment allowance balance.
2. Aging analysis: 0-30 $400K at 1%, 31-60 $100K at 4%, 61-90 $50K at 10%, over-90 $20K at 25%. Existing allowance: $3,000 DEBIT (write-offs exceeded estimates). Required entry?
3. A $2,000 receivable is written off in March. In December, the customer pays $800. Show all entries.
FAQs
Common questions about this topic
Because direct write-off violates the matching principle. The expense recognized when a specific account is written off may be in a different period than the revenue that originally generated that receivable, sometimes years later. The allowance method estimates uncollectibles in the same period as the credit sales, achieving matching. Direct write-off is permitted only when uncollectibles are immaterial — for tax purposes the IRS requires it because they want to tax actual rather than estimated bad debt.
Most companies use both in a layered way. Percentage of sales is operationally simpler and produces consistent monthly bad debt expense for management reporting. Aging is more accurate at the balance sheet date but is labor-intensive to refresh frequently. A common pattern: monthly percentage-of-sales accruals during the year, then a year-end aging analysis that adjusts (trues up) the allowance to the audit-defensible balance. Public companies disclose the method in the receivables note of the financial statements.
Accounting changes are governed by ASC 250. A change in estimation methodology is treated as a change in accounting estimate (prospective), not a change in accounting principle (retrospective restatement). Disclose the change, its effect on the current period, and recompute future periods using the new method. No restatement of prior years.
When receivables are factored without recourse, both the gross AR and the related allowance come off the books at the carrying values, with any gain or loss flowing to the income statement. When factored with recourse, the company retains exposure and typically maintains the allowance against the residual risk. Securitization through SPVs follows ASC 860 — control transfer is the key test for derecognition.
SEC registrants must disclose the rollforward of the allowance (beginning balance, additions, write-offs, recoveries, ending balance) in a Schedule II. Public companies also disclose the methodology in the receivables note, often with discussion of how aging percentages were determined and how COVID-era assumptions were updated. Under CECL (ASC 326), banks and certain financial institutions have additional disclosures around lifetime expected credit losses.
Snap a photo of any bad debt problem and AccountingIQ identifies whether the question calls for percentage of sales, aging, write-off, or recovery treatment. It builds the reconciliation table showing the existing allowance balance, the target balance, and the plug entry. T-account walkthroughs show how the allowance evolves through accruals, write-offs, and recoveries across periods.