Days sales outstanding turns receivables into an approximate number of days, but cannot identify which customer is late or why. It becomes useful when compared with credit terms, past trend and the aging report.
What collection days can tell you
A common formula divides average receivables by period credit sales and multiplies by period days. Use a consistent basis and consider cash sales, tax and seasonality. Lower days may reflect better collection or simply a changed sales mix.
Calculate days on a consistent basis
Average receivables of SAR 200,000 and annual credit sales of SAR 2.4 million produce about 30.4 days using 365 days. If terms are 20 days, the aging and customer detail need review rather than relying on the ratio alone.
A falling indicator can mislead
With average receivables of SAR 120,000 and credit sales of SAR 360,000 over ninety days, approximate collection days are 120,000 ÷ 360,000 × 90 = 30. Use consistent treatment of tax and returns in numerator and denominator. Do not silently compare receivables from credit sales with total sales including cash transactions.
Thirty days does not mean every customer pays on day thirty. Half the customers might pay within two weeks while a large balance remains overdue for months. Accompany the indicator with ageing, overdue proportions and disputed amounts. The average describes the trend; detail identifies the customer requiring a call, invoice correction or credit decision.
The measure can improve because late-period sales increased rather than because collections improved. It can also fall after writing off an old receivable without receiving any cash. Explain growth, seasonality, customer mix and write-offs when comparing periods. A favourable indicator should prompt investigation of the cause, not end it.
Relate targets to actual selling terms. A business offering approved sixty-day contracts cannot be directly compared with a cash retailer. Grouping customers with similar terms and tracking each group against its own history produces a more meaningful view of changes in collection behaviour.
- Define period credit sales and average receivables.
- Calculate on a consistent basis and compare with terms.
- Open the aging report and identify material overdue items.
- Assign an action, owner and date to each important case.
A better number without better collection
Suppose one longstanding customer has a large overdue balance while new customers generate strong sales this month. Average collection days can fall because the denominator grew, even though the old problem is unchanged. Maintain a consistent watchlist of major overdue balances rather than replacing it every month with the biggest current sellers.
State the calculation period, sales source and receivables averaging method. Add a plain explanation such as “The improvement reflects new sales; the largest overdue balance remains unpaid.” That makes the indicator useful for fair follow-up across both sales and collections.
Sources & further reading
Visit the original source to explore the concept and its wider context.
General educational content. Appropriate treatment depends on your business and accounting policies; consult your accounting professional when applying it to business records.
