---
title: "Bad debt ratio: Definition, formula and example"
description: "Bad debt ratio explained: the formula using expense or write-offs, a worked example with recoveries, what a good ratio is, and how CECL feeds it."
url: https://emptyspaces.ai/glossary/bad-debt-ratio
language: en
---

[Home](https://emptyspaces.ai/) [Glossary](https://emptyspaces.ai/glossary) Bad debt ratio

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

Updated November 17, 2026[Accounts receivable, billing and collections](https://emptyspaces.ai/glossary#browse)

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 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.

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](https://emptyspaces.ai/product/close) 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

## Related terms

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).

Net credit sales Sales made on credit during a period, minus returns, allowances, and discounts, excluding cash sales.

Days sales outstanding (DSO) Average days to collect receivables: average gross accounts receivable divided by credit sales, times days in the period. Ending AR is a simpler proxy.

Accounts receivable turnover ratio How many times a year a company collects its receivables: net credit sales divided by average accounts receivable.

Collection effectiveness index (CEI) Percentage measuring how much collectible receivables were actually collected in a period, with 100 percent meaning everything collectible was collected.

Average days delinquent (ADD) Average days late customers pay: days sales outstanding minus best possible DSO, showing how overdue the typical payment is.

Full guides: [Month-end close KPIs](https://emptyspaces.ai/resources/blog/month-end-close-kpis), [Adjusting entries](https://emptyspaces.ai/resources/blog/adjusting-entries), and [Balance sheet reconciliation](https://emptyspaces.ai/resources/blog/balance-sheet-reconciliation).

Measure the bad debt ratio on an allowance that ties to the ledger.

Our Close Agent ties the AR subledger to the general ledger at close and prepares the entry. Your team approves before anything posts.

[Book a working session](https://emptyspaces.ai/contact-us)

No implementation commitment.

[All 721 glossary terms](https://emptyspaces.ai/glossary)
