Logo Credit Management tools
FR | EN
Tools, tutorials, methods and services
To know how to get paid by your clients

DSO calculation


The Days Sales Outstanding (DSO) is a key performance indicator for the management of your accounts receivables. It is composed by two variables:
  • The average payment period granted to your customers resulting of the trade negotiation,
  • The average number of days of delayed payment (or prepayment) based on your performance in debt collection.
The DSO represents the number of days sales blocked in the accounts receivable which is one of the biggest item in the assets  of the balance sheet of companies !
DSO

The DSO has a direct impact on the Working Capital Requirement (WCR), the cash and the overall risk to have unpaid invoices and bad debts.

Lower is your DSO, the lower is your WCR and your overall risk of unpaid customers. Impacts are a better cash flow and profitability.
If your DSO is high, your WCR increases and consumes financial resources of your company. The overall risk of default customers rises as well resulting in accruals for doubtful accounts, which directly impacts profitability and the net result of your company.
 The accounts receivables are a big consumer of cash for your company. The other big item consumer of cash that increase the working capital requirement is the inventory.

Calculate your DSO

The DSO is not a perfect indicator as it may be fluctuating because of many different reasons. However, it remains the main KPI to assess credit management performance. There are many methods of calculating DSO.

The roll back method

We propose to use the most coherent and fairer calculation of DSO by depletion of accounts receivable by turnover.
Download the tool below to calculate your DSO with a few clicks or us the online tool.
You can calculate your DSO for your accounts receivable but also for a group of client or for a single client (to assess his payment behavior for example).

Once the DSO is calculated, it is important to understand the reasons of its level. Has it increased because of longer payment term granted to customers? Or because more overdue invoices? Or due to less down payments received from customers...etc. This work analysis is key in order to take good initiatives to improve it.
Well understanding the DSO is essential to drive a proper actions plan!
  • DSO calculation in My DSO Manager

    The DSO in My DSO Manager

    The DSO is a key performance indicator in My DSO Manager.

    It is calculated at several levels: all accounts receivable, by customer groups by customer, or by analitycal field (activity, profit center, ...etc.).

    The DSO is divided into a contractual part (corresponding to not due invoices) and late part (due to late payments). See more with online demo.

The balance sheet method

This is another classical way to compute the DSO. Its advandage is to be very simple and to be close to other financial ratios done on the balance sheet.

AR: Accounts receivable amount at end of the period
Nb days: Number of days of the period
Sales: Amount of Sales including tax of the period.

Formula: AR / Sales x Nb of days
The period chosen is often 3 months, ie 91 days. It is possible to perform the calculation over a longer period but the indicator is less accurate in this case.
If AR is 300, Sales of the period 200 and number of days of the period 91, the DSO is equal to 300 / 430 x 91 = 63.5 days
Advantages of this method: the calculation is very simple to perform. In financial analysis, it can be done from the balance sheet and the income statement (with the period of the exercise).

Disadvantages of this method: the result is very volatile from one month to the next and it is strongly impacted by the variations of turnover, which is not representative of the performance in the management of the receivables. It is unwise to draw conclusions about a sudden drop or rise in this index. It must therefore be interpreted over the medium term taking into account, for example, a sliding average over 6 months.

How to improve your DSO?

Improving DSO represents an achievable Grail for businesses. Indeed, it is the main lever to reduce the Working Capital Requirement, and therefore improve the cash flow and the investment capacity of the company.

Trade receivables usually represent in average about 30% of total balance sheet of companies. Reducing receivables with a lower DSO improves the creditworthiness of the business and releases financial resources which will be much better used elsewhere (investment...etc.).

Main ways of DSO improvement:

Conclusion

The DSO is a key performance indicator in credit management and it can be calculated in several ways according to the method and the data taken into account (deduction of provision from the AR, adding of unbilled revenue to the sales, ...).

The understanding of the DSO results can be complex in some cases. See our article about the enigmas of the DSO.

Beyond to the cash and WCR stakes covered by the DSO, this indicator also shows the quality of the organization of a company. If it is too high, it may be due to lack of efficiency at one or several steps of the sales process.

Indeed, the "box" of overdue invoices is like a receptacle in which each invoice represents a malfunction in the sales process. Each overdue has a cause that can be the starting point to improve internal processes:

  • Overdue due to a delivery problem
  • Invoice unpaid because customer creditworthiness. This cause indicates a flaw in the analysis of customer risk and in securing receivables
  • Late payment due to lack of customer reminders. This highlights a poor management of Accounts Receivable
  • Invoice rejected due to error on the invoice (missing PO number, wrong company name, ...)

Next: overdue ratio calculation
 


Online tools:

DSO calculation based on roll back method
Reporting DSO online

Tools download:




Comment this page


Your name:
Your comment:
Your email (not published) :
What is the result of 2 5 ?

Articles on the same topic

My DSO Manager presentation
Online debt recovery software available for all companies. Presentation of this inovative tool

Overdue ratio calculation
Overdue % or % current calculation tool. This credit management key performance indicator shows the collection efficiency

Bad debts ratio calculation
Bad debts ratio calculation tool is a key performance indicator in credit management

Debt collection in My DSO Manager
What are the main features of MY DSO MANAGER for debt recovery?

Reporting in My DSO Manager
Top features of My DSO Manager to identify and address customers disputes

Disputes management in My DSO Manager

Credit risk management in My DSO Manager

Upload your data in My DSO Manager


My DSO Manager
Subscribe
Not yet registered? The subscription allows downloading and unlimited use of all files of Credit Management tools.
User reviews

Really a good work.

Social networks
Find Credit Management tools on your favorite social networks