Details

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

      Description

      NA

        Attachments

          Issue Links

            Activity

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - Long 1095C Report is ready to be run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - Long 1095C Report is ready to be run. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have run 'Long 1095C Report'.
            Refer latest run '12/28/2017 10:24:37 PM' to download.
            PFA QA verification checklist for additional information.

            Observation: MEC indicator is marked as 'NO' for all 12 months.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have run 'Long 1095C Report'. Refer latest run '12/28/2017 10:24:37 PM' to download. PFA QA verification checklist for additional information. Observation: MEC indicator is marked as 'NO' for all 12 months. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - please re-run this group. Please note that I have included all of the classes under Class 1 as they want a 1095C form for all of their employees including part-time, temps and interns. I also changed their customization to not be conditional - again I'm not sure how this got changed so would be great if we could start tracking this in the future through the history.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - please re-run this group. Please note that I have included all of the classes under Class 1 as they want a 1095C form for all of their employees including part-time, temps and interns. I also changed their customization to not be conditional - again I'm not sure how this got changed so would be great if we could start tracking this in the future through the history.
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            This group has been run. Please find the below run details for verification.

            Report Name Run details
            Long 1095C Report 1/19/2018 9:39:51 AM

            Observation: MEC indicator is marked as 'NO' for all 12 months.

            We have noted your request in our learning points about tracking the changes through history.

            Thanks,
            Revan
            CC- Ramya Tantry, Nandkumar Prabhakar Karlekar,Smita Pawar, Sachin Hingole

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , This group has been run. Please find the below run details for verification. Report Name Run details Long 1095C Report 1/19/2018 9:39:51 AM Observation: MEC indicator is marked as 'NO' for all 12 months. We have noted your request in our learning points about tracking the changes through history. Thanks, Revan CC- Ramya Tantry , Nandkumar Prabhakar Karlekar , Smita Pawar , Sachin Hingole
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have noted down your request to track ACA Customization changes.We will take up this request once ACA execution is done and this request is approved.

            Looking at the history of changes user "jleugers" have changed the conditional offer on "2018-01-19 08:11:08 AM" and again changed the customization to not be conditional on "2018-01-19 08:11:14 AM".

            CC: Nandkumar Prabhakar Karlekar,Revansiddha Gaur

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We have noted down your request to track ACA Customization changes.We will take up this request once ACA execution is done and this request is approved. Looking at the history of changes user "jleugers" have changed the conditional offer on "2018-01-19 08:11:08 AM" and again changed the customization to not be conditional on "2018-01-19 08:11:14 AM". CC: Nandkumar Prabhakar Karlekar , Revansiddha Gaur
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - I can't figure out why some of the employees are still getting 1E for some months (example Kenneth Allen). I show the EE only cost is lower than the FPL and the employee is not marked as part-time on the analysis. Please advise. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - I can't figure out why some of the employees are still getting 1E for some months (example Kenneth Allen). I show the EE only cost is lower than the FPL and the employee is not marked as part-time on the analysis. Please advise. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Also - I need the attached uploaded (I didn't see the template to upload it from the UI). Password is standard convention.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Also - I need the attached uploaded (I didn't see the template to upload it from the UI). Password is standard convention.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            Employees got 1E for some months because the rate of minimum cost plan that was eligible to them changed effective 09/01/2017. Their cost is greater than 9.5% (as adjusted) of mainland single federal poverty line.
            i.e : FPL Amount : $12060
            Per month FPL amount: $12060/12=$1005
            9.5% of $1005 = $95.47.

            From IRS Site :
            1A: Qualifying Offer: Minimum essential coverage providing minimum value offered to full-time employee with Employee Required Contribution equal to or less than 9.5% (as adjusted) of mainland single federal poverty line and at least minimum essential coverage offered to spouse and dependent(s).

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Hi Jennifer Leugers , Employees got 1E for some months because the rate of minimum cost plan that was eligible to them changed effective 09/01/2017. Their cost is greater than 9.5% (as adjusted) of mainland single federal poverty line. i.e : FPL Amount : $12060 Per month FPL amount: $12060/12=$1005 9.5% of $1005 = $95.47. From IRS Site : 1A: Qualifying Offer : Minimum essential coverage providing minimum value offered to full-time employee with Employee Required Contribution equal to or less than 9.5% (as adjusted) of mainland single federal poverty line and at least minimum essential coverage offered to spouse and dependent(s).
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            This group has been re-run by applying correction. Please find the below run details for verification.

            Report Name Run details
            Long 1095C Report 1/25/2018 3:47:29 AM

            Observation:
            1. A.Qualifying Offer Method=Yes, D.98% Offer Method=No
            2. MECIndicator- All 12 months -No

            While importing, System has been given bad file for the reason of Invalid Code - Bad_ACA 1095C Correction Import- LONG201_25_2018 03_42_40 AM.zip , we have imported it by correcting as 1H/2D instead of 1A/2D.

            Password is based on defined standard convention.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Jennifer Leugers , This group has been re-run by applying correction. Please find the below run details for verification. Report Name Run details Long 1095C Report 1/25/2018 3:47:29 AM Observation: 1. A.Qualifying Offer Method=Yes, D.98% Offer Method=No 2. MECIndicator- All 12 months -No While importing, System has been given bad file for the reason of Invalid Code - Bad_ACA 1095C Correction Import- LONG201_25_2018 03_42_40 AM.zip , we have imported it by correcting as 1H/2D instead of 1A/2D. Password is based on defined standard convention. Thanks, Revan
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Thanks - for some reason I thought the FPL was $97.38 for 2017.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Thanks - for some reason I thought the FPL was $97.38 for 2017.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - I thought the FPL was 9.69% (which is also what we show as the standard on the ACA Parameters tab) -

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - I thought the FPL was 9.69% (which is also what we show as the standard on the ACA Parameters tab) -
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Show
            jennifer.leugers Jennifer Leugers added a comment -
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - I really need to get an answer to this. I'm very worried this is a universal issue across all clients and I need to know if I need to pull the files we've already sent to the mail house or not.

            Samir
            Sachin Hingole
            Revansiddha Gaur

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - I really need to get an answer to this. I'm very worried this is a universal issue across all clients and I need to know if I need to pull the files we've already sent to the mail house or not. Samir Sachin Hingole Revansiddha Gaur
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            9.69% is actually the safe harbor percentage. For 2G/F/H ,this 9.69% is used to calculate affordability safe harbor cost.
            So,if employee cost is less than $97.38 and if plan uses FPL safe harbor then only 2G code will get populated.
            9.69% is not used for calculating 1A.
            As mentioned in IRS 1095C instructions, for 1A,employee cost must be less than or equal to 9.5% of FPL amount.

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

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , 9.69% is actually the safe harbor percentage. For 2G/F/H ,this 9.69% is used to calculate affordability safe harbor cost. So,if employee cost is less than $97.38 and if plan uses FPL safe harbor then only 2G code will get populated. 9.69% is not used for calculating 1A. As mentioned in IRS 1095C instructions, for 1A,employee cost must be less than or equal to 9.5% of FPL amount. CC : Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Sachin Hingole , Satya , Samir , Smita Pawar
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Jennifer Leugers

            We have changes the FPL % from 9.5 to 9.69 for long company where 241 distinct employees code has been changes from 1E to 1A.

            Please download the latest run with run date 1/26/2018 11:46:12 PM.

            We will scan all the companies and let you know the details.

            Samir,Ramya Tantry,Revansiddha Gaur,Sachin Hingole,Satya,Smita Pawar,

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Jennifer Leugers We have changes the FPL % from 9.5 to 9.69 for long company where 241 distinct employees code has been changes from 1E to 1A. Please download the latest run with run date 1/26/2018 11:46:12 PM. We will scan all the companies and let you know the details. Samir , Ramya Tantry , Revansiddha Gaur , Sachin Hingole , Satya , Smita Pawar ,
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - I'm totally confused. Ramya's comments were that the 9.69% is NOT used to determine 1A but then in Nandu's comments, we made the change and some employees changed from 1E to 1A. Could you please help me understand which comment is correct?

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - I'm totally confused. Ramya's comments were that the 9.69% is NOT used to determine 1A but then in Nandu's comments, we made the change and some employees changed from 1E to 1A. Could you please help me understand which comment is correct?
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            Please disregard my comment.
            Please refer to Nandu's comment. Nandu has already sent you a separate mail regarding FPL percentage issue where in all production companies were scanned and 5 companies where affected.
            All the affected companies and their 15 reports have been re-run. Please refer to the attached excel sheet containing report names with run details. FPL percent issue.xls.
            In excel column "Affected Employee Count " have a count of employees whose line 14 has been changes from 1E to 1A.

            Total Employees affected for all production companies are 1055.

            Note: As you have sent some of the drafts to print so if required we can send you only affected employees PDF's report wise,this will reduce the reprint overhead.

            Please let us know you view on the same.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Please disregard my comment. Please refer to Nandu's comment. Nandu has already sent you a separate mail regarding FPL percentage issue where in all production companies were scanned and 5 companies where affected. All the affected companies and their 15 reports have been re-run . Please refer to the attached excel sheet containing report names with run details. FPL percent issue.xls . In excel column "Affected Employee Count " have a count of employees whose line 14 has been changes from 1E to 1A. Total Employees affected for all production companies are 1055 . Note : As you have sent some of the drafts to print so if required we can send you only affected employees PDF's report wise,this will reduce the reprint overhead. Please let us know you view on the same. CC: Nandkumar Prabhakar Karlekar , Smita Pawar
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Yes please provide the affected employee's PDFS. Could you make sure they say corrected on them? Thanks.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Yes please provide the affected employee's PDFS. Could you make sure they say corrected on them? Thanks.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            In LONG company,239 employees where affected.
            We have furnished 239 employees PDF's only with Form status as Corrected.
            Please refer run dated "1/30/2018 11:30:36 PM" for 239 employees PDF of report "Long 1095C Report".
            In case you require PDF's of all employees along with affected employees,please refer run dated "1/26/2018 11:46:12 PM" of report "Long 1095C Report".

            To furnish only 239 employees PDF, we had to do some changes in the back-end. We have reverted those changes and also removed corrected form status from the report customization too.

            Since you are using latest run for consolidated download of other draft approved affected companies (Austin and DMA), latest changes are already present in that run.

            CC:Nandkumar Prabhakar Karlekar,Smita Pawar,Revansiddha Gaur

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , In LONG company,239 employees where affected. We have furnished 239 employees PDF's only with Form status as Corrected. Please refer run dated " 1/30/2018 11:30:36 PM " for 239 employees PDF of report "Long 1095C Report". In case you require PDF's of all employees along with affected employees,please refer run dated " 1/26/2018 11:46:12 PM " of report "Long 1095C Report". To furnish only 239 employees PDF, we had to do some changes in the back-end. We have reverted those changes and also removed corrected form status from the report customization too. Since you are using latest run for consolidated download of other draft approved affected companies (Austin and DMA), latest changes are already present in that run. CC: Nandkumar Prabhakar Karlekar , Smita Pawar , Revansiddha Gaur
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - why did the Long run go from 475 employees to 239?

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - why did the Long run go from 475 employees to 239?
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I see now (didn't see the comment before). But they were the only ones that I didn't send to the mailhouse yet so I need their full run. Could you please do this ASAP? I need to get their forms to them this morning.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I see now (didn't see the comment before). But they were the only ones that I didn't send to the mailhouse yet so I need their full run. Could you please do this ASAP? I need to get their forms to them this morning.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            As mentioned in my earlier comment, Please consider run dated "1/26/2018 11:46:12 PM" for their full run.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , As mentioned in my earlier comment, Please consider run dated "1/26/2018 11:46:12 PM" for their full run.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Oops thanks! I do need the corrected PDFS for the other companies as I need for the client to approve just those; they had already approved their previous file so I don't want to give them the full file again.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Oops thanks! I do need the corrected PDFS for the other companies as I need for the client to approve just those; they had already approved their previous file so I don't want to give them the full file again.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            Till now, Austin and DMA 's drafts have been approved.So we will generate corrected PDF's only for Austin and DMA. Please confirm

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Till now, Austin and DMA 's drafts have been approved.So we will generate corrected PDF's only for Austin and DMA. Please confirm
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Please also provide for Del Norte.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Please also provide for Del Norte.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            We will provide affected employees PDF's of Austin,DMA and Del Norte by tomorrow EOD as we need to do some manual back-end changes to furnish the same.All these PDF's will be marked as Corrected.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , We will provide affected employees PDF's of Austin,DMA and Del Norte by tomorrow EOD as we need to do some manual back-end changes to furnish the same.All these PDF's will be marked as Corrected.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All it looks like Long is still incorrect; there are still a lot of 1Es showing on their analysis. Please look into this ASAP.

            Show
            jennifer.leugers Jennifer Leugers added a comment - All it looks like Long is still incorrect; there are still a lot of 1Es showing on their analysis. Please look into this ASAP.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            We are also showing some 1E / blanks - is that due to their premiums being over the FPL amounts?

            Show
            jennifer.leugers Jennifer Leugers added a comment - We are also showing some 1E / blanks - is that due to their premiums being over the FPL amounts?
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            There are 1E's because their employee cost is greater than FPL amount.We have verified some of the employees.
            1. Karen L An :- Jan-Aug : 1A/2C , Sept-Dec : 1E/2C
            Rates of ACA plan changed from Sept.This minimum rate($146.08) is greater than FPL amount.

            2. Aaron M Morris : Jan-Dec : 1E/2C
            Minimum Employee cost($454.22) is greater than FPL amount.

            3. Destry J. Atkinson: Jan-Dec : 1E/Blank, Line15 : $454.22
            Employee's salary is set in Benefit salary.However,on ACA Parameters page, salary to be considered is set as W2 wages.
            As per implementation, if W2 wages on employee payroll is blank,we consider gross annual salary by default. Gross annual salary is also 0,so safe harbor cost comes up as 0.As employee cost is greater than 0,line 16 comes up as blank.

            NOTE: Please verify ACA Parameters as which to salary is to be considered. For some of the employees,benefit salary is set as 0.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , There are 1E's because their employee cost is greater than FPL amount.We have verified some of the employees. 1. Karen L An :- Jan-Aug : 1A/2C , Sept-Dec : 1E/2C Rates of ACA plan changed from Sept.This minimum rate($146.08) is greater than FPL amount. 2. Aaron M Morris : Jan-Dec : 1E/2C Minimum Employee cost($454.22) is greater than FPL amount. 3. Destry J. Atkinson: Jan-Dec : 1E/Blank, Line15 : $454.22 Employee's salary is set in Benefit salary.However,on ACA Parameters page, salary to be considered is set as W2 wages. As per implementation, if W2 wages on employee payroll is blank,we consider gross annual salary by default. Gross annual salary is also 0,so safe harbor cost comes up as 0.As employee cost is greater than 0,line 16 comes up as blank. NOTE: Please verify ACA Parameters as which to salary is to be considered. For some of the employees,benefit salary is set as 0.
            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:
              Deborah Mascot (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 22.5h
                  22.5h