Bad debt expense represents the portion of accounts receivable (AR) that a business does not expect to collect. To calculate bad debt expense with accounts receivable, review all AR balances, analyze historical payment patterns, and identify invoices unlikely to be collected. Use methods like percentage of sales or aging of receivables to estimate uncollectible amounts. Record the bad debt expense in your accounting system and set up an allowance for doubtful accounts. This ensures accurate financial statements, realistic cash flow forecasts, and helps make informed decisions about client credit and future invoicing.
Understand What Bad Debt Expense Is
Bad debt expense occurs when customers fail to pay invoices and the amounts are deemed uncollectible. Recognizing this expense aligns revenue with actual expected cash flow and complies with accrual accounting principles.
Example: A construction company issues $50,000 in invoices, but after several collection attempts, $2,500 is expected to be uncollectible. This $2,500 is recorded as bad debt expense.
Choose a Method for Estimating Bad Debt
There are two common methods to calculate bad debt:
1. Percentage of Sales Method
- Estimate a fixed percentage of total credit sales as bad debt.
- Commonly based on historical data.
Example:
- Total credit sales: $100,000
- Historical bad debt rate: 2%
- Bad debt expense = $100,000 × 2% = $2,000
2. Aging of Accounts Receivable Method
- Classify AR by age and assign different risk percentages.
- Older invoices have higher chances of being uncollectible.
Example:
Record the Bad Debt Expense
Once calculated, record the expense in your accounting system:
Journal Entry Example:
- Debit: Bad Debt Expense $3,150
- Credit: Allowance for Doubtful Accounts $3,150
This creates an allowance account to offset AR, without removing invoices immediately from the ledger.
Adjust the Allowance for Doubtful Accounts
As payments are received or invoices are written off, update the allowance account:
- Write-off Example: If $500 of AR is uncollectible:
- Debit: Allowance for Doubtful Accounts $500
- Credit: Accounts Receivable $500
This keeps AR and financial statements accurate.
Analyze and Refine Estimates
Regularly review bad debt estimates for accuracy:
- Compare historical estimates with actual write-offs.
- Adjust percentages based on trends or changes in client payment behavior.
- Monitor industry-specific risk factors that may affect collectability.
Example: A contractor notices clients in a new service line have a higher default rate, so they increase the bad debt percentage from 2% to 4% for those invoices.
Use Automation Tools for Tracking
Modern accounts receivable automation software can simplify the calculation of bad debt expense by:
- Generating aging reports automatically
- Suggesting bad debt estimates based on historical data
- Recording journal entries and adjusting allowances in real-time
Examples: DepositFix allows businesses to track AR and calculate bad debt efficiently.
Maintain Documentation
Keep detailed records of:
- AR aging reports
- Estimates used for bad debt
- Journal entries and adjustments
- Written-off invoices
Proper documentation is important for audits, tax compliance, and internal financial analysis.
To write off accounts receivable, review overdue invoices, exhaust collection efforts, and record bad debts to maintain accurate books and cash flow forecasts.
Calculate net accounts receivable by subtracting allowances for doubtful accounts from total AR to see the actual expected cash inflow for accurate financials.
To calculate gross accounts receivable, total all outstanding invoices before allowances, track unpaid balances, and monitor cash flow for effective collections.
Ready to streamline your payment operations?
Discover the hidden automation in your payment, billing and invoicing workflows. Talk to our experts for a free assement!
