-
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
-
Reported by:Support
-
Company:KPAG
-
Module:ACA
Attached is the spreadsheet for Ken-Page - South Atlanta Investments missing 1095c forms
Nandkumar Prabhakar Karlekar
Yogesh Chaudhari
Hello - I just added the spreadsheet for Ken-Page - South Atlanta Investments misc 1095c changes. Some of the changes involve splitting out ee 1095c between 2 entities creating 2 forms per employee. For example Jan-June EE worked at Newnan Nissan and July-Dec South Atlanta Investments. Please let me know if you have any questions. Password remains the same.
Sachin Hingole
The corrections are done.
Please verify with latest run.
Please verify IRS submission,1094C report.
If not present please create the reports and verify the submission and part 3 of 1094c report.
In case of issue please assign to Revan
CC - Sachin Hingole Nandkumar Prabhakar Karlekar Yogesh Chaudhari
We have download latest run - " 1095C South Atlanta Investments Inc - 6/29/2016 10:04:30 AM" We have verified missing employee list from"South Atlanta Investments 1095c missing forms.xlsx" with latest run and observed that below employee is still missing,
Below is the missing employee list
Duane Straguhter
Hailee Chappell
Frederick Stephens
Larry Lewis
Ricardo Ponce
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Dijon Howze
Eddie Wynn
Ramona Warren
Tanya Foster
Wascar Santos
Albert Wilson
Chandy Khiev
Christopher Barrios
Ciarra Lopez
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Please do the needful and let us know
Thanks,
Mahendra
Below is the missing employee list from Tab -"MISSING W OFFER"
Albert Wilson
Chandy Khiev
Christopher Barrios
Ciarra Lopez
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Please look into this.
CC- Sachin Hingole Nandkumar Prabhakar Karlekar
We have verified below employee's 1095C with shared excel sheet -"South Atlanta Investments 1095c ACA Dev Corrections-1.xls". We used latest download - " 1095C South Atlanta Investments Inc - 6/29/2016 10:04:30 AM"
Below employee codes are correct as per above sheet.
Annissa Carter
Benadette Thomas-Britt
James Hill
Khoi Vu
Leila Lane
Ronnie Dorsey
Tristan Johnson
Below employee codes is correct or not in sheet - Jennifer Leugers
1.Cleveland Tubbs - 1/1/15-8/1/15 -1H 245.09 2H
2.Cynthia Vega - 1H 101.81 2H - Need to Check expected code.On 1095C line 16 is
blank for 06/01- 08/01
1H 99.38 2H - Need to Check expected code.On 1095C line 16 is
blank for 09/01- 12/01
3.Kacey Evans - 1/1/15-8/1/15 1H 186.81 2H code combination submitted in sheet
Please review the same and add your comments.
Thanks,
Mahendra
Please see below corrections
Below employee codes is correct or not in sheet - Jennifer Leugers
1.Cleveland Tubbs - 1/1/15-8/1/15 -1E 245.09 2H
2.Cynthia Vega - 1E 101.81 2H - Need to Check expected code.On 1095C line 16 is
blank for 06/01- 08/01
1E 99.38 2H - Need to Check expected code.On 1095C line 16 is
blank for 09/01- 12/01
3.Kacey Evans - 1/1/15-8/1/15 1E 186.81 2H code combination submitted in sheet
Mahendra Mungase Chris Finocchio
I have done analysis of above employees. 1095C forms for many employees is not generated due to invalid combination of Class1 and EIN values. We have to correct EIN or class1 values for these employees to generate 1095C forms. I have attached file KPAG_Employee_1095C_Details.xls to the JIRA WT-3291 contains list of all the employee whose 1095C is not generated.
Yogesh Chaudhari
Mahendra Mungase
Were you able to make the corrections below based on my changes?
Please see below corrections
Below employee codes is correct or not in sheet - Jennifer Leugers
1.Cleveland Tubbs - 1/1/15-8/1/15 -1E 245.09 2H
2.Cynthia Vega - 1E 101.81 2H - Need to Check expected code.On 1095C line 16 is
blank for 06/01- 08/01
1E 99.38 2H - Need to Check expected code.On 1095C line 16 is
blank for 09/01- 12/01
3.Kacey Evans - 1/1/15-8/1/15 1E 186.81 2H code combination submitted in sheet
Chris Finocchio Nandkumar Prabhakar Karlekar
As we discuss, I have made correction for below 2 employees
1.Cleveland Tubbs
2.Kacey Evans
For employee Cynthia Vega, we will to create 2 1095C forms so Ramya Tantry will make the required changes and generate 1095C forms.
Sachin Hingole,Mahendra Mungase
I have done the changes.
Please re-run and verify.
CC - Jennifer Leugers Sachin Hingole Nandkumar Prabhakar Karlekar
We have re run the - 1095C South Atlanta Investments Inc - 6/29/2016 11:40:47 PM. Download latest run, as mentioned in same JIRA. Review the below employee code and observed that it is correct.
1.Cleveland Tubbs
2.Cynthia Vega
@Ramya - Below EE Line 15 amount is incorrect
Kacey Evans - Expected - 1/1/15-8/1/15 - 186.81 Actual - 245.09
Incorrect 1095C for below employee
Deltiwon Harris
Thanks,
Mahendra
Hi Ramya Tantry
CC- Sachin Hingole Nandkumar Prabhakar Karlekar
We have run the below reports and verify below mentioned EE.
1095C Town Center Investments Inc -6/30/2016 4:37:33 AM
Below employee code is correct
Cynthia Vega - Correct
Taylor Kemper - Correct
1095C Union City Nissan Inc - 6/30/2016 12:51:44 AM
Below is my observation
Bernadette Thomas-Britt - Incorrect cost on Line 15 Expected - 101.81 Actual - 101.81,102.81,103.81 etc
Cleveland Tubbs - Incorrect code on 1095C Expecetd - 1/1/15-8/1/15 1H Blank 2A
9/1/15-12/1/15 1E 99.38 2C
Kacey Evans - Incorrect code on 1095C Expecetd - 1/1/15-10/1/2015 1H Blank 2A
Leila Lane - Correct
Ronnie Dorsey - Correct
Sakeem McMillan , Tristan Johnson - 1H 2A for all 12 months -So 1095C is not generated
1095C Newnan Nis LLC 6/30/2016 1:40:34 AM
Below employee code is correct
Deltiwon Harris
Taylor Buckholtz
Tiffany Little
Thanks,
Mahendra
I have done the corrections as mentioned in your comment.
Please refer to Chris's excel sheet (20937_KPAG+Invalid+codes+provided CF.xlsx) added in WT-3291 and verify those too.
CC- Sachin Hingole Nandkumar Prabhakar Karlekar Yogesh Chaudhari Jennifer Leugers
After correction we re run the below 1095C and observed that issues raised by us has fixed.Please see below my comments in line.
1095C South Atlanta Investments Inc - 6/30/2016 3:14:56 AM
Kacey Evans - Expected - 1/1/15-8/1/15 - 186.81 - Issue does not exist and 186.81 is now showing
Now correct 1095C for below employee is generated
Deltiwon Harris
===================================
1095C Union City Nissan Inc - 6/30/2016 4:13:24 AM
Issue for below EE is fixed
Bernadette Thomas-Britt
Cleveland Tubbs
Kacey Evans
====================================
Hi Jennifer Leugers -
We observed that below EE 1095C did not get generated.As they did not satisfy the rule condition used in "1095C South Atlanta Investments Inc" report
Duane Straguhter
Hailee Chappell
Frederick Stephens
Larry Lewis
Ricardo Ponce
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Dijon Howze
Eddie Wynn
Ramona Warren
Tanya Foster
Wascar Santos
Albert Wilson
Chandy Khiev
Christopher Barrios
Ciarra Lopez
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Albert Wilson
Chandy Khiev
Christopher Barrios
Ciarra Lopez
Gwinnette McKan
Edwardo Mendez
Jessica Jordan
Karol Milner
Linda Blash
Raven Ratliffe
Terrell Tillman
Please review the same and let us know.
Thanks,
Mahendra.
Hi Ramya Tantry
Cynthia Vega - Code is incorrect when we compared 1095C with your mentioned shared sheet in WT-3291
Thanks,
Mahendra
Cynthia Vega falls in 2 reports. The codes mentioned are for both the reports.Please refer previous excel which contains the original codes of this employee.
We already check this Cynthia Vega and observed it's code is correct.
Nandkumar Prabhakar Karlekar
Yogesh Chaudhari
Missing 1095c forms for Ken Page - South Atlanta investments