DSO Formula: How to Calculate Days Sales Outstanding

Tracking Days Sales Outstanding (or DSO for short) is important for understanding the liquidity and cash flow efficiency of your business. It indicates how long it takes to get paid after an invoice is issued. A lower DSO reflects faster payment collection, while a high DSO can point to potential cash flow issues.

There are two common ways to calculate DSO: the simple method and the countback method. In this article, we’ll explain both approaches and help you choose the one that suits your business.

In plain terms: DSO divides the money customers still owe you by what you sell on credit, then multiplies by the days in the period, giving the average number of days an invoice waits to be paid.

Use the calculator below to run your own numbers with either method, or keep reading for worked examples of both.

What is Days Sales Outstanding (DSO)?

DSO measures the average number of days it takes for a business to collect outstanding payments after a sale. It tells you how effectively your credit sales turn into cash, which is crucial for healthy cash flow. Businesses that rely on credit sales, like recruitment agencies, wholesalers, and SaaS companies, need to monitor their DSO regularly.

Why is DSO Important?

• Liquidity: DSO shows how quickly you can convert credit sales into cash.
• Cash Flow Management: Understanding DSO helps you manage and predict your company’s cash inflows.
• Credit Terms Evaluation: A high DSO might indicate that your credit terms are too lenient or that your collection efforts need improvement.

The DSO Formula: Simple vs Countback Method

There are two main ways to calculate DSO, each with its own pros and cons.

The Simple DSO Calculation Formula

This method is the easiest way to calculate DSO. Here's the formula:

Worked example: your business has $200,000 in accounts receivable and $2,000,000 in credit sales for the year:

On average, it takes your business 36.5 days to collect payment after invoicing.

Pros:

• Quick and Easy: Simple to calculate and provides a broad view of your accounts receivable performance.
• Trend Indicator: Useful for tracking whether your DSO is improving or getting worse over time.

Cons:

• Not Ideal for Seasonal Businesses: It doesn’t account for seasonal variations in sales, which could skew results.
• Ignores Payment Patterns: It may not accurately reflect customer payment patterns, especially if payments are unevenly distributed.

The Countback Method

This method is more accurate for businesses with seasonal sales or irregular sales patterns. It takes into account when sales were made and when payments were received, offering a more precise measure of cash collection efficiency.

Here’s how it works:

1. Start with your accounts receivable at the end of the period (usually a month).
2. Count back to see how many days of sales it takes to cover the accounts receivable balance.
3. Adjust for any months where sales exceeded receivables.

Worked example: your accounts receivable at 30 June is $80,000. June credit sales were $50,000 and May credit sales were $60,000. Count back through each month until the balance is covered:

All of June's $50,000 in sales is still unpaid, so you count the full 30 days. The remaining $30,000 is half of May's $60,000 in sales, so you add roughly half of May's 31 days. Countback DSO comes to about 45.5 days.

Pros:

• Highly Accurate: Reflects actual payment behaviors and provides a more detailed view of how quickly sales turn into cash.
• Ideal for Seasonal Businesses: Accounts for seasonal sales fluctuations, making it suitable for industries like retail or event management.

Cons:

• Time-Consuming: It’s more complex and takes longer to calculate, especially if done manually.
• Requires Detailed Data: You need monthly sales and accounts receivable data, which may not always be readily available.

Choosing the Right DSO Calculation Method

Which method should you use? It depends on your business’s needs:

• Use the Simple Method if:
  • You want a quick estimate of your DSO.
  • Your sales and receivables don’t fluctuate much throughout the year.
  • You want to track long-term trends in collections.
• Use the Countback Method if:
  • You need more precise DSO tracking, especially if your business has seasonal sales.
  • You want to understand your customers’ payment patterns more accurately.
  • Your industry requires high accuracy, such as in construction, retail, or event management.

What is a Good DSO?

A good DSO is one that sits close to your payment terms: if you invoice on net 30, a DSO in the low 30s means customers are paying roughly on time. There is no single number that fits every business, because DSO reflects the terms you offer. As a rough guide, a DSO that runs 50% or more above your standard terms (say, 45+ days on net 30) usually points to a collections problem rather than a terms problem.

• Compare against your own terms first, then your industry. Sectors that bill on net 60 or net 90, such as construction and wholesale, naturally carry a higher DSO than businesses billing on net 7.
• Watch the trend: a DSO that climbs for three consecutive months is a stronger warning sign than any single reading.
• Pair DSO with an AR aging report to see which specific customers and invoices are dragging the average up.

How to Reduce DSO

Lowering DSO comes down to invoicing promptly, making payment easy, and following up consistently. The levers that move it fastest:

• Automate payment reminders: email and SMS reminders before and after the due date stop invoices from going quiet.
• Charge late fees and interest: automatic late fees give slow payers a concrete reason to move your invoice up the pile.
• Send monthly statements: automated customer statements put every outstanding invoice in front of the customer in one place.
• Reward fast payers: early payment discounts pull cash forward on your biggest accounts.

To see what this is worth in dollars, run your numbers through the DSO calculator, then use the DSO savings calculator to estimate how much cash a lower DSO would free up.

Automating DSO Calculation for Efficiency

Manual DSO calculation can work for small businesses, but as your company grows, it becomes more cumbersome. Automating DSO calculations with accounts receivable software like Paidnice can save time and improve accuracy.

Why Automate Your DSO Calculation?

• Reduces Errors: Manual calculations are prone to errors, especially with the countback method.
• Saves Time: Automation frees up your finance team to focus on more valuable tasks like cash flow forecasting or credit risk management.
• Real-Time Insights: Tools like Paidnice provide real-time DSO calculations, allowing you to spot trends early and take action when needed.

Paidnice integrates with accounting platforms like Xero and QuickBooks, automating not just DSO calculations but also late payment reminders, late fees, and customer segmentation, making accounts receivable management more efficient.

Final takeaway: The size of your business, the intricacy of operations, and its needs all determine which DSO calculation method should be used. The simple method gives you a quick overview of receivables performance, while the countback method is more practical for businesses with fluctuating sales cycles.

Ready to automate your DSO calculations and improve your collections? Book a demo with Paidnice today and see how our solution can help you get paid on time, every time.

Written by

Denym Bird

Co-founder & CEO of Paidnice

Denym is a software entrepreneur and writes about accounts receivables management for small business.

LinkedIn X