Days sales outstanding · Calculation guide

Estimate the average collection period on credit sales.

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.

dso = (opening+closing)*days/(2*sales); average = (opening+closing)/2

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

InputValue
Opening trade receivables20,000
Closing trade receivables30,000
Net credit sales in period250,000
Days in measurement period365
ResultValue
Collection period36.5 days
Average receivables25,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening trade receivables20,00022,000Collection period36.5 days37.96 days
Closing trade receivables30,00033,000Collection period36.5 days38.69 days
Net credit sales in period250,000275,000Collection period36.5 days33.181818 days
Days in measurement period365402Collection period36.5 days40.2 days
Days sales outstanding →

Sources