-
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
- clones
-
-
- Closed
-
Smita Pawar (Inactive)
created issue -
Smita Pawar (Inactive)
made changes -
Smita Pawar (Inactive)
made changes -
| Description | All companies are linked to this Jira which will get processed for IRS submission in year 2018 |
Smita Pawar (Inactive)
made changes -
| Company | All Clients/Multiple Clients [ 18434 ] | Ken-Ton [ 10483 ] |
Smita Pawar (Inactive)
made changes -
| Account Executive | Tracy Kot [ tkot ] |
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Smita Pawar [ smita.pawar ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Ramya Tantry [ ramya.tantry ] |
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.
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 Ramya Tantry (Inactive)
logged work - 28/Dec/17 07:52 AM -
- Time Spent:
- 4h
-
Analysis
Verify ACA Customization
Run report
Test sample PDF
Analysis report verification
Ramya Tantry (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 4h [ 14400 ] | |
| Worklog Id | 98227 [ 98227 ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Ramya Tantry [ ramya.tantry ] | Jennifer Leugers [ jennifer.leugers ] |
Ramya Tantry (Inactive)
made changes -
| Status | Open [ 1 ] | Waiting for Customer Input [ 10500 ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 4h [ 14400 ] | 4.25h [ 15300 ] |
| Worklog Id | 98384 [ 98384 ] |
Hi all - client has approved their forms; please re-run final. thanks!
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
Sachin Hingole (Inactive)
made changes -
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Jennifer Leugers [ jennifer.leugers ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 4.25h [ 15300 ] | 6.25h [ 22500 ] |
| Worklog Id | 100636 [ 100636 ] |
-
- Time Spent:
- 2h
-
Eligibility process run & report run , verification,reply.
-
- Time Spent:
- 1h
-
tried to find out the cause of issue.
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.
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Ramya Tantry [ ramya.tantry ] |
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
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 Ramya Tantry (Inactive)
made changes -
| Status | In Progress [ 3 ] | Open [ 1 ] |
Ramya Tantry (Inactive)
logged work - 18/Jan/18 12:46 PM -
- Time Spent:
- 3h
-
Analysis and discussion
report run and verification
Ramya Tantry (Inactive)
made changes -
| Time Spent | 6.25h [ 22500 ] | 9.25h [ 33300 ] |
| Worklog Id | 100940 [ 100940 ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Ramya Tantry [ ramya.tantry ] | Jennifer Leugers [ jennifer.leugers ] |
Ramya Tantry (Inactive)
made changes -
| Status | Open [ 1 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 9.25h [ 33300 ] | 10.25h [ 36900 ] |
| Worklog Id | 101020 [ 101020 ] |
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!
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
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
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Jennifer Leugers [ jennifer.leugers ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
-
- Time Spent:
- 2.5h
-
Report run,comparison report upload,draft reply.
Hi all - client has updated some employee addresses; please re-run final forms. Thanks!
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Smita Pawar (Inactive)
logged work - 24/Jan/18 01:47 PM -
- Time Spent:
- 0.75h
-
Analysis
Jira updates
Report rerun
draft
Hi Jennifer Leugers,
We have rerun '2017 1095C' report.
Please refer latest run '1/24/2018 3:31:52 AM'to download.
Thanks!
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! Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Smita Pawar (Inactive)
made changes -
| Time Spent | 10.25h [ 36900 ] | 11h [ 39600 ] |
| Worklog Id | 101866 [ 101866 ] |
| Time Spent | 11h [ 39600 ] | 13.5h [ 48600 ] |
| Worklog Id | 102235 [ 102235 ] |
| Status | Waiting for Customer Input [ 10500 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Waiting for Input [ 11502 ] |
| Workflow | WB - Workterra BenAdmin Support workflow [ 65402 ] | 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65803 ] |
Closing this ticket
| Resolution | Done [ 10000 ] | |
| Status | Waiting for Input [ 11502 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Ramya Tantry (Inactive)
made transition
-
|
13h 4m | 1 |
Ramya Tantry (Inactive)
made transition
-
|
27d 2h 55m | 2 |
|
20d 11h 23m | 3 |
|
2h 19m | 2 |
|
46d 13h 54m | 1 |
|
2m 27s | 1 |
|
1m 59s | 1 |
|
48d 22h 13m | 1 |
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!