Estimating Bad Debts — Estimate bad debts (percent of sales vs aging of receivables) - Financial Accounting

SECTION 1

Historical Context & Motivation

Whenever a business extends credit to its customers, it accepts the reality that some portion of those receivables will never be collected. In the earliest days of double-entry bookkeeping, merchants simply wrote off individual debts when they became obviously uncollectible — a practice known as the direct write-off method. While straightforward, this approach violated what accountants would later formalize as the matching principle, because the expense recognition often lagged the revenue recognition by months or even years. The evolution of credit-based economies in the nineteenth and twentieth centuries demanded more systematic and anticipatory methods for estimating uncollectible accounts, leading to the two dominant techniques studied today: the percent-of-sales method and the aging-of-receivables method.

1494 • Pacioli and Double-Entry Bookkeeping

Luca Pacioli published Summa de Arithmetica, codifying double-entry bookkeeping. Credit transactions were recorded, but bad debts were handled only when definitively uncollectible — no estimation was attempted.

1850s • Rise of Trade Credit in Industrial Economies

As industrial firms extended trade credit at scale, the volume of uncollectible accounts grew. Businesses began reserving general provisions against receivables, planting the seeds of the allowance method.

1930s • Formalization of the Matching Principle

After the 1929 stock market crash, regulatory bodies including the SEC and predecessor organizations to the AICPA pushed for accrual-based accounting standards. The matching principle required expenses — including bad debts — to be recognized in the same period as the related revenue.

1970s–2000s • GAAP Codification and the Allowance Method

FASB codified the allowance method as the preferred GAAP treatment for material receivables. The percent-of-sales and aging-of-receivables approaches became standard estimation techniques taught in every introductory accounting curriculum.

2016–Present • ASC 326 and Current Expected Credit Losses (CECL)

FASB introduced the CECL model under ASC 326, requiring entities to estimate expected credit losses over the life of a financial instrument at inception. The foundational concepts of percent-of-sales and aging remain core building blocks within this more forward-looking framework.

The central question that these historical developments address is deceptively simple: how much of a company's accounts receivable will ultimately prove uncollectible, and when should that expense be recognized? The answer requires balancing the need for timely expense recognition against the inherent uncertainty of predicting future customer defaults. The two estimation methods examined in this lesson — percent of sales and aging of receivables — each approach this question from a different angle, yielding complementary insights for financial statement preparers and users alike.

SECTION 2

Core Principles & Definitions

Before diving into the mechanics of estimation, it is essential to understand the conceptual framework underpinning the allowance method and the key accounts involved. Under GAAP, companies with material credit sales must use the allowance method rather than the direct write-off method, because the allowance method satisfies the matching principle by recording estimated bad debt expense in the same period as the related sales revenue. The two estimation approaches — percent of sales and aging of receivables — both feed into the same allowance framework but differ in their focal point: one emphasizes the income statement, the other the balance sheet.

Allowance for Doubtful Accounts

A contra-asset account that reduces gross Accounts Receivable on the balance sheet to its estimated net realizable value (NRV). Its normal balance is credit.

Bad Debt Expense

An operating expense on the income statement representing the estimated cost of credit sales that will not be collected. It is debited when the allowance is adjusted.

Percent-of-Sales Method

An income-statement approach that computes bad debt expense as a fixed percentage of net credit sales for the period. The resulting figure is added directly to the Allowance for Doubtful Accounts.

Aging-of-Receivables Method

A balance-sheet approach that classifies outstanding receivables by the length of time they have been unpaid. Increasingly higher uncollectibility percentages are applied to older categories.

Net Realizable Value (NRV)

The amount of receivables a company actually expects to collect: Accounts Receivable (gross) minus the Allowance for Doubtful Accounts. NRV is the figure reported on the balance sheet.

✦

KEY TAKEAWAY

Think of the allowance for doubtful accounts like a rainy-day fund for your receivables. Just as a prudent project manager builds a contingency budget before a project begins — not after a cost overrun hits — the allowance method requires companies to estimate and set aside resources for expected losses before they materialize. The percent-of-sales method sizes that fund based on the volume of new projects (sales), while the aging method sizes it by reviewing the existing portfolio and identifying which projects are falling behind schedule (aging receivables).

SECTION 3

Visual Explanation — How Each Method Works

The left panel illustrates the percent-of-sales method, which flows from sales down to the allowance without considering the existing allowance balance. The right panel shows the aging-of-receivables method, which starts from the receivables balance, computes a required ending allowance, and then backs into the expense by subtracting the existing allowance balance.

