Average Collection Period Calculator

The average collection period measures the time span between a credit sale and the receipt of cash. The primary formula used by this calculator is: Average Collection Period = (Accounts Receivable * Number of Days) / Total Net Credit Sales. Alternatively, you can first calculate the Accounts Receivable Turnover Ratio using Turnover Ratio = Total Net Credit Sales / Accounts Receivable, and then divide the number of days in the period by that ratio. For the most accurate assessment, your Accounts Receivable figure should represent the average of your beginning and ending balances over a specific timeframe, such as a year or quarter.

Imagine your company operates on a standard 365-day business year. Over this period, your total net credit sales amount to $1,200,000. Your average accounts receivable balance—derived by taking the sum of your starting and ending receivables and dividing by two—stands at $150,000. To find the average collection period, apply the formula: multiply your accounts receivable ($150,000) by the number of days (365), yielding 54,750,000. Next, divide that product by your total net credit sales ($1,200,000). The resulting calculation reveals an average collection period of 45.6 days. This means your customers take approximately 46 days to settle their invoices.

To get the most actionable insights from your collection metrics, always use average accounts receivable rather than a single ending balance, as seasonal fluctuations can skew your data. Regularly benchmark your results against your established credit terms; if your terms are 30 days but your collection period is 46 days, you may need to tighten credit policies or introduce early-payment incentives. Furthermore, track this metric month-over-month to spot delayed payments before they evolve into severe cash flow shortages.