Receivable Days and Turnover
Calculate using the labelled inputs: Receivable Days and Turnover.
Enter a finite value within the formula’s domain and supported numeric range.
Calculation and assumptions
average=(opening+closing)/2; DSO=average·days/credit_sales; turnover=credit_sales/average. daily=credit_sales/days; gap=DSO−terms (terms>0).
The two-point average approximates receivables; ratios use its unrounded value. Use credit sales and balances from the same period with consistent tax and return treatment. Cash sales are excluded. DSO is an aggregate ratio, not an invoice deadline or actual payment history. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied. Daily sales are rounded for display only. The signed DSO-minus-terms gap is an aggregate comparison, not evidence that a particular invoice is overdue; zero terms disables it.
Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.
Frequently asked questions
How is the result calculated?
average=(opening+closing)/2; DSO=average·days/credit_sales; turnover=credit_sales/average. daily=credit_sales/days; gap=DSO−terms (terms>0).
What assumptions apply?
The two-point average approximates receivables; ratios use its unrounded value. Use credit sales and balances from the same period with consistent tax and return treatment. Cash sales are excluded. DSO is an aggregate ratio, not an invoice deadline or actual payment history. A dash means the corresponding ratio is undefined because its denominator is zero. In one chosen two-decimal currency; no taxes or current market rates are supplied. Daily sales are rounded for display only. The signed DSO-minus-terms gap is an aggregate comparison, not evidence that a particular invoice is overdue; zero terms disables it.
How precise are the results?
Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.