Tutorials › VEE Accounting and Finance › Estimating Bad Debt from Credit Sales

VEE Accounting and Finance · Accrual Accounting and Adjustments · Tutorial 43 of 996

Estimating Bad Debt from Credit Sales

Estimate bad debt expense as a percentage of credit sales, record the adjusting entry, and distinguish the expense estimate from the allowance account’s ending balance.

Beginner 10 min read

What You'll Learn

  • Calculate bad debt expense from net credit sales and an applicable loss rate.
  • Determine whether the stated percentage applies to gross or net credit sales.
  • Prepare the period-end debit to bad debt expense and credit to the allowance.
  • Explain why the existing allowance balance does not change this method’s expense estimate.
  • Compute the allowance balance after the adjustment, including when it begins with a debit balance.
  • Apply separate loss rates to different categories of credit sales.

Estimating Bad Debt from Credit Sales

When a business makes a sale on credit, it records revenue before knowing whether the customer will pay the full amount. Some credit sales may eventually be uncollectible. The percentage-of-credit-sales method estimates the expense associated with those sales in the period the sales occur, consistent with accrual accounting’s matching of expenses to related revenue.

The key distinction is between estimating this period’s bad debt expense and calculating the allowance account’s ending balance. Under the percentage-of-credit-sales method, the expense estimate comes from the period’s credit sales and the applicable loss rate. The allowance balance before adjustment does not change that estimate.

Definition: Under the percentage-of-credit-sales method, estimated bad debt expense for a period equals the relevant credit sales for that period multiplied by an estimated uncollectible percentage. The period-end adjusting entry debits Bad Debt Expense and credits Allowance for Uncollectible Accounts (also called the allowance for doubtful accounts).

The Estimate and the Adjusting Entry

Let \(S\) be the amount of credit sales to which the stated rate applies, and let \(r\) be the estimated uncollectible rate expressed as a decimal. The method estimates the period’s expense as follows:

$$ \text{Estimated bad debt expense} = S \times r $$

Use the sales base specified in the problem. If the rate is stated as a percentage of net credit sales, subtract the relevant credit sales returns and allowances before applying the rate. Do not subtract cash sales, and do not subtract returns twice. If a problem explicitly defines the base as gross credit sales, use that stated base.

The adjusting entry records the estimate in the period’s accounts:

$$ \begin{aligned} \text{Debit: Bad Debt Expense} &\quad S \times r \\ \text{Credit: Allowance for Uncollectible Accounts} &\quad S \times r \end{aligned} $$

The allowance is a contra-asset account: its credit balance reduces the related receivables when net receivables are presented. The adjustment increases bad debt expense and increases the allowance by the same amount. The allowance’s balance after adjustment is the balance before adjustment plus the credit adjustment, with a debit balance treated as negative.

Important distinction: This method estimates an expense from sales activity. It does not calculate an allowance balance that must equal a specified target. Therefore, the pre-adjustment allowance balance affects the ending allowance balance, but not the expense estimated from credit sales.

Why the Percentage-of-Sales Formula Works

The rate represents an estimated share of the relevant sales that will not be collected. The multiplication follows from applying that share to the sales amount. For a more explicit justification, suppose the period has credit sales \(s_1, s_2, \ldots, s_n\), and the expected uncollectible amount associated with each dollar of these sales is the same fraction \(r\). The expected uncollectible amount associated with sale \(j\) is \(r s_j\). By adding the expected amounts across the sales:

$$ \begin{aligned} E[\text{total uncollectible amount}] &= \sum_{j=1}^{n} E[\text{uncollectible amount from sale }j] \\ &= \sum_{j=1}^{n} r s_j \\ &= r \sum_{j=1}^{n} s_j \\ &= rS \end{aligned} $$

