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

ACA - 2017 KPAG 1095C Reports

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Reported by:
      Support
    • Company:
      KPAG
    • Module:
      ACA - 2017

      Attachments

      1. KPAG_EmployeesWithoutEIN.xls
        69 kB
      2. Revised KPAG_EmployeesWithoutEIN.xls
        87 kB
      3. screenshot-1.png
        screenshot-1.png
        17 kB
      4. screenshot-2.png
        screenshot-2.png
        47 kB
      5. screenshot-3.png
        screenshot-3.png
        42 kB

        Issue Links

          Activity

          kumar.chhajed Kumar Chhajed (Inactive) created issue -
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Field Original Value New Value
          Assignee Kumar Chhajed [ kumar.chhajed ] Jennifer Leugers [ jennifer.leugers ]
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Hi Jennifer Leugers

          Please verify ACA Customization on this company and please make changes on this screen if necessary,so that the report can be re-run with latest customization.

          CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers Please verify ACA Customization on this company and please make changes on this screen if necessary,so that the report can be re-run with latest customization. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
          jennifer.leugers Jennifer Leugers made changes -
          Attachment screenshot-1.png [ 32657 ]
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Customization confirmed; please mark forms as void and run the attached

          Show
          jennifer.leugers Jennifer Leugers added a comment - Customization confirmed; please mark forms as void and run the attached
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Jennifer Leugers,

          KPAG forms will be ready for verification tomorrow(11/18/2016).

          CC:Nandkumar Prabhakar Karlekar,Sachin Hingole

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , KPAG forms will be ready for verification tomorrow(11/18/2016). CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Hi Jennifer Leugers,

          We have re-run KPAG forms. Please refer latest run for verification.

          CC : Nandkumar Prabhakar Karlekar Sachin Hingole

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Jennifer Leugers , We have re-run KPAG forms. Please refer latest run for verification. CC : Nandkumar Prabhakar Karlekar Sachin Hingole
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Customization updated to not select a value for the conditional offer; please re-run all reports. Thanks!

          Show
          jennifer.leugers Jennifer Leugers added a comment - Customization updated to not select a value for the conditional offer; please re-run all reports. Thanks!
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Additional issues / questions with their initial runs -
          Employees have line 16 missing for one month for some reason
          Terminated employees have a different amount on line 15 on their last month than the other months

          I've asked lisa davison to provide examples as soon as she gets them from the client.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Additional issues / questions with their initial runs - Employees have line 16 missing for one month for some reason Terminated employees have a different amount on line 15 on their last month than the other months I've asked lisa davison to provide examples as soon as she gets them from the client.
          Hide
          lisadavison lisa davison added a comment -

          Hello All,

          Below I have listed EIN's and addressed needed.

          EIN Name Address

          59-2317215 Page Brothers Associates, inc. 9400 W. Atlantic Blvd, Coral Springs, FL 33071
          59-2317213 Coral Springs Nissan, Inc. 9350 W. Atlantic Blvd, Coral Springs, FL 33071
          59-2413280 Coral Springs KGB, Inc. 9300 or 9330 W. Atlantic Blvd, Coral Springs, FL 33071 (this is 2 dealerships and have 2 different addresses, but same EIN
          90-0889734 KPMC, LLC 9400 W. Atlantic Blvd, Coral Springs, FL 33071
          26-4055944 Nissan Of St Augustine, Inc 2755 US1 South,. St Augustine, FL 32086
          52-2189209 West Street Motors, LLC 1736 West Street, Annapolis, MD 21401
          65-0511721 Union City Nissan, Inc 4080 Jonesboro Road, Union City, GA 30291
          27-3328876 South Atlanta Investments, Inc 4115 Jonesboro Road, Union City, GA 30291
          16-1725347 Nissanof South Atlanta, LLC 6889 Jonesboro Road, Morrow, GA 30260
          20-8110812 Town Center Investments, Inc 1221 Auto Park Drive NW, Kennesaw, GA 30144
          46-1852730 Newnan Nis, LLC 783 Bullsbroro Drive, Newnan, GA 30265

          In addition, I have attached the names of sample employee's $$ amount differences in last month and missing a code or two.

          Brittany Daniels - Terminated
          Adrien Hemans - Active
          Andrew Londin - Terminated
          Dennis Yu - Active
          Denniston McKitty - Terminated
          Anthiny Martorano -Cobra
          AAron Theruaylt - Active
          David Garcia - Inactive
          Louis Diana - Terminated

          Show
          lisadavison lisa davison added a comment - Hello All, Below I have listed EIN's and addressed needed. EIN Name Address 59-2317215 Page Brothers Associates, inc. 9400 W. Atlantic Blvd, Coral Springs, FL 33071 59-2317213 Coral Springs Nissan, Inc. 9350 W. Atlantic Blvd, Coral Springs, FL 33071 59-2413280 Coral Springs KGB, Inc. 9300 or 9330 W. Atlantic Blvd, Coral Springs, FL 33071 (this is 2 dealerships and have 2 different addresses, but same EIN 90-0889734 KPMC, LLC 9400 W. Atlantic Blvd, Coral Springs, FL 33071 26-4055944 Nissan Of St Augustine, Inc 2755 US1 South,. St Augustine, FL 32086 52-2189209 West Street Motors, LLC 1736 West Street, Annapolis, MD 21401 65-0511721 Union City Nissan, Inc 4080 Jonesboro Road, Union City, GA 30291 27-3328876 South Atlanta Investments, Inc 4115 Jonesboro Road, Union City, GA 30291 16-1725347 Nissanof South Atlanta, LLC 6889 Jonesboro Road, Morrow, GA 30260 20-8110812 Town Center Investments, Inc 1221 Auto Park Drive NW, Kennesaw, GA 30144 46-1852730 Newnan Nis, LLC 783 Bullsbroro Drive, Newnan, GA 30265 In addition, I have attached the names of sample employee's $$ amount differences in last month and missing a code or two. Brittany Daniels - Terminated Adrien Hemans - Active Andrew Londin - Terminated Dennis Yu - Active Denniston McKitty - Terminated Anthiny Martorano -Cobra AAron Theruaylt - Active David Garcia - Inactive Louis Diana - Terminated
          ramya.tantry Ramya Tantry (Inactive) logged work - 24/Nov/16 05:05 AM
          • Time Spent:
            0.5h
             

            Analysis of the sample employees cost and line 16 blank codes.

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ]
          Original Estimate 3h [ 10800 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ] 2.5h [ 9000 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 10336 [ 10336 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Mahendra Mungase,

          Please verify the EIN and address and re run reports for 2016.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Mahendra Mungase , Please verify the EIN and address and re run reports for 2016.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Mahendra Mungase [ mahendra.mungase ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          hi Ramya Tantry

          We have verified EIN and address on company and observed that bewlo EIN data does not match with given data in same ticket.So we have updated data as per given.

          Also we have run 1095C on Production and observed that all code combination are valid.

          Below EIN correction done on Production KPAG company

          461852730 Newnan Nis, LLC 783 Bullsbroro Drive, Newnan, GA 30265 | Lena Polston
          900889734 KPMC, LLC 9400 W. Atlantic Blvd, Coral Springs, FL 33071 | Cindy Morrow
          650511721 Union City Nissan, Inc 4080 Jonesboro Road, Union City, GA 30291 | Lena Polston
          273328876 South Atlanta Investments, Inc 4115 Jonesboro Road, Union City, GA 30291
          161725347 Nissan of South Atlanta, LLC 6889 Jonesboro Road, Morrow, GA 30260 | Lena Polston
          592317215 Page Brothers Associates, inc. 9400 W. Atlantic Blvd, Coral Springs, FL 33071 |Cindy Morrow

          Thanks

          Sachin Hingole Nandkumar Prabhakar Karlekar Ramya Tantry

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - hi Ramya Tantry We have verified EIN and address on company and observed that bewlo EIN data does not match with given data in same ticket.So we have updated data as per given. Also we have run 1095C on Production and observed that all code combination are valid. Below EIN correction done on Production KPAG company 461852730 Newnan Nis, LLC 783 Bullsbroro Drive, Newnan, GA 30265 | Lena Polston 900889734 KPMC, LLC 9400 W. Atlantic Blvd, Coral Springs, FL 33071 | Cindy Morrow 650511721 Union City Nissan, Inc 4080 Jonesboro Road, Union City, GA 30291 | Lena Polston 273328876 South Atlanta Investments, Inc 4115 Jonesboro Road, Union City, GA 30291 161725347 Nissan of South Atlanta, LLC 6889 Jonesboro Road, Morrow, GA 30260 | Lena Polston 592317215 Page Brothers Associates, inc. 9400 W. Atlantic Blvd, Coral Springs, FL 33071 |Cindy Morrow Thanks Sachin Hingole Nandkumar Prabhakar Karlekar Ramya Tantry
          mahendra.mungase Mahendra Mungase (Inactive) logged work - 25/Nov/16 05:16 AM
          • Time Spent:
            4h
             
            <No comment>
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Remaining Estimate 2.5h [ 9000 ] 0h [ 0 ]
          Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
          Worklog Id 10455 [ 10455 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Assignee Mahendra Mungase [ mahendra.mungase ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Jennifer Leugers,lisa davison,

          We observed that safe harbor is set to rate of pay for all ACA plans.So to calculate rate of pay,rate type and current rate is considered. If rate type is not present then we use gross annual salary for safe harbor cost calculation.

          Safe harbor codes will come only if employee cost is less than safe harbor cost.

          Below employees have missing line 16 code because ,these employees gross annual salary have been changed in month of Feb to 0.
          Brittany Daniels - Terminated
          Adrien Hemans - Active
          Dennis Yu - Active

          Andrew London - Terminated : EE was terminated in the month of March.So eligibility of minimum cost plan "United Healthcare Choice Plus HSA" ended on the day of termination.He was enrolled in "United Healthcare Choice Plus" plan till 3/31/2016.So for the March month,"United Healthcare Choice Plus" plan came up as minimum cost plan.So there are differences in amount in the last month.

          Same scenario of Andrew London is for Anthony Martorano -Cobra , Louis Diana - Terminated

          Below employees did not get line 16 code because, as per their gross annual salary, safe harbor cost is coming up less than employee cost.So no safe harbor codes are displayed.
          Denniston McKitty - Terminated
          Aaron THERIAULT - Active
          David Garcia - Inactive

          Above mentioned employees codes are correct as per the data in system. If codes are to be corrected for these employees please correct employees salary data or only codes can be corrected from ACA 1095C Correction tab in ACA Customization. Reports need to be re-run after code correction with apply user correction as Yes.

          We have re-run reports after the change of conditional offer.Please refer latest run for Verification. Also please refer to Mahendra's comment above for EIN changes done.

          CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , lisa davison , We observed that safe harbor is set to rate of pay for all ACA plans.So to calculate rate of pay,rate type and current rate is considered. If rate type is not present then we use gross annual salary for safe harbor cost calculation. Safe harbor codes will come only if employee cost is less than safe harbor cost. Below employees have missing line 16 code because ,these employees gross annual salary have been changed in month of Feb to 0. Brittany Daniels - Terminated Adrien Hemans - Active Dennis Yu - Active Andrew London - Terminated : EE was terminated in the month of March.So eligibility of minimum cost plan "United Healthcare Choice Plus HSA" ended on the day of termination.He was enrolled in "United Healthcare Choice Plus" plan till 3/31/2016.So for the March month,"United Healthcare Choice Plus" plan came up as minimum cost plan.So there are differences in amount in the last month. Same scenario of Andrew London is for Anthony Martorano -Cobra , Louis Diana - Terminated Below employees did not get line 16 code because, as per their gross annual salary, safe harbor cost is coming up less than employee cost.So no safe harbor codes are displayed. Denniston McKitty - Terminated Aaron THERIAULT - Active David Garcia - Inactive Above mentioned employees codes are correct as per the data in system. If codes are to be corrected for these employees please correct employees salary data or only codes can be corrected from ACA 1095C Correction tab in ACA Customization. Reports need to be re-run after code correction with apply user correction as Yes. We have re-run reports after the change of conditional offer.Please refer latest run for Verification. Also please refer to Mahendra's comment above for EIN changes done. CC: Nandkumar Prabhakar Karlekar , Sachin Hingole
          ramya.tantry Ramya Tantry (Inactive) logged work - 28/Nov/16 04:29 AM
          • Time Spent:
            0.75h
             

            Employee cost issue analysis and draft reply

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Time Spent 4.5h [ 16200 ] 5.25h [ 18900 ]
          Worklog Id 10536 [ 10536 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 5.25h [ 18900 ]
          Original Estimate 3h [ 10800 ] 6h [ 21600 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 5.25h [ 18900 ] 0.75h [ 2700 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Link This issue relates to WT-7247 [ WT-7247 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Closing the ticket as final forms are approved.
          Refer WT-7247 for more details

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Closing the ticket as final forms are approved. Refer WT-7247 for more details
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Hide
          lisadavison lisa davison added a comment - - edited

          Hello All,

          It appears we failed to generate a 1095 form for EE: Javel Wright. Dev can you determine why the record wasn't included on the 1095 reporting? Also, can we check to see if anyone else was affected.

          Show
          lisadavison lisa davison added a comment - - edited Hello All, It appears we failed to generate a 1095 form for EE: Javel Wright. Dev can you determine why the record wasn't included on the 1095 reporting? Also, can we check to see if anyone else was affected.
          lisadavison lisa davison made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          lisadavison lisa davison made changes -
          Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Smita Pawar,

          Can you please look into the query and advise.

          CC: Nandkumar Prabhakar Karlekar,Kumar Chhajed,Revansiddha Gaur,Sachin Hingole

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Smita Pawar , Can you please look into the query and advise. CC: Nandkumar Prabhakar Karlekar , Kumar Chhajed , Revansiddha Gaur , Sachin Hingole
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 20/Mar/17 10:50 AM - edited
          • Time Spent:
            3h
             

            Analysis
            Update Data from backend
            Verfiy Reports
            Internal discussion with Smita and Nandu

          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi lisa davison

          'Javel Wright' employee's EIN was blank in database.
          Currently we have updated dummy EIN for employess which were having blank EIN.
          We have created a new eligibility rule 'New Rule 17' and new 1095-C report as "1095-C New Report".
          Please refer latest run to download report.

          Note: Let us know required EIN for those employees which needs to be updated for those employees.
          Currently we have processed these employee under EIN 592317215

          Thanks,
          Smita

          FYI Nandkumar Prabhakar Karlekar, Revansiddha Gaur, Sachin Hingole,Kumar Chhajed

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi lisa davison 'Javel Wright' employee's EIN was blank in database. Currently we have updated dummy EIN for employess which were having blank EIN. We have created a new eligibility rule 'New Rule 17' and new 1095-C report as "1095-C New Report". Please refer latest run to download report. Note: Let us know required EIN for those employees which needs to be updated for those employees. Currently we have processed these employee under EIN 592317215 Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Revansiddha Gaur , Sachin Hingole , Kumar Chhajed
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) logged work - 20/Mar/17 01:19 PM
          • Time Spent:
            4h
             

            Analysis
            Report Rerun
            Internal discussion
            Draft
            Jira updated

          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 0.75h [ 2700 ] 0h [ 0 ]
          Time Spent 5.25h [ 18900 ] 9.25h [ 33300 ]
          Worklog Id 32370 [ 32370 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 9.25h [ 33300 ] 12.25h [ 44100 ]
          Worklog Id 32482 [ 32482 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Worklog Id 32482 [ 32482 ]
          lisadavison lisa davison made changes -
          Attachment screenshot-2.png [ 42854 ]
          Hide
          lisadavison lisa davison added a comment - - edited

          Dev,

          The assigned EIN is based on employee class 1 (dealership). I have listed the EIN's number per location below

          59-2317215 Page Brothers Associates, inc.
          59-2317213 Coral Springs Nissan, Inc.
          59-2413280 Coral Springs KGB, Inc.
          90-0889734 KPMC, LLC
          26-4055944 Nissan Of St Augustine, Inc
          52-2189209 West Street Motors, LLC
          65-0511721 Union City Nissan, Inc
          27-3328876 South Atlanta Investments, Inc
          16-1725347 Nissanof South Atlanta, LLC
          20-8110812 Town Center Investments, Inc
          46-1852730 Newnan Nis, LLC

          WT LOCATION CLASS

          also, I RAN A CENSUS report and noticed some employees with a EIN# 12345678- Can you also make sure these employees are assigned under the correct EIN#'s.

          thanks

          Show
          lisadavison lisa davison added a comment - - edited Dev, The assigned EIN is based on employee class 1 (dealership). I have listed the EIN's number per location below 59-2317215 Page Brothers Associates, inc. 59-2317213 Coral Springs Nissan, Inc. 59-2413280 Coral Springs KGB, Inc. 90-0889734 KPMC, LLC 26-4055944 Nissan Of St Augustine, Inc 52-2189209 West Street Motors, LLC 65-0511721 Union City Nissan, Inc 27-3328876 South Atlanta Investments, Inc 16-1725347 Nissanof South Atlanta, LLC 20-8110812 Town Center Investments, Inc 46-1852730 Newnan Nis, LLC WT LOCATION CLASS also, I RAN A CENSUS report and noticed some employees with a EIN# 12345678- Can you also make sure these employees are assigned under the correct EIN#'s. thanks
          lisadavison lisa davison made changes -
          Attachment screenshot-3.png [ 42855 ]
          Hide
          lisadavison lisa davison added a comment -

          Show
          lisadavison lisa davison added a comment -
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Kumar Chhajed [ kumar.chhajed ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi lisa davison,

          PFA file of employees without EIN.
          Please update the EIN in attached sheet.
          It will be very helpful for us to complete task correctly.

          In this file, 3 employee's are without class 1. Please update Class 1 data for these employees.
          Note: Sending password in separate mail.

          Thanks,
          Smita

          FYI Nandkumar Prabhakar Karlekar, Sachin Hingole, Kumar Chhajed,Revansiddha Gaur

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi lisa davison , PFA file of employees without EIN. Please update the EIN in attached sheet. It will be very helpful for us to complete task correctly. In this file, 3 employee's are without class 1. Please update Class 1 data for these employees. Note: Sending password in separate mail. Thanks, Smita FYI Nandkumar Prabhakar Karlekar , Sachin Hingole , Kumar Chhajed , Revansiddha Gaur
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment KPAG_EmployeesWithoutEIN.xls [ 43015 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) logged work - 23/Mar/17 01:30 PM
          • Time Spent:
            2.5h
             

            Analysis
            Internal discussion
            Draft
            Jira updates

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 12.25h [ 44100 ] 14.75h [ 53100 ]
          Worklog Id 33296 [ 33296 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Mar/17 01:45 PM
          • Time Spent:
            2h
             

            Analysis
            Internal discussion with smita

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 14.75h [ 53100 ] 16.75h [ 60300 ]
          Worklog Id 33309 [ 33309 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 23/Mar/17 09:00 PM
          • Time Spent:
            0.5h
             

            Internal discussion.

          lisadavison lisa davison made changes -
          Hide
          lisadavison lisa davison added a comment -

          Hello,

          Please review the spreadsheet with the updated EIN's. The first 3 employees in EBS / Workterra don't belong to Ken Page or in WT please remove.

          Show
          lisadavison lisa davison added a comment - Hello, Please review the spreadsheet with the updated EIN's. The first 3 employees in EBS / Workterra don't belong to Ken Page or in WT please remove.
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Kumar Chhajed [ kumar.chhajed ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 16.75h [ 60300 ] 17.25h [ 62100 ]
          Worklog Id 33411 [ 33411 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Hi lisa davison,

          We have updated the EIN of the employees as per the spreadsheet you have provided.
          FYI we are not running the reports as we saw that you have submitted the XML Submission for those reports and it can cause problem for IRS submission if we change the customization now.
          If you want those employees under the run then you can re-run the reports as we have updated their EIN from back-end.

          Let us know if you have any queries.
          CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi lisa davison , We have updated the EIN of the employees as per the spreadsheet you have provided. FYI we are not running the reports as we saw that you have submitted the XML Submission for those reports and it can cause problem for IRS submission if we change the customization now. If you want those employees under the run then you can re-run the reports as we have updated their EIN from back-end. Let us know if you have any queries. CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Smita Pawar
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] lisa davison [ lisadavison ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 24/Mar/17 12:37 PM
          • Time Spent:
            3h
             

            Analysis
            Update data from Back-end
            Internal discussion with Nandu
            Draft reply

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 17.25h [ 62100 ] 20.25h [ 72900 ]
          Worklog Id 33635 [ 33635 ]
          Hide
          lisadavison lisa davison added a comment -

          Kumar,

          the client has reported back for the following locations line 16 codes are missing. in quickly reviewing the examples provided, it appears line 16 is blank following the limited assessment period.

          Can you check the below locations and determine why line 16 is blank:

          Town Center Investments (dba Cobb County Kia)
          Newnan Nissan
          Nissan of Union City
          South Atlanta Investments (dba Toyota of Union City)
          Nissan of South Atlanta

          Example Employees:
          David Jech
          Chance Drake
          Bonnie Mullinax
          Gabriell
          Malik Grant
          James lOVINS

          tHANKS

          Show
          lisadavison lisa davison added a comment - Kumar, the client has reported back for the following locations line 16 codes are missing. in quickly reviewing the examples provided, it appears line 16 is blank following the limited assessment period. Can you check the below locations and determine why line 16 is blank: Town Center Investments (dba Cobb County Kia) Newnan Nissan Nissan of Union City South Atlanta Investments (dba Toyota of Union City) Nissan of South Atlanta Example Employees: David Jech Chance Drake Bonnie Mullinax Gabriell Malik Grant James lOVINS tHANKS
          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Kumar Chhajed [ kumar.chhajed ]
          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Smita Pawar Please look into this. CC Nandkumar Prabhakar Karlekar Revansiddha Gaur Ramya Tantry Sachin Hingole
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Time Spent 20.25h [ 72900 ] 21.75h [ 78300 ]
          Worklog Id 44286 [ 44286 ]
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi lisa davison,

          I have checked these employes and their salary data is not available into the Workterra System.

          Thanks,
          Nandkumar

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi lisa davison , I have checked these employes and their salary data is not available into the Workterra System. Thanks, Nandkumar
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          Hide
          lisadavison lisa davison added a comment -

          for informational purposes, why does salary matter?

          Show
          lisadavison lisa davison added a comment - for informational purposes, why does salary matter?
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 11/May/17 12:08 AM
          • Time Spent:
            1.5h
             

            Salary is not loaded for these empoyees

          lisadavison lisa davison made changes -
          Assignee lisa davison [ lisadavison ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 12/May/17 01:09 AM
          • Time Spent:
            1h
             
            <No comment>
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

          Hi lisa davison,

          line 16 will get code 2C if employee is enrolled in ACA plan else system will write safe harbor codes.

          To calculate safe harbor codes, we need to calculate 9.66% salary and offered cost.
          If offered cost is less then 9.66% salary then system will write the safe harbor code else it will be blank.

          1095 c PDF has the detail explanation for the same for more information you can refer the 1095 c PDF.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited Hi lisa davison , line 16 will get code 2C if employee is enrolled in ACA plan else system will write safe harbor codes. To calculate safe harbor codes, we need to calculate 9.66% salary and offered cost. If offered cost is less then 9.66% salary then system will write the safe harbor code else it will be blank. 1095 c PDF has the detail explanation for the same for more information you can refer the 1095 c PDF.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Time Spent 21.75h [ 78300 ] 22.75h [ 81900 ]
          Worklog Id 46479 [ 46479 ]
          Hide
          lisadavison lisa davison added a comment -

          Hey Nandkumar,

          Sorry for the delay the client just responded. Per the client request for those with blank line 16, can we code them from the back end using 2H for those that did not elect coverage, 2C for those you did elect coverage?

          Show
          lisadavison lisa davison added a comment - Hey Nandkumar, Sorry for the delay the client just responded. Per the client request for those with blank line 16, can we code them from the back end using 2H for those that did not elect coverage, 2C for those you did elect coverage?
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          If required take the help of Kumar Chhajed

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - If required take the help of Kumar Chhajed
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Assignee Nandkumar [ satyap ] Smita Pawar [ smita.pawar ]
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi lisa davison,

          This task can be done from UI also.
          Below mentioned are the steps to complete this.

          1.Edit company & Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> IRS report
          2.Edit required 1095-C report & Click on Show run to Download data analysis report.
          3.Filter those employees with line 16 code as blank
          4.Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> ACA Customization
          5.Click on ACA 1095C corrections tab.
          6.Click on Download Specifications. Select '1095C Import - PART II' sheet.
          7.Prepare import file with correction codes using specification for those employee having Line 16 code as blank to import data
          8.Import data by navigating to Home >> Company Home >> Manual Import/Export by using template 'ACA Correction 1095 C Part II SSN'
          9.Rerun the 1095-C report by setting User Correction to YES.

          With these steps corrections will get reflected on 1095-C report. Let us know if you need any additional information.

          CC: Jennifer Leugers,Nandkumar Prabhakar Karlekar,Rakesh Roy,Sachin Hingole,Yogesh Chaudhari,Revansiddha Gaur

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi lisa davison , This task can be done from UI also. Below mentioned are the steps to complete this. 1.Edit company & Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> IRS report 2.Edit required 1095-C report & Click on Show run to Download data analysis report. 3.Filter those employees with line 16 code as blank 4.Navigate to Home >> Company Home >> BenAdmin Home >> BenAdmin Company Home >> ACA >> ACA Customization 5.Click on ACA 1095C corrections tab. 6.Click on Download Specifications. Select '1095C Import - PART II' sheet. 7.Prepare import file with correction codes using specification for those employee having Line 16 code as blank to import data 8.Import data by navigating to Home >> Company Home >> Manual Import/Export by using template 'ACA Correction 1095 C Part II SSN' 9.Rerun the 1095-C report by setting User Correction to YES. With these steps corrections will get reflected on 1095-C report. Let us know if you need any additional information. CC: Jennifer Leugers , Nandkumar Prabhakar Karlekar , Rakesh Roy , Sachin Hingole , Yogesh Chaudhari , Revansiddha Gaur
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] lisa davison [ lisadavison ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          smita.pawar Smita Pawar (Inactive) logged work - 07/Aug/17 02:13 PM
          • Time Spent:
            2h
             

            Analysis
            Internal discussion
            Jira updates

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 22.75h [ 81900 ] 24.75h [ 89100 ]
          Worklog Id 69808 [ 69808 ]
          Hide
          mandark Mandar Kulkarni (Inactive) added a comment -

          Hi lisa davison,
          I am marking this ticket as closed for now. Feel free to reopen in case any further action expected on this. Thanks.

          -----------------------------------------------------
          CC: Vijay Siddha, Satya, Jaideep Vinchurkar

          Show
          mandark Mandar Kulkarni (Inactive) added a comment - Hi lisa davison , I am marking this ticket as closed for now. Feel free to reopen in case any further action expected on this. Thanks. ----------------------------------------------------- CC: Vijay Siddha , Satya , Jaideep Vinchurkar
          mandark Mandar Kulkarni (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          mandark Mandar Kulkarni (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          Open In Progress
          3d 20h 43m 1
          Ramya Tantry (Inactive) made transition -
          In Progress Open
          20m 48s 2
          Ramya Tantry (Inactive) made transition -
          Open Waiting for Customer Input
          3h 14m 2
          lisa davison made transition -
          Closed Reopen
          49d 11h 37m 1
          Smita Pawar (Inactive) made transition -
          Reopen In Progress
          2d 20h 29m 1
          Smita Pawar (Inactive) made transition -
          In Progress Waiting for Customer Input
          47d 22h 2m 3
          Smita Pawar (Inactive) made transition -
          Waiting for Customer Input In Progress
          160d 18h 43m 5
          Mandar Kulkarni (Inactive) made transition -
          In Progress Resolved
          45d 19h 34m 2
          Mandar Kulkarni (Inactive) made transition -
          Resolved Closed
          10s 2

            People

            Assignee:
            lisadavison lisa davison
            Reporter:
            kumar.chhajed Kumar Chhajed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Production Due Date:

                Time Tracking

                Estimated:
                Original Estimate - 6h Original Estimate - 6h
                6h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 24.75h
                24.75h