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
          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