This calculation uses the linearity of expected value; the sales do not need to be independent for the sum of their expected uncollectible amounts to equal the expected total. The method is an estimate, not a prediction that exactly \(rS\) will fail to be collected. It assumes the selected rate is suitable for the sales being measured, such as because past experience is relevant to the current period’s customers and credit conditions. If different groups of sales have meaningfully different expected loss rates, apply the appropriate rate to each group and add the estimates.

Worked Example: Applying a Rate to Credit Sales

A hypothetical equipment supplier reports $640,000 of net credit sales for the year. Its estimated uncollectible rate is 1.5% of net credit sales. Before adjustment, Allowance for Uncollectible Accounts has a credit balance of $2,300. Calculate the expense adjustment and the allowance balance after posting it.

Method. Apply the percentage-of-credit-sales method to net credit sales. The $2,300 balance is used only to find the ending allowance balance.

Step 1: Convert the rate to a decimal. \(1.5\% = 1.5 \div 100 = 0.015\).

Step 2: Estimate the expense.

$$ \$640{,}000 \times 0.015 = \$9{,}600 $$

Step 3: Record the adjustment. Debit Bad Debt Expense for $9,600 and credit Allowance for Uncollectible Accounts for $9,600.

Step 4: Find the ending allowance balance. The account begins with a $2,300 credit balance, so its ending credit balance is \(\$2{,}300+\$9{,}600=\$11{,}900\).

Check and common mistake avoided. The expense is $9,600, and the allowance increases by $9,600. Subtracting the existing $2,300 balance from the expense would incorrectly treat the sales method as a method that targets an ending allowance balance.

Net Sales, Existing Balances, and Multiple Rates

Two details often determine whether an answer is correct: the sales base and the role of the existing allowance balance. Read the wording carefully. A rate applied to net credit sales is not applied to gross credit sales when credit returns are given. Conversely, do not assume a net-sales base if the problem explicitly defines the rate on gross sales.

After calculating the expense, post that full amount to the allowance. If the allowance begins with a credit balance, add the adjustment to that credit balance. If it begins with a debit balance, the credit adjustment first offsets that debit; if the adjustment is larger, the remainder becomes a credit balance. In neither case does the opening balance alter the expense computed from sales.

When sales groups have different loss rates, estimate each group separately. This avoids treating a high-risk group and a lower-risk group as if they necessarily had the same expected uncollectible share.

Worked Example: Returns and an Existing Credit Balance

A hypothetical online retailer has $840,000 of gross credit sales and $36,000 of credit sales returns for the period. Its estimated uncollectible rate is 1.75% of net credit sales. The allowance has a $4,500 credit balance before adjustment. Calculate the bad debt expense, the adjusting entry, and the ending allowance balance.

Method. First find net credit sales because the rate is explicitly based on that amount. Then calculate the expense independently of the existing allowance balance.

Step 1: Calculate net credit sales.

$$ \$840{,}000-\$36{,}000=\$804{,}000 $$

Step 2: Convert the rate and estimate bad debt expense. \(1.75\%=0.0175\), so:

$$ \$804{,}000 \times 0.0175 = \$14{,}070 $$

Step 3: Record the adjustment. Debit Bad Debt Expense for $14,070 and credit Allowance for Uncollectible Accounts for $14,070.

Step 4: Calculate the ending allowance. Both the opening balance and the adjustment are credits:

$$ \$4{,}500+\$14{,}070=\$18{,}570\text{ credit} $$

Check and common mistake avoided. The estimated expense is $14,070. A tempting but incorrect calculation is \(\$14{,}070-\$4{,}500=\$9{,}570\), which treats the opening allowance as though it reduces the expense required by this method. It does not. Using gross sales would also be wrong here because the rate is specified on net credit sales.

Worked Example: Different Rates for Two Sales Groups

A hypothetical wholesaler separates its net credit sales into two groups. Group A has $1,020,000 in net credit sales and an estimated uncollectible rate of 0.6%. Group B has $260,000 in net credit sales and an estimated uncollectible rate of 3.2%. Before adjustment, the allowance has a $2,600 debit balance. Find total bad debt expense and the allowance balance after adjustment.

Method. Apply each group’s own rate to its own net credit sales, add the expense estimates, then post the total to the allowance.

Step 1: Estimate Group A’s expense. \(0.6\%=0.006\):

$$ \$1{,}020{,}000 \times 0.006 = \$6{,}120 $$

Step 2: Estimate Group B’s expense. \(3.2\%=0.032\):

$$ \$260{,}000 \times 0.032 = \$8{,}320 $$

Step 3: Add the group estimates.

$$ \$6{,}120+\$8{,}320=\$14{,}440 $$

Step 4: Record the adjustment. Debit Bad Debt Expense for $14,440 and credit Allowance for Uncollectible Accounts for $14,440.

Step 5: Calculate the ending allowance balance. The credit adjustment first offsets the $2,600 debit balance:

$$ \$14{,}440-\$2{,}600=\$11{,}840\text{ credit} $$

Check and common mistake avoided. Total expense is $14,440, not $11,840. The $11,840 is the ending credit balance after accounting for the opening debit. Applying one unweighted average rate to both groups would ignore the fact that their sales amounts and estimated loss rates differ.

Accounting Effects and Exam Traps

The adjustment affects both the income statement and the balance sheet. Bad Debt Expense increases expenses and reduces income for the period. The credit to the allowance increases the contra-asset that reduces receivables in the balance sheet presentation. Cash is not paid as part of this estimate, and the entry does not represent a particular customer’s account being identified as uncollectible.

The central trap is confusing an expense estimate based on sales with an allowance balance calculation. The percentage-of-credit-sales method answers, “What expense is associated with this period’s credit sales?” Its calculation is \(S \times r\). The prior allowance balance is needed only when the question also asks for the ending balance after the adjustment.

  • Wrong base: applying a rate to gross sales when the question specifies net credit sales. Use the stated sales base.
  • Wrong role for the opening balance: adding or subtracting the allowance balance when calculating expense. Calculate expense from sales first; then use the opening balance to find the ending allowance.
  • Wrong aggregation: applying one rate to all sales when separate groups have specified rates. Calculate each group’s estimate and add them.
  • Wrong sign for a debit balance: treating an opening debit in the allowance as a credit. A debit balance is offset by the credit adjustment before any remaining amount becomes an ending credit balance.

A reliable solution therefore identifies the applicable sales base, converts each percentage to a decimal, computes the expense estimate, records the debit and credit, and only then calculates the ending allowance if requested. That sequence keeps the income statement estimate separate from the balance sheet account’s accumulated balance.

Check Your Understanding

For each problem, calculate the requested expense and allowance information using the sales base and rate specified.

  1. A hypothetical repair firm has $450,000 of net credit sales. Its uncollectible rate is 1.2% of net credit sales, and its allowance has a $900 credit balance before adjustment. Find the bad debt expense and ending allowance balance. (Answer: $5,400 expense; $6,300 ending credit balance.)
  2. A hypothetical supplier reports $390,000 of gross credit sales and $15,000 of credit sales returns. The estimated uncollectible rate is 2% of net credit sales, and the allowance begins with an $800 debit balance. Find the expense and ending allowance balance. (Answer: $7,500 expense; $6,700 ending credit balance.)
  3. A hypothetical distributor has two sales groups: $700,000 of net credit sales at a 0.9% estimated uncollectible rate, and $180,000 at a 4% rate. Its allowance has a $2,100 credit balance before adjustment. Find total expense and the ending allowance balance. (Answer: $13,500 expense; $15,600 ending credit balance.)
  4. A hypothetical business estimates its uncollectible rate from prior experience: $18,000 of uncollectible credit sales out of $1,200,000 of net credit sales. In the current period, net credit sales are $920,000 and the allowance begins with a $5,000 credit balance. Calculate the estimated rate, current bad debt expense, and ending allowance balance. (Answer: 1.5% rate; $13,800 expense; $18,800 ending credit balance.)
Clinical Biostats