Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP Year-End Release 2015: Affordable Care Act (ACA)

Terry R Heley Profile Picture Terry R Heley Microsoft Employee

For Your Information…IRS Extends Due Dates for New 2015 Information Reporting Requirements

On Dec. 28, the IRS extended the due dates for new health care information reporting forms in 2016.   Insurers, self-insuring employers, other coverage providers, and applicable large employers now have additional time to provide health coverage information for 2015 to individual taxpayers and the IRS.  Providers and certain employers must now furnish individuals with either Form 1095-B or 1095-C by March 31, 2016.  The due dates for issuers filing these forms and the associated Form 1094 with the IRS are May 31, 2016 for paper filers and June 30, 2016 for electronic filers.

Due to these extensions, some individual taxpayers may not receive a Form 1095-B or Form 1095-C by the time they are ready to file their 2015 tax return. While the information on these forms may assist in preparing a return, they are not required. Like last year, taxpayers can prepare and file their returns using other information about their health insurance.  Individuals do not have to wait for their Form 1095-B or 1095-C in order to file. 

Link to complete article on IRS website

https://www.irs.gov/Affordable-Care-Act/Individuals-and-Families/The-Affordable-Care-Act-Whats-Trending

 

***UPDATE***
We have noticed once you install the 2015 year end update and create the year end wage file, the print 1095-C routine is printing all employees instead of just employees with amounts.  Below is a script you can run to remove those records of zero from the year end table.  If you recreate the year end wage file, this will need to be run again.  This will be fixed in a future release.

delete from upr10111

where (MonthofCost_1='0' AND MonthofCost_2='0' AND MonthofCost_3='0' AND MonthofCost_4='0'and

MonthofCost_5='0' AND MonthofCost_6='0' AND MonthofCost_7='0' AND MonthofCost_8='0' AND

MonthofCost_9='0' AND MonthofCost_10='0' and MonthofCost_11='0' AND MonthofCost_12='0' AND

MonthofCoverage_1='0' and MonthofCoverage_2='0' and MonthofCoverage_3='0' and MonthofCoverage_4='0'and

MonthofCoverage_5='0' AND MonthofCoverage_6='0' AND MonthofCoverage_7='0' AND MonthofCoverage_8='0' AND

MonthofCoverage_9='0' AND MonthofCoverage_10='0' AND MonthofCoverage_11='0' AND MonthofCoverage_12='0')

and YEAR1='2015'

Now that Microsoft Dynamics GP 2015 and Microsoft Dynamics GP 2013 U.S. Year-End Updates have all shipped, click HERE, we can now get down to business! 

This topic has been on many of your minds and honestly a thorn in our side.

I have lots of documentation already publically available to you that goes through what needs to be done.

There were MANY changes in the year end update for ACA, so if you are going to track ACA in our system, it is MANDATORY... :-) that you install the year end update to co-inside with all the changes.

A few that I would like to call out that we are getting questions on:
(but it is all documented in detail in my ACA 2015 year end doc below)

1. After the update we are now tracking lowest cost premium and the date change of the premium.  Just like we do with the ACA codes.  This is important and I would recommend you to install the update, put your Microsoft Dynamics GP user date back to 1/1/2015 and from the setup, roll down the monthly lost cost premium on your plans to the employees.  This should then report correctly in box 15.

2. You DO NOT need to order/purchase the 1095-C and 1094-C forms, we will be printing the forms with the lines and the instruction page that goes with the 1095-C.  You will still however need to order your W-2 forms and Payables 1099 forms....I know, you were hoping right?

3. Check out the table changes that were made in the year end update, some related to ACA. Click HERE

4. Changes made to printing of dependents when you are not a self-insured plan.

5. Microsoft will not create the electronic file if you are over 250 employees.  There are ISV products that will, please review my detailed document below if you need this functionality.

6. Employees that do not have wages may still get a 1095-C we wanted this condition so customers that did not use our Payroll product could still create ACA forms.

 

Click HERE for a VIEW I created of the ACA tables that you can run in SmartList Designer.

