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

Please run 2016 1095C for SBM

Hi Jennifer Leugers,

We have run "2016 1095C for SBM" report. Please refer latest run for verification.

As Employee count is high,analysis report will not be downloaded from UI.I am sending you SBM analysis report in separate mail.
NOTE: As no plans are marked self insured, Covered individual part is not present in analysis report.

CC: Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi Jennifer,

Please see the attached excel where you can fill the appropriate values as per class and date range which will reflect on 1095c report[sheet name :SBM].
As per our understanding all the union employee will get the 1H 2E Codes.

OR
This patch is already deployed on production so Please configure the values on below page and let us know so we will run the SBM 1095 c tomorrow.
See the video uploaded video for more details how to configure this requirement : Classwise Cost configuration .mp4.

FTP Path : /users/workterraaca/ACA Setup Demo

Hi Jennifer Leugers,

As per your mail communication, we have created a new rule as Union Benefits, selected this rule under Multi employer rule and furnished the forms. Union Benefits rules contains the union classes mentioned in the excel sheet.
1H-2E will be displayed for employees only for those months which satisfy the Union Benefits rule.
Please download the latest run for verification.

NOTE: If you refer code analytics tab (line 22 part) of Analysis report, you can see that these group is not providing MEC for all 12 months. Informing you this so as to avoid any last minute changes on 1095C and 1094C

All - these forms are still not right. They are including part-time in the run even though that class is not selected. The rates that are showing up are also not correct.

Example - Milagros Acosta is showing $140 for months January through May and then $164.67 for months June through December. When I do a QE for this employee for June 1, the lowest cost plan is $63.29 per pay period, or $126.58 per month.

Also - the Excel file is too large for us to download. It is over 65,000 lines which our Excel will not allow.

We need to get all items fixed ASAP for this group. They were expecting a final run last Friday.

Hi Jennifer Leugers

This is a customization issue because aca is configured as use annual salary and the WORKTERRAis configured as use benefit salary on medical rate.

So suggest which salary need to use on ACA.Please confirm ASAP.

Hi Jennifer Leugers,

We have resolved the rates issue and re -run the reports with the existing customization.
Please refer latest run for verification.
We will be providing you with the analysis report in separate mail.

Smita Pawar: Please provide the analysis report and also break down the files so that they can be uploaded.

Hi Jennifer Leugers,

We have completed 'SBM 1095C PDF' task.
PDF files and Data analysis report are uploaded on FTP.

Below mentioned are details to download files.

URL: https://ftpsecure.ebsbenefits.com/thinclient/Transfer.aspx
Path: /users/workterraaca/SBM 1095 C/01102017

Let us know if you need any additional information.

Thanks,
Sachin Hingole

SBM - Please look at this tonight.

1. From January 1, 2016 – May 31, 2016, SBM was using the W2 safe harbor. Employee monthly premium contributions were 9.5% of gross hourly pay. Then beginning June 1, 2016 – December 31, 2016, SBM used the rate of pay safe harbor. It appears from my first glance at the revised forms that you show W2 safe harbor for the entire year.

2. Because we used the W2 safe harbor for the first half of last year, employees who earned less than $11.33 per hour, would not have paid the entire $140 employee monthly contribution. (Please see Brude Abathan’s 1095 C Form).

Jennifer Leugers
Lorena.Nava@ebsbenefits.com

Hi Cathleen Harrington,

1.The forms where using W2 safe harbor as it was set on ACA Customization.
We have updated the forms to show 2H(Rate of Pay) from June 1, 2016 – December 31, 2016.Please refer latest run for verification.

2. We are not clear on what exactly should be the cost of EE who earned less than $11.33 per hour and would not have paid the entire $140 employee monthly contribution.
We will discuss this in call.

Smita Pawar:Please provide the analysis report and also break down the files so that they can be uploaded.

CC: Jennifer Leugers,Lorena.Nava@ebsbenefits.com,Nandkumar Prabhakar Karlekar,Sachin Hingole

Hi Cathleen Harrington

We have completed refurnishing of 'SBM 1095C PDF ' task .
PDF files and Data analysis report are uploaded on FTP.

Below mentioned are details to download files.

URL: https://ftpsecure.ebsbenefits.com/thinclient/Transfer.aspx
Path: /users/workterraaca/SBM 1095 C/01122017

Let us know if you need any additional information.

Thanks,
Smita

CC Jennifer Leugers,Lorena.Nava@ebsbenefits.com,Sachin HingoleNandkumar Prabhakar Karlekar

SBM
1. Ran the Consolidation file.
2. System error encountered.

I do not want to re-run the Consolidation file as it may cause a problem. This is a large file. Screen shot attached to show the error I received. SBM System Error on Consolidated report run.pdf

Jennifer LeugersLorena.Nava@ebsbenefits.com

Hi Cathleen Harrington,

We have run the consolidated download and it is available for download.
You can download the file by clicking on download icon of Download Consolidated Zip File column.
Refer -

Let us know if you have any queries.

CC - Nandkumar Prabhakar Karlekar Ramya Tantry