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

Linium ACA Data Load Customization Spread Sheet

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Historical Data Load
    • Environment:
      Stage
    • Reported by:
      Support
    • Company:
      Linium
    • Module:
      ACA

      Description

      Hello

      Please review attached ACA customization spread sheet that needs to be loaded for linium 1095-C reporting.

        Attachments

        1. Copy of WORKTERRA ACAMP IRS Reporting Tool Configuration Data Files v2016-02-16 LK.xlsx
          869 kB
          lisa davison
        2. image001.jpg
          1.0 kB
          lisa davison
        3. image002.jpg
          1 kB
          lisa davison
        4. image003.png
          1 kB
          lisa davison
        5. image004.jpg
          1 kB
          lisa davison
        6. image005.jpg
          64 kB
          lisa davison
        7. image006.jpg
          2 kB
          lisa davison
        8. image007.png
          5 kB
          lisa davison
        9. image008.jpg
          2 kB
          lisa davison
        10. image009.png
          0.7 kB
          lisa davison
        11. Linium_DataRequired.xls
          97 kB
          Yogesh Chaudhari
        12. WORKTERRA ACA Tool Configuration v2016-02-16 LK.xlsx
          32 kB
          lisa davison
        13. Linium_ACA Spreadsheet.xls
          120 kB
          lisa davison
        14. Bad_Election.txt
          3 kB
          Suraj Sokasane
        15. screenshot-1.png
          90 kB
          Jennifer Leugers
        16. screenshot-2.png
          68 kB
          Jennifer Leugers
        17. screenshot-3.png
          8 kB
          Jennifer Leugers
        18. ACA Employee CensusACA Employee Census23260_2985.xls
          303 kB
          lisa davison
        19. Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
          lisa davison
        20. Employee_NotExists.xls
          8 kB
          Yogesh Chaudhari
        21. Copy of Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
          lisa davison
        22. Linium_Employee_Not_Exists.xls
          8 kB
          Yogesh Chaudhari
        23. Employee_NotExists_RemainingLoad Sheet.xls
          7 kB
          Yogesh Chaudhari
        24. Qualifying_Event.png
          52 kB
          Yogesh Chaudhari
        25. History.png
          78 kB
          Yogesh Chaudhari
        26. screenshot-4.png
          97 kB
          Jennifer Leugers
        27. Copy of Linium ACA Data Correction_Final.xlsx
          24 kB
          lisa davison
        28. REVISED Linium ACA Data Correction_Final.xlsx
          29 kB
          lisa davison
        29. Linium_Discrepancies.xls
          9 kB
          Ramya Tantry
        30. Linium-EmployeeVerified.txt
          0.6 kB
          Sachin Hingole
        31. employee coding.xlsx
          55 kB
          lisa davison
        32. Linium_Data.xls
          341 kB
          Ramya Tantry
        33. Correction of 20710_Linium_Data.xls
          384 kB
          lisa davison

          Activity

          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Smita Pawar

          FYI Nandkumar Prabhakar Karlekar,Sachin Hingole

          I loaded above four employee's data into the system.
          Please re-run the forms and verify.

          Also ensure that Daniel Rowe ad Jill Hunt are considered under Linium LLC.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Smita Pawar FYI Nandkumar Prabhakar Karlekar , Sachin Hingole I loaded above four employee's data into the system. Please re-run the forms and verify. Also ensure that Daniel Rowe ad Jill Hunt are considered under Linium LLC.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          FYI Ramya Tantry,Nandkumar Prabhakar Karlekar,Sachin Hingole,Rakesh Roy

          Hi lisa davison,

          We have verified below mentioned employees 1095-C report PDF's and are as per
          mentioned in the correction Excel

          Ali Dada
          Kristie Anzolone
          Stephanie Cosgrove
          Jenni Davis

          but for Stephanie Cosgrove employee cost is not displayed on line 15 for the month Dec as codes on Line 14, 16 are 1H, 2A

          Currently below mentioned employees are considered under Linium LLC.
          Jill Hunt 108566444 - Displayed codes Jan to June 1E to 2C with line 15 cost 203.00
          Jul to Dec 1E to 2C with line 15 cost 187.40
          Daniel Rowe 498028426 -Displayed codes Jan to June 1E to 2C with line 15 cost 203.00
          Jul to Dec 1E to 2C with line 15 cost 187.40

          Request you to refer latest run for changes.
          Let us know if you need any additional information.

          Thanks,
          Smita

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - FYI Ramya Tantry , Nandkumar Prabhakar Karlekar , Sachin Hingole , Rakesh Roy Hi lisa davison , We have verified below mentioned employees 1095-C report PDF's and are as per mentioned in the correction Excel Ali Dada Kristie Anzolone Stephanie Cosgrove Jenni Davis but for Stephanie Cosgrove employee cost is not displayed on line 15 for the month Dec as codes on Line 14, 16 are 1H, 2A Currently below mentioned employees are considered under Linium LLC. Jill Hunt 108566444 - Displayed codes Jan to June 1E to 2C with line 15 cost 203.00 Jul to Dec 1E to 2C with line 15 cost 187.40 Daniel Rowe 498028426 -Displayed codes Jan to June 1E to 2C with line 15 cost 203.00 Jul to Dec 1E to 2C with line 15 cost 187.40 Request you to refer latest run for changes. Let us know if you need any additional information. Thanks, Smita
          Hide
          lisadavison lisa davison added a comment -

          Hello All,

          we have one more record to correct. The changes that need to be made to Ali Dada’s 1095c:

          Line 15: remove the amounts in the Nov and Dec boxes
          Line 16: Should reflect “Jan-Apr 2A; May 2D; Jun-Oct 2C; Nov-Dec 2A”

          Show
          lisadavison lisa davison added a comment - Hello All, we have one more record to correct. The changes that need to be made to Ali Dada’s 1095c: Line 15: remove the amounts in the Nov and Dec boxes Line 16: Should reflect “Jan-Apr 2A; May 2D; Jun-Oct 2C; Nov-Dec 2A”
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Smita Pawar

          FYI Nandkumar Prabhakar Karlekar

          The correction is loaded into the system.
          Please re-run the forms and verify.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Smita Pawar FYI Nandkumar Prabhakar Karlekar The correction is loaded into the system. Please re-run the forms and verify.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          FYI Nandkumar Prabhakar Karlekar, Sachin Hingole,Rakesh Roy ,Ramya Tantry

          Hi lisa davison,

          We have verified corrections for employee Ali Dada on Production company [Linium] and its as required
          1.No cost displayed for the month of Nov and Dec.
          2.Displayed 2A codes from Jan to April, 2D for the month of May,2C from June to Oct, 2A for the month of Nov to Dec

          Let us know if require any information

          Thanks,
          Smita

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Rakesh Roy , Ramya Tantry Hi lisa davison , We have verified corrections for employee Ali Dada on Production company [Linium] and its as required 1.No cost displayed for the month of Nov and Dec. 2.Displayed 2A codes from Jan to April, 2D for the month of May,2C from June to Oct, 2A for the month of Nov to Dec Let us know if require any information Thanks, Smita

            People

            Assignee:
            lisadavison lisa davison
            Reporter:
            lisadavison lisa davison
            Account Executive:
            lisa davison
            Developer:
            Shubhankar Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: