Calculation guide
Average opening and closing trade receivables. Use net credit sales for the same number of days; exclude cash sales and keep tax treatment consistent.
Inputs
Opening trade receivables
Example entry 20000 (in the selected currency).
Closing trade receivables
Example entry 30000 (in the selected currency).
Net credit sales in period
Example entry 250000 (in the selected currency).
Days in measurement period
Example entry 365. Minimum 1.0. Use whole numbers.
Worked example
| Input | Value |
|---|---|
| Opening trade receivables | 20,000 |
| Closing trade receivables | 30,000 |
| Net credit sales in period | 250,000 |
| Days in measurement period | 365 |
| Result | Value |
|---|---|
| Collection period | 36.5 days |
| Average receivables | 25,000 |
Calculation steps
Collection period = (((Opening trade receivables + Closing trade receivables) × Days in measurement period) ÷ (2 × Net credit sales in period))
(((20,000 + 30,000) × 365) ÷ (2 × 250,000)) = 36.5 days
Average receivables = ((Opening trade receivables + Closing trade receivables) ÷ 2)
((20,000 + 30,000) ÷ 2) = 25,000
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening trade receivables | 20,000 | 22,000 | Collection period | 36.5 days | 37.96 days |
| Closing trade receivables | 30,000 | 33,000 | Collection period | 36.5 days | 38.69 days |
| Net credit sales in period | 250,000 | 275,000 | Collection period | 36.5 days | 33.181818 days |
| Days in measurement period | 365 | 402 | Collection period | 36.5 days | 40.2 days |
