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

Five Guys - payroll deduction file - employee cost not considering defined contribution amounts

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Reported by:
      Client
    • Module:
      Exchange

      Description

      Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered.

      The EE deduction should be the total premium that is in the system with the Defined Contribution for that plan / tier subtracted out.

        Attachments

        1. ~WRD000.jpg
          ~WRD000.jpg
          0.8 kB
        2. Copy without phi.xls
          596 kB
        3. Deduction Amounts.jpg
          Deduction Amounts.jpg
          157 kB
        4. example for dev.xlsx
          10 kB
        5. fiveguys_ADP_payroll_Deduction File Test 20161221.csv
          112 kB
        6. image009.png
          image009.png
          0.6 kB
        7. Plan Selection.JPG
          Plan Selection.JPG
          122 kB
        8. screenshot-1.png
          screenshot-1.png
          26 kB
        9. screenshot-2.png
          screenshot-2.png
          101 kB
        10. screenshot-3.png
          screenshot-3.png
          20 kB

          Issue Links

            Activity

            Rochelle.Thomas Rochelle Thomas created issue -
            Rochelle.Thomas Rochelle Thomas made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: Exchange(10103)
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Sonali Punse [ sonali.punse ]
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Sonali Punse [ sonali.punse ] Avnish Yadav [ avnish.yadav ]
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Sonali Punse [ sonali.punse ]
            Status Open [ 1 ] In Progress [ 3 ]
            jennifer.leugers Jennifer Leugers made changes -
            Attachment screenshot-1.png [ 35341 ]
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Sonali Punse [ sonali.punse ] Shyam Sharma [ shyam sharma ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Assignee Shyam Sharma [ shyam sharma ] Vijay Siddha [ vijays ]
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Avnish Yadav [ avnish.yadav ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment Plan Selection.JPG [ 36455 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Rochelle Thomas [ rochelle.thomas ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description
            The deductions are mapped using Employee cost, the deductions are not correct because the credits are not being considered.

            example: Taylor Johnson with medical plan HDHP w/ HSA 2500
            the employee cost is $229.49 and has allocated credits of $412.50

            The deductions are mapped using Employee cost, the deductions are not correct because the credits are not being considered.

            example: Taylor Johnson with medical plan HDHP w/ HSA 2500
            the employee cost is $229.49 and has allocated credits of $412.50

            Remaining Estimate 0h [ 0 ]
            Original Estimate 4h [ 14400 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 4h [ 14400 ]
            Worklog Id 16878 [ 16878 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Original Estimate 4h [ 14400 ] 7h [ 25200 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 4h [ 14400 ] 7h [ 25200 ]
            Worklog Id 16948 [ 16948 ]
            Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
            Summary Five Guys - payroll deduction file - employee cost not considering credits Five Guys - payroll deduction file - employee cost not considering defined contribution amounts
            Rochelle.Thomas Rochelle Thomas made changes -
            Description The deductions are mapped using Employee cost, the deductions are not correct because the credits are not being considered.

            example: Taylor Johnson with medical plan HDHP w/ HSA 2500
            the employee cost is $229.49 and has allocated credits of $412.50

            Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered.


            A field available for use in the export template
            example: Taylor Johnson with medical plan HDHP w/ HSA 2500
            the employee cost is $229.49 and has defined contributions of $412.50

            Rochelle.Thomas Rochelle Thomas made changes -
            Description Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered.


            A field available for use in the export template
            example: Taylor Johnson with medical plan HDHP w/ HSA 2500
            the employee cost is $229.49 and has defined contributions of $412.50

            Payroll deductions for Five Guys on production Exchange are mapped using Employee cost, the deductions are not correct because defined contributions are not being considered.

             The EE deduction should be the total premium that is in the system with the Defined Contribution for that plan / tier subtracted out.



            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Rochelle Thomas [ rochelle.thomas ] Vijay Siddha [ vijays ]
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Avnish Yadav [ avnish.yadav ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment Deduction Amounts.jpg [ 36600 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Assignee Aniruddha Dev [ aniruddha.dev ] Rochelle Thomas [ rochelle.thomas ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 7h [ 25200 ] 10h [ 36000 ]
            Worklog Id 17116 [ 17116 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 10h [ 36000 ] 11h [ 39600 ]
            Worklog Id 17210 [ 17210 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment ~WRD000.jpg [ 36613 ]
            Attachment image001.jpg [ 36614 ]
            Attachment image002.jpg [ 36615 ]
            Attachment image003.png [ 36616 ]
            Attachment image004.png [ 36617 ]
            Attachment image005.jpg [ 36618 ]
            Attachment image006.jpg [ 36619 ]
            Attachment image007.jpg [ 36620 ]
            Attachment image009.png [ 36621 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment Copy without phi.xls [ 36623 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment screenshot-2.png [ 36628 ]
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Rochelle Thomas [ rochelle.thomas ] Samir [ samir ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image005.jpg [ 36618 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image004.png [ 36617 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image007.jpg [ 36620 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image006.jpg [ 36619 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image001.jpg [ 36614 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment example for dev.xlsx [ 36639 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Attachment screenshot-3.png [ 36641 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image002.jpg [ 36615 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Attachment image003.png [ 36616 ]
            samir Samir made changes -
            Assignee Samir [ samir ] Avnish Yadav [ avnish.yadav ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Rochelle Thomas [ rochelle.thomas ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 11h [ 39600 ] 13h [ 46800 ]
            Worklog Id 17541 [ 17541 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Worklog Id 17541 [ 17541 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 13h [ 46800 ] 19h [ 68400 ]
            Worklog Id 17544 [ 17544 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 19h [ 68400 ] 20h [ 72000 ]
            Worklog Id 17597 [ 17597 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Time Spent 20h [ 72000 ] 21.5h [ 77400 ]
            Worklog Id 17599 [ 17599 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Link This issue causes WT-7586 [ WT-7586 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 21.5h [ 77400 ] 24.5h [ 88200 ]
            Worklog Id 17969 [ 17969 ]
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Rochelle Thomas [ rochelle.thomas ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Avnish Yadav [ avnish.yadav ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Rochelle Thomas [ rochelle.thomas ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 24.5h [ 88200 ] 26.5h [ 95400 ]
            Worklog Id 21837 [ 21837 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 26.5h [ 95400 ] 31.5h [ 113400 ]
            Worklog Id 21903 [ 21903 ]
            Rochelle.Thomas Rochelle Thomas made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Component/s ACA [ 10004 ]
            Component/s Exchange [ 10003 ]

              People

              Assignee:
              Rochelle.Thomas Rochelle Thomas
              Reporter:
              Rochelle.Thomas Rochelle Thomas
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 7h Original Estimate - 7h
                  7h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 31.5h
                  31.5h