Free tool

DSO calculator: work out your days sales outstanding

Days sales outstanding (DSO) is the average number of days it takes your customers to pay you after a sale. Use this free calculator to see your DSO, how it compares with your own payment terms, and how much cash is tied up in late payment.

  • Your DSO

    Using the standard method and, if you want it, the countback method
  • Best possible DSO and average days delinquent (ADD)

    How much of your DSO comes from late payment
  • The cash tied up in late payment

    What you’d collect sooner if customers paid closer to their due date
  • A free PDF summary

    To share with your team

Nothing you enter is saved unless you ask for the PDF summary.

Work out your DSO

Enter figures from your accounts. Nothing is saved unless you ask for the PDF.

Only sales made on credit (invoiced), not cash sales.

Everything customers owe you.

Invoices still within their terms.

Companies that trust Chaser

Air IT logo
Bright+Network+Logo
gipsy hill brewery
Huttie Logo 1
Marvel logo
minor figures london
Wolfgang-digital-logo-264x104
image001
silverbug logo
Chaser-TaxAssist Logo Blue background
The-New-Statesman-Logo
Mindful education
pact coffee logo
runway east logo

How is DSO calculated?

DSO divides what customers owe you by what you sold on credit, then scales the result to the number of days in the period.

DSO = (total receivables ÷ credit sales for the period) × days in the period

Use credit sales only, not cash sales, and make sure the sales figure and the number of days cover the same period. That’s why the calculator sets the days for you when you pick a period.

A worked example

A business made £270,000 of credit sales last quarter (90 days). Customers owe it £150,000 today, and £90,000 of that isn’t due yet. Its payment terms are 30 days.

  • DSO: £150,000 ÷ £270,000 × 90 = 50 days.
  • Best possible DSO: £90,000 ÷ £270,000 × 90 = 30 days. This is the DSO the business would have if nothing were overdue.
  • Average days delinquent: 50 − 30 = 20 days. On average, customers pay 20 days after the due date.
  • Cash tied up in late payment: £270,000 ÷ 90 × 20 = £60,000. That’s exactly the overdue balance (£150,000 − £90,000).

Standard or countback DSO?

The standard method assumes your sales were spread evenly across the period. If your sales go up and down from month to month, the countback method is usually more accurate. It starts with your most recent month and works backward, adding each month’s days until the sales cover what customers owe.

Take the same £150,000 owed. October’s credit sales of £100,000 cover the first £100,000, so all 31 days of October count. The remaining £50,000 is covered by part of September’s £80,000, which counts as 50,000 ÷ 80,000 × 30 = 18.75 days. Countback DSO is 31 + 18.75 = 49.75 days.

MeasureWhat it tells youHow it’s calculated
DSOHow long customers take to pay, on averageTotal receivables ÷ credit sales × days in the period
Countback DSOThe same, adjusted for sales that change from month to monthWorks back month by month through your credit sales
Best possible DSOYour DSO if every customer paid on timeReceivables not yet due ÷ credit sales × days in the period
Average days delinquent (ADD)How late customers pay, on averageDSO − best possible DSO

What your results mean

The calculator judges your result by your average days delinquent (ADD): the part of your DSO that comes from customers paying after the due date. Your own payment terms sit alongside it as context, rather than an industry average, because they’re what you’ve agreed with your customers.

Why look at average days delinquent as well as DSO?

DSO moves when your sales go up or down, even if customers pay exactly as they always have. ADD strips that out by comparing your DSO with your best possible DSO, so it shows only the part that comes from late payment. That’s also why a DSO inside your payment terms can still hide late invoices. If ADD is falling, your collections are improving.

  • Your ADD is close to zero

    Customers are paying on time. Your DSO is about the same as your best possible DSO, so it comes from your payment terms rather than late payment. Check it every month: a rising ADD is often the first sign that one or two large customers have started to pay late.

  • You have a few days of ADD

    That’s close, but some invoices are late, and a handful of late payers can usually explain it. Your aged receivables report shows which invoices are holding the figure up.

  • You have more than a few days of ADD

    Late payment is tying up cash. Customers are regularly paying after the due date, and your ADD shows by how much. The cash figure is what you’d collect sooner if customers paid closer to their due date.

How to improve your DSO

  • Put clear payment terms and the due date on every invoice.

  • Send invoices as soon as the work is done or the goods are delivered.

  • Remind customers before the due date, on it and after it, on a set schedule.

  • Make paying easy, with a payment link on every invoice and reminder.

  • Follow up on overdue invoices consistently, and escalate the ones that stay unpaid.

  • Review your aged receivables every week, starting with the largest and oldest balances.

For more ideas, read how to reduce DSO.

How to calculate DSO in Excel

Put your total receivables in cell B1, your credit sales for the period in B2 and the number of days in the period in B3. Then enter =B1/B2*B3 in another cell.

For best possible DSO, put your receivables not yet due in B4 and enter =B4/B2*B3. ADD is the first result minus the second.

Bring your DSO down with Chaser

Chaser automates the routine work behind a lower DSO: personalized payment reminders sent on your schedule, a payment portal so customers can pay straight from the email, and a clear view of who owes you what. Your team spends less time chasing, and customers pay sooner.

See how DSO reduction software works.

FAQs

Quick answers to the questions people ask most about DSO and this calculator.

Accounts receivable support and services

Get hands-on support from Chaser’s receivables specialists to strengthen your collections process, resolve payment issues faster, and keep your cash flow on track.  

Start your 10-day free trial