Average Collection Period Calculator
Calculate the average collection period (average debtors collection period) from accounts receivable and net credit sales. Get the exact number of days and receivables turnover instantly.
Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in PeriodAdjust Variables
Interactive Step-by-Step Calculation Proofs
View how variables resolve algebraically down to peer-reviewed standard outputs.
Dynamic E-E-A-T Metric Valuation
The average collection period — also called the average debtors collection period in UK and international accounting — measures how many days, on average, a business takes to collect cash from its customers after a credit sale. It's calculated as: Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in Period, where average accounts receivable is typically the mean of the beginning and ending receivable balances for the period. A shorter average collection period means faster cash conversion and generally healthier working capital; a lengthening period can signal looser credit policies or emerging collections problems. This calculator supports both the standard average accounts receivable approach and a simpler ending accounts receivable snapshot for a quick estimate. Note that 'average collection period' and 'A/R days' (also called days sales outstanding, or DSO) are the same underlying metric — different industries and textbooks simply use different names for it.
Mathematical Formula Explanation
Calculated standard benchmarks are based on direct functional dependencies. The primary calculation logic follows this formula:
Average Collection Period = (Average Accounts Receivable ÷ Net Credit Sales) × Days in PeriodWhen using our reverse-solving system, the unknown parameter is algebraically isolated. For instance, solving for total impressions required derived from an active budget uses the inverted ratio, safeguarding metrics calculations against arbitrary platform fees or roundoffs.
Standard Campaign Scenarios (Step-by-Step)
Review these typical campaign outlines to verify how calculation steps behave under realistic media buying conditions:
Example 1: Average Collection Period From Average Balance
“A company started the year with $140,000 in accounts receivable and ended with $160,000, on $1,825,000 in net credit sales over 365 days. What is the average collection period?”
- BEGINNINGAR: 140,000
- ENDINGAR: 160,000
- NETCREDITSALESAVG: 1,825,000
- DAYSINPERIODAVG: 365
- AVERAGEAR: 150,000
- COLLECTIONPERIODAVG: 30
- TURNOVERAVG: 12.17
Example 2: Average Collection Period From Ending Balance
“A company has $150,000 in accounts receivable at year-end and generated $1,825,000 in net credit sales over the year. What is the average collection period?”
- ACCOUNTSRECEIVABLE: 150,000
- NETCREDITSALES: 1,825,000
- DAYSINPERIOD: 365
- COLLECTIONPERIOD: 30
- DAILYSALESEND: 5,000
- TURNOVEREND: 12.17