The diagram above highlights the fundamental distinction between the two methods. Under the percent-of-sales approach, you begin at the top of the income statement — specifically, net credit sales — and multiply by a historically derived uncollectibility percentage to arrive at the period's bad debt expense. That figure is then added to the Allowance for Doubtful Accounts without regard to the account's pre-existing balance. In contrast, the aging-of-receivables approach starts from the balance sheet, categorizing every outstanding receivable by its age and applying escalating loss percentages to each age bucket. The sum of those estimated losses yields the required ending balance of the allowance account; the adjusting entry is then the difference between this target and whatever balance currently sits in the allowance.

SECTION 4

Mathematical Framework

Method 1: Percent-of-Sales (Income Statement Approach)

BAD DEBT EXPENSE — PERCENT OF SALES

Bad Debt Expense = Net Credit Sales × Estimated Uncollectible %

Net Credit Sales = Total credit sales − sales returns and allowances − sales discounts. Estimated Uncollectible % is derived from historical collection data, typically ranging from 1% to 5% depending on industry and customer credit quality.

Under this approach, the computed Bad Debt Expense is simply added to the existing Allowance for Doubtful Accounts balance. Because the method focuses on matching the expense to the current period's sales, it does not attempt to correct any over- or under-estimation from prior periods. Over time, this can cause the allowance account to drift from its economically appropriate level, which is why periodic reconciliation using the aging method is recommended.

Method 2: Aging of Receivables (Balance Sheet Approach)

REQUIRED ALLOWANCE — AGING METHOD

Required Ending Allowance = Σ (Receivables in Age Categoryᵢ × Estimated Uncollectible %ᵢ)

Each age category i (e.g., 0–30 days, 31–60 days, 61–90 days, over 90 days) is assigned a progressively higher uncollectibility percentage reflecting the greater risk of non-payment as receivables age.

BAD DEBT EXPENSE — AGING METHOD

Bad Debt Expense = Required Ending Allowance − Existing Allowance Balance

If the existing allowance has a credit balance (the normal case), the expense equals the required ending balance minus that credit balance. If the existing allowance has a debit balance (due to excessive write-offs), the expense equals the required ending balance plus the absolute value of that debit balance.

⚠

Debit vs. Credit Balance in the Allowance

A pre-adjustment debit balance in the Allowance for Doubtful Accounts means that actual write-offs during the period exceeded the allowance provided. Under the aging method, you must add this debit balance to the required ending allowance to arrive at the correct bad debt expense. For example, if the required ending allowance is $15,000 and the existing balance is a $2,000 debit, then Bad Debt Expense = $15,000 + $2,000 = $17,000.

NET REALIZABLE VALUE

NRV = Accounts Receivable (Gross) − Allowance for Doubtful Accounts

This is the amount reported on the balance sheet. Both estimation methods ultimately aim to produce a reliable NRV, though they arrive at the allowance figure from different starting points.

SECTION 5

The Aging Schedule — Detailed Breakdown

The aging schedule is the analytical tool that drives the aging-of-receivables method. It classifies every outstanding customer balance by the number of days the invoice has been outstanding, then applies category-specific estimated uncollectibility rates. Because older receivables carry substantially higher default risk, the percentages increase sharply as invoices age — a pattern that reflects empirical evidence from credit loss databases across industries. Constructing and interpreting this schedule is one of the most practical skills in receivables management.

This dual-axis chart shows receivable balances by age category (bars, left axis) and the corresponding estimated uncollectibility percentage (dashed line with dots, right axis). Note how the uncollectibility rate climbs steeply as receivables age past 60 days, even though the dollar balances in those categories are much smaller.

Age Category	Receivable Balance	Est. Uncollectible %	Estimated Bad Debt
0–30 days	$450,000	1%	$4,500
31–60 days	$200,000	3%	$6,000
61–90 days	$100,000	10%	$10,000
91–120 days	$60,000	20%	$12,000
Over 120 days	$40,000	30%	$12,000
Total	$850,000	—	$44,500

Sample Aging Schedule

In this example, the aging analysis reveals that the required ending balance of the Allowance for Doubtful Accounts is $44,500. If the allowance account currently carries a credit balance of $5,000 before adjustment, the bad debt expense for the period would be $44,500 − $5,000 = $39,500. Conversely, if write-offs during the period had exceeded prior provisions, leaving a debit balance of $3,000, the required expense would be $44,500 + $3,000 = $47,500. The aging method's key advantage is that it self-corrects with every adjustment period, ensuring the balance sheet presents a realistic net realizable value.

