Why Receivables Turnover Matters
A sale made on credit creates a receivable: the customer has received goods or services, but the business has not yet collected the cash. Receivables turnover relates the period’s credit sales to the receivables balance that those sales generate. The related collection-days measure expresses that relationship in a more intuitive unit: an estimated number of days of credit sales held in receivables.
These measures are useful for assessing collection efficiency and tracking changes over time. They are averages, however, not a record of how long each invoice has been outstanding. Their interpretation depends on using an appropriate sales numerator, a representative receivables balance, and a consistent day-count convention.
Formulas and Measurement Choices
For an annual analysis using a 365-day convention, let net credit sales be credit sales after applicable sales returns, allowances, and discounts. Average trade receivables are commonly estimated as the average of the opening and closing balances:
The 365 in the formula is a convention, not an unavoidable feature of the ratio. If the analysis uses a 360-day year, substitute 360 and use that convention consistently in all comparisons. The numerator and denominator must also refer to matching periods and currency units. For example, annual sales stated in thousands of dollars should be divided by receivables stated in thousands of dollars.
Use credit sales, rather than total sales, because cash sales do not create trade receivables. If only total sales are available and cash sales are material, total sales may overstate the sales that generated the receivables. Net credit sales should reflect relevant reductions such as returns and allowances on credit transactions. The balance should represent the corresponding trade receivables; if the balance is reported net of an allowance for doubtful accounts, use that reported measure consistently and recognize that estimates of uncollectible amounts affect the ratio.
Why Collection Days Is the Inverse of Turnover
The conversion follows directly from the definitions. Suppose the period contains \(D\) days and net credit sales occur at a roughly steady rate. Average daily net credit sales are then net credit sales divided by \(D\). Dividing average receivables by average daily sales estimates how many days of sales are tied up in receivables:
This derivation explains both the reciprocal formula and its limitation. The calculation estimates days represented by the average balance if sales flow is reasonably representative. A highly seasonal business, a major change in credit terms, or a large sale near period-end can make a simple opening-and-closing average less representative. When available, monthly or quarterly receivables balances can provide a more informative average.
Worked Example: Calculating Turnover and Collection Days
A hypothetical equipment supplier reports net credit sales of $1,440,000 for the year. Trade receivables were $150,000 at the start of the year and $210,000 at year-end. Calculate receivables turnover and estimated collection days using 365 days. Check the result using the direct collection-days formula.
Method. First calculate average receivables, then divide net credit sales by that average. Use the resulting turnover to estimate collection days. The common mistake to avoid is using only the ending balance in the denominator.
Step 1: Average receivables. \((\$150{,}000+\$210{,}000)/2=\$360{,}000/2=\$180{,}000.\)
Step 2: Receivables turnover. \(\$1{,}440{,}000/\$180{,}000=8.00\) times for the year.
Step 3: Estimated collection days. \(365/8.00=45.625\) days, which rounds to 45.63 days to two decimal places.
Check. Using the direct formula gives \(365\times\$180{,}000/\$1{,}440{,}000=\$65{,}700{,}000/\$1{,}440{,}000=45.625\) days, or 45.63 days to two decimal places. The two methods agree. This is an estimated average, not a statement that every customer pays in exactly 45.63 days.
Comparing Collection Efficiency Across Periods
A change in turnover and a change in collection days describe the same relationship from opposite directions. Higher turnover corresponds to fewer collection days, while lower turnover corresponds to more collection days. To compare periods fairly, use the same day-count convention and compatible definitions of net credit sales and receivables in each period.
Worked Example: Interpreting a Two-Year Change
A hypothetical distributor uses a 365-day year. In Year 1, net credit sales were $1,760,000, beginning receivables were $200,000, and ending receivables were $240,000. In Year 2, net credit sales were $1,620,000, beginning receivables were $210,000, and ending receivables were $230,000. Calculate turnover and collection days for each year, then describe the change. Round collection days to two decimal places.
Method. Compute each year’s average balance and turnover separately, then convert to days. Keep the unrounded ratios for the calculations; rounding turnover early can create a small discrepancy in collection days.
Year 1 average receivables. \((\$200{,}000+\$240{,}000)/2=\$220{,}000.\)
Year 1 turnover and days. \(\$1{,}760{,}000/\$220{,}000=8.00\) times. Collection days are \(365/8.00=45.625\), or 45.63 days.
Year 2 average receivables. \((\$210{,}000+\$230{,}000)/2=\$220{,}000.\)
Year 2 turnover and days. \(\$1{,}620{,}000/\$220{,}000=7.363636\ldots\) times. Collection days are \(365/7.363636\ldots=49.567901\ldots\), or 49.57 days.
Interpretation and check. Turnover declined from 8.00 to about 7.36 times, while collection days increased. Using the displayed rounded figures, collection days increased by \(49.57-45.63=3.94\) days. The direct Year 2 calculation confirms the result: \(365\times\$220{,}000/\$1{,}620{,}000=\$80{,}300{,}000/\$1{,}620{,}000=49.567901\ldots\) days, which rounds to 49.57 days. The figures suggest slower collection relative to credit sales, but do not by themselves establish why the change occurred.
Choosing the Right Sales Numerator
The numerator is a frequent source of error. A company can report substantial total revenue while making a meaningful portion of its sales for cash. Since those cash transactions do not create receivables, including them in the numerator can make turnover appear higher and collection days shorter than the credit activity supports.
Worked Example: Separating Credit Sales from Total Revenue
A hypothetical service-parts business reports total sales revenue of $2,000,000, consisting of $1,600,000 of gross credit sales and $400,000 of cash sales. Credit customers received $40,000 of returns and allowances. Beginning trade receivables were $180,000 and ending receivables were $220,000. Calculate turnover and collection days on a 365-day basis. Also show the effect of mistakenly using total sales less the credit returns.
Method. Determine net credit sales first, then use average receivables. The common mistake is to include cash sales in a ratio intended to measure the collection of credit sales.
Step 1: Net credit sales. \(\$1{,}600{,}000-\$40{,}000=\$1{,}560{,}000.\) Cash sales are excluded because they did not create trade receivables.
Step 2: Average receivables. \((\$180{,}000+\$220{,}000)/2=\$200{,}000.\)
Step 3: Correct turnover and collection days. \(\$1{,}560{,}000/\$200{,}000=7.80\) times. Thus \(365/7.80=46.794871\ldots\) days, or 46.79 days to two decimal places. The direct calculation is \(365\times\$200{,}000/\$1{,}560{,}000=\$73{,}000{,}000/\$1{,}560{,}000=46.794871\ldots\) days, confirming the result.
Incorrect alternative. Total sales less the credit returns would be \(\$2{,}000{,}000-\$40{,}000=\$1{,}960{,}000\). Dividing this by $200,000 gives an erroneous turnover of 9.80 times and \(365/9.80=37.244897\ldots\), or 37.24 days. That calculation treats cash sales as if they had generated receivables, understating the estimated collection period for credit sales.
Interpreting the Measures with Care
A lower collection-days figure is often consistent with faster collection, and a higher turnover is often consistent with more efficient use of receivables. Neither result is automatically good or bad in isolation. A firm may tighten credit terms and collect faster but lose sales; another may intentionally offer longer payment terms to support customer relationships. The ratio describes a financial relationship, not management’s objective or the quality of every customer account.
Collection days is also not the same as an invoice-aging statistic. It is derived from a period-wide sales flow and an average receivables balance. Some customers may pay quickly while others pay late, and a rising average can conceal a much larger overdue balance in a subset of accounts. An aging schedule or other account-level information is needed to assess how receivables are distributed by time outstanding.
When interpreting a result, ask whether credit sales changed substantially, whether the firm’s credit terms changed, and whether the average balance represents the period. Seasonal sales, acquisitions, unusual transactions near year-end, and changes in the accounting treatment of returns or allowances can all affect comparability. Use peer or prior-period comparisons only when these underlying definitions and business conditions are sufficiently comparable.
Use net credit sales for the period, excluding cash sales and reflecting relevant credit returns and allowances.
Use average trade receivables; the opening-and-closing average is a basic estimate, while more frequent balances may be preferable when activity is seasonal.
Divide net credit sales by average receivables for turnover, then divide the stated number of days in the period by turnover for estimated collection days.
Check Your Understanding
For each problem, use a 365-day year unless otherwise stated. Round collection days to two decimal places and retain unrounded values until the final step.
- A hypothetical wholesaler has net credit sales of $960,000, beginning receivables of $100,000, and ending receivables of $140,000. Calculate average receivables, turnover, and collection days. (Answer: Average receivables = $120,000; turnover = 8.00 times; collection days = 45.63 days.)
- A hypothetical manufacturer reports gross credit sales of $1,250,000, credit returns and allowances of $50,000, and average receivables of $150,000. Calculate turnover and collection days using net credit sales. (Answer: Net credit sales = $1,200,000; turnover = 8.00 times; collection days = 45.63 days.)
- A hypothetical distributor has net credit sales of $2,400,000 and average receivables of $300,000 in Year 1. In Year 2, net credit sales are $2,100,000 and average receivables are $350,000. Calculate turnover and collection days in each year, then find the increase in collection days using the displayed rounded values. (Answer: Year 1 turnover = 8.00 and days = 45.63; Year 2 turnover = 6.00 and days = 60.83; increase = 15.20 days.)
- A hypothetical company’s net credit sales are $3,285,000. Its estimated collection period is 50 days using a 365-day convention. Find its implied receivables turnover and average receivables. (Answer: Turnover = 7.30 times; average receivables = $450,000.)
- A hypothetical business has annual net credit sales of $3,650,000 and is evaluating a target collection period of 32 days. On a 365-day basis, what average receivables balance corresponds to the target, and what turnover does it imply? (Answer: Average receivables = $320,000; turnover = 11.40625 times, approximately 11.41 times.)