Days Sales Outstanding Calculator

Why DSO matters for a small business

A profitable business can still run out of cash if customers take too long to pay. Days sales outstanding converts your receivables balance into time, which is easier to compare from quarter to quarter than a dollar figure that rises and falls with sales.

Compare DSO with your own terms first. If you offer 30-day terms and your DSO is 40, customers take about 10 days longer than agreed on average. The dollar figure shows how much cash would come in if they all paid on time.

The formulas

DSO

DSO = Accounts receivable ÷ Credit sales × Days in period

Cash tied up beyond terms

Excess = (DSO − Payment terms) × (Credit sales ÷ Days in period)

Worked example

At quarter end, a company has $80,000 of unpaid invoices and made $180,000 of credit sales over 90 days. It offers 30-day terms.

1. Daily credit sales: $180,000 ÷ 90 = $2,000.00.
2. DSO: $80,000 ÷ $2,000 = 40 days.
3. Beyond terms: 40 − 30 = 10 days.
4. Cash tied up beyond terms: 10 × $2,000 = $20,000.00.

Reading it with care

• It is an average. One large overdue invoice can distort the figure, so check an aged receivables report too.
• Use credit sales only. Including cash sales makes collection look faster than it is.
• Sales timing affects it. A jump in sales late in the period raises receivables and pushes up DSO, even if everyone pays on time.
• Look at the trend. A slow rise over several periods is usually more important than a single reading.

Ways to bring DSO down

Invoice immediately when work is delivered, make due dates obvious, take deposits on larger jobs and send reminders before an invoice is overdue. Where it makes sense, you could add late fees or early payment discounts to your terms.