Real DSO vs Reported DSO: Definition, Calculation and Methods
Real DSO vs Reported DSO: Definition, Formula and Calculation Methods

What Is DSO (Days Sales Outstanding)?
DSO (Days Sales Outstanding) measures the average number of days a company takes to collect payment after issuing an invoice. It is the central metric in B2B credit management.
Simple DSO formula:
DSO = (Accounts Receivable ÷ Credit Revenue) × Number of Days in the Period
Example: a company with €2M in receivables and €1M in monthly revenue shows a DSO of 60 days.
What Is the Difference Between Reported DSO and Real DSO?
Reported DSO is the figure automatically produced by ERPs using the simple method. Real DSO is the actual collection delay, calculated taking into account contractual terms by client, receivables age and individual payment behaviour.
The gap between the two can reach 10 to 20 days depending on the composition of the receivables portfolio. This gap results from the averaging effect: the simple method treats a current invoice and a 120-day overdue invoice identically.
Why Do ERPs Show an Inaccurate DSO?
ERPs calculate DSO using the simple method (or accounting method), which divides total receivables by the period's revenue. This method produces a balance-weighted average that masks three realities:
- Volume fluctuations: a large contract signed at end of quarter mechanically inflates receivables and raises DSO, even if payment behaviour hasn't changed.
- Variable contractual terms: an enterprise client paying on day 58 against 60-day terms is performing well. A small client paying on day 58 against 30-day terms is 28 days late. Consolidated DSO treats both identically.
- Silent accumulation of aged receivables: a portfolio with 20% of receivables over 90 days can show a DSO of 36 days, a reassuring figure that masks severe non-collection risk.
What Is the Count-Back Method (Exhaustion DSO)?
The count-back method (or exhaustion method) is an alternative to simple DSO calculation, considered the standard in professional credit management.
Instead of mechanically dividing receivables by revenue, it works backwards month by month, cumulatively subtracting each period's revenue from the receivables balance until fully exhausted.
Why it is more accurate: the count-back method precisely identifies how many months of sales remain outstanding, without being distorted by monthly volume variations. It is particularly useful for companies with seasonal or irregular sales.
Why ERPs don't use it by default: it requires more granular data and more complex calculation. The simple method is easier to automate.
What Is the Best Possible DSO (BPDSO)?
The Best Possible DSO (BPDSO) measures the theoretical DSO a company would achieve if every client paid exactly on their contractual due date, with no delays.
The gap between BPDSO and real DSO is called the collections performance gap. It represents the cost of payment delays expressed in days, directly convertible into euros of tied-up cash.
Example: a BPDSO of 35 days and a real DSO of 52 days means 17 days of revenue are blocked in avoidable delays. For a company with €10M annual revenue, this represents approximately €465,000 of unavailable cash.
What Is an Aging Report?
An aging report is a financial report that distributes accounts receivable into age buckets: 0–30 days, 30–60 days, 60–90 days, 90+ days.
It identifies at-risk receivables that consolidated DSO masks. A company showing a DSO of 42 days can simultaneously have €800,000 of receivables stuck beyond 90 days, a warning signal invisible in the surface figure.
Credit managers use the aging report to:
- Prioritise collections actions by age and amount
- Detect receivables migration between buckets (a leading indicator of DSO deterioration)
- Calculate provisions for doubtful debts
What Is the CEI (Collection Effectiveness Index)?
The CEI (Collection Effectiveness Index) measures the proportion of available receivables actually collected over a given period.
Formula:
CEI = [(Beginning receivables + Period sales − Ending receivables) ÷ (Beginning receivables + Period sales − Ending current receivables)] × 100
A CEI above 80% is generally considered healthy. The best credit management organisations exceed 90%.
Unlike DSO, the CEI measures actual collections efficiency independently of contractual terms. It is an essential complementary indicator.
What Is the Average DSO in Europe?
According to the Intrum 2024 European Payment Report:
- The average European DSO sits between 55 and 60 days
- Around 40% of companies report payment delays exceeding 60 days
- Large companies are the worst payers in 15 of the 20 member states surveyed
In France specifically, the average contractual term is around 50 days, significantly higher than Germany's 32-day average.
What Does the European Late Payment Directive Say?
The European Directive 2011/7/EU sets the legal framework for B2B payment terms in Europe:
- 30 days: default payment term between businesses
- 60 days maximum: contractual cap unless explicitly agreed otherwise
- €40 minimum recovery costs per unpaid invoice
- 8 points above the ECB rate: statutory interest rate applicable in the event of late payment
Requesting 30-day payment in B2B is not an aggressive demand, it is the application of the European legal standard.
What Are the 4 Actions to Fix Your DSO?
1. Segment your DSO calculation by client type, contractual term and geography. A single consolidated DSO masks opposite payment realities within the same portfolio.
2. Calculate your Best Possible DSO (BPDSO) to quantify the cost of delays in euros of tied-up cash.
3. Track migration in the aging report: acceleration in the 30–60 day segment signals DSO deterioration before it appears in the consolidated figure.
4. Combine DSO, aging report and CEI: DSO alone is not sufficient. These three indicators together give a complete picture of collections performance.