Accounts Receivable Turnover Calculator

Accounts receivable turnover is a working-capital efficiency ratio. It tells you how quickly a company converts credit sales into cash. A high turnover ratio means customers pay quickly and the company is not tying up capital in unpaid invoices. A low turnover ratio means cash is trapped on the balance sheet as receivables, which can strain liquidity even when the income statement looks profitable.

Credit managers, lenders, and equity analysts all watch this ratio for different reasons. A lender evaluating a borrowing-base line of credit wants to know how much of the pledged receivables collateral is likely to actually convert to cash. An equity analyst comparing two companies in the same industry uses turnover to spot a company whose reported revenue growth is being financed by looser credit terms rather than genuine demand. Internally, a controller tracks turnover trend line by line to catch a slipping collections process before it becomes a cash crisis.

The ratio only means something in the same units as its companion metric, Days Sales Outstanding (DSO). Turnover answers "how many times per year," DSO answers "how many days per collection cycle." They are mathematical inverses of each other and this calculator reports both.

Step 1: Average Accounts Receivable. Average the beginning and ending AR balance for the period, since turnover measures a rate over the period rather than a single balance-sheet snapshot:

$$\text{Average AR} = \frac{\text{Beginning AR} + \text{Ending AR}}{2}$$

Step 2: Turnover Ratio.

$$\text{AR Turnover} = \frac{\text{Net Credit Sales}}{\text{Average Accounts Receivable}}$$

Net credit sales excludes cash sales, since cash sales never sit in receivables and would artificially inflate the ratio.

Step 3: Days Sales Outstanding.

$$\text{DSO} = \frac{\text{Days in Period}}{\text{AR Turnover}}$$

DSO expresses the same information as an average collection period in days, which is usually more intuitive for comparing against a company's stated payment terms (e.g. Net 30, Net 60).

A wholesale distributor reports the following for its fiscal year:

• Net Credit Sales: $5,000,000
• Beginning Accounts Receivable: $450,000
• Ending Accounts Receivable: $550,000
• Days in Period: 365

Step 1: Average AR = ($450,000 + $550,000) / 2 = $500,000

Step 2: AR Turnover = $5,000,000 / $500,000 = 10.00x

Step 3: DSO = 365 / 10.00 = 36.5 days

The distributor collects its entire average receivables balance ten times per year, or roughly once every 36.5 days. If its stated terms are Net 30, a 36.5-day average collection period suggests some customers are paying a week or so past terms, worth a closer look at the aging schedule rather than an emergency.

• Seasonality. A single beginning/ending snapshot can misrepresent a business with seasonal sales spikes; a retailer with a holiday-heavy fourth quarter may show a distorted turnover ratio if the beginning and ending balances straddle the peak unevenly. Monthly averaging is more accurate for seasonal businesses.
• Sales mix. The ratio does not distinguish between a $10,000 invoice 90 days overdue and one hundred $100 invoices paid on time. Two companies with identical turnover ratios can have very different concentrations of collection risk.
• Write-offs and factoring. If a company sells or factors receivables, or writes off bad debt aggressively, turnover can look artificially strong because the AR balance never sits on the books long enough to age.
• Cash sales mixed into the total. If a company cannot cleanly separate cash and credit sales in its reporting, using total sales instead of net credit sales in the numerator overstates turnover, sometimes significantly for retail-heavy businesses.
• Bad debt allowance timing. Receivables are typically reported net of an allowance for doubtful accounts, which involves management estimates. Aggressive allowance assumptions change the reported AR balance and therefore the ratio, independent of actual collection performance.

• Using total revenue instead of net credit sales. This is the single most common error. If a business is majority cash sales, using total revenue in the numerator inflates the turnover ratio and understates DSO.
• Comparing turnover across industries without adjustment. A grocery chain with mostly cash and card sales will show near-infinite turnover; a construction contractor billing on 90-day milestone terms will show a naturally low turnover. Only compare turnover within the same industry.
• Ignoring the trend. A single period's turnover ratio in isolation says little. What matters is whether turnover is rising or falling quarter over quarter, and whether it's moving in the same direction as sales growth.
• Treating DSO as identical to stated payment terms. DSO of 36.5 days does not necessarily mean the average customer takes 36.5 days to pay; it is a blended average that can be skewed by a handful of large, slow-paying accounts.
• Forgetting the denominator is an average, not an ending balance. Using only the ending AR balance instead of the average overstates turnover in periods where receivables were rising and understates it where receivables were falling.

• Investopedia, "Receivables Turnover Ratio Defined: Formula, Importance, Examples, Limitations"
• Corporate Finance Institute (CFI), "Accounts Receivable Turnover Ratio"
• Investopedia, "Days Sales Outstanding (DSO) Defined and How It's Used"