The average collection period calculator estimates how many days your business takes to collect payment on credit sales. Enter your reporting period, average accounts receivable, and credit sales to assess how long cash remains tied up in unpaid customer invoices.
The result is useful for reviewing collection performance and planning liquidity, but it is not a direct average of individual invoice payment times.
How to use the average collection period calculator
- Period: Enter the number of days covered by your sales and receivables data. The default is 365 days. For a quarterly or monthly calculation, enter the actual number of days in that period.
- Avg. Accounts Receivables: Enter the average outstanding customer receivables balance during the same period, not the total amount you collected.
- Total Credit Sales: Enter sales made on credit during that period. Exclude cash sales because they do not create accounts receivable. Use credit sales net of returns and allowances where available, consistent with your receivables records.
The Avg. Collection Period result is expressed in days. Although the monetary fields display dollars, the calculation works with any currency as long as both monetary inputs use the same currency and scale.
How to calculate average accounts receivable
A common starting point is:
Average accounts receivable = (Beginning receivables + Ending receivables) ÷ 2
For example, beginning receivables of $12,000 and ending receivables of $18,000 give an average of $15,000. If balances fluctuate substantially, use a more representative average of monthly, weekly, or daily balances instead. Two snapshots can be misleading for a seasonal business.
Average collection period formula
The calculator uses:
Average collection period = (Average accounts receivable × Days in period) ÷ Credit sales during the period
Equivalently, divide average accounts receivable by average daily credit sales. The monetary units cancel, leaving a result in days.
Worked examples
| Input or result | Business A | Business B |
|---|---|---|
| Period | 365 days | 365 days |
| Average accounts receivable | $15,000 | $25,000 |
| Credit sales | $100,000 | $200,000 |
| Average collection period | 54.75 days | 45.63 days |
For Business A: $15,000 × 365 ÷ $100,000 = 54.75 days. Its average receivables balance represents about 55 days of credit sales.
For Business B: $25,000 × 365 ÷ $200,000 = 45.625 days, rounded to 45.63 days. Despite having a larger receivables balance, Business B has a shorter collection period relative to its sales.
What does your collection period mean?
A shorter period generally means faster cash recovery. A longer period means more money is tied up in receivables relative to daily credit sales. Neither result, by itself, proves that a business is financially healthy or struggling.
Interpret your result against:
- Your payment terms: A result near 55 days deserves investigation if most invoices are due within 30 days. It may be less concerning if customers have agreed to 60-day terms.
- Your own history: Compare consistent periods and methods. For seasonal businesses, comparisons with the same period in prior years may be more useful than consecutive months.
- Your customer and sales mix: A shift toward customers with longer contractual terms can raise the result without indicating worse collection practices.
- Your receivables aging report: Separate current balances from overdue invoices to identify which customers actually need attention.
There is no universally ideal collection period. Very restrictive credit terms may shorten collection time while discouraging otherwise profitable sales. This calculator does not supply industry benchmarks or determine which payment terms are best for your business.
Common mistakes and unusual results
- Mismatched periods: Do not combine annual credit sales with a 90-day period or an unrelated receivables average.
- Including cash sales: This increases the denominator and understates the time needed to collect receivables.
- Zero credit sales: The formula divides by zero, so there is no finite collection-period result. Negative credit sales also generally make the metric unsuitable for normal collection analysis.
- A result longer than the reporting period: This is mathematically possible when average receivables exceed credit sales for that period. Investigate old unpaid balances, declining sales, and data consistency rather than assuming a calculation error.
Write-offs can also lower receivables and shorten the calculated period without producing any cash. Review bad-debt activity alongside the result.
Turn the result into a collection plan
If the period is increasing, first check the data, then review overdue balances and disputed invoices. Useful actions include sending invoices promptly, confirming purchase-order details, offering convenient payment methods, and scheduling reminders around due dates.
You can also estimate how much less cash might be tied up in receivables:
Potential receivables reduction = Average daily credit sales × Reduction in collection days
For Business A, reducing the collection period by 10 days would imply approximately $100,000 ÷ 365 × 10 = $2,739.73 less in average receivables, assuming credit sales remain stable. That is potential working capital released, not additional revenue or profit.
For cash forecasting, combine this metric with invoice due dates, customer payment histories, and expected sales. An aggregate collection period cannot tell you when a particular customer will pay.
Related metrics for a fuller cash-flow picture
- Receivables turnover ratio measures how many times credit sales cover average receivables during a period. Using the same inputs, average collection period equals days in the period divided by receivables turnover.
- The cash conversion cycle calculator adds inventory holding time and supplier payment timing to show the wider working-capital cycle.
- The free cash flow calculator examines cash remaining after capital expenditures. Faster collections may support cash flow, but a collection-period result alone does not measure available cash.
Build a receivables savings calculator for your clients
Accounting firms and finance consultants can use Calcopolis to build a customized working-capital savings calculator that estimates the cash potentially released by faster collections, giving prospective clients a concrete starting point for a review.