It's Big Awesome Savings time
75% OFF FOR 6 MONTHS*
Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
Image Alt Text
Running a business

What is days sales outstanding? How to calculate and improve DSO

It’s important to keep your accounts receivable to a minimum. However, to get a handle on your accounts receivable, you must first determine how long it takes to collect on an overdue account. Days sales outstanding is a metric that can help you understand how long it takes clients and customers to pay you.

Use these links to get a specific answer, or keep reading to learn more about days sales outstanding:

What is days sales outstanding (DSO)?

A company’s days sales outstanding (DSO) is the average number of days it takes the business to collect payment over a period following a sale. A lower DSO means you’re collecting overdue balances faster. Days sales outstanding is also sometimes referred to as “days sales in receivable”.

Why is days sales outstanding important?

Days sales outstanding is important because it represents how efficiently a business collects payments, which can impact profitability. Analysing DSO can help you pinpoint issues in your accounts receivable process and help forecast cash flow. Tracking DSO over time can help you identify trends that might inform your cash flow forecast.

If your business has a high DSO, consider evaluating your credit policies, including to whom you extend credit. If your DSO begins to climb, it may mean more of your cash is tied up in accounts receivable. A high DSO may indicate an approaching cash crunch.

But DSO is just one piece of the puzzle when it comes to analysing business performance. Business owners should assess days sales outstanding alongside other KPIs and financial ratios to get a full understanding of business health.

Other metrics businesses can use to assess the effectiveness of their collections include the cash conversion cycle and accounts receivable turnover ratio.

Components of the DSO formula

The days sales outstanding formula divides accounts receivable by total credit sales, multiplied by a number of days in a measurement period.

Your “accounts receivable (A/R)” are all outstanding payments owed to your company, and they can be found by reviewing your balance sheet and income statement. “Credit sales” are sales to be settled on a future date.

For example, let’s say you have $20,000 in accounts receivable and you’ve 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.

DSO only applies to businesses that issue credit sales. Cash sales have a DSO of zero, and you shouldn’t factor them into DSO calculations, as they will skew the metric.

How to calculate DSO with the days sales outstanding formula

The formula for days sales outstanding is:

 

(Accounts receivable ÷ total credit sales) x number of days = standard DSO

In addition to calculating the standard DSO on your overdue accounts, you can calculate your best possible DSO. Your best possible DSO divides a current portion of your accounts receivable by total credit sales, multiplied by a number of days. The formula follows:

(Current accounts receivable ÷ total credit sales) x number of days = best possible DSO

Days sales outstanding calculation example

Here’s how to use the days sales outstanding formula:

Let’s use an example of a business that has $10,000 in accounts receivable on 1 January, 2021. The next month, on 1 February, 2021, the business has $12,000 in accounts receivable. The business also makes $8,000 in credit sales between 1 January and 1 February.

Use these steps to calculate DSO:



1. Calculate average account receivable

First, we’ll find the average accounts receivable over the time period being analysed:

($10,000 + $12,000) ÷ 2 = $11,000 average accounts receivable



2. Find total credit sales

In this case, we know that total credit sales over the time period being analysed is $8,000.

3. Find the total number of days in the time period

January has 31 days, so 31 will be the number of days we use in the DSO formula.


4. Apply these numbers to the DSO formula

Using the DSO formula, we can calculate days sales outstanding with the numbers we’ve found. Given the DSO formula:

(Accounts receivable ÷ total credit sales) x number of days = standard DSO

($11,000 ÷ $8,000) x 31 = 42 days sales outstanding



Grow Your Business with QuickBooks

How do days sales outstanding affect business finances?

When the cash your clients owe your business sits in their bank accounts, it negatively affects your finances in a few ways. The most apparent is the loss of revenue.

When overdue accounts go past 120 days, this decreases your chances of collecting. If that happens, you stand to lose that amount on your pre-tax income. You may also lose out on an opportunity to expand or otherwise enhance your business because you won’t have the cash to invest.

Lost revenue may also result in cash flow problems that may lead you to seek outside finance. If you can’t pay your monthly operational costs, your interest payments may increase your cash burden. And if you send the account to a collection agency, they may collect a percentage of the balance.

