A Step-by-Step Guide to Calculating Days Sales Outstanding

While accounts receivable days can vary from industry to industry, you are generally looking for a balance between giving your client enough time to get the money and collecting the money after the service as quickly as possible. The ratio is calculated by dividing the ending accounts receivable by the total credit sales for the period and multiplying it by the number of days in the period. If there is a steady increase in the average time to receive payments, it might be necessary for a business to tighten its credit policy. However, if there is a continuous decline, lenient payment terms can be introduced to attract more customers. So, to make the most of A/R days metric, it’s essential to pair it with other data.

This aspect becomes apparent when an investor analyses companies that work for govt. Let us now see another common factor where companies face challenges in recovery money when companies work for govt. The biggest concern presently is the domestic industrial environment along with credit worthiness of large clients.

Receivables days ratio

Whereas the companies that sell to other companies (i.e. B2B), they give their customers some time for payment after the sale. Normally, this period is 30 to 45 days and may stretch to 60 days in some cases. However, credit periods beyond 60 days are longer than common business practices and demand deeper analysis by investors. If the company had a 30-day payment policy for its customers, the average accounts receivable turnover shows that, on average, customers are paying one day late. However, it’s important to remember that the accounts receivable days formula is an overall measurement of accounts receivable, rather than a customer-specific measurement.

By discounting the bills of “reputed customers”, which mostly are expected to be Amara Raja Batteries Ltd, from the bank and therefore it showed remaining ₹29 cr. 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 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.

Is DSO a good ratio to calculate for your business?

This is because the accounts receivable days allow the company to understand how effectively it is utilizing its assets and where most of the cash is stuck up. The optimum number of accounts receivable days varies from industry to industry and will be different for only businesses with seasonal demand. This allows the company to collect payments from customer’s bank accounts directly when they become due, ensuring that delays in receiving payments are considerably reduced. Other methods to increase payment collection efficiency include introducing a stricter credit policy. The accounts receivable days is an efficiency measure that evaluates the efficiency of the business in collecting payments. This way, a company has a constant cash flow for longer projects and can keep the accounts receivable days low.

For instance, if you wish to calculate DSO for the first quarter of 2020, you’d run a balance sheet as of Jan. 1, 2020, to locate your beginning accounts receivable balance. 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, you should supplement it with an ongoing examination of the aged accounts receivable report and the collection notes of the collection staff. Therefore, bill discounting effectively converts trade receivables into contingent liabilities. Investors should always keep this aspect and the contingent risk in mind when they assess any company showing lower receivable days by using bill discounting. 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.

Related Articles

An investor should read the contingent liabilities section of the annual report for all the companies before making her opinion. Another example is to compare a single company’s accounts receivable turnover ratio over time. A company may track its accounts receivable turnover ratio every 30 days or at the end of each quarter. In this manner, a company can better understand how its collection plan is faring and whether it is improving in its collections. For example, if the company’s distribution division is operating poorly, it might be failing to deliver the correct goods to customers in a timely manner. As a result, customers might delay paying their receivables, which would decrease the company’s receivables turnover ratio.

• DSO is not particularly useful in comparing companies with significant differences in the proportion of sales that are made on credit.
• By adding multiple payment options like credit cards, debit cards, electronic fund transfers, and checks, businesses can reduce the friction of payments.
• The company used to have receivable days of 47 in FY2012, which has steadily increased to 74 days in FY2019 and FY2020.

This provides significant insight into understanding the success of the company’s credit policy and its ability to evaluate how the company’s cash cycle can be improved. It is perhaps one of the initial steps that are taken towards achieving an improved cash cycle. Similarly, if the number of days in which payment is recollected is long, this is an indication of very lenient payment terms and could create problems for the business. However, as mentioned previously, what is considered to be a long or a short period varies from one industry to another. When customers pay for a service in advance, it is most advantageous for a company. To make this more attractive to customers, you can give them cash discounts or other rebates.

What is Days Sales Outstanding (DSO)?

If the number gets too high, it could even disrupt the normal operations of the business, causing its own outstanding payments to be delayed. Since days sales outstanding (DSO) is the number of days it takes to collect due cash payments from customers that paid on credit, a lower DSO is preferred to a higher DSO. To conclude what has been said above, calculating the accounts receivable days provides an opportunity for the company to understand its efficiency in being able to collect payments from its customers. Businesses often extend credit to their customers wherein the payments for the sales made arrive later.

As you can see in the example below, the accounts receivable balance is driven by the assumption that revenue takes approximately 10 days to be received (on average). Therefore, revenue in each period is multiplied by 10 and divided by the number of days in the period to get the AR balance. This is because if the sales reported by the company are fictitious, and the customers are not real, then the company may never receive the money due from the sales.

Even if this reduces profits somewhat, it avoids creating a cash shortage due to delayed revenues. Once a service has been rendered (e.g. goods delivered to the customer), it is advisable to create an invoice immediately and send it to the customer. Some companies wait until the end of the month to issue their invoices, thereby pushing their revenues further into the future and, in the worst case, getting themselves into payment difficulties. It is important that the values for both Average accounts receivable and Revenue are based on 90 days, otherwise the result for Accounts receivable days will be incorrect.

How to make the most of the accounts receivable days metric?

Customer satisfaction might be declining, or the salespeople may be offering longer terms of payment to drive increased sales. Perhaps the company may be allowing customers with poor credit to make purchases on credit. It suggests how efficient the company’s collections department is, and the degree to which the company declining balance method of assets depreciation pros & cons is maintaining customer satisfaction. Obtaining your ending accounts receivable balance is done in the same manner, only this time you’ll run a balance sheet report as of March 31, 2020. This information can be obtained from a balance sheet that is run as of the first date of the period you’ll be examining.

• An increase in DSO can result in cash flow problems, and may result in a decision to increase the creditor company’s bad debt reserve.
• A high ratio is desirable, as it indicates that the company’s collection of accounts receivable is frequent and efficient.
• Accounts receivable days is an important key figure for companies, as it has an influence on the liquidity situation.
• If your DSO begins to climb, it may mean more of your cash is tied up in accounts receivable.
• The accounts receivable days obtained above imply that the company collects payments from its customers in 60.83 days.

Both upfront deposits and progress payments, which are delivered based on the completion of a specific part of the work you’re doing for a client, can help you get paid faster for your work. To interpret this metric, we will need details on the company’s industry and past data. It’s useful to compare a company’s ratio to that of its competitors or similar companies within its industry. Looking at a company’s ratio, relative to that of similar firms, will provide a more meaningful analysis of the company’s performance rather than viewing the number in isolation.

For example, let’s say you have $20,000 in accounts receivable and sold $10,000 on credit in a 30-day period. Using the DSO formula, you find it takes an average of 60 days to collect your invoices. Most business owners compare figures quarterly or annually, not over prior time periods.

However, it is important to understand that factors influencing the ratio such as inconsistent accounts receivable balances may accidently impact the calculation of the ratio. The accounts receivables turnover ratio measures the number of times a company collects its average accounts receivable balance. It is a quantification of a company’s effectiveness in collecting outstanding balances from clients and managing its line of credit process.