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

Valmet Billing Details Report and LTD Rate issue

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Configuration
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      Valmet Benefits
    • Module:
      BenAdmin

      Description

      Please see the email from BSG below. The Billing details report that is being run is below

      Not all of the LTD plans are coming out on the report. The LTD rate also is coming out wrong. In the employee example below it appears that the employees salary was updated on 8/17 to a lesser amount but it does not show on the payroll screen. I also cannot figure out what salary it is using.

      BSG Email

      I am in the process of doing my September, 2016 bill for Valmet today. The Billing Details Report that generates for me every month was fine, with the exception of the LTD coverage. The report (attached) shows that there are 134 employees with LTD. The correct amount per month is around 1076 employees. We ran a separate enrollment report for LTD for September, 2016 and it came up with 1076 employees, however, the employer cost is not correct. For some individuals (ie. Gregory Ellis (see attached) and Gregory Bridges) the employer cost is shown as double of what it should be.

      See attached - Gregory Ellis -
      Salary is $49,379.20 / 12 = $4114.93 x .496 = $2,041.01/100 = $20.41 - This is the correct amount and was on the Billing Details Report for August, 2016

      Shown on the confirmation statement (generated today) is the employer cost of $18.84. If I take $18.84 x 26 = $489.84 / 12 = $40.82
      $40.82 is the incorrect amount that is showing on the Enrollment Report that was generated today.

      In summary:

      1. Billing Details Report is not pulling all of the employees that have LTD coverage;
      2. Confirmation statement is not showing the correct employer cost for LTD

        Attachments

          Issue Links

            Activity

            dkulling Debbie Kulling created issue -
            amitg Amit Gude (Inactive) made changes -
            Field Original Value New Value
            Assignee Amit Gude [ amitg ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Deepali Tidke [ deepalit ]
            deepalit Deepali Tidke (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            deepalit Deepali Tidke (Inactive) made changes -
            Assignee Deepali Tidke [ deepalit ] Amit Gude [ amitg ]
            amitg Amit Gude (Inactive) made changes -
            Assignee Amit Gude [ amitg ] Amnesh Goel [ amnesh.goel ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Assignee Amnesh Goel [ amnesh.goel ] Amruta Lohiya [ amruta.baheti ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Avnish Yadav [ avnish.yadav ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Attachment Billing Details Sep 2016.xls [ 26513 ]
            Attachment BillingSummaryReport.xls [ 26514 ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Attachment Billing Details Sep 2016.xls [ 26513 ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Attachment BillingSummaryReport.xls [ 26514 ]
            amnesh.goel Amnesh Goel (Inactive) made changes -
            Attachment Billing Summary Report LTD Sep 2016.xls [ 26519 ]
            Attachment Billing Details LTD Sep 2016.xls [ 26520 ]
            Attachment Enrollment LTD Sep 2016.xls [ 26521 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Attachment List of Employee_Valmet.xls [ 26530 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Debbie Kulling [ dkulling ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-4762 [ WT-4762 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: