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. ACA Employee CensusACA Employee Census23260_2985.xls
          303 kB
        2. Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
        3. Bad_Election.txt
          3 kB
        4. Copy of Additional Historical Data for Workterra_FINAL.xlsx
          42 kB
        5. Copy of Linium ACA Data Correction_Final.xlsx
          24 kB
        6. Copy of WORKTERRA ACAMP IRS Reporting Tool Configuration Data Files v2016-02-16 LK.xlsx
          869 kB
        7. Correction of 20710_Linium_Data.xls
          384 kB
        8. Employee_NotExists_RemainingLoad Sheet.xls
          7 kB
        9. Employee_NotExists.xls
          8 kB
        10. employee coding.xlsx
          55 kB
        11. History.png
          History.png
          78 kB
        12. image001.jpg
          image001.jpg
          1.0 kB
        13. image002.jpg
          image002.jpg
          1 kB
        14. image003.png
          image003.png
          1 kB
        15. image004.jpg
          image004.jpg
          1 kB
        16. image005.jpg
          image005.jpg
          64 kB
        17. image006.jpg
          image006.jpg
          2 kB
        18. image007.png
          image007.png
          5 kB
        19. image008.jpg
          image008.jpg
          2 kB
        20. image009.png
          image009.png
          0.7 kB
        21. Linium_ACA Spreadsheet.xls
          120 kB
        22. Linium_Data.xls
          341 kB
        23. Linium_DataRequired.xls
          97 kB
        24. Linium_Discrepancies.xls
          9 kB
        25. Linium_Employee_Not_Exists.xls
          8 kB
        26. lINIUM C&C 1095.zip
          500 kB
        27. Linium-EmployeeVerified.txt
          0.6 kB
        28. Linium-ET-881 Format.zip
          30 kB
        29. Qualifying_Event.png
          Qualifying_Event.png
          52 kB
        30. REVISED Linium ACA Data Correction_Final.xlsx
          29 kB
        31. screenshot-1.png
          screenshot-1.png
          90 kB
        32. screenshot-2.png
          screenshot-2.png
          68 kB
        33. screenshot-3.png
          screenshot-3.png
          8 kB
        34. screenshot-4.png
          screenshot-4.png
          97 kB
        35. WORKTERRA ACA Tool Configuration v2016-02-16 LK.xlsx
          32 kB

          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: