Days Sales Outstanding (DSO) Calculator

Estimate how quickly you collect receivables. DSO = (Average A/R ÷ Net Credit Sales) × Days in Period.

Use (Beginning A/R + Ending A/R) ÷ 2 for the period.
$
$
$
$

Results

  • Days Sales Outstanding (DSO) days
  • Receivables Turnover
  • Average Accounts Receivable $
  • Collection Efficiency

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

Monthly DSO & Receivables Metrics (example data)
PeriodCredit SalesBeginning A/REnding A/RAverage A/RDays in PeriodAvg Daily SalesDSO (days)Receivables Turnover (×)Best-Possible DSO (days)
Apr 2025120,000.0080,000.0085,000.0082,500.00304,000.0020.631.4510.00
May 2025135,000.0085,000.0090,000.0087,500.00314,354.8420.091.549.65
Jun 2025125,000.0090,000.0088,000.0089,000.00304,166.6721.361.409.84
Jul 2025140,000.0088,000.0092,000.0090,000.00314,516.1319.921.569.52
Aug 2025150,000.0092,000.0095,000.0093,500.00314,838.7119.321.609.09
Sep 2025145,000.0095,000.0093,000.0094,000.00304,833.3319.451.549.00
Notes & formulas:
  • Average A/R = (Beginning A/R + Ending A/R) / 2
  • Avg Daily Sales (ADS) = Credit Sales / Days in Period
  • DSO = Average A/R / ADS
  • Receivables Turnover = Credit Sales / Average A/R
  • Best-Possible DSO ≈ Current (not past-due) A/R / ADS

How to Use the DSO Calculator

  1. Decide your period: monthly, quarterly or annually.

  2. Gather your Accounts Receivable at beginning and end of the period (or use ending balance if simpler).

  3. Gather Net Credit Sales or Total Sales for the same period (exclude cash sales if possible).

  4. Plug into the formula: (Average AR ÷ Net Credit Sales) × Number of Days.

  5. Interpret results:

      • If DSO is increasing, your collections may be weakening or credit terms loosening.

    - Compare your DSO with industry peers and historical trend to identify issues.

    - Use the metric to monitor and improve your working-capital/receivables process.

Frequently Asked Questions

Methodology & Sources

Bibliography

  1. Days Sales Outstanding (DSO) — Corporate Financial Institute
    Accessed 2025-11-03