Why Age Receivables?
At period-end, a business may have many customer balances outstanding, but not all are equally likely to be collected. A balance that is not yet due may have a lower estimated loss rate than one that has remained unpaid for several months. An accounts-receivable aging schedule makes this difference explicit by grouping receivables according to how long they have been outstanding and applying an estimated uncollectible rate to each group.
The aging method estimates a target balance for the allowance account at the reporting date. That target is not necessarily the amount of the adjusting entry: the allowance may already have an unadjusted balance from earlier entries. The adjustment must bring the account from its current balance to the target.
Calculate the Required Ending Allowance
For each age band, multiply the receivables in that band by the estimated uncollectible rate assigned to it. Then add the estimated uncollectible amounts across all bands. If the balances are stated in dollars, the resulting allowance is in dollars; if balances are stated in thousands, the result is in thousands.
The rates are estimates provided by management or stipulated in a problem. They ordinarily rise with age because older overdue balances are generally assessed as less likely to be collected. The arithmetic uses the rate assigned to each band; it does not mean that every account in that band will be uncollectible.
The calculation is a balance-sheet estimate: it uses the receivables outstanding at the reporting date to estimate the required ending allowance. This differs from estimating bad-debt expense as a percentage of credit sales, which applies a rate to sales during a period. The two methods use different bases, so a rate or calculation from one should not be substituted into the other.
Worked Example: Finding the Target and the Adjustment
A hypothetical retailer prepares this aging schedule at year-end. The allowance account has an unadjusted credit balance of $1,250. Find the required ending allowance and the adjusting entry.
Method. Calculate the estimated loss in each age band, total those amounts to obtain the target, and then subtract the existing credit balance to find the adjustment.
| Age band | Receivables | Estimated uncollectible rate | Estimated uncollectible amount |
|---|---|---|---|
| Current | $84,000 | 1% | $84,000 × 0.01 = $840 |
| 1–30 days past due | $25,000 | 4% | $25,000 × 0.04 = $1,000 |
| 31–60 days past due | $12,000 | 12% | $12,000 × 0.12 = $1,440 |
| More than 60 days past due | $4,000 | 35% | $4,000 × 0.35 = $1,400 |
Step 1: Add the age-band estimates. The total is $840 + $1,000 + $1,440 + $1,400 = $4,680. This is the required ending allowance.
Step 2: Compare with the unadjusted balance. The allowance already has a $1,250 credit balance, so the amount needed to reach $4,680 is $4,680 − $1,250 = $3,430.
Step 3: Record and check the adjustment. Debit Bad Debt Expense $3,430 and credit Allowance for Uncollectible Accounts $3,430. The ending credit balance is $1,250 + $3,430 = $4,680, as required. The common mistake avoided here is recording the full $4,680 as the adjustment even though $1,250 is already in the account.
From the Target Balance to the Adjusting Entry
Use signed balances to keep the adjustment logic clear. Treat a credit balance in the allowance as positive and a debit balance as negative. The adjustment is the required ending balance minus the unadjusted balance. A positive result calls for a credit to the allowance; a negative result calls for a debit.
This relationship follows from the basic account-balance calculation: ending balance = unadjusted balance + adjustment, where a credit adjustment is positive and a debit adjustment is negative. Rearranging gives adjustment = ending balance − unadjusted balance. The target is therefore not automatically the entry; it is the ending balance the entry must produce.
Multiply each age-band receivable balance by its assigned estimated uncollectible rate, then sum the products.
Determine whether the allowance currently has a credit balance or a debit balance, and note its amount.
Subtract the signed unadjusted balance from the required ending allowance.
Record the difference in the direction indicated, then confirm that the resulting allowance equals the target.
When the allowance needs to increase, the usual adjusting entry is a debit to Bad Debt Expense and a credit to the allowance. If an existing credit balance is larger than the required target, the allowance needs to decrease instead: debit the allowance and credit Bad Debt Expense. In either case, check the account balance after the entry rather than assuming the entry itself should equal the target.
Worked Example: Adjusting from a Debit Balance
A hypothetical equipment supplier has $100,000 of current receivables, $35,000 that are 1–30 days past due, $18,000 that are 31–90 days past due, and $7,000 that are more than 90 days past due. The estimated uncollectible rates for these bands are 0.5%, 3%, 15%, and 55%, respectively. Before adjustment, the allowance has a $600 debit balance. Calculate the required ending allowance and the adjustment.
Method. First calculate the target from the aging schedule. Then treat the existing debit balance as negative when finding the adjustment.
Current: $100,000 × 0.005 = $500.
1–30 days past due: $35,000 × 0.03 = $1,050.
31–90 days past due: $18,000 × 0.15 = $2,700.
More than 90 days past due: $7,000 × 0.55 = $3,850.
Step 1: Find the target. Add the estimates: $500 + $1,050 + $2,700 + $3,850 = $8,100.
Step 2: Find the adjustment. The unadjusted debit balance is −$600 when a credit balance is treated as positive. Therefore, the adjustment is $8,100 − (−$600) = $8,700 credit.
Step 3: Record and check. Debit Bad Debt Expense $8,700 and credit Allowance for Uncollectible Accounts $8,700. The allowance moves from a $600 debit to an $8,100 credit: $8,700 − $600 = $8,100. The debit balance increases the adjustment required; subtracting $600 as if it were a credit balance would understate the needed credit by $1,200.
Worked Example: When the Existing Credit Balance Exceeds the Target
A hypothetical wholesaler has $70,000 of current receivables, $20,000 that are 1–30 days past due, $8,000 that are 31–60 days past due, and $2,000 that are more than 60 days past due. The estimated uncollectible rates are 1%, 5%, 20%, and 50%, respectively. The allowance has an unadjusted credit balance of $5,000. Determine the required ending allowance and the adjusting entry.
Method. Estimate the target by age band, then compare it with the existing credit balance. A target lower than the existing balance requires a debit adjustment to the allowance.
Current: $70,000 × 0.01 = $700.
1–30 days past due: $20,000 × 0.05 = $1,000.
31–60 days past due: $8,000 × 0.20 = $1,600.
More than 60 days past due: $2,000 × 0.50 = $1,000.
Step 1: Find the target. The sum is $700 + $1,000 + $1,600 + $1,000 = $4,300.
Step 2: Calculate the adjustment. $4,300 − $5,000 = −$700, so the allowance must be debited by $700.
Step 3: Record and check. Debit Allowance for Uncollectible Accounts $700 and credit Bad Debt Expense $700. The resulting allowance credit balance is $5,000 − $700 = $4,300. The common mistake avoided is automatically debiting expense and crediting the allowance for every aging adjustment, even when the unadjusted allowance already exceeds the target.
Common Mistakes and Checks
Aging adjustments involve two separate calculations, and each can go wrong in a different way. The age-band calculation determines the target; the account-balance comparison determines the entry. Keep those stages distinct.
- Applying one rate to all receivables. Use each band’s specified rate on that band’s balance, not a single rate on total receivables.
- Adding the band estimates incorrectly. Show the product for every band and then add the products. This makes it easier to catch a misplaced decimal or a skipped band.
- Confusing target with adjustment. The target is the required ending balance. The adjustment is the difference between that target and the unadjusted balance.
- Treating a debit balance as a credit. A debit balance is on the opposite side of the allowance’s normal credit balance, so it must be added to the credit needed to reach a positive target.
- Ignoring units. Keep all receivable amounts in the same units throughout. A schedule stated in thousands produces an allowance in thousands, not dollars.
A useful final check is to write the balance equation explicitly: unadjusted balance plus signed adjustment equals required ending balance. If the two sides do not agree, revisit the sign of the adjustment before recording the entry.
Check Your Understanding
For each problem, calculate the required ending allowance first and then determine the adjustment from the unadjusted balance.
- A hypothetical firm has $52,000 current, $14,000 1–30 days past due, and $6,000 more than 30 days past due. The respective estimated uncollectible rates are 0.8%, 4%, and 25%. The allowance has a $976 credit balance. What is the target and adjustment? (Answer: Required ending allowance $2,476; credit adjustment $1,500.)
- A hypothetical service company has $90,000 current, $24,000 1–30 days past due, and $10,000 more than 30 days past due. Rates are 1%, 6%, and 30%. The allowance has a $460 debit balance. What is the target and adjustment? (Answer: Required ending allowance $5,340; credit adjustment $5,800.)
- A hypothetical distributor’s aging schedule gives estimated uncollectible amounts of $400, $500, $800, and $600 across its four age bands. Its unadjusted allowance is a $3,100 credit. What adjustment is needed? (Answer: Required ending allowance $2,300; debit adjustment $800.)
- A hypothetical business has $120,000 current at 0.5%, $30,000 1–30 days past due at 2%, $15,000 31–60 days past due at 12%, and $5,000 more than 60 days past due at 40%. Its allowance has a $250 debit balance. What is the required ending allowance and credit adjustment? (Answer: Required ending allowance $5,000; credit adjustment $5,250.)
- A hypothetical firm estimates $325 uncollectible for current receivables, $540 for 1–30 days past due, $1,620 for 31–60 days past due, and $1,500 for older balances. Its allowance has a $4,200 credit balance. What adjustment is required, and in which direction? (Answer: Required ending allowance $3,985; debit adjustment $215.)