Average Collection Period Calculator
Results are estimates based on the values you enter. Recheck your inputs and assumptions before using the output for decisions.
Calculate the average collection period from beginning receivables, ending receivables, net credit sales, and days in the period.
Average Collection Period Calculator
Free online average collection period calculator to measure how many days a business takes, on average, to collect cash from customers after making credit sales. This calculator is useful for finance teams, business owners, accountants, analysts, and students who want to understand receivables efficiency and cash collection speed. A shorter collection period usually means the business is turning receivables into cash more quickly, while a longer period may point to slower payments or weaker collection practices.
The calculator works with beginning accounts receivable, ending accounts receivable, net credit sales, and the number of days in the period. It first calculates average accounts receivable, then finds receivables turnover, and finally converts that into the average collection period in days. This makes it easier to see how efficiently the company manages customer credit. The result can be used for internal performance reviews, financial statement analysis, working capital planning, and lender or investor discussions.
The formula of average collection period
Average accounts receivable = (Beginning accounts receivable + Ending accounts receivable) / 2
Receivables turnover = Net credit sales / Average accounts receivable
Average collection period = (Average accounts receivable / Net credit sales) x Days in period
Average collection period = Days in period / Receivables turnover
Here beginning accounts receivable means the receivables balance at the start of the period, ending accounts receivable means the balance at the end of the period, net credit sales means sales made on credit after adjustments, and days in period means the number of days for the period being reviewed, such as 30, 90, or 365.
Solved Example
Example 1: Find the average collection period if beginning receivables are $90,000, ending receivables are $110,000, net credit sales are $1,200,000, and the period has 365 days.
Solve: Average accounts receivable = (90000 + 110000) / 2 = $100,000
Receivables turnover = 1200000 / 100000 = 12.00 times
Average collection period = (100000 / 1200000) x 365 = 30.42 days
Example 2: Find the result if beginning receivables are $50,000, ending receivables are $70,000, net credit sales are $600,000, and the period has 365 days.
Solve: Average accounts receivable = (50000 + 70000) / 2 = $60,000
Receivables turnover = 600000 / 60000 = 10.00 times
Average collection period = (60000 / 600000) x 365 = 36.50 days
Example 3: Find the result if beginning receivables are $140,000, ending receivables are $160,000, net credit sales are $1,800,000, and the period has 365 days.
Solve: Average accounts receivable = (140000 + 160000) / 2 = $150,000
Receivables turnover = 1800000 / 150000 = 12.00 times
Average collection period = (150000 / 1800000) x 365 = 30.42 days
Table of average collection period calculator
| Beginning AR | Ending AR | Net Credit Sales | Average AR | Receivables Turnover | Collection Period |
|---|---|---|---|---|---|
| $50,000 | $70,000 | $600,000 | $60,000 | 10.00 | 36.50 days |
| $90,000 | $110,000 | $1,200,000 | $100,000 | 12.00 | 30.42 days |
| $140,000 | $160,000 | $1,800,000 | $150,000 | 12.00 | 30.42 days |
| $200,000 | $260,000 | $2,000,000 | $230,000 | 8.70 | 41.98 days |
How to use this average collection period calculator
Enter the beginning accounts receivable amount in the proper input field and then enter the ending accounts receivable amount. After that, enter net credit sales for the same period. Next, enter the number of days in the period, such as 30 for a month, 90 for a quarter, or 365 for a year. Finally, click the calculate button. The calculator will show average accounts receivable, receivables turnover, and average collection period in days.
This calculator is useful for checking whether customers are paying within expected terms and whether collections are getting stronger or weaker over time. If the average collection period is rising, the business may be collecting more slowly, which can create cash flow pressure. If the period is falling, it may indicate stronger collections, tighter credit control, or better customer payment behavior. Comparing this number across periods can help track operational discipline and credit risk.
When using the result, remember that industry norms matter. A 30-day collection period may be strong in one industry and average in another. It is also helpful to compare the result with the company’s stated credit terms. This calculator gives a quick numerical view, but it should be used along with aging reports, bad debt analysis, and customer concentration reviews for a fuller picture of receivables quality and working capital performance.