Microsoft Dynamics GP Year-End Update 2021: Affordable Care Act (ACA)

For the 2021 year, the ACA form, 1095-C was published late and did not make it in the US Year-End Update in November 2021.  The form and code changes will be in the January 2022 Hotfix due to release mid-January 2022.

If you are going to print the form in Dynamics GP you will need to install the January Hotfix.

Check out the ACA VIDEO and SLIDES for setup and ACA troubleshooting.

Here are the list of items you need to be aware of that changed for the 2021 year and ACA reporting.

***Make sure you are printing the ORIGINAL form and you do not have security set to an older modified version of the 1095-C form***

1.  The due date for furnishing Form 1095-C to individuals is March 2, 2022.

2. Instructions changed on the 1095-C form, page 2 and page 4.  Updates were also made to the instruction page to print more clearly.

3. Box 14 added 2 new codes 1T and 1U for completing the 1095-C form.

1T. Individual coverage HRA offered to employee and spouse (no dependents) with affordability determined using employee's primary residence location ZIP code.
1U. Individual coverage HRA offered to employee and spouse (no dependents) using employee's primary employment site ZIP code affordability safe harbor.

4. The Plan Start Month was required started with the 2020 year.  We made some modifications to this in the 2021 year.  It will no longer calculate as the "employee" plan start month but Employer plan start month.  
Plan Start Month should indicate the beginning of the plan year for the health plan that was offered to the employee. For example, if an employer’s plan year begins in January for all of its employees, the employer will complete the plan start month box for all of its Forms 1095-C with 01. However, if an employer’s plan year operates on a fiscal year of July through June for all of its employees, the employer will complete the plan start month box for all its Forms 1095-C with 07.

We also added this as a field in the Print W-2 window for you to populate to print on the forms.                          

5. As prior years, the Employee's Age will be calculated and printed on the form.  If the employee date of birth is not populated on the employee record, the age will not calculate correctly, see below example.
The age will be calculated on the fly when you print the 1095-C form, it is not stored when you create the year end wage file.  It takes the year the year end wage file is created minus birthday year.
The employee birth date is stored under the Additional Information window from the main employee maintenance record, table UPR00100 field brthdate

select brthdate, * from UPR00100

6. Changes were made in the system to ONLY print the dependents page 3 when Employer provided self-insured coverage is MARKED in the Print W-2 window. (Prior it would print page 3 all blank when some customers do not use this form)

Below I have still listed some of our top items we get in support to help you, but the main change this year are listed above.

1. Inactive employees -
With how the ACA rules changed, now you cannot leave a box blank/empty, so when employee Joe leaves the company, what customers do is put 2A in Box 16 - meaning Employee not employed during the month. 

Remember, it is when you click the PRINT button for the 1095-C form, if an employee is 2A for all 12 months, the form will not print.  I feel this is a great indicator to go by.  You will see the employees get compiled in the year end, (incase you need to edit this employee and make changes to the record) but when you go to print, those employees will not be included.

If you did not get all your employees / codes set correctly, here is a nice script that will remove all inactive employees for you:

2. Multiple insurance plans (dental and vision examples) dishevel the 1095-C reporting.
As I painfully worked with customers on this reporting YOY another area that was causing ACA data inconsistencies was insurance codes that are non ACA reportable, such as Vision or Dental as an example.  If I had a health insurance code that did not change all year, then I added Dental, we would grab that "None" record as that was the newest record for the year.  How we decided to "identify" true ACA recordable codes is from the Health Insurance Setup on the Human Resource side. The field we will use to determine if the code is ACA recordable is at the Setup, None and None.  Then we will not include this code when we create the year end wage file.

Most of you have this properly set already based on prior year learning.

What I need you to make sure and do is at the SETUP for your health codes you want ACA recordable, make sure you do not have None and None.

Pick a default that would suite most of your employees, such as 1A and 2C as an example.

This code will NOT be picked up for ACA reporting.

This code will be picked up for ACA reporting as Box 14 and 16 are something other than None

3. Microsoft Dynamics GP will NOT support the electronic filing for the 2021 year for ACA.
Greenshades and Integrity-Data will allow you to track ACA in Microsoft Dynamics GP, and just do the electronic filing for you at a lower cost option.
Thanks to both ISV's for doing this!!
Greenshades - https://www.greenshades.com /             Integrity Data - http://www.integrity-data.com/

4. Similar to prior years, the all 12 month checkbox is not required for employee so we are populating each individual amount for employee,
but on the dependent the covered all 12 month box will be populated.

5. When you need to change what is reporting for an employee for a month, change the user date to the end of that month, example, you want to change the month of March and on, set the Microsoft Dynamics GP user date to 3/31/2021 make your record change, and recreate the year end wage file and you will see the change, you can also do this by rolling down from setup by a date.  We always take the last record of the month for what should print on the form.

6. We have had a couple of requests where a few forms have been rejected by the IRS.  Make sure if you are submitting forms, the 1094-C, we only print 1 page as that is all that is in Dynamics GP for information, but the form is actually more pages.  Make sure to complete the entire 1094-C prior to sending in to the IRS.

Click HERE for the FREE SmartList Designer reports library, free to you, it includes ACA SmartLists for you and many more!!

There is no new video this year as the tracking is the same as last year, click HERE if you are just getting started to track ACA and want to ramp up.

Enjoy, and everyone have a successful ACA 2021 year.

Be sure to refer to the GP 2021 Year-End Blog Schedule  to review current and upcoming blog posts and other helpful resource links related to Year-End Closing for Dynamics GP.

Terry Heley

non-ACA expert
Microsoft