How do I calculate accounts receivable turnover?

Receivables turnover is credit sales divided by average receivables. $365,000 on a $30,000 average turns 12.17×, or 30 days. Examples cover slow payers, cash sales, and a blank opening balance.

Receivables turnover asks how many times credit sales collect the average amount customers owe.

The SBA glossary defines Days Receivable as accounts receivable divided by annual sales on credit, times 365. Turnover is that relationship flipped. An SEC computation of ratios exhibit writes the matching average as beginning plus ending, divided by two.

The accounts receivable turnover calculator uses both balances:

Average receivables = (beginning + ending) ÷ 2

Turnover = credit sales ÷ average receivables

Days outstanding = days in the period ÷ turnover

Receivables turnover on this page is a count of turns for the period you type. Days outstanding is that count read as a wait. One ending balance, without the average, is the days sales outstanding calculator. The DSO post walks that version. A late fee on one invoice is the late fee post. The wait joins inventory days and payable days in the cash conversion cycle post.

Use credit sales only. A cash sale never sits in receivables. Example 5 mixes cash sales in and the turns look faster than the book.

Fig 1

Two balances, then the turns

Credit sales only

Beginning receivablesAverage the twobalancesEnding receivablesCredit salesSales divided by theaverageDay count divided byturns

Average the beginning and ending receivables. Divide credit sales by that average. Divide the day count by the turns.

What a higher turn means

More turns, on the same credit sales, means a smaller average balance. Cash is leaving the receivable book faster. Fewer turns means the average balance is large relative to sales, so a typical dollar sits longer. The day count has to match the sales. A year on this page is 365 days. Example 6 is a 90-day quarter, and its turns belong to those 90 days.

The SBA days line uses one receivables figure. This calculator uses the average of two. Example 7 runs both on the default year.

Example 1: the calculator defaults

Inputs:

  • beginning receivables: $28,000
  • ending receivables: $32,000
  • credit sales: $365,000
  • days: 365

Average receivables: (28,000 + 32,000) ÷ 2 = $30,000.00

Turnover: 365,000 ÷ 30,000 = 12.1667, shown as 12.17×

Days outstanding: 365 ÷ (365,000 ÷ 30,000) = 30 days

Calculator result

Accounts receivable turnover

Beginning accounts receivable
$28,000.00
Ending accounts receivable
$32,000.00
Annual credit sales
$365,000.00
Days in the period
365 days

12.17×

receivables turns in the period

Average receivables
$30,000.00
Days sales outstanding
30 days
Credit sales
$365,000.00
Open the calculator

Credit sales per day are 365,000 ÷ 365 = $1,000.00. Thirty days of that is 30 × 1,000 = $30,000, which is the average balance. The book turned a bit more than once a month. The ending balance is $4,000 above the start, so the year closed with more owed than it opened with. The average still uses both.

Fig 2 · 1/2

30 days inside a 365-day year

Defaults. Average receivables $30,000. Credit sales $365,000.

Days outstanding

30 days

Days in the year

Year length next

365 days

Days outstanding are 30.

The period you typed is 365 days.

Example 2: slow payers, same sales

Hold the $365,000 of credit sales and the 365 days. Change the balances to beginning $80,000 and ending $100,000.

Average: (80,000 + 100,000) ÷ 2 = $90,000.00

Turnover: 365,000 ÷ 90,000 = 4.0556, shown as 4.06×

Days outstanding: 365 × 90,000 ÷ 365,000 = 90 days

The average balance is three times Example 1’s $30,000. Turns fall from 12.17× to 4.06×. The wait goes from 30 days to 90. Sales did not slow. Collection did. Ninety days of $1,000 credit sales is the $90,000 average.

Example 3: a fast book

Inputs: beginning $12,000, ending $8,000, credit sales $480,000, days 365.

Average: (12,000 + 8,000) ÷ 2 = $10,000.00

Turnover: 480,000 ÷ 10,000 = 48×

Days outstanding: 365 ÷ 48 = 7.6042, shown as 7.6 days

The balance shrank over the year, and sales are larger than Example 1. 48 ÷ 12.17 = 3.94 times the displayed default. Unrounded, 365 ÷ 48 = 7.6042 days, and the page shows 7.6 days.

Example 4: what if the ending balance doubles

Hold Example 1’s beginning balance, credit sales, and 365 days. Change ending receivables from $32,000 to $64,000.

Average: (28,000 + 64,000) ÷ 2 = $46,000.00

Turnover: 365,000 ÷ 46,000 = 7.9348, shown as 7.93×

Days outstanding: 365 × 46,000 ÷ 365,000 = 46 days

The extra $32,000 at the close raised the average by 46,000 − 30,000 = $16,000.00. Half of the extra ending balance lands in the average, because the start did not change. Turns fall from 12.17× to 7.93×. Days rise from 30 to 46. Same credit sales, more owed at year end.

Fig 3 · 1/5

Turns in the period

One series. The fast book is 48 turns. The others share the axis with it.

Turns

Turns in the period012.52537.550DefaultSlowFastEnd doublesStudio
  • Turns
Turns in the period
CategoryTurns
Default12.2
Slow4.1
Fast48
End doubles7.9
Studio14.4

The default year turns 12.17 times.

The fast book turns 48 times. The slow book turns 4.06.

Example 5: the mistake of mixing in cash sales

Hold Example 1’s balances. Average receivables stay $30,000.00. Credit sales are $365,000. Cash sales of $135,000 went through the register and never sat in receivables. Someone types the combined $500,000 as the sales box.

Turnover: 500,000 ÷ 30,000 = 16.6667, shown as 16.67×

Days outstanding: 365 × 30,000 ÷ 500,000 = 21.9 days

Calculator result

Accounts receivable turnover

Beginning accounts receivable
$28,000.00
Ending accounts receivable
$32,000.00
Annual credit sales
$500,000.00
Days in the period
365 days

16.67×

receivables turns in the period

Average receivables
$30,000.00
Days sales outstanding
21.9 days
Credit sales
$500,000.00
Open the calculator

The credit-only result is still Example 1: 12.17× and 30 days. The gap is 16.67 − 12.17 = 4.5 turns, and 30 − 21.9 = 8.1 days. Cash sales made the book look faster. Leave them out. Card-at-sale receipts that never become a receivable belong with cash sales, not in this numerator.

Example 6: a 90-day quarter

Inputs: beginning $20,000, ending $28,000, credit sales $90,000, days 90.

Average: (20,000 + 28,000) ÷ 2 = $24,000.00

Turnover: 90,000 ÷ 24,000 = 3.75×

Days outstanding: 90 ÷ 3.75 = 24 days

Three and three quarter turns in a 90-day period means the average balance sat 24 days inside that quarter. Multiplying 3.75 × 4 and calling it 15 turns a year assumes the next three quarters look like this one. Type 365, with that year’s sales and balances, when you want a year.

Example 7: one ending balance instead of the average

The days sales outstanding calculator uses the receivables figure you type, not the average of two dates.

Type the default ending balance: receivables $32,000, credit sales $365,000, days 365.

DSO: 32,000 ÷ 365,000 × 365 = 32 days

Turnover on that one balance: 365,000 ÷ 32,000 = 11.4063, shown as 11.41×

Credit sales per day on that page: $1,000.00

The average method in Example 1 says 12.17× and 30 days. The ending-only method says 11.41× and 32 days. The difference is the opening balance. Beginning was $28,000, which on its own would be 28,000 ÷ 365,000 × 365 = 28 days and 365,000 ÷ 28,000 = 13.0357, shown as 13.04×. The SEC-style average sits between them: 30 days, between 28 and 32.

