Days sales outstanding calculator
Estimate collection time for credit sales.
Your inputs
Your results
Ready when you areYour results will appear here.
Compare two scenarios.
Run the tool, then save A or B to compare headline results and entered values. Keep currencies, periods and assumptions consistent.
Saved scenarios stay in this browser until you clear them. Reset clears the working result; it keeps saved scenarios. Use Clear saved scenarios on a shared device.
Run the tool to save your first scenario.
How it works
Estimate receivables collection time from beginning and ending trade receivables, net credit sales and period length. Compare the resulting average-day ratio with your typical payment terms while keeping individual overdue invoices in a separate aging report.
A few things to know
DSO is an aggregate balance-to-sales ratio, not the arithmetic average of invoice payment times. Uses a two-point average and assumes comparable sales and receivables scopes. Cash sales, seasonality, write-offs, rapid growth and different customer terms can distort comparisons. Requires positive credit sales and 1–366 whole period days. A zero average receivables balance gives zero DSO but undefined turnover.
Results use your inputs. Keep all money amounts in the same currency.
When to use this tool
Days sales outstanding turns receivables and credit sales into an average-day ratio. It is useful for spotting changes in collection performance, but it is different from counting the actual days each invoice took to pay. This DSO calculator uses a beginning-and-ending receivables average, the matching period’s net credit sales, and a payment-term benchmark that remains separate from the calculation.
- Compare aggregate collection timing across consecutive reporting periods.
- Check whether a rise in unpaid balances is large relative to credit-sales activity.
- Prepare an initial collections review before examining customer-level invoice aging.
How to use days sales outstanding calculator
Enter the two receivables balances
Use opening and closing trade receivables for the reporting period. Keep tax, allowances and credit-note treatment consistent with the credit-sales denominator and your chosen accounting convention.
Align the sales and days
Enter positive net credit sales for that same period and its whole number of days. Exclude immediate cash sales, since those do not produce the receivables being measured.
Add a term benchmark and interpret
Enter typical payment terms to see DSO minus those terms. Review the DSO and period turnover together, then check an aging report before concluding that particular customers paid late.
Receivables equivalent to 20 days of credit sales
Inputs
Opening receivables 30,000; closing receivables 50,000; net credit sales 180,000; reporting period 90 days; typical terms 30 days.
Result
Average receivables are 40,000. DSO is 20 days, period turnover is 4.5×, and DSO minus terms is −10 days.
What it means
Average receivables of 40,000 equal 20 days at the period’s average credit-sales pace of 2,000 per day. The result does not mean every invoice was collected ten days before its due date.
Common mistakes to avoid
Mixing all revenue with trade receivables
Cash sales and unrelated revenue can reduce the ratio without improving collections. Match the numerator’s customer population with the credit-sales activity in the denominator.
Calling the term gap overdue days
DSO minus typical terms is a broad comparison. It is not the late-payment duration of any invoice, and different customers may have different agreed terms.
Ignoring sharp changes within the period
Opening and closing averages can miss a large mid-period sales surge or collection run. Use a consistent method and supplement it with more frequent balance snapshots when needed.
Frequently asked questions
Definitions, edge cases, and practical next steps for this tool. Search all tool FAQs ↗
How is days sales outstanding calculated?
The tool averages opening and closing receivables, divides that average by net credit sales, and multiplies by reporting-period days. With average receivables of 40,000, credit sales of 180,000 and 90 days, DSO is 20 days.
Is DSO the average number of days invoices took to pay?
It is a balance-to-sales ratio expressed in days, not an invoice-by-invoice payment-time average. Sales mix, outstanding older invoices and growth affect the ratio. To measure actual invoice collection durations, analyze issue dates, payment dates and partial payments separately.
Should I use average or closing receivables?
This calculator deliberately uses a two-point average to reduce dependence on one closing-date snapshot. Other dashboards may use ending receivables. Either convention needs clear labeling and consistent comparisons; a result from one method should not be treated as identical to the other.
Why must net credit sales be positive?
The sales amount is the denominator. Zero sales makes DSO undefined, even when unpaid invoices remain. A no-sales period should be reviewed through invoice aging and cash forecasts rather than assigning a manufactured collection-time ratio.
What does a zero DSO mean here?
When both receivables balances are zero and credit sales are positive, the modeled average is zero and DSO is zero. Period turnover is undefined because its denominator is zero. This does not prove there were no receivables between the two snapshot dates.
Does entering payment terms change DSO?
No. Terms only create the comparison labeled DSO minus entered terms. The receivables, credit sales and reporting days determine DSO. A negative gap is below the benchmark; a positive gap warrants investigation but does not identify specific overdue invoices.
Can I compare a monthly result with an annual result?
Both express a ratio in days, but their underlying sales pace and balance averages can differ significantly. Seasonal activity and growth may explain the difference. Prefer comparable periods using the same receivables convention, and examine the underlying invoices before interpreting a trend.
What should I review when DSO increases?
Check invoice aging, disputes, customer mix, credit notes and changes in sales pace. A slower sales period can increase the ratio even without new overdue invoices. Use the aggregate signal to guide investigation rather than automatically changing every customer’s payment terms.
Explore the topic in the blog
Sources and method
Use the references below to check definitions and platform guidance. The model’s scope and limits are explained above. Read our editorial standards.