Calculate Days Sales Outstanding

If a company wants to find out whether its values are too high or too low, only a comparison with companies from the same industry is recommended. This can then be used to assess how one compares to the competition and whether it is necessary to take measures to reduce the accounts receivable days. If the value for accounts receivable days is very high, a company should look at the causes and eliminate them if possible. In this way, it avoids getting into payment difficulties due to delayed receipts. Many times, companies are able to get a loan against their trade receivables from banks.

An effective way to use the accounts receivable days measurement is to track it on a trend line, month by month. Doing so shows any changes in the ability of the company 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.

How do you use days sales outstanding (DSO)?

They may struggle for cash to pay these expenses from time to time if the DSO continues to be at a high value. Divide the total number of accounts receivable during a given period by the total dollar value of credit sales during the same period, then multiply the result by the number of days in the period being measured. Days sales outstanding (DSO) is a measure of the average number of days that it takes a company to collect payment for a sale. The accounts receivable (A/R) line item on the balance sheet represents the amount of cash owed to a company for products/services “earned” (i.e., delivered) under accrual accounting standards but paid for using credit. That said, the number of accounts receivable days that is 25% above the payment terms stated on the invoice is considered optimal.

Therefore, an investor would appreciate that continuously increasing receivable days are a cause for concern. An investor may think that ideally, companies should give as low credit period as possible so that they reduce the risk of a customer not paying after delaying payments for a long time. In addition, when the company get money from its customers at the earliest, then it can avoid using Bank’s money for its day to day activities and therefore, it can reduce its finance costs. Effectively, receivable days represent the number of days (credit period) that customers take to settle their dues to the company.

What is Days Sales in Inventory (DSI)?

In case of excessive follow up by the company for the collection of receivables, a distributor can threaten to remove the products of Quick Heal Technologies Ltd from its shelf/catalogue. While analysing Supreme Industries Ltd, an investor notices that the company consistently has its receivable days in the range of days. In FY2016, the company reported receivable accounting source documents days of 29; however, it was because the company has changed its financial year from June-end to March-end and therefore, it reported only 9-months of sales in FY2016. An investor notices that over the years, receivable days of HEG Ltd has been ranging from 120 days to 150 days indicating that the customers of the company demand significant credit period.

In some sense it measures the balance between a company’s sales efforts and collection efforts. If sales decreases in isolation DSO will increase indicating that may run into cash flow problems in future when the sales dip flows through the collection cycle. If sales decreases proportionally to accounts receivable, DSO will not increase.

AccountingTools

Had those receivables been collected timely, that money could have been spent on some profitable activity. There is not an absolute number of accounts receivable days that is considered to represent 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 represents an opportunity for improvement. Conversely, an accounts receivable days figure that is very close to the payment terms granted to a customer probably indicates that a company’s credit policy is too tight. When this is the case, a company is potentially turning away sales (and profits) by denying credit to customers who are more likely than not to be able to pay the company. In light of the above discussion, an investor would appreciate that Quick Heal Technologies Ltd is not in a very strong position to collect money from its distributors for the sales reported by it in the financial statements.

For example, A/R is forecasted to be $33mm in 2021, which was calculated by dividing 55 days by 365 days and multiplying the result by the $220mm in revenue. During this waiting period, the company has yet to be paid in cash despite the revenue being recognized under accrual accounting. For example, if you had credit sales of $57,000 for the first quarter of 2020, with returns totaling $1,500, your total sales for the period would be $55,500.

Everything You Need To Master Financial Statement Modeling

Tracking DSO over time can help you identify trends that might inform your cash flow forecast. On the whole, there isn’t a universally applicable figure for a “good” accounts receivable days ratio. This is because accounts receivable days vary significantly from industry to industry, as do underlying payment terms.

Therefore, in bill discounting, companies show a contingent liability equal to the amount of receivables discounted by them. An investor should read the contingent liabilities section of the annual report for all the companies before making her opinion. An investor may think of a situation where a distributor has many compact discs (CDs) of Quick Heal antivirus on its shelf, which it has taken from the company on credit. In any case, the distributor has the option to sell other competing antivirus products to its consumers.

Ask for upfront deposits and milestone payments rather than waiting to collect the full balance at the end of the job.

Let us now see what are other common causes of higher receivable days for companies. If the company were to reduce the time that consumers had to pay to less than the time in which it had to pay the supplier, it would get paid before it had to pay up, meaning it could produce endlessly and never run out of cash. Similarly to decisions about payment terms, you can also make decisions about the credit requirements of your clients.

• 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.
• In effect, determining the average length of time that a company’s outstanding balances are carried in receivables can reveal a great deal about the nature of the company’s cash flow.
• While analysing Supreme Industries Ltd, an investor notices that the company consistently has its receivable days in the range of days.
• Suppose we’re tasked with forecasting the accounts receivable (A/R) balance of a hypothetical company that reported revenue of $200mm in 2020.