How to calculate your accounts receivable turnover ratio
Calculating your accounts receivable turnover ratio is simple. You can find all the information you need on your financial statements, including your income statement or balance sheet.
First, you’ll need to find your net credit sales or all the sales customers made on credit. Invoices indicate a credit sale to a customer. You collect the money from credit sales at a later date.
Step 1: Determine your net credit sales
First, you’ll need to find your net credit sales or all the sales customers made on credit. Invoices indicate a credit sale to a customer. You collect the money from credit sales at a later date.
- Start by identifying all sales made on credit during the accounting period. These are typically represented by invoices issued to customers.
- Subtract any sales returns or allowances from the total credit sales. This gives you your net credit sales.
- You can usually find this information on your income statement or balance sheet.
The formula for net credit sales follows:
Sales on credit – sales returns – sales allowances = net credit sales
Step 2: Calculate your average accounts receivable
Average accounts receivable is the sum of starting and ending accounts receivable over an accounting period, divided by two. You can find total accounts receivable on your balance sheet. The formula for average accounts receivable follows:
(Starting accounts receivable + ending accounts receivable) ÷ 2 = average accounts receivable
Step 3: Calculate the accounts receivable turnover ratio
Then divide your net credit sales (from Step 1) by your average accounts receivable (from Step 2) to find your accounts receivable turnover ratio. The accounts receivable turnover ratio formula is as follows:
Net credit sales ÷ average accounts receivable = accounts receivable turnover ratio
What is the normal range for accounts receivable turnover?
Broadly speaking, the normal accounts receivable turnover range generally falls between 4 and 12. But what’s considered a "good" ratio varies by industry, as some industries have ratios that typically fall outside of this range.
It's important to compare your ratio to industry benchmarks and consider your business model and credit policies. A higher ratio generally suggests you're collecting payments quickly, while a lower ratio might indicate potential collection process issues.
What is a bad accounts receivable turnover?
A "bad" accounts receivable turnover ratio is one that is significantly lower than the average for your industry or your historical performance.
A low turnover ratio suggests that your business is taking longer to collect payments from customers. This can lead to cash flow problems and impact your overall financial health. It's important to investigate the reasons for a low ratio and take steps to improve your collection efficiency.