Use the turnover page when you have both dates. Use the DSO page when you have one balance. They answer different inputs. They meet when beginning equals ending, which is Example 9.

Example 8: a small studio

Inputs: beginning $4,000, ending $6,000, credit sales $72,000, days 365.

Average: (4,000 + 6,000) ÷ 2 = $5,000.00

Turnover: 72,000 ÷ 5,000 = 14.4×

Days outstanding: 365 ÷ 14.4 = 25.3472, shown as 25.3 days

The dollars are small next to Example 1. The wait is 25.3 days against 30. The turn count is higher because a $5,000 average is small next to $72,000 of credit sales.

Example 9: beginning equals ending

Inputs: beginning $40,000, ending $40,000, credit sales $240,000, days 365.

Average: (40,000 + 40,000) ÷ 2 = $40,000.00

Turnover: 240,000 ÷ 40,000 = 6×

Days outstanding: 365 ÷ 6 = 60.8333, shown as 60.8 days

When the two balances match, the average is that balance, and it matches a single-balance DSO on $40,000. You still type both. Leaving the beginning at zero is Example 10, and it cuts this kind of average in half.

Example 10: the opening balance left blank

Hold Example 1’s ending balance, credit sales, and 365 days. Type beginning receivables as $0.

Average: (0 + 32,000) ÷ 2 = $16,000.00

Turnover: 365,000 ÷ 16,000 = 22.8125, shown as 22.81×

Days outstanding: 365 × 16,000 ÷ 365,000 = 16 days

Calculator result

Accounts receivable turnover

Beginning accounts receivable
$0.00
Ending accounts receivable
$32,000.00
Annual credit sales
$365,000.00
Days in the period
365 days

22.81×

receivables turns in the period

Average receivables
$16,000.00
Days sales outstanding
16 days
Credit sales
$365,000.00
Open the calculator

Example 1, with the real $28,000 opening, is 12.17× and 30 days. A blank opening cuts the average from $30,000 to $16,000 and almost doubles the turns. Zero belongs in the box when the book opened at zero. If the opening figure is missing, use the ending-only DSO in Example 7, which matches the number you have.

Fig 4 · 1/6

Days outstanding

Same day formula. The balances and the sales change.

Days outstanding

Default

30

Slow

Slow book next

 90

Fast

Fast book next

 7.6

Quarter

Quarter next

 24

Flat balances

Flat balances next

 60.8

Blank opening

Blank opening next

 16

The default year is 30 days.

The slow book is 90 days. A blank opening prints 16.

The results side by side

Example Beginning Ending Average Credit sales Days Turns Days out
1. Defaults $28,000 $32,000 $30,000 $365,000 365 12.17× 30
2. Slow $80,000 $100,000 $90,000 $365,000 365 4.06× 90
3. Fast $12,000 $8,000 $10,000 $480,000 365 48× 7.6
4. Ending doubles $28,000 $64,000 $46,000 $365,000 365 7.93× 46
5. Cash mixed in $28,000 $32,000 $30,000 $500,000 typed 365 16.67× 21.9
6. Quarter $20,000 $28,000 $24,000 $90,000 90 3.75× 24
7. Ending only none $32,000 not used $365,000 365 11.41× 32
8. Studio $4,000 $6,000 $5,000 $72,000 365 14.4× 25.3
9. Flat balances $40,000 $40,000 $40,000 $240,000 365 6× 60.8
10. Blank opening $0 $32,000 $16,000 $365,000 365 22.81× 16

Example 7 has no beginning balance. Those turns come from the DSO calculator: 365,000 ÷ 32,000 = 11.41×.

Example 5 is cash sales in the numerator. Example 10 is a zero that was not a real opening. Example 7 is the right tool when you only have the ending balance.

Receivables still sit in the quick ratio as near cash, whatever their age. The quick ratio post counts the whole receivables line. Turnover tells you how fast that line has been collected. Inventory’s version of this average is the inventory turnover post.