Method 1: Percentage of Sales
Average bad debt as % of sales over past 3-5 years
Method 2: Aging Method
Method 3: Specific Accounts
Current Allowance
Current balance on books for comparison
Recommended Allowance
Aging Method
$42,750
Coverage Ratio:6.33%
Adjustment Needed:$57,250
Journal Entry
Debit:Allowance for Doubtful Accounts
Credit:Bad Debt Expense (recovery)
Amount:$57,250
Method Comparison
Percentage of Sales$125,000
Aging Method$42,750
Specific Identification$36,250
Aging Method Breakdown
0-30 days
$400,000 × 0.5%
$2,000
31-60 days
$150,000 × 3%
$4,500
61-90 days
$75,000 × 15%
$11,250
90+ days
$50,000 × 50%
$25,000
Total Reserve:$42,750
Specific Account Breakdown
ABC Corp (bankruptcy)
$25,000 × 100%
$25,000
XYZ Inc (dispute)
$15,000 × 75%
$11,250
Total Reserve:$36,250
Recommendations
- Significant variance between methods - review assumptions and historical data
- Adjustment exceeds 20% of recommended allowance - consider gradual adjustment over multiple periods
- Review allowance quarterly and adjust based on actual write-offs and collection trends
- Document methodology and assumptions for audit support
Frequently Asked Questions
Get Expert Financial Guidance
Speak with our team about how we can help streamline your back office operations.