You made the sale, but when does the money actually hit your account? Days sales outstanding, or DSO, measures the wait. The Accounts Receivable Days Calculator turns your receivables and credit sales into DSO, turnover, and daily sales.
Business owners, bookkeepers, and finance teams use it to check how quickly customers pay. It works for any company that sells on credit terms such as net 30. A rising DSO is often an early warning that cash will get tight.
Table of Contents
- What the Calculator Does
- How to Use It, Step by Step
- The DSO Formula
- Worked Example
- How to Read the Results
- Speeding Up Collections
- Limitations and Assumptions
- FAQs About the Accounts Receivable Days Calculator
What the Calculator Does
The tool updates live. Three inputs produce five results.
- Days Sales Outstanding (DSO): average days to collect payment after a credit sale.
- AR Turnover Multiple: how many times receivables are collected in the period.
- Average Daily Sales: credit sales divided by the days in the period.
- Outstanding Balance: your average receivables in dollars.
- Collection Health: a short label based on DSO.
- Copy DSO Metric and Reset buttons.
How to Use It, Step by Step
- Enter the typical unpaid customer balance in Average Accounts Receivable ($).
- Enter sales made on credit in Total Credit Sales Revenue ($). Leave out cash sales.
- Choose Measurement Period (Days): 1 Year (365 Days), 1 Quarter (90 Days), or 1 Month (30 Days).
- Match the sales figure to the period you chose.
- Read DSO and the Collection Health label. A red message means a field is blank or invalid. Press Copy DSO Metric to copy a summary.
The DSO Formula
DSO compares what customers owe with what you sold, then scales that to days.
Average AR÷Credit Sales×Days in Period=DSO
- DSO = (average receivables ÷ credit sales) × days.
- AR turnover = credit sales ÷ average receivables.
- Average daily sales = credit sales ÷ days.
The label uses fixed cutoffs. A DSO of 30 or less reads Excellent Cash Collection. Over 30 up to 45 reads Healthy Collection Efficiency. Above 45 reads Delayed Collection (Credit Risk).
Worked Example
Marcus runs a commercial cleaning company. His customers owe an average of $54,000. Credit sales for the year were $612,000, and he selects 1 Year (365 Days).
| Result | Calculation | Output |
|---|
| Days Sales Outstanding | ($54,000 ÷ $612,000) × 365 | 32.2 Days |
| AR Turnover Multiple | $612,000 ÷ $54,000 | 11.33x / Period |
| Average Daily Sales | $612,000 ÷ 365 | $1,676.71 / Day |
| Outstanding Balance | Average receivables | $54,000.00 |
| Collection Health | 32.2 is between 30 and 45 | Healthy Collection Efficiency |
If Marcus's terms are net 30, customers pay about two days late on average. That is a small gap worth watching.
How to Read the Results
DSO should sit close to your payment terms. A DSO of 32 on net 30 terms is normal. A DSO of 60 on the same terms means many invoices are late.
AR Turnover is the same idea as a count. Higher means faster collection. The label says "per period," so match it to the period you selected.
Average Daily Sales helps you size the problem. Each day of delay holds back about that much cash.
Outstanding Balance repeats your receivables input in dollars. Divide it by daily sales to see the same DSO in a second way.
Speeding Up Collections
Slow DSO ties up cash you could use for payroll or stock. Send invoices on the day of sale and offer easy payment options. Follow up before the due date. Some firms give a small early-payment discount.
Watch for a few large late accounts. One slow customer can lift DSO for the whole business. Because this tool uses an average balance, it will not show which customer is late.
See how receivables affect your bank balance with the cash flow calculator. The working capital calculator shows whether collections can cover your bills. For the other side of the cycle, use the accounts payable days calculator and the inventory days calculator.
Review your invoicing costs with the invoice total calculator. Find related tools in the finance and business calculator hub.
Limitations and Assumptions
- The tool uses one average receivables figure. It does not average opening and closing balances for you.
- Use credit sales only. Including cash sales makes DSO look better than it is.
- Blank receivables or blank credit sales show a message and N/A. Sales must be above $0, and receivables must be $0 or more.
- With $0 receivables, DSO shows 0.0 Days, turnover shows N/A, and Collection Health reads N/A (No Receivables).
- If receivables exceed credit sales, a note asks you to check that both cover the same period. The result still shows.
- The label cutoffs of 30 and 45 days are fixed and ignore your industry or stated terms.
FAQs About the Accounts Receivable Days Calculator (DSO)
What is days sales outstanding?
It is the average number of days between a credit sale and the cash payment. It is also called receivable days or collection period.
What is a good DSO?
Compare it with your payment terms. Many businesses aim to stay close to their terms. The right level varies by industry.
Should I use total sales or credit sales?
Use credit sales. Cash sales never create a receivable, so including them lowers DSO and hides slow customers.
Why does the period I choose matter?
The formula multiplies by the number of days. Your sales figure must cover that same span, or the answer will be wrong.
Does a high DSO always mean a problem?
No. Large customers may have longer agreed terms. It becomes a problem when DSO rises above your terms or trends upward over time.
How can I lower my DSO?
Invoice promptly, set clear terms, send reminders, and follow up on late accounts. Checking credit before large sales also helps.
This calculator gives planning estimates only and is not financial advice. Reviewed for general accuracy by Prof. Dr. Khalil Mudassar, PhD.