Tutorials › VEE Accounting and Finance › Estimating the Allowance for Uncollectible Accounts

VEE Accounting and Finance · Accounting Cycle and Reporting Choices · Tutorial 82 of 996

Estimating the Allowance for Uncollectible Accounts

Compare two methods for estimating credit losses, calculate the period-end allowance adjustment, and trace its effects through receivables and income.

Intermediate 10 min read

What You'll Learn

  • Distinguish the percentage-of-sales method from the receivables-aging method
  • Calculate estimated uncollectible amounts from credit sales or aging categories
  • Find the required adjustment when the allowance has a credit or debit balance
  • Record write-offs and explain their effect on gross and net receivables
  • Trace an allowance adjustment to bad-debt expense, net receivables, and income

Why Estimate Uncollectible Accounts?

A business that sells on credit may not collect every amount customers owe. If it waits until a particular customer defaults before recognizing a loss, the receivables shown in the accounts may overstate the amounts expected to be collected, and the expense may be recorded in a different period from the related credit sales. An allowance estimate recognizes expected credit losses in the period-end accounts before the business knows exactly which individual balances will not be collected.

The estimate does not identify a certain future default. It is an accounting estimate based on available information and a chosen method. The two common approaches are the percentage-of-sales method, which estimates the period’s bad-debt expense, and the receivables-aging method, which estimates the required ending allowance.

Definition: The allowance for uncollectible accounts is a contra-asset account that reduces accounts receivable to the amount expected to be collected. It normally has a credit balance. Bad-debt expense (also called credit-loss expense) is the period’s expense recognized for expected uncollectible amounts. Net accounts receivable equals gross accounts receivable less the allowance.

The allowance is an estimate across a group of receivables; it does not erase the legal claim represented by an individual customer’s balance. A subsequent write-off removes a specific account from gross receivables and the allowance. The write-off is distinct from the period-end estimate.

Two Estimation Approaches

Under the percentage-of-sales method, a rate is applied to a defined sales base, commonly credit sales. The resulting amount is the bad-debt expense for the period. The calculation does not adjust for the allowance account’s existing balance: that balance reflects prior estimates and write-offs, while the method estimates expense associated with the current period’s sales.

$$ \text{Bad-debt expense} = \text{credit sales}\times\text{estimated uncollectible percentage} $$

Under the receivables-aging method, receivables are grouped by how long they have been outstanding. Each group is multiplied by an estimated uncollectible rate appropriate to its age. The sum is the required ending allowance, not the expense adjustment. Older balances commonly receive higher estimated rates because they have remained unpaid longer.

$$ \text{Required ending allowance} = \sum_j \left( \text{receivables in age group }j \times \text{estimated uncollectible rate for group }j \right) $$

For the adjusting entry, compare that required ending allowance with the allowance balance before adjustment. Treat a credit balance as positive and a debit balance as negative. The adjustment is the required ending balance minus the unadjusted balance. A positive result is credited to the allowance and debited to bad-debt expense.

$$ \text{Adjustment} = \text{required ending allowance} - \text{unadjusted allowance balance} $$

Why the Allowance Adjustment Uses the Difference

The aging calculation estimates the balance that should remain in the allowance after adjustment. The ledger already contains an unadjusted balance, so the entry must supply only the amount needed to move the account from its current position to the target. This follows from the balance equation for the allowance: ending balance equals unadjusted balance plus the credit adjustment, expressed as a signed amount.

$$ \begin{aligned} \text{Required ending allowance} &= \text{unadjusted allowance balance} + \text{adjustment},\\ \text{Adjustment} &= \text{required ending allowance} - \text{unadjusted allowance balance}. \end{aligned} $$

If the allowance already has a credit balance, that existing amount reduces the additional credit needed. If it has a debit balance, it is below zero on this signed scale, so the adjustment must first eliminate the debit and then establish the required credit balance. This is why simply recording the full aging estimate as expense can be wrong.

Worked Example: Estimating Expense From Credit Sales

A hypothetical equipment supplier has $840,000 of credit sales during the year. Its policy estimates that 1.25% of credit sales will be uncollectible. Before the period-end adjustment, the allowance has a credit balance of $3,200. Gross accounts receivable is $126,000. Use the percentage-of-sales method to calculate bad-debt expense, the ending allowance, net receivables, and the effect on income.

Method. Apply the estimated percentage to credit sales to determine the period’s expense. Do not subtract the existing allowance balance from this sales-based estimate.

First calculate the expense:

$$ \$840{,}000\times 0.0125=\$10{,}500. $$

The adjusting entry is a debit to bad-debt expense for $10,500 and a credit to the allowance for $10,500. The allowance starts with a $3,200 credit balance, so its ending credit balance is:

$$ \$3{,}200+\$10{,}500=\$13{,}700. $$

Net accounts receivable is:

$$ \$126{,}000-\$13{,}700=\$112{,}300. $$

The adjustment increases expense by $10,500 and, before considering any tax effects, decreases income by $10,500. Check: the allowance’s $3,200 starting credit plus the $10,500 credit adjustment equals the $13,700 ending allowance. A common mistake is to expense only $7,300, the amount needed to make the allowance equal $10,500. That calculation treats the sales-based expense as an ending allowance target; it is not the percentage-of-sales method.

Worked Example: Estimating the Allowance From an Aging Schedule

A hypothetical service company has $90,000 of receivables that are current, $24,000 that are 1–30 days overdue, $10,000 that are 31–60 days overdue, and $6,000 that are more than 60 days overdue. Its estimated uncollectible rates for these groups are 1%, 4%, 12%, and 40%, respectively. The allowance has an unadjusted credit balance of $1,260. Gross accounts receivable is the sum of the four groups. Find the required allowance, the adjustment, and net receivables.

