The bad debt ratio measures the cost of customer credit losses relative to sales. While DSO and the overdue ratio focus on cash collection and payment delays, this indicator addresses another essential objective of credit management: protecting profitability by preventing losses on trade receivables.
Accelerate customer payments
Reduce cash tied up in receivables and improve working capital through sound payment terms, dispute resolution and collection processes.
Measure performance with DSO, the overdue ratio and collection efficiency.
Prevent bad debt losses
Assess customer risk, secure transactions and act before receivables become irrecoverable.
Measure the financial consequences through the bad debt ratio and the quality of the receivables portfolio.
What is the bad debt ratio?
The bad debt ratio compares the cost of uncollectible and impaired trade receivables with sales over the same period. It is an ex post indicator: it measures the financial impact of losses and changes in expected credit losses, not simply the number of invoices that are late.
Bad debts affect the income statement through impairment expenses and write-offs. They can reduce profit and, ultimately, equity. They are therefore not just a collection issue: they directly affect the company's ability to finance its development.
Bad debt ratio formula
Bad debt ratio (%)
(Bad debt write-offs + new impairment charges − impairment reversals − recoveries already recognised as income)
÷ Net sales for the period × 100
Use the appropriate accounting classification and avoid double-counting write-offs already covered by an allowance.
The original article uses the same principle: losses for the period plus provisions for doubtful or old debts, less reversals, divided by turnover. For reliable reporting, however, write-offs and provisions must be reconciled. When a fully provided receivable is written off, the write-off is generally offset by the use of its existing allowance; counting both the historical impairment charge and the gross write-off as separate new losses would overstate the ratio.
For international groups, definitions must also be consistent with the applicable accounting framework (such as IFRS 9 or local GAAP). Under IFRS 9, expected credit losses on trade receivables may be recognised before an invoice is overdue.
Worked example
| Item | Annual amount |
|---|---|
| Net sales | €20,000,000 |
| New impairment expense and uncovered write-offs | €85,000 |
| Impairment reversals and recoveries recognised in income | −€25,000 |
| Net bad debt cost | €60,000 |
| Bad debt ratio | 0.30% |
Calculation: €60,000 / €20,000,000 × 100 = 0.30%. In this example, every €1 million in sales generates €3,000 of net credit loss expense. The ratio should be compared with prior periods, portfolio segments and the company's gross margin.
How should you interpret the result?
The original tutorial recommends keeping the ratio below 1%, ideally below 0.2%. These are management ambitions rather than universal benchmarks. An acceptable level depends on margins, customer concentration, industry, credit terms, geography, security and accounting methodology.
A low ratio
May indicate effective prevention, but also check whether impairment allowances are adequate. Under-provisioning can make the indicator artificially attractive.
A rising ratio
Investigate customer insolvencies, disputes, ageing, concentration and changes in the provisioning methodology.
A volatile ratio
A single large default or an annual provisioning review may dominate a monthly or quarterly measure.
For example, with a gross margin of 20%, an additional €100,000 bad debt loss would require €500,000 of additional sales at the same margin to offset the lost gross profit, assuming no additional fixed costs. This illustrates why preventing bad debts can be more valuable than accelerating already-secure payments.
Bad debt ratio versus other credit management KPIs
| Indicator | What it measures | Management question |
|---|---|---|
| DSO | Days of sales tied up in receivables | How much cash is immobilised? |
| Overdue ratio | Overdue balance as a share of total receivables | How much of the portfolio is late? |
| Bad debt ratio | Net credit loss cost relative to sales | How much profitability is being lost? |
| Collection efficiency | Cash collected compared with the amount collectible | How effective are collection activities? |
These indicators are complementary. A company can have a satisfactory DSO while suffering a major loss on one strategic customer; conversely, an increase in DSO does not necessarily mean that the eventual bad debt ratio will deteriorate.
How to reduce the bad debt ratio
1. Assess customer creditworthiness
Review financial statements, payment behaviour, customer concentration and the economic environment before and during the commercial relationship. Start with customer credit assessment.
2. Secure material exposures
Adapt credit limits and payment terms. Depending on the situation, use advance payments, guarantees or credit insurance.
3. Resolve disputes early
Many overdue invoices result from billing errors, missing documents, contractual disagreements or internal communication failures rather than insolvency. Correct the underlying process.
4. Escalate before recovery becomes unlikely
Use ageing analysis, payment promises and risk signals to prioritise actions. Where necessary, consider bad debt collection and legal remedies.
Reducing losses requires a company-wide credit culture. Sales teams, customer service, billing, accounting, legal and credit management all influence whether an invoice will ultimately be paid. The best bad debt is the one prevented before it arises.
Digital reporting and accounting discipline
A digital credit management system can identify doubtful invoices, document the reasons for non-payment, track disputes and support reviews of impairment allowances. My DSO Manager supports customer risk monitoring and cash collection workflows, including the identification of potentially irrecoverable invoices.
However, automation does not replace accounting judgement. Finance and credit management teams should agree on a documented methodology, reconcile invoice-level statuses with the general ledger, and distinguish risk exposure, overdue invoices, impaired receivables and final write-offs.
For consistent reporting, use the same period, currency conversion policy, sales denominator, treatment of VAT and provisioning rules across business units. Where the portfolio changes materially, compare like-for-like segments.
Frequently asked questions
Is a late invoice automatically a bad debt?
No. An overdue invoice is not necessarily irrecoverable. A solvent customer may pay late because of an administrative issue or a commercial dispute.
Can the bad debt ratio be negative?
Yes. In a period with significant impairment reversals or recoveries of previously written-off debts, the net expense may be negative. This does not mean that customer risk has disappeared.
Should the ratio be calculated monthly or annually?
Both can be useful. Monthly monitoring detects changes, while a rolling 12-month measure can reduce distortions caused by irregular impairment reviews or isolated defaults.
Does credit insurance eliminate the bad debt ratio?
No. Policies have limits, deductibles, exclusions and reporting obligations. Insurance compensation and accounting treatment must be considered separately.
Explore related credit management tutorials
- Credit Management: principles, organisation and performance
- DSO calculation: methods and examples
- Overdue ratio: calculation and interpretation
- Bankruptcy proceedings: protecting your receivables
This tutorial describes a management indicator, not a substitute for accounting policies or professional advice. Accounting treatment depends on the applicable standards and facts.
