Payment Statistic Calculations FAQ

Question: How are the various payment statistics calculated?

Answer: The following tables display sample calculations.

Average Days to Pay (ADTP)

Invoice Number

Invoice Amount

Paid Amount

Invoice Date

Due Date

Paid Date

Paid Date Minus Invoice Date

1

$100

$100

10/06/2020

11/06/2020

11/30/2020

55

2

$500

$50

10/06/2020

11/06/2020

Not fully paid

 

3

$200

$200

10/06/2020

11/06/2020

12/01/2020

56

4

$50

$50

10/06/2020

11/06/2020

12/04/2020

59

5

$1,000

$1,000

10/06/2020

11/06/2020

01/01/2021

87

Totals

$1,850

$1,350

 

 

 

257

 

 

 

Divide by number of fully paid invoices

4

 

 

 

 

 

ADTP

64

Weighted Average Days to Pay (WADTP)

Invoice Number

Invoice Amount

Paid Amount

Invoice Date

Due Date

Paid Date

Paid Date minus Invoice Date

Paid Amt times Days to Pay

1

$100

$100

10/06/2020

11/06/2020

11/30/2020

55

5,500

2

$500

$50

10/06/2020

11/06/2020

Not fully paid

 

 

3

$200

$200

10/06/2020

11/06/2020

12/01/2020

56

11,200

4

$50

$50

10/06/2020

11/06/2020

12/04/2020

59

2,950

5

$1,000

$1,000

10/06/2020

11/06/2020

01/01/2021

87

87,000

Totals

$1,850

$1,350

 

 

 

257

106,650

 

 

 

 

Divided by total paid amount

1,350

 

 

 

 

 

 

WADTP

79

Average Days Past Due (ADPD)

Invoice Number

Invoice Amount

Paid Amount

Invoice Date

Due Date

Paid Date

Paid Date minus Due Date

1

$100

$100

10/06/2020

11/06/2020

11/30/2020

24

2

$500

$50

10/06/2020

11/06/2020

Not fully paid

 

3

$200

$200

10/06/2020

11/06/2020

12/01/2020

25

4

$50

$50

10/06/2020

11/06/2020

12/04/2020

28

5

$1,000

$1,000

10/06/2020

11/06/2020

01/01/2021

56

Totals

$1,850

$1,350

 

 

 

133

 

 

 

Divide by number of fully paid invoices

4

 

 

 

 

 

ADPD

33

Weighted Average Days Past Due (WADPD)

Invoice Number

Invoice Amount

Paid Amount

Invoice Date

Due Date

Paid Date

Paid Date minus Due Date

Paid Amt times Days Past Due

1

$100

$100

10/06/2020

11/06/2020

11/30/2020

24

2,400

2

$500

$50

10/06/2020

11/06/2020

Not fully paid

 

 

3

$200

$200

10/06/2020

11/06/2020

12/01/2020

25

5,000

4

$50

$50

10/06/2020

11/06/2020

12/04/2020

28

1,400

5

$1,000

$1,000

10/06/2020

11/06/2020

01/01/2021

56

56,000

Totals

$1,850

$1,350

 

 

 

133

64,800

 

 

 

 

Divided by total paid amount

1,350

 

 

 

 

 

 

WADPD

48

Days Sales Outstanding (DSO)

Invoice Number

Invoice Amount

Paid Amount

Invoice Date

Due Date

Paid Date

Open Amt

1

$100

$100

10/06/2020

11/06/2020

11/30/2020

0

2

$500

$50

10/06/2020

11/06/2020

Not fully paid

450

3

$200

$200

10/06/2020

11/06/2020

12/01/2020

0

4

$50

$50

10/06/2020

11/06/2020

12/04/2020

0

5

$1,000

$1,000

10/06/2020

11/06/2020

01/01/2021

0

Totals

$1,850

$1,350

 

 

 

450

 

90

Days

Divide by average daily sales

$20.56

 

$20.56

Average Daily Sales

DSO

22