Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-7856

Five Guys: defined contribution as negative and rounding issue

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Five Guys
    • Module:
      BenAdmin

      Description

      *Some employees show defined contribution as negative. This is appearing in the payroll file to client and client is asking us to fix immediately. One example is attached for Fallon Palladino who has a medical deduction of -56.59 on the payroll file.

      We also have an issue with the where the client is manually changing the payroll deductions to round correctly. Currently $ amounts are truncated instead of rounded. We need some new macro for rounding the deduction correctly for Five Guys.
      *

        Attachments

          Activity

          Hide
          darryn.carter darryn.carter added a comment -

          Hello Rochelle Thomas
          Can you please assist with the above? Can you provide the path for the payroll file? Also is there a way to not include negatives?

          Hello Lorena.Nava@ebsbenefits.com
          For your 1st issue we are unable to see the same deduction/screen shot you have attached. For your 2nd issue can you please provide an example of the EE and what your expecting to see for the rounding.

          Show
          darryn.carter darryn.carter added a comment - Hello Rochelle Thomas Can you please assist with the above? Can you provide the path for the payroll file? Also is there a way to not include negatives? Hello Lorena.Nava@ebsbenefits.com For your 1st issue we are unable to see the same deduction/screen shot you have attached. For your 2nd issue can you please provide an example of the EE and what your expecting to see for the rounding.
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment - - edited
          • standard rounding up and down for a $ amount
          • negative amounts should be changed to 0
            Fallon Paladino's record has been corrected.
            There are other negatives for deduction amounts that we could not correct.
          Show
          Rochelle.Thomas Rochelle Thomas added a comment - - edited standard rounding up and down for a $ amount negative amounts should be changed to 0 Fallon Paladino's record has been corrected. There are other negatives for deduction amounts that we could not correct.
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Hi Darryn: Unfortunately I did not request specific names I only know they were off by a penny. Rochelle, do you have any names you can share with Darryn? Thanks.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Hi Darryn: Unfortunately I did not request specific names I only know they were off by a penny. Rochelle, do you have any names you can share with Darryn? Thanks.
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          file path? The production files can be downloaded from workterra, exchange, view exported files, multi-company export, Five Guys ADP Payroll bi-weekly

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - file path? The production files can be downloaded from workterra, exchange, view exported files, multi-company export, Five Guys ADP Payroll bi-weekly
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          Hi Darryn,
          I do not have an example of negative defined contributions at this time. They should show up in an enrollment report from workterra.

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - Hi Darryn, I do not have an example of negative defined contributions at this time. They should show up in an enrollment report from workterra.
          Hide
          darryn.carter darryn.carter added a comment -

          We are unable to reproduce the issue and this would need to go to Dev.
          Would you like me to submit?

          Show
          darryn.carter darryn.carter added a comment - We are unable to reproduce the issue and this would need to go to Dev. Would you like me to submit?
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Yes. This issue needs resolution asap. Please escalate asap for me. Thank you!

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Yes. This issue needs resolution asap. Please escalate asap for me. Thank you!
          Hide
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment -

          Hello Dev,

          We were unable to reproduce the negative values that were received for the EEs cost. Can you please review this?

          Thank you

          Show
          Traci.Simpson@ebsbenefits.com Traci Simpson (Inactive) added a comment - Hello Dev, We were unable to reproduce the negative values that were received for the EEs cost. Can you please review this? Thank you
          Hide
          samir Samir added a comment -
          Show
          samir Samir added a comment - Jyoti Mayne
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Traci Simpson,

          We are able to reproduce this issue at our end please refer below steps to Reproduce this issue:-

          Step 1. Login as employee and reach to recommended plans screen. Do not checkout.
          Step 2. In Partner login, While managing this employee, open Enrollment Summery and check value of 'Total Employee Weekly Deduction'. Its -ve value.

          This issue is only for those employee whose "Total Benefit Employee Cost" is less then Defined Contribution Allotted. We will fixed this issue ASAP.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne, Satya,Samir

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Traci Simpson , We are able to reproduce this issue at our end please refer below steps to Reproduce this issue:- Step 1. Login as employee and reach to recommended plans screen. Do not checkout. Step 2. In Partner login, While managing this employee, open Enrollment Summery and check value of 'Total Employee Weekly Deduction'. Its -ve value. This issue is only for those employee whose "Total Benefit Employee Cost" is less then Defined Contribution Allotted. We will fixed this issue ASAP. Thanks, Avnish Y CC- Jyoti Mayne , Satya , Samir
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Please provide an ETA on when this will be corrected. Client wants this fixed today. Thanks.

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Please provide an ETA on when this will be corrected. Client wants this fixed today. Thanks.
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Displaying proper value after changing tier .

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Displaying proper value after changing tier .
          Hide
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment -

          Do we have an update for client?

          Show
          lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive) added a comment - Do we have an update for client?
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Lorena.Nava@ebsbenefits.com This is deployed on production, please check and confirm.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Lorena.Nava@ebsbenefits.com This is deployed on production, please check and confirm.
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment - - edited

          Hi Rakesh Roy,
          I ran the Exchange production payroll export and there is a negative amount for
          Jason Tibby Medical -109.59

          -109.59 Bi-Weekly PPO 500 Employee Only FGO General Manager

          SamirSatyaJennifer Leugers

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - - edited Hi Rakesh Roy , I ran the Exchange production payroll export and there is a negative amount for Jason Tibby Medical -109.59 -109.59 Bi-Weekly PPO 500 Employee Only FGO General Manager Samir Satya Jennifer Leugers
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          Here are a few examples of the rounding issue, client is manually changing to the correct rounding:

          WT Deduction Amount Pay Schedule Plan Desc Tier rounding
          $9.97 Bi-Weekly Dental High Plan Employee Only should be: $9.98
          $3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28
          $6.88 Bi-Weekly Dental Low Plan Employee+Child(ren) should be $6.89
          $209.49 Bi-Weekly PPO 250 Employee+Child(ren) should be $209.48

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - Here are a few examples of the rounding issue, client is manually changing to the correct rounding: WT Deduction Amount Pay Schedule Plan Desc Tier rounding $9.97 Bi-Weekly Dental High Plan Employee Only should be: $9.98 $3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28 $6.88 Bi-Weekly Dental Low Plan Employee+Child(ren) should be $6.89 $209.49 Bi-Weekly PPO 250 Employee+Child(ren) should be $209.48
          Hide
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited

          Hi Rochelle Thomas,

          Please refer below 3'c :-

          Concern :- Negative amount for Jason Tibby Medical -109.59.
          Cause :- We fixed this issue in our code but not recalculated Employer Defined Contribution so this is issue for existing employee.
          Correction :- Now we have recalculated Employer Defined Contribution . It is showing proper cost on UI.

          Regarding rounding issue: Vinayak Kulkarni, could you please provide update on this because this is on file.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited Hi Rochelle Thomas , Please refer below 3'c :- Concern :- Negative amount for Jason Tibby Medical -109.59. Cause :- We fixed this issue in our code but not recalculated Employer Defined Contribution so this is issue for existing employee. Correction :- Now we have recalculated Employer Defined Contribution . It is showing proper cost on UI. Regarding rounding issue : Vinayak Kulkarni , could you please provide update on this because this is on file. Thanks, Avnish Y CC- Jyoti Mayne , Satya
          Hide
          rohan.khandave Rohan J Khandave (Inactive) added a comment -

          Hello Lorena.Nava@ebsbenefits.com & Rochelle Thomas,

          We checked "EmployeeCostMinusCredits" field. As per implementation below is formula
          EmployeeCostMinusCredits = Employee Cost - CreditAmount.

          Both Employee Cost & Credit Amount are rounded up to two decimal points then subtracts . Due to that there difference of 0.01.

          Ex. $3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28
          Monthly Cost : 26.18
          Bi-Weekly Cost: (26.18 * 12)/26 = 12.083 , 12.08 with two decimal point
          Credit Amount : 19.08
          Bi-Weekly Credit Cost : (19.08*12)/26) = 8.806 , 8.81 with two decimal point

          EmployeeCostMinusCredits : 12.083 - 8.806 = 3.277 with two decimal rounding 3.28
          EmployeeCostMinusCredits : 12.08 - 8.81 = 3.27 with two decimal rounding 3.27

          Thanks,
          Rohan J Khandave

          CC – Vinayak Kulkarni , Ganesh Sadawarte

          Show
          rohan.khandave Rohan J Khandave (Inactive) added a comment - Hello Lorena.Nava@ebsbenefits.com & Rochelle Thomas , We checked " EmployeeCostMinusCredits " field. As per implementation below is formula EmployeeCostMinusCredits = Employee Cost - CreditAmount. Both Employee Cost & Credit Amount are rounded up to two decimal points then subtracts . Due to that there difference of 0.01. Ex. $3.27 Bi-Weekly Dental Low Plan Employee Only should be $3.28 Monthly Cost : 26.18 Bi-Weekly Cost: (26.18 * 12)/26 = 12.083 , 12.08 with two decimal point Credit Amount : 19.08 Bi-Weekly Credit Cost : (19.08*12)/26) = 8.806 , 8.81 with two decimal point EmployeeCostMinusCredits : 12.083 - 8.806 = 3.277 with two decimal rounding 3.28 EmployeeCostMinusCredits : 12.08 - 8.81 = 3.27 with two decimal rounding 3.27 Thanks, Rohan J Khandave CC – Vinayak Kulkarni , Ganesh Sadawarte

            People

            Assignee:
            lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive)
            Reporter:
            lorena.nava@ebsbenefits.com Lorena.Nava@ebsbenefits.com (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 6h Original Estimate - 6h
                6h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11h
                11h