-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Duplicate
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Bug Type:UI
-
Bug Severity:Critical
-
Level:Partner
-
Module:BenAdmin
-
Reported by:White Label
-
Company:Jefferson County
-
Item State:Development - In Analysis
I was re-auditing Jefferson County’s life rates and found that the REPORTS are not calculating the EE cost correctly. When you go on the employee record itself the EE or ER Cost calculation are correct as the Basic Life, Basic AD&D, Vol Life, Vol AD&D and LTD rates are all on a 24 pay period pay schedule. However the reports are calculating incorrectly on a 26 pay period schedule.
FYI, all the actual rates are correct I have checked them all, just the per pay period amounts are off on the Standard REPORTS. Again, the employee records of ee cost in the site are right, the reports are wrong.
For example, Ashley Ainsworth's basic life life coverage of $40000 has a rate of $0.10. On the employee record this line of coverage has a rate of $2.00, which is correct. However, on the Enrollment Reports in Standard Reports the rate is $1.85, which is incorrect.
*RIGHT-->Employee Record is calculating like this....
40000 coverage/1000 rate divisor*rate of 0.10*12/24 pay periods = $2.00
WRONG-->Enrollment Report is calculating like this.....
40000 coverage/1000 rate divisor*rate of 0.10*12/26 pay periods = $1.85*
I have screenshotted some examples below for your reference.
- duplicates
-
WD-80 Calculate cost based on the plan payroll schedule
-
- Closed
-