
A days sales outstanding calculator estimates how many days of credit sales are still tied up in unpaid invoices. Enter the receivables balance at the end of a period, credit sales made during that same period and the number of days in it. The calculator divides receivables by credit sales, then multiplies by the period length. The result is a working signal about collection speed, not a promise that every customer pays on that day.
Duebay’s calculator starts with $52,000 of receivables, $120,000 of credit sales and a 90-day period. It shows the arithmetic as ($52,000 ÷ $120,000) × 90 = 39 days. Those are the tool’s actual starting values, so you can reproduce the number before entering your own. The form runs in the browser; the numbers you type are not sent to a server.
The calculation in plain English
The simple DSO formula is (accounts receivable ÷ credit sales in the period) × days in the period. Suppose your business has $52,000 of open invoices after recording $120,000 in credit sales over 90 days. $52,000 divided by $120,000 is about 0.4333. Multiply that share by 90 and the answer is 39 days. In effect, the receivables balance is equivalent to 39 days of the period’s average credit sales.
This is the standard method documented by Oracle’s financial-management guide and used by Duebay’s calculation engine. Keep the numerator and denominator aligned: the receivables balance is a point-in-time figure at the end of the period, while credit sales cover the period. Use the same currency and business unit for both. Mixing a group-wide sales figure with one subsidiary’s receivables produces a precise-looking answer to the wrong question.
Enter the three inputs that belong in the tool
- Accounts receivable outstanding. Use the total open invoice balances on the date you are measuring. Leave cash already received out. Check credit notes, void invoices and disputed balances so the figure matches your ledger’s definition of receivables.
- Credit sales in the period. Use invoices issued on credit during the selected window. Do not include card payments or cash sales made and collected at checkout: they did not create receivables. If you use total revenue instead, the denominator can be too large and DSO can look artificially low.
- Days in the period. Choose 30, 90 or 365 days in Duebay’s calculator, and enter sales from that same window. A 90-day sales total paired with 30 days understates the result by two-thirds. When comparing month to month, keep the window and calculation method consistent.
Read 39 days against the terms you offer
A DSO of 39 days does not tell you by itself whether collections are healthy. If most invoices are due in 30 days, the gap deserves investigation. If your contracts allow 45 days, the same result may sit within the agreed payment window. A useful comparison starts with your own terms and your own trend, not a borrowed industry average. APQC defines days sales outstanding as the time from a sale until the customer’s cash is received; that definition is useful, but your chosen formula and period still need to stay consistent when you track change.
The result is an average across a book, not an invoice-by-invoice due date. A business can have a DSO of 39 while many customers pay on day 30 and one large account pays much later. Growth can also push the ratio up because the receivables snapshot rises before those newer invoices have had time to be paid. For the full explanation of what counts as a good result, see what is a good DSO.
What this calculator does differently
Duebay’s free DSO calculator uses the same `computeDso` function as the product’s receivables engine. The browser form converts the dollar inputs into cents, applies the selected period and rounds the displayed result to one decimal place. At the default inputs, the unrounded calculation is 39 exactly. This shared calculation means the public tool and product dashboard use the same simple method, rather than two separately maintained formulas.
There is a small but useful honesty check in the zero-sales case. If credit sales are zero, the engine returns no DSO number and the page says DSO is undefined for that period. It does not display zero days, which would suggest that customers paid immediately. The tool also shows the formula beside the answer, and its inputs stay in your browser. This is especially useful when you are checking a sensitive ledger or want to test several scenarios without uploading a file.
| Input or result | Value | What to check |
|---|---|---|
| Receivables outstanding | $52,000 | Open invoice balances at the measurement date |
| Credit sales | $120,000 | Credit invoices issued in the same 90-day period |
| Period | 90 days | Use the same window for sales and comparison |
| DSO | 39 days | Compare with your actual customer payment terms |
Use the answer to find the next job
If DSO is above your terms, do not change every customer’s credit policy from one headline result. Open the accounts receivable ageing report and find the balances driving the number. Separate invoices that are still within terms from overdue invoices; then distinguish a missing purchase-order number, an open dispute, a payment promise and an invoice nobody has followed up. Each needs a different next step.
A useful weekly routine is to record the measurement date, period, receivables balance, credit sales and DSO together. Compare like with like next time. If the number rises, review the oldest and largest invoices first, then check whether the cause was slower payment, a spike in sales, longer terms or a change in what your ledger includes. The days sales outstanding formula with examples explains the method in more depth, while the accounts receivable turnover ratio gives a related view of how often receivables convert to cash.
Common mistakes that make the result less useful
- Putting total revenue in the sales field. Include credit sales only. Cash sales were never outstanding, so adding them can make collection performance seem better than it is.
- Using mismatched windows. The sales total and days selected must describe the same period. Label the result with the window so a colleague can reproduce it.
- Treating DSO as a forecast. It is a ratio based on the balance and sales period you enter; it does not predict a specific customer’s payment date.
- Ignoring the ageing tail. The average cannot tell you whether one large invoice is stuck. Review the ageing report alongside DSO.
- Calling a lower number automatically good. A lower result may reflect faster collection, but it can also follow a shrinking sales period or a changed denominator. Check the inputs and terms before celebrating.
Questions people ask
Is a DSO of 39 days good? It depends on your payment terms and the trend using the same method. Against net-30 terms, inspect the overdue balances; against longer terms, 39 days may be within the agreed window.
Should I use average or closing receivables? The simple method shown here uses the receivables balance at the end of the selected period. Some analysts use average receivables, so state your method and do not mix the two in a trend.
What happens when credit sales are zero? DSO is undefined for that period. Duebay shows a note instead of returning zero, because zero would falsely imply immediate collection.
Does the calculator upload my figures? No. Duebay’s calculator runs in your browser, and the values you enter are not sent anywhere.
Sources and limits
The formula and definition are cross-checked against Oracle’s DSO calculation documentation, APQC’s days sales outstanding measure and Intuit QuickBooks’ DSO guide. These sources describe the metric; they do not establish a universal good or bad threshold. Judge the result against your contracts and consistent historical method.
Enter your receivables, credit sales and period to see DSO with the arithmetic beside it. The calculation runs locally in your browser.
Open the free DSO calculator