Click HERE for the latest ACA documentation for the 2015 year and all changes in the update in detail.

Click HERE for a 2014 year end document that covers reconcile Payroll information to Human Resource to start to set up Benefits in Human Resource as ACA required Human Resource.
Click HERE to view the 1095-C form with my sample data of multiple dependents and instructional page.
Click
HERE for the IRS instructions.
Click
HERE for an ACA overview VIDEO with all year end changes included!!!!

****NOTE****

After installing the 2015 Year-End Update on GP 2015 only the Human Resource Enrollment ACA field has a missing label.  I have modified the window to add the label back if you want you can download and import this new form and set security to it.  Click HERE for the form
Copy this package file to a shared location, import the form

  1. Go to Microsoft Dynamics GP >> Tools >> Customize > Customization Maintenance, click Import and import the package file you downloaded above.

  2. Go to Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Alternate/Modified Forms and Reports

    1. Select the Alternate/Modified Forms and Reports ID used by the end user(s)

    2. Select a product of Human Resources.

    3. Select a Type of Windows

    4. Expand 3rd party, expand Health Insurance Enrollment and choose ‘Human Resources (Modified)’

  3. Save the changes and confirm the window appears as expected.

 Everyone have a wonderful year end with all your W-2, 1095-C and payroll reporting needs.

Terry Heley, working hard for you,

Escalation Engineer - Microsoft
theley@microsoft.com


Comments

*This post is locked for comments

  • Deb@gpsupport Profile Picture Deb@gpsupport 112
    Posted 17 Mar 2022 at 19:01:47
    I have a client on 18.4.1343 and when they print the 2021 1095-C it still prints all employees since the beginning of time in GP (like 2000 documents for 168 employees active in 2021). How do we get rid of the old ones?
  • TamiCampbell Profile Picture TamiCampbell 19
    Posted 19 Jan 2017 at 21:46:45

    I am still seeing this issue on the GP 2016 R2 Year-End Update.

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 13 Jul 2016 at 20:25:34

    I cannot BELIEVE that the fact that ACA electronic filing is not supported in Microsoft Dynamics GP 2013 was not made BLATANTLY obvious from the start!!!!!  This really makes me angry!!!!!

    When/where/how did Microsoft ever relay this fact to its customers?

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 24 Mar 2016 at 14:18:02

    I created the views and the smartlist but I get no results when I run it.  Any suggestions?

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 08 Mar 2016 at 18:57:09

    I have the same question as Jae Chang.  Only the first page of the 1094C form is printing.  I see line 19 box is not marked, therefore I guess maybe this is the culprit.  How do I line 19 box marked in GP?

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 04 Mar 2016 at 22:35:51

    This is GREAT information....better than my IT support company (which is a MS partner) can provide me.   I listened to the video, but I still can't figure out why only the first page of my 1094-C is printing (page 2 is not printing).

  • Jae Chang Profile Picture Jae Chang 2,305
    Posted 24 Dec 2015 at 03:07:19

    GP's 1094-C form only prints the first page(Part 1 and Part 2), but the 1094-C form from the IRS site has three pages that go to Part4. I'm assuming it is because GP does not grab the data from the 1095-C's it generates? Can someone confirm why Part 3 and Part 4 are not included in GP?

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 17 Dec 2015 at 19:45:43

    Like Jae, I have a question about printing the 1095-C's.  The form is not one that will work in an envelope.  Will the form print with the address/return address on the top half of the page and the 1095-C document at the bottom?

  • Community Member Profile Picture Community Member Microsoft Employee
    Posted 15 Dec 2015 at 20:17:11

    In order to do all of this do I have to install the HR Module, I am currently on Microsoft Dynamics 2013 and I have the payroll module installed only.  Thank you

  • Jae Chang Profile Picture Jae Chang 2,305
    Posted 04 Dec 2015 at 18:57:34

    Hello,

    How do we mail the 1095-C's out to the employees? Should we be including these in the W2 envelopes? The form is not formatted so that envelope mailing is possible.