DSO Calculator

The calculation relies on two fundamental steps. First, the average accounts receivable is determined by adding the beginning receivables balance to the ending receivables balance, then dividing by two. Second, this average is divided by total credit sales for the period and multiplied by the number of days in that period. The core mathematical formula is represented as: DSO = (Average Receivables / Total Sales) * Days, where Average Receivables = (Beginning Receivables + Ending Receivables) / 2.

Imagine a mid-sized manufacturing company evaluating its collection efficiency over a standard 90-day quarter. At the beginning of the quarter, customers owed them $120,000 (Beginning Receivables). By the end of the quarter, outstanding customer invoices totaled $140,000 (Ending Receivables). Total credit sales generated during these 90 days amounted to $900,000. First, we find the average receivables: ($120,000 + $140,000) / 2 = $130,000. Next, we apply the main formula: ($130,000 / $900,000) * 90 days = 13.0 days. This means, on average, it takes the company 13 days to collect payment after a sale.

To make the most of your DSO metrics, always compare your results against industry benchmarks rather than generalized standards, as payment terms vary wildly between sectors. Additionally, calculate DSO monthly or quarterly rather than annually to spot seasonal cash flow anomalies and slow-paying clients before they impact your operational liquidity.