SECTION 6

Worked Example — Both Methods Side by Side

Apex Electronics Inc. has the following data for the fiscal year ending December 31, 2024. Net credit sales for the year totaled $2,000,000. The Accounts Receivable balance at December 31 is $600,000 (gross). The Allowance for Doubtful Accounts has a pre-adjustment credit balance of $4,000. Historical data suggest that 2% of net credit sales prove uncollectible. The company's aging schedule shows the following breakdown: 0–30 days, $350,000 (1% uncollectible); 31–60 days, $140,000 (4%); 61–90 days, $70,000 (12%); over 90 days, $40,000 (25%). We will compute the adjusting entry under each method.

Method A: Percent-of-Sales

Percent-of-Sales Method — Apex Electronics

1
Step 1 — Identify Net Credit Sales

Net credit sales for the year = $2,000,000. This figure has already been adjusted for returns, allowances, and discounts.
2
Step 2 — Apply the Estimated Uncollectible Percentage

Bad Debt Expense = $2,000,000 × 2% = $40,000. Under the percent-of-sales method, this is the adjusting entry amount regardless of the existing allowance balance.

Bad Debt Expense = $40,000
3
Step 3 — Record the Adjusting Journal Entry

Debit Bad Debt Expense $40,000; Credit Allowance for Doubtful Accounts $40,000. The allowance now has an ending balance of $4,000 (existing) + $40,000 = $44,000.
4
Step 4 — Compute Net Realizable Value

NRV = $600,000 − $44,000 = $556,000. This is the amount Apex expects to collect, reported on the balance sheet.

NRV = $556,000

Method B: Aging of Receivables

Aging-of-Receivables Method — Apex Electronics

1
Step 1 — Prepare the Aging Schedule

Classify receivables by age and apply estimated loss percentages: 0–30 days: $350,000 × 1% = $3,500; 31–60 days: $140,000 × 4% = $5,600; 61–90 days: $70,000 × 12% = $8,400; Over 90 days: $40,000 × 25% = $10,000.
2
Step 2 — Sum the Estimated Losses

Required ending balance of the Allowance = $3,500 + $5,600 + $8,400 + $10,000 = $27,500.

Required Allowance = $27,500
3
Step 3 — Determine Bad Debt Expense

The existing Allowance has a credit balance of $4,000. Therefore, Bad Debt Expense = $27,500 − $4,000 = $23,500.

Bad Debt Expense = $23,500
4
Step 4 — Record the Adjusting Journal Entry

Debit Bad Debt Expense $23,500; Credit Allowance for Doubtful Accounts $23,500. The allowance ending balance is now exactly $27,500.
5
Step 5 — Compute Net Realizable Value

NRV = $600,000 − $27,500 = $572,500. Note how the two methods yield different NRV figures ($556,000 vs. $572,500) because they approach the estimation from different angles.

NRV = $572,500

💡

Why the Results Differ

The percent-of-sales method adds a fixed expense to the allowance without regard to its existing level, producing a higher cumulative allowance ($44,000) in this example. The aging method targets a specific allowance balance ($27,500) calibrated to the actual receivables composition. In practice, companies often use percent-of-sales for interim periods and the aging method at year-end to true up the allowance.

SECTION 7

Strengths, Limitations & Method Comparison

Neither estimation method is inherently superior; each offers distinct advantages that make it more appropriate in certain contexts. Understanding these trade-offs enables managers and accountants to select or combine methods strategically. The table below provides a systematic comparison across several dimensions that matter in practice.

Dimension	Percent-of-Sales	Aging of Receivables
Primary Focus	Income statement — matching expense to revenue	Balance sheet — accuracy of NRV
Computation Complexity	Low — single multiplication	Moderate — requires detailed aging schedule
Existing Allowance Balance	Ignored in the calculation	Subtracted from required balance to determine expense
Self-Correcting?	No — allowance can drift over time	Yes — recalibrates each period
Best Used For	Monthly or quarterly interim adjustments	Year-end true-up and external reporting
Data Required	Net credit sales and historical loss rate	Detailed receivables subledger with invoice dates
Key Weakness	Does not reflect changes in receivable quality	Requires reliable age-categorization data; more time-consuming

Percent-of-Sales vs. Aging of Receivables — Feature Comparison

✦

KEY TAKEAWAY