What is a good DSO ratio?

Generally, a low DSO ratio is better for your business, but your ideal days sales outstanding ratio depends on your industry and type of business.

To understand the effectiveness of your accounts receivables process, analyse individual DSO values and review trends in DSOs over time. DSOs may also vary according to seasonality. Generally, seasonal rises and falls aren’t a cause for concern. Instead, forecast your business’s cash flow to plan for seasonal changes.


Why would days sales in receivables increase?

An increase in days sales outstanding indicates that it may be taking your business longer to collect outstanding payments.

Reasons why you may see a higher DSO include:

  • Customers are taking longer to make payments.
  • Customers aren’t satisfied with your business or customer service, so they may be reluctant to pay.
  • Customers with poor credit are making purchases on credit. So you may need to review your credit terms.
  • Your sales team is extending flexible payment terms to help drive sales.


How to reduce and improve DSO

Now that you understand how collecting accounts receivable can affect your business’s health, it’s time to put a plan in action. Here are eight ways to encourage your customers to pay their invoices and improve your DSO:

1. Invoice customers as soon as you deliver a product or service.

When it comes time to collect payments from customers, don’t delay on getting invoices sent out. You may not always be able to control how quickly customers pay you once they have your invoice in hand, but sending out invoices as quickly as possible once you’ve delivered a product or service is one action you can take to improve the speed of payments.

2. Use an invoice template that includes your payment terms, due dates and options.

Including information on your invoices like due dates, payment terms and options can help keep you and your customers on the same page. Use an invoice template that includes all of these important details, like the invoices generated by QuickBooks’ free invoice generator, or free invoice templates.

3. Automate your accounting system so that you can get alerts when invoices are overdue.

Automating the accounts receivable process is simple when you use accounting software that integrates with your payment system and business bank account.

QuickBooks Online makes it easy to track the status of your invoices, from when they’re sent and when they’re viewed by your customers to when they’re paid and deposited into your business bank account. Invoices are sorted by status, with overdue invoices listed first, making it easy to see who owes you.


4. Request payment as soon as you notice outstanding accounts.

When you discover overdue accounts, take action to remind clients of their overdue payments. Contacting people about overdue payments can be challenging and even a little uncomfortable, particularly if your ability to pay your business’s bills depends on incoming cash flow from clients.

Using an invoice email reminder template can help you decide what to say when you contact clients. Picking up the phone and giving your customers a call can also speed up the collections process.

5. Review your books and adjust payment terms for clients who pay late consistently.

Decide your payment terms carefully. There are many terms you can offer to clients, and if you find certain customers are consistently behind on payments, it may help to shorten your payment terms. You can also consider requiring full or partial payments in advance.

6. Tighten your credit requirements for new applicants.

Similar to decisions about payment terms, you can also make decisions about the credit requirements of your clients. It’s often easier to decide to adjust payment terms based on a client’s credit history before completing any work than it is to deal with collecting from a late-paying client after you’ve delivered the work. A client’s credit history may give you insight on how to adjust your payment terms and credit policies when working with them.


7. Ask for up-front deposits and milestone payments rather than waiting to collect the full balance at the end of the job.

Another way to improve your cash flow is to require a deposit before starting work, or to agree on payment terms that require progress payments. Both up-front 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.

8. Offer clients more payment options, including electronic payments.

Many clients may be accustomed to making payments using a certain method, which can create friction when it’s time for them to pay their bills. Offering a wide range of payment options can help eliminate this common barrier to getting paid on time.

Applicable laws may vary by state/territory or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Intuit Inc does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Intuit Inc does not warrant that the material contained herein will continue to be accurate nor that it is completely free of errors when published. Readers should verify statements before relying on them.

We provide third-party links as a convenience and for informational purposes only. Intuit does not endorse or approve these products and services, or the opinions of these corporations, organisations or individuals. Intuit accepts no responsibility for the accuracy, legality or content of these sites.


Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Stay up-to-date with the latest small business insights and trends!


Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A person is smiling and holding a laptop.