About the Bad Debt Expense Calculator
This bad debt expense calculator estimates how much of your accounts receivable you will not collect, using the three allowance methods taught in accounting courses and used at month-end: percentage of credit sales (income statement approach), percentage of receivables, and the aging of receivables method (balance sheet approaches). It returns the bad debt expense to record, the required ending balance in the allowance for doubtful accounts, and the net realizable value of receivables.
It is built for bookkeepers, controllers, small business owners and students who need the adjusting journal entry: debit bad debt expense, credit allowance for doubtful accounts. Enter your receivables by aging bucket and the loss rates you expect for each, and the existing balance in the allowance account before adjustment; the calculator works out the plug.
Loss rates should come from your own collection history, adjusted for current conditions — the defaults are illustrative only. Under the balance sheet methods the expense is the difference between the required allowance and the unadjusted balance (a debit balance is entered as a negative number), so it can even be negative when the allowance is already too high. The direct write-off method is not GAAP for material receivables and is not covered.
With the default inputs, the bad debt expense to record is $4,400.00. Change any value above to recalculate instantly.
How to use the bad debt expense calculator
- 1Choose the estimation method: aging, percentage of receivables or percentage of credit sales.
- 2Enter receivables in each aging bucket (from an AR aging report).
- 3Enter the expected loss rate for each bucket, for total receivables, or for credit sales.
- 4Enter the allowance balance before adjustment — negative if it has a debit balance.
- 5Record the bad debt expense shown as your adjusting journal entry.
Formula and method
The aging method applies a loss rate to each aging bucket — older balances get higher rates because they are less likely to be paid — and adds them up to get the allowance the balance sheet should show. The percentage-of-receivables method is a simplified version with one rate on total receivables. For both balance-sheet methods, bad debt expense is the adjustment needed to move the allowance from its unadjusted balance to the required balance.
The percentage-of-sales method focuses on matching expense with revenue: bad debt expense equals credit sales times the historical loss rate, and the ending allowance is the unadjusted balance plus that expense. Net realizable value is gross receivables minus the ending allowance.
- Loss rate
- Expected percentage of a balance that will not be collected
- Unadjusted allowance
- Credit balance in the allowance before this adjustment (negative if debit)
- NRV
- Gross receivables − allowance for doubtful accounts
Worked examples
Aging method with an existing credit balance
Applying the loss rates gives $1,200 + $1,200 + $1,500 + $2,000 + $2,500 = $8,400 required allowance on $188,000 of receivables. The allowance already has a $4,000 credit balance, so bad debt expense is $8,400 − $4,000 = $4,400, and receivables are reported at $179,600.
Percentage of credit sales
With $900,000 of credit sales and a 1.5% historical loss rate, bad debt expense is $13,500 regardless of the existing allowance. The allowance rises from $4,000 to $17,500, leaving net receivables of $188,000 − $17,500 = $170,500.
Percentage of receivables with a debit balance
Five percent of $188,000 requires a $9,400 allowance. Because write-offs left a $1,200 debit balance, the adjustment must cover both: $9,400 + $1,200 = $10,600 of bad debt expense.
Frequently asked questions
How do you calculate bad debt expense?+
Under the allowance method, either multiply credit sales by a historical loss rate (percentage of sales), or estimate the required allowance from receivables — often by aging bucket — and record the difference between that and the current allowance balance as expense.
What is the allowance for doubtful accounts?+
It is a contra-asset account that reduces gross accounts receivable to the amount the company expects to collect. It is increased by bad debt expense and reduced when specific customer balances are written off as uncollectible.
What is the difference between the aging method and percentage of sales?+
The aging method is a balance-sheet approach that sets the allowance based on how old receivables are, so the expense is a plug. The percentage-of-sales method is an income-statement approach that sets the expense from sales, and the allowance balance is whatever results.
What if the allowance has a debit balance before adjustment?+
A debit balance means more accounts were written off than were reserved. Under the aging or receivables method you add that debit balance to the required allowance, so bad debt expense is larger than the ending allowance.
What loss rates should I use for each aging bucket?+
Base them on your own history: divide past write-offs by the balances that were in each bucket, then adjust for current economic conditions and specific risky customers. Under CECL (ASC 326), US GAAP entities must also consider reasonable forecasts.
Is the direct write-off method allowed?+
The direct write-off method expenses a receivable only when it is deemed uncollectible. It is used for US tax purposes, but it is not acceptable under GAAP when bad debts are material because it does not match the expense with the related revenue.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.