Method. Estimate the uncollectible amount for each age group, then add the estimates to find the required ending allowance.

For current receivables, $90,000 × 1% = $900. For 1–30 days overdue, $24,000 × 4% = $960. For 31–60 days overdue, $10,000 × 12% = $1,200. For more than 60 days overdue, $6,000 × 40% = $2,400. Therefore:

$$ \$900+\$960+\$1{,}200+\$2{,}400=\$5{,}460. $$

The required ending allowance is $5,460. Since the unadjusted allowance already has a $1,260 credit balance, the adjustment is:

$$ \$5{,}460-\$1{,}260=\$4{,}200. $$

The entry debits bad-debt expense and credits the allowance for $4,200. Gross accounts receivable is $90,000 + $24,000 + $10,000 + $6,000 = $130,000. Net accounts receivable is:

$$ \$130{,}000-\$5{,}460=\$124{,}540. $$

Check: the $1,260 existing credit plus the $4,200 adjustment gives the target allowance of $5,460. A common mistake is to record the full $5,460 as the adjustment; that would leave an allowance of $6,720, above the amount estimated by the aging schedule.

Write-Offs and the Allowance Account

When the business concludes that a specific customer balance will not be collected, it writes off that balance against the allowance. The usual entry debits the allowance and credits accounts receivable. It does not debit bad-debt expense again, because the expense was recognized through the estimate. A write-off reduces both gross receivables and the allowance by the same amount, leaving net receivables unchanged at the time of the write-off.

Worked Example: A Write-Off Before the Period-End Adjustment

A hypothetical parts distributor begins the year with a $12,500 credit balance in its allowance. During the year, it writes off a customer’s $1,800 unpaid balance. At year-end, an aging analysis of the remaining receivables estimates that the allowance should have a $15,000 credit balance. Gross receivables after the write-off are $208,200. Calculate the allowance adjustment, net receivables, and the income effect of the adjustment.

Method. First apply the write-off to the existing allowance, then compare the resulting unadjusted balance with the aging target.

The write-off entry is a debit to the allowance and a credit to accounts receivable, both for $1,800. The allowance after the write-off, but before the year-end adjustment, is:

$$ \$12{,}500-\$1{,}800=\$10{,}700\text{ credit}. $$

The required ending allowance is $15,000 credit, so the adjustment is:

$$ \$15{,}000-\$10{,}700=\$4{,}300. $$

The year-end entry debits bad-debt expense and credits the allowance for $4,300. Net receivables after that adjustment are:

$$ \$208{,}200-\$15{,}000=\$193{,}200. $$

The adjustment increases expense and decreases income by $4,300 before tax effects. The earlier write-off did not create a second expense. Check: the allowance’s $10,700 unadjusted credit plus the $4,300 adjustment equals the $15,000 target. A common mistake is to ignore the write-off when finding the unadjusted allowance balance, which would produce an incorrect adjustment of $2,500.

Comparing the Methods and Their Effects

FeaturePercentage-of-sales methodReceivables-aging method
Amount estimated directlyBad-debt expense for the periodRequired ending allowance
Key calculationCredit sales × estimated rateSum of age-group balances × their rates
Effect of existing allowance balanceDoes not change the sales-based expense calculationChanges the adjustment needed to reach the target balance

Both methods produce an adjusting entry that debits bad-debt expense and credits the allowance when the adjustment is positive. The entry increases expenses and reduces income for the period; on the balance sheet, it increases the contra-asset and therefore reduces net accounts receivable. The allowance is presented as a reduction of receivables, not as a liability.

The methods are not interchangeable calculations. In particular, a percentage-of-sales result is not automatically the required ending allowance, and an aging total is not automatically the expense adjustment. Read the problem’s method and identify whether the requested amount is an expense or an ending account balance before calculating.

Key takeaway: Percentage of sales estimates the period’s expense directly. Aging estimates the ending allowance; the adjustment is the target allowance less the unadjusted allowance balance, with a debit balance treated as negative.

Check Your Understanding

For each problem, identify whether the requested amount is an expense estimate or an allowance target before computing.

  1. A hypothetical wholesaler has $640,000 of credit sales and estimates uncollectible accounts at 0.75% of sales. The allowance has an unadjusted credit balance of $1,100. Under the percentage-of-sales method, find bad-debt expense and the ending allowance. (Answer: expense $4,800; ending allowance $5,900 credit.)
  2. An aging analysis estimates $7,800 as the required ending allowance. The unadjusted allowance has a $600 debit balance. Find the adjustment and state the entry’s debit and credit. (Answer: adjustment $8,400; debit bad-debt expense $8,400 and credit the allowance $8,400.)
  3. Receivables are $50,000 current at 2%, $20,000 1–30 days overdue at 5%, and $8,000 more than 30 days overdue at 25%. The unadjusted allowance is a $2,000 credit. Find the aging target and adjustment. (Answer: target $4,000; adjustment $2,000.)
  4. A company has gross receivables of $96,000 and an allowance credit balance of $5,400 before adjustment. It writes off a $900 customer balance. The year-end aging target for the remaining accounts is $6,200. Find the adjustment and net receivables after adjustment. (Answer: adjustment $1,700; net receivables $88,900.)
  5. A business uses the percentage-of-sales method: credit sales are $1,250,000 and the estimated loss rate is 1.2%. The allowance has a $3,500 credit balance, and gross receivables are $180,000. Find the adjustment, ending allowance, and net receivables. (Answer: adjustment $15,000; ending allowance $18,500 credit; net receivables $161,500.)
Clinical Biostats