Worked example
Start with Accounts receivable of $40,000, Revenue in the period of $120,000, and 90 days in the period. Days sales outstanding is 30.0. The breakdown is Revenue per day of $1,333.33.
How this number is made
Days sales outstanding is receivables divided by daily revenue. A rising number means customers are paying slower, or you are booking revenue you will not collect. Use a period that matches the receivable.
- Revenue is the credit sales if cash sales never become receivables.
- Days in the period is 30, 90, or 365, matching the revenue figure.
Formula
DSO = receivables ÷ (revenue ÷ days).
Questions
What is a good DSO?
Lower than your payment terms, roughly. A DSO of 70 on net-30 invoices means you are not being paid on time.
Do cash sales belong?
They lower the average and hide a slow credit book. Exclude them if you can.