added closing or reports and color coding