Think of these two methods as complementary instruments in a pilot's cockpit. The percent-of-sales method is like an airspeed indicator — it gives a quick, forward-looking read tied to activity (sales), but it doesn't tell you your exact altitude (allowance accuracy). The aging method is like an altimeter — it tells you precisely where you are relative to the ground (actual receivable collectibility), but it requires more instrumentation. Using both in tandem — speed for interim navigation and altitude checks at year-end — produces the most reliable flight path for financial reporting.

SECTION 8

Connection to Advanced Theory — CECL and Beyond

The percent-of-sales and aging-of-receivables methods represent the foundational building blocks upon which more sophisticated credit loss models are constructed. In 2016, the Financial Accounting Standards Board issued ASU 2016-13, codified as ASC 326, which introduced the Current Expected Credit Loss (CECL) model. Under CECL, entities must estimate expected credit losses over the entire remaining life of a financial instrument at the time of origination, rather than waiting for a loss to become probable. This forward-looking philosophy dramatically changes when and how losses are recognized, particularly for banks and financial institutions.

Feature	Traditional Allowance Methods	CECL Model (ASC 326)
Loss Recognition Trigger	Losses recognized when probable (incurred loss model)	Expected losses recognized at origination over entire life
Time Horizon	Current period or near-term	Remaining contractual life of the instrument
Estimation Inputs	Historical loss rates applied to current balances	Historical data plus macroeconomic forecasts and qualitative factors
Applicability	All entities with material receivables	Public and SEC-reporting entities (effective 2020); private entities (2023)
Foundational Skills	Percent-of-sales, aging schedule	Same foundational methods plus regression analysis, probability-weighted scenarios

Traditional Estimation vs. CECL

Even under the CECL framework, the aging-of-receivables analysis remains a commonly used methodology — particularly for trade receivables of non-financial entities. Companies can build their CECL estimate on an aging schedule enhanced with forward-looking macroeconomic adjustments. Therefore, mastering the percent-of-sales and aging approaches is not merely an introductory exercise; these techniques form the analytical backbone of credit loss estimation at all levels of complexity, from a small retailer's year-end adjustment to a multinational bank's loan loss provisioning system.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why the percent-of-sales method is described as an income-statement approach while the aging-of-receivables method is described as a balance-sheet approach. How does each method determine its key output — bad debt expense or the required allowance balance?

Show answer

The percent-of-sales method is income-statement oriented because its starting point is net credit sales, an income statement figure. The method directly calculates the period's bad debt expense by multiplying sales by an estimated uncollectibility rate, and this expense is simply added to the existing allowance balance without adjusting for prior over- or under-provisions. In contrast, the aging method is balance-sheet oriented because it begins with the accounts receivable balance, classifies it by age, and determines the required ending balance of the Allowance for Doubtful Accounts — a balance sheet figure. The bad debt expense is then derived as the residual: the required ending allowance minus the existing balance. This distinction means the aging method inherently self-corrects the allowance account each period, while the percent-of-sales method does not.

Question 2: BASIC CALCULATION

Greenfield Corp. reports net credit sales of $1,500,000 for 2024. Historical data indicate that 2.5% of credit sales are uncollectible. The Allowance for Doubtful Accounts has a pre-adjustment credit balance of $6,000. Using the percent-of-sales method, compute (a) bad debt expense, (b) the ending balance of the Allowance, and (c) net realizable value if gross Accounts Receivable is $420,000.

Show answer

(a) Bad Debt Expense = $1,500,000 × 2.5% = $37,500. Under the percent-of-sales method, this is the full expense amount regardless of the existing allowance balance. (b) Ending Allowance = $6,000 (existing credit) + $37,500 = $43,500. (c) NRV = $420,000 − $43,500 = $376,500. The adjusting journal entry is: Debit Bad Debt Expense $37,500; Credit Allowance for Doubtful Accounts $37,500. Notice that the $6,000 pre-existing balance was not subtracted from the computed expense — that is a hallmark of the percent-of-sales approach.

Question 3: INTERMEDIATE

BlueStar Inc. has the following aging schedule at December 31: 0–30 days, $280,000 (est. 1% uncollectible); 31–60 days, $110,000 (est. 5%); 61–90 days, $55,000 (est. 15%); over 90 days, $35,000 (est. 40%). The Allowance for Doubtful Accounts has a pre-adjustment debit balance of $2,200. Compute (a) the required ending allowance, (b) bad debt expense, and (c) the adjusting journal entry.

Show answer

