Jaxworks: Bad Debt Analysis


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