Bad Debt Expense Calculator
Estimate uncollectible accounts expense using either the percentage of sales or the aging of receivables method.
Use the Bad Debt Expense Calculator
Estimation Method
Percentage of Sales Method
Enter the percentage of net credit sales that historically become uncollectible.
Aging of Receivables Method
Enter each age bucket balance and the estimated uncollectible % for that bucket.
| Age Bucket | Balance ($) | Rate (%) |
|---|
Enter the existing credit balance as a positive number; a debit balance as negative.
Fill in the inputs and click Calculate.
Aging Schedule Breakdown
| Age Bucket | Balance | Rate | Est. Uncollectible |
|---|---|---|---|
| Total |
Suggested Journal Entry
| Account | Debit | Credit |
|---|---|---|
| Bad Debt Expense | — | |
| Allowance for Doubtful Accounts | — |
Summary
Summary
Bad debt expense is the amount a business expects will never be collected from its credit customers. This calculator supports two standard estimation methods: the percentage of sales (income statement) approach, which applies a historical loss rate directly to net credit sales, and the percentage of receivables (aging) approach, which targets the desired ending balance in the Allowance for Doubtful Accounts based on how long invoices have been outstanding. Both methods comply with GAAP matching and conservatism principles.
How it works
- Select the method: Percentage of Sales or Percentage of Receivables (Aging).
- For the sales method, enter net credit sales and your uncollectible rate.
- For the aging method, enter each age bucket balance and its estimated uncollectible percentage.
- Enter the current Allowance for Doubtful Accounts balance (positive = credit, negative = debit) for the aging method.
- The calculator instantly shows bad debt expense, the required journal entry amount, and a summary.
Use cases
- Prepare the year-end bad debt expense journal entry.
- Reconcile the Allowance for Doubtful Accounts balance.
- Compare how much expense each method produces before choosing one.
- Estimate allowance requirements during monthly close.
- Support audit documentation with a transparent calculation.
- Teach accounting students the difference between the two GAAP methods.