What is the bad debt ratio? Definition, formula, and example
Accounts receivable, billing and collections
The bad debt ratio is bad debt expense or write-offs divided by credit sales over a period, showing expected or realized credit losses relative to net credit sales, depending on the numerator used. It's a receivables credit-quality KPI, also called the bad debt to sales ratio or bad debt percentage, and it isn't the leverage debt ratio (total liabilities divided by total assets) or a consumer debt-to-income ratio.
- Type
- Receivables credit-quality KPI
- Formula
- Bad debt ÷ net credit sales × 100
- Numerator
- Expense or net write-offs
- Not the same as
- The leverage debt ratio
Bad debt ratio formula
The bad debt ratio formula divides bad debt for a period by net credit sales for the same period, times 100. Pick one numerator and use it every period.
Expense basis: Bad debt ratio = Bad debt expense ÷ Net credit sales × 100
Write-off basis: Bad debt ratio = (Write-offs − Recoveries) ÷ Net credit sales × 100
- Bad debt expense: The provision charged to the income statement, which under CECL reflects expected losses
- Write-offs net of recoveries: Accounts actually removed, less amounts later collected
- Net credit sales: Credit sales minus returns, allowances, and discounts, excluding cash sales
Dividing by accounts receivable gives a different ratio. SEC filers often show both numerators in the allowance roll-forward that Regulation S-X Rule 12-09 (Schedule II) calls for, with additions "Charged to costs and expenses" and "Deductions."
Bad debt ratio example
The same year can produce four different bad debt ratios, depending on the numerator and denominator you pick.
Kestrel Packaging closes fiscal 2026 on Thursday, December 31, 2026, and uses the allowance method under CECL. Sales were $12,800,000, of which $800,000 were cash sales. All amounts are illustrative.
| Bad debt ratio version | Calculation | Result |
|---|---|---|
| Expense basis | $240,000 ÷ $12,000,000 × 100 | 2.00% |
| Write-off basis, net of recoveries | ($210,000 − $30,000) ÷ $12,000,000 × 100 | 1.50% |
| Gross write-offs, no recoveries | $210,000 ÷ $12,000,000 × 100 | 1.75% |
| Expense ÷ total sales (understated) | $240,000 ÷ $12,800,000 × 100 | 1.88% |
| Allowance for doubtful accounts, fiscal 2026 | Amount |
|---|---|
| Beginning balance, January 1 | $90,000 |
| Add: bad debt expense | 240,000 |
| Less: write-offs | (210,000) |
| Add: recoveries | 30,000 |
| Ending balance, December 31 | $150,000 |
| GL allowance balance | $150,000 |
| Difference | $0 |
The expense and write-off ratios differ because the provision reflects this year's change in expected losses, while many write-offs come from earlier sales.
How is bad debt recorded?
Under the allowance method, you debit bad debt expense and credit the allowance for doubtful accounts, then charge write-offs against the allowance. Kestrel's 2026 activity, in summary:
| Date | Account | Debit | Credit |
|---|---|---|---|
| FY 2026 | Bad debt expense | 240,000 | |
| Allowance for doubtful accounts | 240,000 | ||
| FY 2026 | Allowance for doubtful accounts | 210,000 | |
| Accounts receivable | 210,000 | ||
| FY 2026 | Accounts receivable | 30,000 | |
| Allowance for doubtful accounts | 30,000 | ||
| FY 2026 | Cash | 30,000 | |
| Accounts receivable | 30,000 | ||
| Total | 510,000 | 510,000 |
The direct write-off method, which expenses an account only when it's written off, isn't allowed under US GAAP when losses are material. In QuickBooks Online, the help guide uses a "Bad debts" expense account, the "Accounts Receivable Aging Detail" report, and a credit memo applied through "Receive payment," which is a direct write-off; under the allowance method you'd book the provision by journal entry instead.
What is a good bad debt ratio?
There's no universal good bad debt ratio, because it depends on your industry, terms, and customer mix. Track your own trend and compare it with your allowance assumptions.
For scale only, the Federal Reserve's charge-off rate on commercial and industrial loans at insured US-chartered commercial banks was 0.58% (seasonally adjusted, annualized, net of recoveries) in the second quarter of 2026, per its release last updated August 25, 2026. That measures bank loans, not trade credit.
What is the bad debt ratio confused with?
The bad debt ratio is most often confused with bad debt expense, write-offs, and the allowance. It's a ratio built from them.
| Term | What it is | How it differs from the bad debt ratio |
|---|---|---|
| Bad debt expense | Expense recognized for receivables expected not to be collected, recorded with an increase in the allowance for doubtful accounts or on direct write-off | The numerator on the expense basis |
| Write-off | Removing an uncollectible receivable from the books by reducing the receivable and charging the allowance or bad debt expense | The numerator on the write-off basis |
| Allowance for doubtful accounts | Contra-asset account that reduces receivables to the amount expected to be collected, built from estimated credit losses (CECL under US GAAP) | A balance; allowance ÷ AR is the allowance ratio |
| Collection effectiveness index (CEI) | Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collected | Measures collection speed, not losses |
How do you lower the bad debt ratio?
You lower the bad debt ratio by screening credit before you sell and acting early when invoices age.
- Credit checks and limits: Approve new accounts and cap exposure
- Deposits or cash in advance: Use them for high-risk customers
- Dunning and credit holds: Remind early and stop shipping to accounts far past due
- Credit insurance or letters of credit: Transfer part of the risk
Bad debt ratio at month end
Calculate the bad debt ratio after the allowance is updated for the period, so the numerator matches the close.
- Age receivables: Run the aging and update expected-loss rates
- Book the provision: True up the allowance to the CECL estimate
- Post write-offs and recoveries: Charge or credit the allowance
- Tie out: Agree the allowance roll-forward and AR subledger to the general ledger
For FP&A, forecast bad debt expense as a percentage of forecast credit sales, using the expense-basis ratio. Our Close Agent ties the AR subledger to the general ledger at close and prepares the entry, and nothing posts until a named approver signs off.
Common bad debt ratio mistakes
The most common bad debt ratio mistakes mix two formulas or the wrong concepts into one number.
- Mixing denominators: Credit sales and accounts receivable give two different ratios
- Borrowing the leverage debt ratio: Liabilities ÷ assets and debt-to-income are unrelated
- Treating write-offs and expense as equal: They differ in amount and timing under the allowance method
- Ignoring recoveries: Net them against write-offs on the write-off basis
- Using total sales: Including cash sales understates the ratio