Back To Table of Contents

Download This Workbook FREE

                     
  Bad Debt Analysis  
   
 

Days past due:

Current

1 - 30

31 - 60

61 - 90

90 +

Total

 
 

Amount

$24,655

$5,671

$1,950

$1,063

$532

$33,871

 
 

Percent

73%

17%

6%

3%

2%

100%

 
   
 

Days

Historical

Amounts

Doubtful

1. This is a 3 step workbook.
2. You enter the data and it does the rest.
3. Track how others are using your money at no interest.
 
 

past due

Percentages

collections

 
   
 

Current

0.5%

$24,655

123.28

 
 

1 - 30

2.0%

$5,671

113.42

 
 

31 - 60

7.0%

$1,950

136.50

 
 

61 - 90

15.0%

$1,063

159.45

 
 

90 +

46.0%

$532

244.72

 
   
  Total:

777.37

 
   
                     

Back To Table of Contents

  Copyright, 2014, JaxWorks, All Rights Reserved.