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

ACA - 2017 City of Redding 1095C Reports

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      City of Redding
    • Module:
      ACA - 2017

      Attachments

      1. Liapis.jpg
        Liapis.jpg
        197 kB
      2. screenshot-1.png
        screenshot-1.png
        2 kB
      3. screenshot-2.png
        screenshot-2.png
        54 kB
      4. Tackett.jpg
        Tackett.jpg
        209 kB

        Activity

        Hide
        kumar.chhajed Kumar Chhajed (Inactive) added a comment -

        Hi Jennifer Leugers

        Please verify ACA Customization on this company and please make changes on this screen if necessary,so that the report can be re-run with latest customization.

        CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers Please verify ACA Customization on this company and please make changes on this screen if necessary,so that the report can be re-run with latest customization. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Customization confirmed; please run 2016 1095C for Redding

        Show
        jennifer.leugers Jennifer Leugers added a comment - Customization confirmed; please run 2016 1095C for Redding
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

        Hi Jennifer Leugers

        We have run " 2016 1095C for Redding" report. Please refer latest run for verification.

        Note: EIN is not mapped for the eligibility rule used in this report.So in 1095C report,Employer name and EIN will display details present in Company Information. Please change EIN's rule from EIN Classes mapping tab in ACA Customization and also please verify the contact person.Reports need to be re-run after this change.

        CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Hi Jennifer Leugers We have run " 2016 1095C for Redding" report. Please refer latest run for verification. Note: EIN is not mapped for the eligibility rule used in this report.So in 1095C report,Employer name and EIN will display details present in Company Information. Please change EIN's rule from EIN Classes mapping tab in ACA Customization and also please verify the contact person.Reports need to be re-run after this change. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Please re-run the forms with the employees included who have Temporary selected in the drop-down on the demographics page (I could not see where to do this from the UI).


        Show
        jennifer.leugers Jennifer Leugers added a comment - Please re-run the forms with the employees included who have Temporary selected in the drop-down on the demographics page (I could not see where to do this from the UI).
        Hide
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        Hi Jennifer Leugers,

        We run "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports on redding production.
        Please refer latest run from both reports.

        Out of above mentioned 20EE's, 12 EE's are not in any of the 1095C reports. Below is the list of 10EEs who are not in 1095C reports.
        These EEs are not in PDF because their class 2 is "Part Time - 990" and this class is not selected on any of the eligibility rule selected on "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports. Please select "Part Time - 990" class on any one eligibility rule used on these 2 reports.

        Benoit Denis
        Boughton Paul
        Devaney Kevin
        Haas Daniel
        Hunter Darrell
        MCCarty Christopher
        Murphy TD
        NewNam Joshua
        Prokupek Christopher
        Richards Michael
        Sanderson Samuel
        Tackett Kevin

        Please note, we have changed eligibility rule setting on "EIN classes mapping" page to match it with 1095C reports.

        Thanks,
        Sachin Hingole

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , We run "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports on redding production. Please refer latest run from both reports. Out of above mentioned 20EE's, 12 EE's are not in any of the 1095C reports. Below is the list of 10EEs who are not in 1095C reports. These EEs are not in PDF because their class 2 is "Part Time - 990" and this class is not selected on any of the eligibility rule selected on "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports. Please select "Part Time - 990" class on any one eligibility rule used on these 2 reports. Benoit Denis Boughton Paul Devaney Kevin Haas Daniel Hunter Darrell MCCarty Christopher Murphy TD NewNam Joshua Prokupek Christopher Richards Michael Sanderson Samuel Tackett Kevin Please note, we have changed eligibility rule setting on "EIN classes mapping" page to match it with 1095C reports. Thanks, Sachin Hingole
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - please see below and let me know if you can re-run the forms tonight

        The following Unions will have $154 entered into box 15 Part II:

        Unrepresented

        RPOA

        RPMA

        IBEW Maintenance

        IBEW Electric

        UPEC

        IAFF

        RIEO – Supervisor – Confidential

        The following Unions will have $165 entered into box 15 Part II:

        RPOA Miscellaneous

        RIEO Clerical Technical Professional

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - please see below and let me know if you can re-run the forms tonight The following Unions will have $154 entered into box 15 Part II: Unrepresented RPOA RPMA IBEW Maintenance IBEW Electric UPEC IAFF RIEO – Supervisor – Confidential The following Unions will have $165 entered into box 15 Part II: RPOA Miscellaneous RIEO Clerical Technical Professional
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment -

        Hi Jennifer Leugers

        Hi Jennifer,

        We have rerun "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports.
        Please refer latest run from both reports.

        For achieving this we have created two rules on below mentioned path
        Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> ACA Customization >> ACA 1095C Class Wise Rate Configuration
        If any changes is required in this customization in future, please update the rules and Rerun the reports.

        Our observations are as follows.
        1.RPOA
        2.RPMA
        3.IAFF
        these classes where not available for selecting $154 cost on line 15 of 1095-C report.

        Similarly
        1.RPOA Miscellaneous
        This Class is also not available for selecting $164 cost on line 16 of 1095-C report.

        Please let us know, if any additional information is required.

        Thanks,
        Smita

        FYI Nandkumar Prabhakar Karlekar,Sachin Hingole,Ramya Tantry

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers Hi Jennifer, We have rerun "2016 1095C for Redding ACTIVE" and "2016 1095C for Redding RETIREE" reports. Please refer latest run from both reports. For achieving this we have created two rules on below mentioned path Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> ACA Customization >> ACA 1095C Class Wise Rate Configuration If any changes is required in this customization in future, please update the rules and Rerun the reports. Our observations are as follows. 1.RPOA 2.RPMA 3.IAFF these classes where not available for selecting $154 cost on line 15 of 1095-C report. Similarly 1.RPOA Miscellaneous This Class is also not available for selecting $164 cost on line 16 of 1095-C report. Please let us know, if any additional information is required. Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Ramya Tantry
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi - why is Bernard Shaw showing a 1G for all 12 months? He was hired on 5.2.16 and terminated 10.28.16. I do not know if he is the only one but please verify the rest of the run for this group are correct.

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi - why is Bernard Shaw showing a 1G for all 12 months? He was hired on 5.2.16 and terminated 10.28.16. I do not know if he is the only one but please verify the rest of the run for this group are correct.
        Hide
        sachin.hingole Sachin Hingole (Inactive) added a comment -

        Hi Jennifer Leugers,

        We have verified all the employees who are getting 1G on 1095C PDF, and codes are correct for all the employees including "Bernard Shaw", As all these employees Employment Type is either Part-Time or Temporary.

        Also "MARGERY J STOCKWELL" employee got 1G on 1095C PDF as she is Retired with effective date 12/31/2015 and then terminated with effective date 05/19/2016.

        Please let us know if you need any other details.

        Thanks,
        Sachin Hingole

        Nandkumar Prabhakar Karlekar Ramya Tantry Rakesh Roy Smita Pawar

        Show
        sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , We have verified all the employees who are getting 1G on 1095C PDF, and codes are correct for all the employees including "Bernard Shaw", As all these employees Employment Type is either Part-Time or Temporary. Also "MARGERY J STOCKWELL" employee got 1G on 1095C PDF as she is Retired with effective date 12/31/2015 and then terminated with effective date 05/19/2016. Please let us know if you need any other details. Thanks, Sachin Hingole Nandkumar Prabhakar Karlekar Ramya Tantry Rakesh Roy Smita Pawar
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Hi all - I have a call with Shawn tomorrow at 8 AM my time so really need to figure this out tonight if at all possible. There are roughly 20 or so employees that are in the part time classes that need to be added to the 1095C run. I couldn't figure out a way to do this so I've just created the run with those individuals (listed in the additional criteria under social). I know I can continue down this path but how would we put them together for the IRS? Is there another way for me to accomplish this?

        Show
        jennifer.leugers Jennifer Leugers added a comment - Hi all - I have a call with Shawn tomorrow at 8 AM my time so really need to figure this out tonight if at all possible. There are roughly 20 or so employees that are in the part time classes that need to be added to the 1095C run. I couldn't figure out a way to do this so I've just created the run with those individuals (listed in the additional criteria under social). I know I can continue down this path but how would we put them together for the IRS? Is there another way for me to accomplish this?
        Hide
        smita.pawar Smita Pawar (Inactive) added a comment - - edited

        Hi Jennifer Leugers,

        We have changed the additional eligibility criteria for "2016 1095C for Redding ACTIVE" for combining required part time employees and active employees and Rerun reports.
        Similarly we have changed eligibility rule on EIN Class mapping rule screen also.
        Eligibility rule used is "1095C Active And PT".

        Please refer latest run, steps to down reports are as follows.

        1.Login to Production with Partner.
        2.Edit company City of Redding For Hspl.
        3.Navigate to "Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> IRS Report".
        4.Edit Report "2016 1095C for Redding ACTIVE"
        5.Click on Show Runs and wait till "ACA Report Finalization" pop up to open.
        6.Download zip folder for latest RUN by clicking on Download link.

        Please review it and revert back if any query.

        Thanks,
        Smita

        FYI Ramya Tantry,Nandkumar Prabhakar Karlekar,Sachin Hingole

        Show
        smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Jennifer Leugers , We have changed the additional eligibility criteria for "2016 1095C for Redding ACTIVE" for combining required part time employees and active employees and Rerun reports. Similarly we have changed eligibility rule on EIN Class mapping rule screen also. Eligibility rule used is "1095C Active And PT". Please refer latest run, steps to down reports are as follows. 1.Login to Production with Partner. 2.Edit company City of Redding For Hspl. 3.Navigate to "Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> IRS Report". 4.Edit Report "2016 1095C for Redding ACTIVE" 5.Click on Show Runs and wait till "ACA Report Finalization" pop up to open. 6.Download zip folder for latest RUN by clicking on Download link. Please review it and revert back if any query. Thanks, Smita FYI Ramya Tantry , Nandkumar Prabhakar Karlekar , Sachin Hingole
        Hide
        jennifer.leugers Jennifer Leugers added a comment -

        Thanks! That worked for all but Liapis and Tackett. I double-checked and their socials are added but their forms are not populating. Could you please check into why?

        Show
        jennifer.leugers Jennifer Leugers added a comment - Thanks! That worked for all but Liapis and Tackett. I double-checked and their socials are added but their forms are not populating. Could you please check into why?
        Hide
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Jennifer Leugers,
        Please find below comments.

        CHRIS T LIAPIS : He was terminated in the year 2015 and had no benefits in 2016.As he neither present in the company for the year 2016 nor he had benefits,1095C form is not generated for this employee.
        Refer screenshot:

        KEVIN D TACKETT : This EE is hired on 03/14/2016,but he is terminated with backdate(06/19/2015).
        Refer screenshot:

        As per the employee data,this employee is not present in the company for 2016 and had no benefits in 2016.So,1095C form is not generated for this employee.

        Please let us know if you need any other details.

        CC:Smita Pawar,Sachin Hingole,Nandkumar Prabhakar Karlekar

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Please find below comments. CHRIS T LIAPIS : He was terminated in the year 2015 and had no benefits in 2016.As he neither present in the company for the year 2016 nor he had benefits,1095C form is not generated for this employee. Refer screenshot: KEVIN D TACKETT : This EE is hired on 03/14/2016,but he is terminated with backdate(06/19/2015). Refer screenshot: As per the employee data,this employee is not present in the company for 2016 and had no benefits in 2016.So,1095C form is not generated for this employee. Please let us know if you need any other details. CC: Smita Pawar , Sachin Hingole , Nandkumar Prabhakar Karlekar

          People

          Assignee:
          jennifer.leugers Jennifer Leugers
          Reporter:
          kumar.chhajed Kumar Chhajed (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          5 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Production Due Date:

              Time Tracking

              Estimated:
              Original Estimate - 20h
              20h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 17.25h Time Not Required
              17.25h