About the Accounts Receivable Turnover Calculator
This accounts receivable turnover calculator measures how many times a business collects its average receivables balance during a period, and converts that into the average collection period — the number of days it typically takes customers to pay. Enter net credit sales and the receivables balance at the start and end of the period.
Finance teams use it to monitor credit control, lenders use it to judge the quality of receivables offered as collateral, and investors compare it with competitors. Add your standard credit terms (for example net 30) to see how far actual collections run ahead of or behind what customers agreed to.
Use net credit sales — total sales minus cash sales, returns and allowances — for the most accurate ratio. If you only have total revenue, the result will overstate turnover for businesses with a lot of cash sales. Averages of the opening and closing balance can also hide seasonal peaks, so use monthly averages if your sales are very uneven.
With the default inputs, the receivables turnover ratio is 8 ×. Change any value above to recalculate instantly.
How to use the accounts receivable turnover calculator
- 1Enter net credit sales for the period from the income statement or sales ledger.
- 2Enter receivables at the start and end of the same period.
- 3Set the number of days in the period — 365 for annual figures.
- 4Optionally enter your standard credit terms to compare.
- 5Read the turnover ratio and the average days customers take to pay.
Formula and method
Receivables turnover divides net credit sales by the average accounts receivable balance for the same period. The average is the simple mean of the opening and closing balances. A higher ratio means the business converts credit sales into cash more quickly.
The average collection period (also called days sales outstanding, DSO) divides the number of days in the period by the turnover ratio — equivalently, average AR ÷ daily credit sales. Comparing it with your credit terms shows whether customers pay on time. The receivables “excess” is average AR minus the balance you would carry if everyone paid exactly on terms (daily sales × term days).
- Net credit sales
- Sales on account, after returns, allowances and discounts
- AR
- Accounts receivable (trade debtors) balance
- Days
- Length of the period in days (365 for a year)
Worked examples
$1.2M credit sales, AR from $140k to $160k
Average receivables are ($140,000 + $160,000) ÷ 2 = $150,000, so turnover is 1,200,000 ÷ 150,000 = 8 times. 365 ÷ 8 = 45.6 days to collect, about 15.6 days beyond net-30 terms; at $3,288 of sales a day that ties up around $51,370 of extra cash.
Quarterly figures for a distributor
Average AR is $112,500 and quarterly credit sales are $450,000, giving a turnover of 4 for the quarter. 90 ÷ 4 = 22.5 days, half of the 45-day terms.
Slow-paying customers
Average AR of $180,000 against $600,000 of credit sales gives turnover of 3.33. Customers take 365 ÷ 3.33 = 109.5 days on average — almost 50 days beyond 60-day terms.
Frequently asked questions
What is a good accounts receivable turnover ratio?+
It depends on your terms and industry. A business offering net-30 terms would aim for turnover of roughly 10–12 (30–36 days). Compare with your own history and peers rather than a single benchmark.
Should I use total sales or credit sales?+
Use net credit sales. Cash sales never create a receivable, so including them inflates turnover and makes collections look faster than they are. If credit sales are not disclosed, analysts use total revenue as an approximation.
What is the difference between AR turnover and DSO?+
They measure the same thing in different units. Turnover counts how many times receivables are collected per period; days sales outstanding (average collection period) converts that into days by dividing the period length by turnover.
Can a turnover ratio be too high?+
Very high turnover can mean credit terms are so strict that you lose sales to competitors who offer longer terms. It can also reflect mostly cash customers. Balance faster collections against sales growth.
How do I improve receivables turnover?+
Invoice promptly, state clear terms, offer early-payment discounts, automate reminders, check new customers’ credit before extending terms and chase overdue invoices quickly. An AR aging report shows which accounts to target.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.