(a) Required ending allowance: ($280,000 × 1%) + ($110,000 × 5%) + ($55,000 × 15%) + ($35,000 × 40%) = $2,800 + $5,500 + $8,250 + $14,000 = $30,550. (b) Because the allowance has a debit balance of $2,200 (meaning write-offs exceeded prior provisions), the adjusting expense must bring the account from a $2,200 debit to a $30,550 credit. Bad Debt Expense = $30,550 + $2,200 = $32,750. (c) Journal entry: Debit Bad Debt Expense $32,750; Credit Allowance for Doubtful Accounts $32,750. This entry moves the allowance from a $2,200 debit balance to the required $30,550 credit balance, properly reflecting the risk profile of BlueStar's outstanding receivables.

Question 4: APPLIED

Metro Distributors uses the percent-of-sales method for quarterly interim reporting and the aging method for year-end adjustments. For Q1–Q3 of 2024, the company recorded cumulative bad debt expense of $90,000 based on 3% of quarterly credit sales. At December 31, the aging analysis shows a required ending allowance of $72,000. The Allowance for Doubtful Accounts has a credit balance of $85,000 (resulting from the three quarterly entries and $5,000 of write-offs). What year-end adjusting entry, if any, is required? Explain the managerial implications.

Show answer

The aging method targets a required ending allowance of $72,000. Currently, the allowance carries a credit balance of $85,000 after three quarters of percent-of-sales accruals. Since $85,000 exceeds the $72,000 target, the allowance is over-provisioned by $13,000. The year-end adjusting entry reverses the excess: Debit Allowance for Doubtful Accounts $13,000; Credit Bad Debt Expense $13,000. This reduces bad debt expense for Q4 (effectively a negative expense), bringing total annual bad debt expense to $90,000 − $13,000 = $77,000. The managerial implication is that the percent-of-sales method over-estimated bad debts during interim periods relative to the actual risk profile of year-end receivables. This scenario demonstrates exactly why companies pair the two methods — the aging analysis at year-end serves as a reality check that corrects cumulative estimation error from the simpler interim approach.

Question 5: CRITICAL THINKING

A company's CEO proposes switching from the aging method to the percent-of-sales method exclusively, arguing it is simpler and saves accounting staff time. The CFO objects, citing balance-sheet accuracy concerns. Evaluate both positions. Under what circumstances might a company reasonably use only the percent-of-sales method? When would exclusive reliance on it be problematic? How might the CECL model under ASC 326 inform this discussion?

Show answer

The CEO's position has merit from an operational efficiency standpoint — the percent-of-sales method requires only one piece of data (net credit sales) and one multiplication, whereas the aging method demands a detailed receivables subledger analysis. For a company with highly homogeneous customers, short credit terms, and consistently low write-off rates, the percent-of-sales method may produce estimates that closely approximate those from aging analysis, making the additional effort hard to justify on a cost-benefit basis. However, the CFO's concern is well-founded for companies with diverse customer portfolios, long collection cycles, or cyclical industries where receivable quality can deteriorate rapidly. Exclusive reliance on percent-of-sales can cause the allowance to drift from its economically appropriate level, potentially overstating or understating net realizable value on the balance sheet. Over multiple periods without a self-correcting mechanism, the cumulative error can become material. Under ASC 326 (CECL), the analysis becomes even more relevant: CECL requires forward-looking loss estimates that incorporate macroeconomic forecasts — a level of analysis more naturally conducted within an aging-style framework augmented by predictive models. Companies subject to CECL would likely find that exclusive reliance on percent-of-sales fails to satisfy the standard's requirements for reasonable and supportable forecasts. The optimal approach is typically a hybrid: percent-of-sales for interim efficiency, with periodic aging-based reconciliation to ensure balance-sheet accuracy.

SUMMARY

Lesson Summary

Summary

Estimating bad debts under the allowance method satisfies the matching principle by recognizing bad debt expense in the same period as the credit sales that generated the receivables. The percent-of-sales method is an income-statement approach that computes expense as a fixed percentage of net credit sales, adding the result directly to the Allowance for Doubtful Accounts without regard to its existing balance. It is quick, efficient, and well-suited to interim reporting.

The aging-of-receivables method is a balance-sheet approach that classifies outstanding receivables by age, applies escalating uncollectibility percentages to each category, and determines a required ending allowance balance. The expense is the difference between the required balance and the existing allowance, making this method self-correcting and ideal for year-end adjustments. In practice, many companies use both methods in tandem — percent-of-sales for interim periods and aging at year-end — to balance efficiency with balance-sheet accuracy. These foundational techniques also underpin the more advanced CECL model (ASC 326), which extends the analysis to the full expected life of financial instruments.