Average Collection Period Calculator

How to Use This Tool

Follow these simple steps to calculate your average collection period:

1. Enter your total credit sales for the selected period (annual, quarterly, etc.) in the Total Credit Sales field.
2. Input your beginning and ending accounts receivable balances for the same period.
3. Select your reporting period type from the dropdown, or choose Custom to enter a specific number of days.
4. Click the Calculate Period button to view your results.
5. Use the Reset button to clear all inputs and start over, or Copy Results to save your output.

Formula and Logic

The average collection period is calculated using two core financial metrics:

• Average Accounts Receivable = (Beginning Accounts Receivable + Ending Accounts Receivable) ÷ 2
• Accounts Receivable (AR) Turnover Ratio = Total Credit Sales ÷ Average Accounts Receivable
• Average Collection Period = (Average Accounts Receivable ÷ Total Credit Sales) × Number of Days in Period

Alternatively, the average collection period can be calculated as Number of Days in Period ÷ AR Turnover Ratio, which produces the same result. This metric measures how many days on average it takes to collect outstanding customer payments.

Practical Notes

• Only include credit sales in your total, not cash sales, as cash sales are collected immediately and do not contribute to accounts receivable.
• Use consistent time periods for all inputs: if you use annual credit sales, your accounts receivable balances should be the beginning and ending balances for the same fiscal year.
• A shorter average collection period indicates more efficient payment collection, improving your business’s cash flow and liquidity.
• If your collection period is longer than your payment terms (e.g., net 30), review your invoicing process, late payment penalties, or customer credit checks.
• Seasonal businesses should use a 12-month period to avoid skewed results from peak or off-peak sales cycles.

Why This Tool Is Useful

Tracking your average collection period helps you:

• Identify cash flow bottlenecks caused by slow-paying customers.
• Evaluate the effectiveness of your credit and collections policies.
• Compare your collection efficiency to industry benchmarks.
• Make informed decisions about extending credit to new customers.
• Prepare accurate cash flow forecasts for budgeting and financial planning.

Frequently Asked Questions

What is a good average collection period?

A good average collection period is typically 25-30% shorter than your standard payment terms. For example, if your terms are net 30, a collection period of 21-22 days is excellent. Most healthy businesses aim for a period under 60 days, depending on their industry.

Should I include cash sales in total credit sales?

No, cash sales should not be included in total credit sales for this calculation. Cash sales are collected at the time of purchase and do not add to your accounts receivable balance, so they do not affect how long it takes to collect outstanding payments.

How do I calculate average accounts receivable if I don’t have beginning and ending balances?

If you only have a single accounts receivable balance, use that value as both the beginning and ending balance to calculate your average. For more accurate results, pull your beginning and ending AR balances from your balance sheet for the same period as your credit sales.

Additional Guidance

• Review your average collection period quarterly to spot trends early, rather than waiting for annual reports.
• Segment your collection period by customer type or invoice size to identify which groups are slowing down your collections.
• Pair this metric with your days payable outstanding (DPO) to calculate your cash conversion cycle, a key measure of overall business liquidity.
• If your collection period is rising over time, audit your invoicing process for errors, delays, or unclear payment terms.