How to Review Accounts Receivable Using Days Sales Outstanding

May 27 2017
How to Review Accounts Receivable Using Days Sales Outstanding

How to Review Accounts Receivable Using Days Sales Outstanding

Managing cash flow is a core responsibility for accounting teams. One practical way to evaluate how quickly customers are paying is to calculate Days Sales Outstanding, or DSO. Tracking this metric helps determine whether receivables are aligned with your standard payment terms and whether collection patterns are trending in the right direction.

DSO provides a clear view of how many days of sales remain uncollected. When monitored regularly, it helps accounting teams identify payment delays, spot trends, and evaluate whether customer behavior is shifting away from expectations.

How to Calculate DSO

To calculate DSO for a period, divide total credit sales for the most recent twelve months by 365 to determine average credit sales per day. Then take the beginning and ending accounts receivable balances for the period, add them together, and divide by two to determine your average receivables. Finally, divide the average receivables by the credit sales per day figure. The result is your DSO.

Example: A small distributor wants to confirm whether customers are paying according to Net 30 terms. The accounts receivable balance at the beginning of June was $54,000 and at the end of June it was $56,000. Total credit sales for the prior twelve months were $547,500.

$547,500 ÷ 365 = $1,500 per day

$54,000 + $56,000 = $110,000 ÷ 2 = $55,000 average receivables

$55,000 ÷ $1,500 = 36.6 DSO

A DSO of 36.6 indicates that customers are paying slightly beyond Net 30 terms. Monitoring this metric monthly helps teams identify movement in either direction and investigate the causes behind material changes.

Key Takeaways

  • DSO measures how many days of sales remain uncollected at any point in time.
  • Comparing DSO to standard terms helps assess collection performance.
  • Tracking DSO over time helps identify trends and potential payment issues early.

Conclusion

Understanding DSO provides accounting teams with practical insight into customer payment behavior and cash flow performance. Regularly calculating and reviewing this metric helps identify changes in receivables activity and supports better financial forecasting and decision-making.