Calculate DSO with the right sales and receivables inputs

To calculate days sales outstanding, or DSO, divide ending accounts receivable by credit sales for the same period, then multiply by the number of days in that period. The result estimates the average number of days a company takes to collect payment after a credit sale.

A lower result generally indicates quicker collection. A higher result means receivables are collected more slowly and may create cash-flow strain.

How to calculate DSO

Use either equivalent form of the simple DSO formula:

DSO = (Ending accounts receivable ÷ total credit sales) × number of days in the period

DSO = Ending accounts receivable ÷ (total credit sales ÷ number of days in the period)

The second form expresses the calculation as receivables divided by average daily credit sales.

1. Choose a reporting period. Use a specific month, quarter or year, and use the number of days in that period.
2. Take accounts receivable at the end of the period. For the simple method, this is the balance of outstanding customer invoices at period end, taken from the balance sheet.
3. Identify credit sales during the same period. These are sales for which payment is due later. Exclude cash sales from the calculation.
4. Apply the formula. Use consistent receivables and sales definitions when tracking the measure over time.

Worked example: a 30-day monthly DSO calculation

Hypothetical inputs

• Ending accounts receivable: $200,000
• Credit sales during the 30-day month: $600,000
• Days in the period: 30

Calculation

DSO = ($200,000 ÷ $600,000) × 30

DSO = 0.3333 × 30

DSO = 10 days

The month-end receivables balance is equal to roughly 10 days of that month's credit sales. The simple method provides a period average.

Use consistent inputs

Pair the period-end receivables balance with credit sales from the matching month, quarter or year. Cash sales should remain outside the denominator because DSO measures collection after credit sales.

APQC sets out a separate annual measure using average gross accounts receivable ÷ (total gross annual sales ÷ 365). Its approach excludes unbilled receivables. Organisations using either ending or average receivables should retain that definition consistently across the series.

Simple DSO and countback DSO

• Simple DSO: uses one period-end receivables balance, matching-period credit sales and the number of days in the period. It is a quick period-average measure.
• Countback DSO: starts with current receivables and works backward through monthly sales. Add all days in each recent month where remaining receivables exceed that month's sales. In the final month, add remaining receivables divided by that month's sales, multiplied by that month's days.

Countback may be useful where sales are uneven or seasonal, since the simple calculation does not account for sales fluctuations.

How to interpret DSO

Compare DSO with the company's prior periods, payment terms and recurring seasonal pattern. Comparisons with businesses in the same industry and with similar business models and proportions of credit sales are more informative than a universal target.

A rising DSO may reflect slower payment, longer credit terms, customer financial difficulty, or invoicing and collections issues. DSO is also a component of the cash conversion cycle, which combines customer-collection timing with inventory and supplier-payment timing.

Frequently asked questions

Why are cash sales excluded from DSO?

DSO measures the time required to collect credit sales. Cash sales are excluded from the calculation because they do not represent receivables awaiting collection.

What is a good DSO for a business?

There is no universal good DSO. The useful comparison depends on industry, business model, credit-sales proportion, payment terms and seasonality. Compare the figure with the company's own history and relevant peers.

How does countback DSO handle seasonal sales?

Countback works backward through monthly sales from the current receivables balance. It adds full days for months in which remaining receivables exceed sales, then calculates a fraction of days in the final month. This approach may better reflect uneven or seasonal sales.

Sources

• Understanding Days Sales Outstanding (DSO) — www.investopedia.com
• Days Sales Outstanding (DSO): How to Calculate and ... — www.salesforce.com
• DSO Formula: How to Calculate, Benchmark & Improve — upflow.io
• What is DSO in Finance? - APQC — www.apqc.org