Receivables Turnover Ratio Calculator (turnover & days sales outstanding)

Understanding the receivables turnover ratio calculator — concept and principle

This calculator measures how quickly a business collects money from customers who buy on credit. It works out receivables turnover, days sales outstanding (DSO), average receivables, how many days collection runs beyond your credit terms, turnover on year-end receivables and sales per day. Finance teams, credit controllers and analysts use it to monitor collection and cash flow.

How fast customers pay — with the default inputs: 45.6 days.

How it is calculated

Average receivables = (start + end) ÷ 2
Receivables turnover = net credit sales ÷ average receivables
DSO = days in the period ÷ turnover
Days beyond credit terms = DSO − credit terms
Turnover on year-end receivables = credit sales ÷ ending receivables
Sales per day = credit sales ÷ days

The principle

Turnover counts how many times in a period the business collects its typical receivables balance. Dividing the days in the period by turnover gives DSO, the average number of days customers take to pay. Comparing DSO with your credit terms shows how late payments run on average. Use credit sales when available: cash sales never create receivables and would make collection look faster than it is. Seasonal businesses should average more than two balances, for example twelve month-end figures.

Worked example

Defaults: credit sales 1,200,000; receivables 140,000 at the start and 160,000 at the end; 365 days; terms 30 days.

Average receivables = (140,000 + 160,000) ÷ 2 = $150,000.
Turnover = 1,200,000 ÷ 150,000 = 8×.
DSO = 365 ÷ 8 = 45.6 days.
Days beyond terms = 45.6 − 30 = 15.6.
Turnover on year-end receivables = 1,200,000 ÷ 160,000 = 7.5; sales per day = $3,288.

Each point is the calculator re-run with only “Net credit sales for the period” changed; the gold point is the default example. Change the inputs above and this chart follows your numbers.

Net credit sales for the period	Receivables turnover
300,000	2×
600,000	4×
900,000	6×
1.2e+06	8×
1.5e+06	10×
1.8e+06	12×
2.4e+06	16×

How to read the result

Customers here pay on average about two weeks later than the 30-day terms. Each day of DSO ties up about 3,288 in receivables, so cutting DSO by ten days would free roughly 33,000 of cash. Look at an aged receivables report as well: an average can hide a few very late accounts.

Common mistakes

Using total sales when much of it is cash.
Using only year-end receivables in a seasonal business.
Comparing DSO across industries with different normal credit terms.
Ignoring bad debts that sit in receivables but will never be collected.

Keep in mind: DSO is an average. It does not show which customers pay late or which balances are doubtful. Not financial advice.

Frequently asked questions

What is a good receivables turnover?

Higher is better, but it depends on your credit terms and industry; compare DSO with your own terms.

How do I lower DSO?

Invoice promptly, follow up overdue accounts, check credit before selling and consider early-payment incentives.

Why use average receivables?

Sales happen throughout the year, so the average balance matches them better than one date.

Sources: CFA Institute, "CFA Program Level II Financial Ratio List" · OpenStax, Principles of Finance (2022), section 6.2 "Operating Efficiency Ratios"

Checked 9 Nov 2026. Receivables turnover ratio = total revenue ÷ average receivables and DSO = number of days in period ÷ receivables turnover: CFA Institute, “CFA Program Level II Financial Ratio List” (ratios 5 and 6). Net credit sales ÷ average of beginning and ending receivables: OpenStax, “Principles of Finance” (2022), section 6.2 “Operating Efficiency Ratios”.

Your numbers