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

Revised 1095c fixes for County of Lake

    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 Historical Data Load
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      County of Lake
    • Module:
      BenAdmin

      Description

      Hello - After the client reviewed the revised files they found more errors that need to be corrected. I've attached the revised list to update their forms. Please run program as soon as possible to allow us to process their 1094c file.

        Attachments

        1. 1094_C County of Lake.zip
          65 kB
        2. COL Opt Out dev repairv2.xlsx
          18 kB
        3. County of Lake Latest Report Run.JPG
          County of Lake Latest Report Run.JPG
          66 kB
        4. image001.jpg
          image001.jpg
          1.0 kB
        5. image002.jpg
          image002.jpg
          1 kB
        6. image003.png
          image003.png
          1 kB
        7. image004.png
          image004.png
          5 kB
        8. image005.jpg
          image005.jpg
          64 kB
        9. image006.jpg
          image006.jpg
          2 kB
        10. image007.jpg
          image007.jpg
          2 kB
        11. image009.png
          image009.png
          0.6 kB

          Activity

          cfinocchio Chris Finocchio (Inactive) created issue -
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Spreadsheet password: ACA2015

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Spreadsheet password: ACA2015
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Ramya Tantry

          After completion of this task please review the same.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Ramya Tantry After completion of this task please review the same.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Abhijeet Khandagale [ abhijeet.khandagale ]
          Hide
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Chris Finocchio Due to lack of bandwidth, we were not able to look into this.
          We will start working on this tomorrow [05/17/2016]

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Chris Finocchio Due to lack of bandwidth, we were not able to look into this. We will start working on this tomorrow [05/17/2016]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Hide
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Chris Finocchio, We have made code changes for the mentioned employees.
          We have kept Line 16 code as that of previous run where Line16 code is blank in excel sheet.
          Please download latest run,

          In excel, it is mentioned that Employee "TAYLOR OCONNOR" should have "1E" on Line14 in June, but it is not mentioned what code line 16 should have. As mentioned earlier, we have kept Line 16 code as that of previous run where Line16 code is blank in excel sheet.
          Taylor has "2D" in June in previous run which is reflected in this run as well. But, when line 16 has "2D" code then line 14 should have "1H". That's why code "1E" will not be displayed on line 14 for June month in Taylor's 1095C report.

          Please let us know, if you want us to keep line 16 codes blank as mentioned in excel sheet.

          Ramya Tantry Nandkumar Prabhakar Karlekar [~chimane@ebsbenefits.com]

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Chris Finocchio , We have made code changes for the mentioned employees. We have kept Line 16 code as that of previous run where Line16 code is blank in excel sheet. Please download latest run, In excel, it is mentioned that Employee "TAYLOR OCONNOR" should have "1E" on Line14 in June, but it is not mentioned what code line 16 should have. As mentioned earlier, we have kept Line 16 code as that of previous run where Line16 code is blank in excel sheet. Taylor has "2D" in June in previous run which is reflected in this run as well. But, when line 16 has "2D" code then line 14 should have "1H". That's why code "1E" will not be displayed on line 14 for June month in Taylor's 1095C report. Please let us know, if you want us to keep line 16 codes blank as mentioned in excel sheet. Ramya Tantry Nandkumar Prabhakar Karlekar [~chimane@ebsbenefits.com]
          abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
          Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Chris Finocchio [ cfinocchio ]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Ramya Tantry
          Nandkumar Prabhakar Karlekar
          [~chimane@ebsbenefits.com]

          Please see the below changes. Please let me know if you need me to submit an updated spreadsheet

          Taylor - For June change to 1H for line 14 and 2D for line 16.

          Also - Brockwalder, Drewery, Fix-Davis, Ford, Olson, Pierucci, Salmeron, Steely, Walsh should be 1E/2G for the entire year not just the month of January.
          And Tyrrell should be 1A/2C Jan-Nov and 1E/2G for Dec

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Ramya Tantry Nandkumar Prabhakar Karlekar [~chimane@ebsbenefits.com] Please see the below changes. Please let me know if you need me to submit an updated spreadsheet Taylor - For June change to 1H for line 14 and 2D for line 16. Also - Brockwalder, Drewery, Fix-Davis, Ford, Olson, Pierucci, Salmeron, Steely, Walsh should be 1E/2G for the entire year not just the month of January. And Tyrrell should be 1A/2C Jan-Nov and 1E/2G for Dec
          Hide
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

          Hi Chris Finocchio, I've made code changes as per your last comment. Please download the latest run and revert in case of any discrepancy.

          Nandkumar Prabhakar Karlekar Ramya Tantry [~chimane@ebsbenefits.com]

          Show
          abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Hi Chris Finocchio , I've made code changes as per your last comment. Please download the latest run and revert in case of any discrepancy. Nandkumar Prabhakar Karlekar Ramya Tantry [~chimane@ebsbenefits.com]
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Ashley Marra

          County of Lake signed off 1095c forms. Ready to proceed with 1094c filing.

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Ashley Marra County of Lake signed off 1095c forms. Ready to proceed with 1094c filing.
          cfinocchio Chris Finocchio (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          amarra Ashley Marra (Inactive) added a comment -

          Chris Finocchio Jennifer Leugers

          Please send me the 1094C form as I have received for my other clients and I will send for approval. Thanks.

          Show
          amarra Ashley Marra (Inactive) added a comment - Chris Finocchio Jennifer Leugers Please send me the 1094C form as I have received for my other clients and I will send for approval. Thanks.
          Hide
          cfinocchio Chris Finocchio (Inactive) added a comment -

          Here you go.

          Chris Finocchio | Senior Analyst, WORKTERRA
          Employee Benefit Specialists, Inc.
          PO Box 11657, Pleasanton, CA 94588
          PH: 925-621-5258| FAX: 925-460-3920 | chris.finocchio@ebsbenefits.com<chris.finocchio@ebsbenefits.com>

          [Description: Description: Description: Description: Description: twitter]<http://twitter.com/#!/workterra> [Description: Description: Description: Description: Description: linkedin-tiny-square2] <http://www.linkedin.com/company/workterra> [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] <http://www.facebook.com/workterra>

          Show
          cfinocchio Chris Finocchio (Inactive) added a comment - Here you go. Chris Finocchio | Senior Analyst, WORKTERRA Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 925-621-5258| FAX: 925-460-3920 | chris.finocchio@ebsbenefits.com< chris.finocchio@ebsbenefits.com > [Description: Description: Description: Description: Description: twitter] < http://twitter.com/#!/workterra > [Description: Description: Description: Description: Description: linkedin-tiny-square2] < http://www.linkedin.com/company/workterra > [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] < http://www.facebook.com/workterra >
          cfinocchio Chris Finocchio (Inactive) made changes -
          Attachment image009.png [ 18353 ]
          Attachment 1094_C County of Lake.zip [ 18354 ]
          Attachment image001.jpg [ 18346 ]
          Attachment image002.jpg [ 18347 ]
          Attachment image003.png [ 18348 ]
          Attachment image004.png [ 18349 ]
          Attachment image005.jpg [ 18350 ]
          Attachment image006.jpg [ 18351 ]
          Attachment image007.jpg [ 18352 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Abhijeet Khandagale (Inactive) made transition -
          Open In Progress
          3d 14h 22m 1
          Chris Finocchio (Inactive) made transition -
          In Progress Resolved
          6d 11h 25m 1

            People

            Assignee:
            cfinocchio Chris Finocchio (Inactive)
            Reporter:
            cfinocchio Chris Finocchio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: