Days sales outstanding calculation

Days sales outstanding (DSO) is the average number of days that receivables remain outstanding before they are collected. The measurement is usually applied to the entire set of invoices that a company has outstanding at any point in time, rather than to a single invoice. The point of DSO is to determine the effectiveness of a company's credit and collection efforts in allowing credit to reputable customers, as well as its ability to collect from them. When measured at the individual customer level, it can indicate when a customer is having cash flow troubles, since the customer will attempt to stretch out the amount of time before it pays invoices. The measurement can be used internally to monitor the approximate amount of cash invested in receivables.

There is not an absolute number of days sales outstanding that represents excellent or poor accounts receivable management, since the figure varies considerably by industry and the underlying payment terms. Generally, a figure of 25% more than the standard terms allowed may represent an opportunity for improvement. Conversely, a days sales outstanding figure that is very close to the payment terms granted to a customer probably indicates that a company's credit policy is too tight.

The formula for days sales outstanding is:

(Accounts receivable ÷ Annual revenue) × Number of days in the year

As an example of the DSO calculation, if a company has an average accounts receivable balance of $200,000 and annual sales of $1,200,000, then its DSO figure is:

($200,000 Accounts receivable ÷ $1,200,000 Annual revenue) × 365 Days

= 60.8 Days sales outstanding

The calculation indicates that the company requires 60.8 days to collect a typical invoice.

An effective way to use the days sales outstanding measurement is to track it on a trend line, month by month. Doing so shows any changes in the ability of the organization to collect from its customers. If a business is highly seasonal, a variation is to compare the measurement to the same metric for the same month in the preceding year; this provides a more reasonable basis for comparison.

No matter how this measurement is used, remember that it is usually compiled from a large number of outstanding invoices, and so provides no insights into the collectability of a specific invoice. Thus, it should be supplemented with an ongoing examination of the aged accounts receivable report and the collection notes of the collection staff.

Similar Terms

Days sales outstanding is also known as DSO.