Anna is a CPA specializing in cash flow and working capital management, ensuring the accuracy and professional relevance of this collection metric.
The **Days Sales Outstanding Calculator** (DSO) is a crucial efficiency metric showing the average number of days it takes a company to collect payment after a sale has been made. This versatile four-function solver allows you to determine the **DSO (D)**, the **Average Accounts Receivable (R)**, the **Net Credit Sales (S)**, or the **Receivables Turnover Ratio (T)**. Simply enter any three of the four required variables and the tool will solve for the missing one, providing a clear picture of your collection speed.
Days Sales Outstanding Solver
Days Sales Outstanding Formulas
The DSO is directly linked to the Receivables Turnover Ratio ($T$), which measures how many times the average accounts receivable balance is collected during the period.
Core Ratio 1: Turnover (T) = Net Credit Sales / Avg. Receivables
Core Ratio 2: DSO (D) = Days in Period (365) / Turnover (T)
$$ T = \frac{S}{R} $$
$$ D = \frac{365}{T} $$
\text{Solve for Receivables (R): } $$ R = \frac{S}{T} $$
\text{Solve for Sales (S): } $$ S = T \cdot R $$
\text{Solve for Turnover (T): } $$ T = \frac{365}{D} $$
Formula Source: Investopedia: Days Sales Outstanding
Variables
- R (Avg. Accounts Receivable): The average amount owed by customers for goods/services sold on credit. (In currency).
- S (Net Credit Sales): Total sales made on credit, net of returns and allowances, over the period. (In currency).
- D (DSO, Days): The average number of days it takes to collect cash after a credit sale is made. (In days).
- T (Receivables Turnover Ratio): The number of times receivables are collected during the period (The collection efficiency). (As a dimensionless number).
Related Cash Flow Calculators
Analyze the full cash conversion cycle for better liquidity management:
What is Days Sales Outstanding (DSO)?
Days Sales Outstanding (DSO) is a measure of the average number of days it takes for a business to receive cash payment for credit sales. It is a critical component of working capital management because it directly impacts a company’s cash flow. A low DSO generally indicates that a company is efficient at collecting its debts, meaning it has faster access to its cash, which can then be used for operations, investments, or paying down its own liabilities.
A high DSO may signal poor credit policies, weak collections efforts, or customers who are struggling financially. Analysts use DSO to track efficiency trends over time and to benchmark a company’s performance against its competitors. If a company’s DSO is significantly higher than its industry average, it’s a strong indicator that management needs to improve its invoicing and collection processes to optimize liquidity.
How to Calculate Days Sales Outstanding (Example)
A firm reports annual Net Credit Sales (S) of $\$730,000$ and Average Accounts Receivable (R) of $\$80,000$.
-
Step 1: Calculate Receivables Turnover Ratio (T)
$$ T = \frac{S}{R} = \frac{\$730,000}{\$80,000} = 9.125 \text{ times} $$
-
Step 2: Apply the DSO Formula (Using 365 days)
$$ D = \frac{365}{T} = \frac{365}{9.125} $$
-
Step 3: Determine the DSO (D)
The resulting DSO is $\mathbf{40 \text{ days}}$. This means the company takes 40 days on average to collect its cash after making a sale.
Frequently Asked Questions (FAQ)
A good DSO should be close to the average credit terms offered by the company (e.g., if terms are 30 days, a DSO of 30-40 days is good). It should also be lower than the industry average. A very low DSO might indicate overly strict credit terms, potentially costing the company sales volume.
It is almost always better to have a **high** Turnover Ratio. A high ratio means sales are generating receivables that are quickly being converted back into cash, demonstrating high efficiency and good liquidity management.
The calculation measures the collection efficiency of amounts owed on **credit**. Cash sales or pre-paid sales do not generate accounts receivable, so including them would incorrectly deflate the calculated DSO, making the company appear more efficient than it actually is in collecting credit debts.
Average Accounts Receivable (R) must be positive because it is used as the denominator in the Turnover Ratio calculation ($T=S/R$). Furthermore, negative receivables would mean the company owes money to customers for sales, representing an illogical scenario in this model.