Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      Ken-Ton
    • Categories:
      ACA
    • Reported by:
      Client

      Description

      NA

        Attachments

          Issue Links

            Activity

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - the lowest monthly cost Ken-Ton plan for the period January - June 2017 is $374.00 and for the period July - December 2017 is $377.74. Could you please put that into the system and run their forms? Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - the lowest monthly cost Ken-Ton plan for the period January - June 2017 is $374.00 and for the period July - December 2017 is $377.74. Could you please put that into the system and run their forms? Thanks!
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have created a new 1095C report "2017 1095C" with same customization as previous 1095C report.

            To reflect the costs as per your request we have made following changes.
            We have created two class wise rules under ACA Customization->ACA 1095C Class Wise Configuration.
            1. 01/01/2017-6/30/2017 for Eligibility rule "Employee" as this rule is selected on 1095C report with cost $374.00
            2. 07/01/2017-12/31/2017 for Eligibility rule "Employee" with cost $377.74

            We have run the report "2017 1095C" with Apply classwise configuration flag as "YES".

            Employees will have cost $374 from Jan to June and $377.74 from July to Dec.
            However these cost are irrespective of the plans.

            In ACA Customization,there are plans whose employee cost is set.These are not considered for current report.
            In case if plan wise costs are to be considered, please provide the data of plan and cost in below format.

            Plan Name Jan-June Cost July-Dec Cost

            We need to do additional coding if plan wise and month wise costs are to be applied.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar,Kumar Chhajed

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have created a new 1095C report " 2017 1095C " with same customization as previous 1095C report. To reflect the costs as per your request we have made following changes. We have created two class wise rules under ACA Customization->ACA 1095C Class Wise Configuration . 1. 01/01/2017-6/30/2017 for Eligibility rule "Employee" as this rule is selected on 1095C report with cost $374.00 2. 07/01/2017-12/31/2017 for Eligibility rule "Employee" with cost $377.74 We have run the report "2017 1095C" with Apply classwise configuration flag as "YES". Employees will have cost $374 from Jan to June and $377.74 from July to Dec. However these cost are irrespective of the plans. In ACA Customization,there are plans whose employee cost is set.These are not considered for current report. In case if plan wise costs are to be considered, please provide the data of plan and cost in below format. Plan Name Jan-June Cost July-Dec Cost We need to do additional coding if plan wise and month wise costs are to be applied. CC: Nandkumar Prabhakar Karlekar , Smita Pawar , Kumar Chhajed
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - client has approved their forms; please re-run final. thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - client has approved their forms; please re-run final. thanks!
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            This group has been run. Please download latest run as per below report for verification.

            Report Name Run details Remark
            2017 1095C 1/16/2018 1:42:39 PM Observation:A.Qualifying Offer Method-No,D.98% Offer Method-No

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , This group has been run. Please download latest run as per below report for verification. Report Name Run details Remark 2017 1095C 1/16/2018 1:42:39 PM Observation:A.Qualifying Offer Method-No,D.98% Offer Method-No Thanks, Revan
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - could you take a look at the comparison report for this group and see if you can tell me why Dina Ferraraccio and James Ellerton were deleted? I can't decipher why from the UI.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - could you take a look at the comparison report for this group and see if you can tell me why Dina Ferraraccio and James Ellerton were deleted? I can't decipher why from the UI.
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Ramya Tantry,

            Can you please look into the Jennifer Leugers's query?

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Ramya Tantry , Can you please look into the Jennifer Leugers 's query? Thanks, Revan
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            While analyzing the issue, we found that in ACA Customization->EIN mapping, two records were there for same EIN but different eligibility rule. Out of these two,only one is in use.
            As there were two EIN set, EIN change code, deleted these employees as they satisfy both EIN rules.
            If there would have been a report for other rule,these employees would have come in that report.

            This is not an issue on other companies,because there were proper reports created for each EIN and same rule have been mapped.

            I have deleted the EIN record that was not in use and re-run the report.
            Please refer latest run for verification.

            CC: Revansiddha Gaur,Sachin Hingole,Smita Pawar,Nandkumar Prabhakar Karlekar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , While analyzing the issue, we found that in ACA Customization->EIN mapping, two records were there for same EIN but different eligibility rule. Out of these two,only one is in use. As there were two EIN set, EIN change code, deleted these employees as they satisfy both EIN rules. If there would have been a report for other rule,these employees would have come in that report. This is not an issue on other companies,because there were proper reports created for each EIN and same rule have been mapped. I have deleted the EIN record that was not in use and re-run the report. Please refer latest run for verification. CC: Revansiddha Gaur , Sachin Hingole , Smita Pawar , Nandkumar Prabhakar Karlekar
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Trying to run the comparison from 12.27.17 to yesterday (1.17.18) and it's not rendering. Could you please run and post to the FTP site? Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Trying to run the comparison from 12.27.17 to yesterday (1.17.18) and it's not rendering. Could you please run and post to the FTP site? Thanks!
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have uploaded the manually generated comparison report on ftp path: /users/workterraaca/ACA2018/WT-12545.
            Please find the below report name & comparison report file name.

            Report Name File Name
            2017 1095C ACA_1095C_Comparison_Report_2017 1095C_2017-12-27_2018-01-17.xls

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , We have uploaded the manually generated comparison report on ftp path: /users/workterraaca/ACA2018/ WT-12545 . Please find the below report name & comparison report file name. Report Name File Name 2017 1095C ACA_1095C_Comparison_Report_2017 1095C_2017-12-27_2018-01-17.xls Thanks, Revan
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - client has updated some employee addresses; please re-run final forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - client has updated some employee addresses; please re-run final forms. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have rerun '2017 1095C' report.
            Please refer latest run '1/24/2018 3:31:52 AM'to download.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have rerun '2017 1095C' report. Please refer latest run '1/24/2018 3:31:52 AM'to download. Thanks!
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Tracy Kot (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 13.5h
                  13.5h