Days Sales Outstanding Calculator
Calculate DSO, translate the result into working-capital impact and receive practical guidance tailored to your payment terms, trend and collection performance.
Turn four core figures into useful management information
The calculator deliberately uses a limited number of inputs. Optional fields provide deeper analysis but are not required.
Your figures
Use figures from the same reporting period and exclude cash sales where possible.
Enter your figures to generate an analysis
Your result will include DSO, days beyond terms, cash tied up, estimated cash-release opportunity and a tailored action plan.
A practical DSO improvement framework
Use the calculator result as a trigger for investigation, not as a standalone verdict.
Validate the number
Confirm that receivables and sales cover the same period and that cash sales have not distorted the denominator.
- Reconcile to the ledger
- Review seasonal sales movements
- Separate disputed and current debt
Locate the cause
Break the headline DSO into operational drivers rather than applying a generic collections response.
- Ageing by customer and value
- Promise-to-pay performance
- Billing and dispute root causes
Control the outcome
Assign actions, owners and dates, then monitor movement monthly alongside cash and overdue debt.
- Prioritised account plans
- Escalation milestones
- Target, forecast and actual DSO
Understanding DSO properly
DSO is useful when interpreted against terms, trend, business model and the underlying aged debt profile.
What does DSO measure?
DSO estimates the average number of days represented by the trade receivables balance. It is commonly used to monitor collection efficiency and working-capital absorption.
Why is payment terms comparison important?
A 45-day DSO can be relatively controlled where standard terms are 45 days, but materially weak where terms are 14 days. The gap between DSO and terms provides a more useful operational signal than DSO in isolation.
What can distort DSO?
Rapid sales growth, declining sales, seasonality, major one-off invoices, milestone billing, cash sales, credit notes and the use of a closing rather than average receivables balance can all affect the result.
Should DSO be compared across industries?
Use caution. Contract structures, customer type, billing cycles and standard terms vary. Internal trend, terms-adjusted DSO and peer data for genuinely comparable businesses are usually more meaningful.
What should senior leaders review alongside DSO?
Overdue debt, ageing distribution, disputed debt, concentration risk, collection effectiveness, bad-debt exposure, cash forecast accuracy and the value of promises due should be reviewed together.
When overdue debt requires external recovery action
HK Commercial Debt Recovery provides UK business-to-business debt recovery on a genuine no win, no fee basis, subject to assessment and terms.