DSO tells you, on average, how many days your customers take to pay you.
Days sales outstanding equals trade receivables divided by credit sales for the period, multiplied by the number of days in the period. If receivables are 200,000 and monthly credit sales are 300,000, DSO for a 30-day month is 20 days. Track it monthly as a trend, compare it with your payment terms, and use best-possible DSO to separate slow payers from normal terms.
DSO = trade receivables ÷ credit sales for the period × days in the period
Use credit sales only. Cash sales were never owed to you, so including them makes DSO look better than it is. Use receivables before the bad debt provision, so the figure measures collection rather than accounting estimates.
| Item | Amount |
|---|---|
| Trade receivables at month end | 200,000 |
| Credit sales for the month | 300,000 |
| Days in the month | 30 |
| DSO = 200,000 ÷ 300,000 × 30 | 20 days |
In Excel: =B2/B3*B4
Best-possible DSO uses only receivables that are not yet due. It shows what DSO would be if every customer paid exactly on terms. The gap between actual DSO and best-possible DSO is the part you can influence through collection effort:
=CurrentReceivables/CreditSales*Days
If actual DSO is 45 and best-possible is 30, around 15 days of sales are sitting in overdue invoices.
Each day taken off DSO releases roughly one day of credit sales in cash. The free DSO calculator below works this out for your own numbers. For the wider routine, see the credit control process, and for how DSO fits with inventory and payables, the cash conversion cycle.
A single DSO figure invites the wrong questions. Report it alongside best-possible DSO, the value of overdue invoices, and the top five overdue customers with the reason each is late. That turns DSO from a number on a dashboard into a short list of actions for credit control and sales. Track the same measures every month, so improvement is visible and the team can see that the effort is working.
UK teams often call DSO "debtor days". The formula is the same. Exclude VAT or sales tax consistently: if receivables include tax, include it in sales too, or exclude it from both.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
One that is close to your standard payment terms and stable or falling. Compare with your own history and close competitors rather than a general benchmark.
Either, as long as the days match the period. Monthly DSO reacts quickly; a three-month rolling figure smooths out lumpy months.
DSO uses all receivables. Best-possible DSO uses only current, not-yet-due receivables. The gap shows how much is tied up in overdue invoices.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.