Other Key Accounts Receivable Metrics
The accounts receivable balance is the first and most critical step—the total amount owed to the business. But two additional metrics, turnover ratio and DSO, add critical context on collection velocity and timing. Let's walk through how to calculate each.
Accounts Receivable Turnover Ratio
The AR turnover ratio measures how many times a company collects its average receivables over a given period. A higher turnover ratio indicates faster collections and more efficient credit management. The formula is as follows:
AR Turnover Ratio = Net Credit Sales ÷ Average Accounts Receivable
To calculate, use net credit sales (total sales on credit minus returns and allowances) for the period, then divide by the average of beginning and ending receivables balances. Data sources include the sales ledger for credit sales and the general ledger for receivables balances.
Interpretation hinges on context. Compare your ratio to past performance and peer benchmarks to determine if payment collections are improving or slipping. A declining ratio may signal lenient credit terms or ineffective collection processes, while an increasing ratio suggests tighter credit policies or more proactive dunning activities.
Example: A manufacturing firm records $800,000 in net credit sales for Q2 and starts the period with $200,000 in receivables and ends with $260,000. Its average receivables balance is ($200,000 + $260,000) ÷ 2 = $230,000.
Dividing $800,000 by $230,000 yields an AR turnover ratio of approximately 3.48, indicating the firm collects payments about 3½ times during the quarter.
Days Sales Outstanding
Days sales outstanding (DSO) translates the turnover ratio into the average number of days it takes customers to pay. It offers a more intuitive view of payment speed. The formula is:
Days Sales Outstanding = 365 ÷ AR Turnover Ratio
Or equivalently:
DSO = (Average Accounts Receivable ÷ Net Credit Sales) × 365.
Use the same data sources as the turnover ratio calculation. Assess your DSO against internal targets and industry norms—lower DSO values denote quicker payments, while higher values indicate slower cash conversion.
Seasonal sales fluctuations and credit policy changes should be considered when setting benchmarks.
Example: Suppose a company records $240,000 in net credit sales for the month and maintains an average accounts receivable balance of $60,000. Plugging into the formula: DSO = (60,000 ÷ 240,000) × 365 ≈ 91 days, indicating customers take roughly three months on average to pay.