Methods to Calculate Bad Debt Expense
There are two main ways to account for bad debt: the direct write-off method and the allowance method. The right choice depends on the size of your business, your reporting obligations, and how much precision and compliance your process demands. Let's break down each method.
Direct Write-Off Method
The direct write-off method records bad debt only after a specific account is deemed uncollectible. It’s a simple process but doesn’t match GAAP accounting standards and the accrual accounting matching principle because it doesn’t match bad debt to the period when the original sale occurred.
How to use it:
- Identify an unpaid invoice that is unlikely to be collected.
- Determine that all collection efforts have failed.
- Record the bad debt as an expense and reduce accounts receivable.
Example: A small business determines that a $500 invoice is uncollectible. The journal entry would be:
- Bad Debt Expense: 500
- Accounts Receivable: 500
This method is best suited for small businesses that don’t report under GAAP and have minimal uncollectible amounts.
Allowance Method
The allowance method helps businesses estimate how much of their accounts receivable may eventually become uncollectible. Unlike the direct write-off method, this approach anticipates losses before they occur, using historical data or customer trends to make an informed guess.
It creates better alignment with GAAP by recording bad debt expense in the same period as the related credit sales, leading to more timely and accurate reporting.
There are two widely used approaches to the allowance method:
Percentage of Bad Debt
This approach estimates bad debts as a fixed percentage of total credit sales. It’s based on the assumption that a predictable portion of credit sales will go unpaid, using historical data as a guide.
To determine the percentage used in the calculation, businesses often analyze past performance using this formula:
Percentage of Bad Debt = Total Bad Debts / Total Credit Sales
Once this percentage is established, it’s applied to current period credit sales to calculate the expected bad debt expense:
Bad Debt Expense = Estimated % × Total Credit Sales
Example: If a company determines from historical data that 1.5% of its credit sales typically go uncollected, and current credit sales total $200,000, the calculation is:
Bad Debt Expense = 0.015 × $200,000 = $3,000
Aging of Accounts Receivable Method
The aging method evaluates the likelihood that receivables will remain unpaid by segmenting outstanding invoices into aging buckets (e.g., 30, 60, 90+ days). Each bucket is assigned a different probability of default, with older receivables carrying a higher estimated bad debt percentage.
Example: Suppose a company segments its $100,000 in receivables as follows:
- Current: $60,000 (1% estimated uncollectible)
- 31–60 days: $25,000 (3% estimated uncollectible)
- 61–90 days: $10,000 (5% estimated uncollectible)
- 90+ days: $5,000 (10% estimated uncollectible)
Bad debt expense is calculated as:
(60,000 × 0.01) + (25,000 × 0.03) + (10,000 × 0.05) + (5,000 × 0.10) = $600 + $750 + $500 + $500 = $2,350
Both approaches to the allowance method offer finance teams structured, GAAP-compliant ways to plan for losses. Choosing the right one depends on your company’s complexity, reporting needs, and how closely you want to align reserves with receivables risk.