Formula
The standard formula for Days Sales Outstanding (DSO) is:
DSO = (Average Accounts Receivable ÷ Net Credit Sales) × Number of Days in Period
Where “Average Accounts Receivable” often equals (Beginning AR + Ending AR)/2.
A simplified version:
DSO = (Accounts Receivable ÷ Total Sales) × Number of Days
Period Credit Sales Beginning A/R Ending A/R Average A/R Days in Period Avg Daily Sales DSO (days) Receivables Turnover (×) Best-Possible DSO (days) Apr 2025 120,000.00 80,000.00 85,000.00 82,500.00 30 4,000.00 20.63 1.45 10.00 May 2025 135,000.00 85,000.00 90,000.00 87,500.00 31 4,354.84 20.09 1.54 9.65 Jun 2025 125,000.00 90,000.00 88,000.00 89,000.00 30 4,166.67 21.36 1.40 9.84 Jul 2025 140,000.00 88,000.00 92,000.00 90,000.00 31 4,516.13 19.92 1.56 9.52 Aug 2025 150,000.00 92,000.00 95,000.00 93,500.00 31 4,838.71 19.32 1.60 9.09 Sep 2025 145,000.00 95,000.00 93,000.00 94,000.00 30 4,833.33 19.45 1.54 9.00
Notes & formulas: