Receivables turnover and supporting figures
The two balance observations estimate an average for the sales period. Collection days are undefined when no net credit sales occur, and the result states that rather than returning infinity.
For the stock-holding portion of operating capital, the Inventory Turnover Calculator measures inventory replacement separately from receivable collection.
The formula
The two balance observations estimate an average for the sales period. Collection days are undefined when no net credit sales occur, and the result states that rather than returning infinity.
Worked accounts receivable turnover example
Net credit sales of 100,000 with opening receivables of 20,000 and closing receivables of 30,000 give average receivables of 25,000 and turnover of 4×. A 365-day period implies 91.25 collection days.
How to use this calculator
- Enter net credit sales during period, opening net receivables, closing net receivables.
- Set days in reporting period using the stated units or choices.
- Calculate and compare receivables turnover, average net receivables, estimated collection period.
Choosing inputs for accounts receivable turnover
Credit sales generate receivables, while immediate cash sales generally do not. Use net credit sales for the numerator when that figure is available. Substituting total revenue changes the estimate if the business also takes substantial cash sales, and should be documented when interpreting the result.
The average of opening and closing receivables is convenient but can miss peaks and seasonal changes. A business with sharp month-end collections may need additional balance observations for a representative average. This tool does not inspect invoice aging or distinguish collectible balances from doubtful amounts.
Interpreting receivables turnover
Collection days express the reporting period divided by its turnover ratio. When the period is a quarter, enter quarter days rather than automatically using 365. Compare the estimate with credit terms and past periods, recognizing that a high turnover can reflect prompt collection, a tighter credit policy, or a changing sales mix rather than one universally favorable condition.
Assumptions & limitations
What this calculation assumes
- Sales and receivable balances use the same reporting period and currency.
- Average receivables are positive and period days are whole numbers.
What to keep in mind
- Invoice aging, seasonal averages, bad-debt analysis, and transaction-level collection timing are excluded.
Common questions
Why use credit sales rather than all revenue?
Credit sales create the receivables being measured. Including cash sales can inflate the ratio.
What if net credit sales are zero?
Turnover is zero and collection days cannot be estimated from this ratio; the result explains that state.
Can I use a quarter instead of a year?
Yes. Enter quarter credit sales, matching opening and closing balances, and the actual day count for that quarter.
Sources & further reading
Reviewed on