Receivables Turnover Ratio Calculator
Enter net credit sales and the opening and closing accounts receivable to see the receivables turnover ratio, average receivables and days sales outstanding.
Updated
Receivables Turnover Ratio Calculator
Our Receivables Turnover Ratio Calculator shows how quickly a business collects the money customers owe it. Type the net credit sales for the period and the accounts receivable balance at the start and at the end. It returns the average receivables, the receivables turnover ratio and the days sales outstanding (DSO), the average number of days a credit sale takes to turn into cash. It is built for business owners and credit managers watching cash flow, accounting students learning ratio analysis and analysts comparing companies.
Quick answer
The receivables turnover ratio is net credit sales ÷ average accounts receivable: with credit sales of 1,250,000 and receivables of 300,000 at the start and 350,000 at the end, 1,250,000 ÷ 325,000 ≈ 3.85 times, or about 94.9 days to collect.
- Average receivables: (opening + closing) ÷ 2.
- Higher turnover: customers pay faster.
- DSO: 365 ÷ turnover, the days to collect.
- Use credit sales only: cash sales never become receivables.
What Is the Receivables Turnover Ratio?
The receivables turnover ratio, also called the accounts receivable turnover or debtors turnover ratio, counts how many times a business collects its average receivables balance during a period. Each time customers pay off the typical amount they owe, receivables have turned over once.
It answers a simple question: how fast do credit sales turn into cash? A higher ratio means customers pay sooner. A lower one means money stays tied up in unpaid invoices for longer, which can squeeze cash flow even when the business is profitable.
Receivables Turnover Ratio Formula
Avg AR = (Opening + Closing) ÷ 2
DSO = 365 ÷ Turnover
- Net credit sales (Sales): sales made on credit in the period, less returns and allowances. Cash sales are left out.
- Opening receivables: accounts receivable at the start of the period.
- Closing receivables: accounts receivable at the end of the period.
- Average AR: the typical balance owed by customers during the period.
- DSO: days sales outstanding, the average number of days to collect.
Use sales and balances for the same period. For a quarter, replace 365 with the number of days in the quarter (about 91).
How to Calculate Receivables Turnover
A wholesaler made 1,250,000 of credit sales in a year. Its receivables were 300,000 on the first day and 350,000 on the last:
= 325,000
Turnover = 1,250,000 ÷ 325,000
≈ 3.85
DSO = 365 × 325,000 ÷ 1,250,000
= 94.9 days
- Add the opening and closing receivables. 300,000 + 350,000 = 650,000.
- Halve the total. 650,000 ÷ 2 = 325,000 average receivables.
- Divide net credit sales by the average. 1,250,000 ÷ 325,000 ≈ 3.85.
- Convert to days if you need to. 365 ÷ 3.85 gives about 94.9 days.
The wholesaler collects its average receivables about 3.85 times a year. A typical invoice is paid about 95 days after the sale, far longer than 30 or 60 day terms would allow.
Days Sales Outstanding
Turnover is a count, which can be hard to picture. Dividing the days in the period by the turnover gives days sales outstanding (DSO), also called the average collection period:
DSO is easy to compare with the payment terms on your invoices. If you give customers 30 days and DSO is 45, customers pay about two weeks late on average. To hit a 30-day DSO you need a turnover of about 12.17 (365 ÷ 30). A 45-day DSO needs about 8.11.
High vs Low Receivables Turnover
| Turnover | What it can mean |
|---|---|
| High | Fast collection, strict credit terms or many cash-like customers |
| Low | Slow payers, loose credit terms or weak follow-up |
| Below 1 | The average balance was not collected even once in the period |
| Falling | Collections are slowing and cash is getting tied up |
There is no single good number. A shop that takes card payments may turn its receivables dozens of times a year, while a manufacturer selling on 60-day terms may turn them about six times. Compare a business with its own past results, with its credit terms and with others in the same industry.
A very high ratio is not always good news either. Terms that are too strict can push customers to competitors who offer more time to pay.
Receivables Turnover Examples
Consulting firm. Credit sales of 90,000, receivables of 20,000 at the start and 10,000 at the end:
Turnover = 90,000 ÷ 15,000 = 6
DSO ≈ 60.83 days
Retail supplier. Credit sales of 120,000, receivables of 50,000 at the start and 70,000 at the end:
Turnover = 120,000 ÷ 60,000 = 2
DSO = 182.5 days
Distributor with slow payers. Credit sales of 35,000, receivables of 44,000 at the start and 10,000 at the end:
Turnover = 35,000 ÷ 27,000
≈ 1.3
DSO ≈ 281.57 days
The distributor collects its average balance only about 1.3 times a year. Even though the closing balance fell sharply, the year as a whole shows slow collection worth a review of its credit policy.
How to Improve Receivables Turnover
- Invoice promptly. The clock starts when the invoice goes out, so send it on the day of the sale.
- Set clear terms. State the due date and any late fee on every invoice.
- Check credit before selling. Set limits for new customers and review them for slow payers.
- Follow up early. A reminder a few days before the due date works better than a chase weeks after it.
- Offer an early payment discount. Terms like 2% off if paid within 10 days speed up cash, at a cost.
- Make paying easy. Online payment links and direct debit remove excuses for delay.
Common Mistakes
- Using total sales. Cash sales never sit in receivables, so including them makes the ratio look better than it is.
- Using only the closing balance. One date can be unusually high or low. The average smooths that out.
- Mixing periods. Quarterly sales against a 365-day year, or annual sales with quarter-end balances, give a wrong DSO.
- Ignoring seasons. A business that sells most in one quarter can show a misleading average. Compare several periods.
- Forgetting returns. Net credit sales are after returns and allowances.
The result is for education and planning and is not accounting or financial advice.
Key Terms
- Accounts receivable
- Money customers owe for goods or services already delivered on credit.
- Net credit sales
- Credit sales for the period less returns and allowances.
- Average receivables
- Opening plus closing receivables, divided by 2.
- Receivables turnover
- Net credit sales divided by average receivables.
- Days sales outstanding
- Days in the period divided by receivables turnover.
- Credit terms
- The time a customer is given to pay, such as 30 days.
How to Use the Receivables Turnover Ratio Calculator
- Enter net credit sales. Type the credit sales for the period after returns, such as 1,250,000.
- Enter opening receivables. Type accounts receivable at the start of the period, such as 300,000.
- Enter closing receivables. Type accounts receivable at the end of the period, such as 350,000.
- Read and copy the result. The receivables turnover ratio appears as you type, with average receivables and days sales outstanding. Press Copy to copy it, or Clear or Esc to start again.
Example: credit sales of 90,000 with receivables of 20,000 at the start and 10,000 at the end give average receivables of 15,000 and a turnover of 6, about 60.83 days to collect.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
How do you calculate the receivables turnover ratio?
Divide net credit sales by average accounts receivable. Average accounts receivable is the opening balance plus the closing balance, divided by 2.
What is the receivables turnover ratio formula?
Receivables turnover = net credit sales ÷ average accounts receivable, where average accounts receivable = (opening + closing receivables) ÷ 2.
What is the receivables turnover for credit sales of 1,250,000 with receivables of 300,000 and 350,000?
Average receivables are 325,000, so the turnover is 1,250,000 ÷ 325,000 ≈ 3.85. Days sales outstanding are 365 ÷ 3.85, about 94.9 days.
What is a good receivables turnover ratio?
It depends on the industry and the credit terms. A useful check is to convert it to days with 365 ÷ turnover and compare the result with your payment terms. A DSO close to the terms is good.
How do you convert receivables turnover to days?
Divide the number of days in the period by the turnover. For a year, DSO = 365 ÷ turnover, so a turnover of 6 is about 60.83 days.
Why use net credit sales instead of total sales?
Only credit sales create receivables. Including cash sales inflates the ratio and makes collection look faster than it is.
What does a receivables turnover below 1 mean?
It means the business did not collect even its average receivables balance once during the period, which points to very slow payers or very long credit terms.
Is the Receivables Turnover Ratio Calculator free?
Yes. It is free to use, with no sign-up and no limit on how many times you use it.
Sources
- AccountingTools. Accounts receivable turnover ratio definition.
- Corporate Finance Institute. Accounts Receivable Turnover Ratio.
- Wall Street Prep. Accounts Receivable Turnover Ratio.
- Wikipedia. Receivables turnover ratio.
- Wikipedia. Days sales outstanding.
Try our Receivables Turnover Ratio Calculator to see how quickly your credit sales turn into cash.