Days Sales Outstanding Calculator

Accounts receivable represent amounts owed to a business for goods sold on account to customers.

In order to monitor the level of accounts receivable and the collection of receivables it is useful to calculate how many days sales the accounts receivable represents. This value is referred to as days sales outstanding or days sales in accounts receivable, and shows the average number of days the customers are taking to pay the business for sales made to them on account.

Days sales outstanding is calculated using the days sales outstanding formula, which divides accounts receivable, taken from the balance sheet, by the average daily sales, taken from the income statement.

Days sales outstanding = Accounts receivable / Average daily sales

In our tutorial on how to determine days sales outstanding we discuss the calculation of days sales outstanding, and its use in the Financial Projections Template.

days sales outstanding calculator v 1.0
Days Sales Outstanding Calculator Preview
Using the Days Sales Outstanding Calculator

The Excel days sales outstanding calculator, available for download below, calculates the days of sales outstanding by entering details as follows:

  • Enter the sales. This is the value of sales taken from the annual accounts or management accounts.
  • Enter the period. This is number of days in the period, for annual accounts 365 days is used. The days sales outstanding calculator calculates the average daily sales for the period.
  • Enter the accounts receivable. This is the accounts receivable (debtors) taken from the balance sheet of the accounts. If opening and closing balances are available, then the average accounts receivable balance can be used. The days sales outstanding calculator calculates the average days sales outstanding.
Days Sales Outstanding Calculator Download

The days sales outstanding calculator is available for download in Excel format by following the link below.

The days sales outstanding figure calculated by this template can be used as one of the inputs for our Financial Projections Template, which provides the financial section for a business plan.

Notes and major health warnings
Users use the days sales outstanding spreadsheet to calculate dso days at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of days sales outstanding forecasting software that you might use when drawing up a business plan. It is purely illustrative of a days sales outstanding formula calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the days sales outstanding business plan template, please let us know and we will try to fix it.
Days Sales Outstanding Calculator October 5th, 2016Team

You May Also Like