Skip to content

What is the bad debt ratio? Definition, formula, and example

Accounts receivable, billing and collections

Definition

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 versionCalculationResult
Expense basis$240,000 ÷ $12,000,000 × 1002.00%
Write-off basis, net of recoveries($210,000 − $30,000) ÷ $12,000,000 × 1001.50%
Gross write-offs, no recoveries$210,000 ÷ $12,000,000 × 1001.75%
Expense ÷ total sales (understated)$240,000 ÷ $12,800,000 × 1001.88%
Allowance for doubtful accounts, fiscal 2026Amount
Beginning balance, January 1$90,000
Add: bad debt expense240,000
Less: write-offs(210,000)
Add: recoveries30,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:

DateAccountDebitCredit
FY 2026Bad debt expense240,000
Allowance for doubtful accounts240,000
FY 2026Allowance for doubtful accounts210,000
Accounts receivable210,000
FY 2026Accounts receivable30,000
Allowance for doubtful accounts30,000
FY 2026Cash30,000
Accounts receivable30,000
Total510,000510,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.

TermWhat it isHow it differs from the bad debt ratio
Bad debt expenseExpense recognized for receivables expected not to be collected, recorded with an increase in the allowance for doubtful accounts or on direct write-offThe numerator on the expense basis
Write-offRemoving an uncollectible receivable from the books by reducing the receivable and charging the allowance or bad debt expenseThe numerator on the write-off basis
Allowance for doubtful accountsContra-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 collectedMeasures 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.

  1. Age receivables: Run the aging and update expected-loss rates
  2. Book the provision: True up the allowance to the CECL estimate
  3. Post write-offs and recoveries: Charge or credit the allowance
  4. 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