A Setup Guide for ACA Tracking in Microsoft Dynamics GP

Visit Website View Our Posts

In the employer reporting puzzle of the Affordable Care Act (ACA), a missing and critical piece recently surfaced. Faintly.

We now have a draft of Form 1095-C. The IRS released this draft, along with other ACA draft forms, on July 24, 2014. Even without being finalized, Form 1095-C lends insight about steps that companies which process payroll in-house should start taking to get ready for January 1, 2015 – when the penalty-assessment period for most employers begins.

For companies that process payroll with Microsoft Dynamics GP (Great Plains), and which don't already have an ACA system strategy, this insight leads to a review of the five setups detailed below. First, though, let's cover what you need to know about Form 1095-C.

Why Form 1095-C is important for employer ACA compliance

Collecting the information sought on Form 1095-C will show the IRS that an employer has, according to the layers of ACA directives, met the requirement of offering health care coverage to employees.

This document will be a new yearly staple for distribution to employees – much like a W-2. Form 1095-C will also be given to each employee by the end of every January for information from the previous year.

Who will have to produce Form 1095-C

Every employer with 50 or more full-time employees and full-time equivalents will be required to produce Form 1095-C.

Confusion abounds, as many companies believe that their insurance provider will be able to generate this report for them. Not so. Insurance providers will be submitting their own reports to the IRS – reports that cover only those employees who had coverage. Reporting for every employee, regardless of whether they elected coverage, is the employer’s responsibility.

What this means for Dynamics GP Payroll users

To better capture the data needed, and segment that data for generating the information sought on this form, review these setups in Dynamics GP Payroll and make the five following adjustments:


1.  Use the Employment Type field in Employee Maintenance.

ACA GP setup guide Employment Type
For ACA tracking, use this field in Dynamics GP Payroll to segment variable-hour employees from full-time employees.

This field allows you to segment full-time employees from variable-hour employees. For full-time employees, use Full Time Regular; for variable-hour employees, use Part Time Regular. You will then be able to report on both groups better.

If an employee is expected to work at least 30 hours a week on average, they are considered full-time from date of hire and must be offered employer health care coverage within 90 days of their hire date or 90 days from the first day of the next month of their hire date.

If an employer can't tell whether an employee will be working 30 hours a week on average, that employee is considered variable-hour and subject to a measurement period to test whether they will meet the 30-hour threshold for full-time status.


2.  Set up benefit codes for employer's contribution to health care insurance.

Some employers bypass benefit codes to capture employer contributions to employee health care costs and manually update Box 12 on the W-2 form at year-end to reflect those costs.

In the ACA world, that practice won't give you the information needed.

One of the requirements for ACA reporting is to show what months an employee had health care coverage. By using a benefit code, you can annotate when the coverage started and keep track of individual health care benefits on a month-to-month basis.

Each plan should have its own benefit code. If your company offers multiple health care insurance options, you should set them up separately. In order to meet the threshold of “affordable,” you will need to make sure one of the plans meets the minimum value criteria of the ACA and that an employee contribution does not exceed 9.5% of the employee’s gross wages. (There are exceptions to this that we will highlight in other posts.)

In setting up the benefit code, you also set up the eventual feed into Box 12 on the W-2.


3.  Separate deductions for the employee portion of health insurance and the dependents' portion of health insurance.

If an employee elects both individual and family coverage, don't lump all employee contributions to health care insurance into one deduction code. Employers will have to keep track of employee portions of health care expenses separately from coverage for dependents.

Employers will be responsible for providing monthly information on when an employee had health care coverage, and on if and when their family was covered. Having accurate start dates in the deduction and benefit code setup for the individual employee will be essential for generating accurate information.


4.  Pay codes may need to be expanded; you need to track more hours.

An employee must be credited with an hour of service for each hour the employee is paid or entitled to be paid for the performance of duties on the job. Additionally, an employee must be credited with an hour of service for each hour the employee is paid or entitled to be paid because of vacation, a holiday, illness, incapacity, a layoff, jury duty, military duty, or a leave of absence.

Companies that pay lump-sum amounts for vacation, illness or any other absences will now have to break those down to numbers of hours.

In addition, the final regulations for the employer shared responsibility rules state that "special unpaid leave" may be defined as unpaid leave under the Family and Medical Leave Act of 1993, the Uniformed Services Employment and Reemployment Rights Act of 1994, or jury duty.  When calculating hours of service for a look-back measurement period, the employer must treat special unpaid leave in one of two ways:

  • Determine the employee's average hours of service by excluding any periods of special unpaid leave during the measurement period and applying that average for the entire measurement period, or
  • Input hours of service during the periods of special unpaid leave at a rate equal to the average weekly hours of service for weeks that are not part of a period of special unpaid leave.


5.  Capture dependent information if employee elects dependent (family) coverage.

ACA setup guide for GP Employee Dependents
For ACA reporting, you will have to track coverage for dependents, which you can do from the HR module of Dynamics GP without fully implementing it.

If you look at Form 1095-C, you will see that you need to report on dependent coverage.

Each dependent is listed individually, so you will need to capture the needed information which, at a minimum, is dependent name, SSN or DOB.

The HR module of Microsoft Dynamics GP can capture the needed information.

Access to this information does not require full implementation of the HR module. The dependent information is tied to the employee’s Payroll record.


What’s easy to do next, and what's not

To be ACA-ready with respect to data collection, the changes you need to make in the Payroll module of Microsoft Dynamics GP are minimal. It's the report generation from calculations and analyses based on this collected data that you may need a system enhancement for in order to be ACA-ready with respect to filing with the IRS.



By Helen Karakoudas, Sypnio Software, www.sypnio.com





2 thoughts on “A Setup Guide for ACA Tracking in Microsoft Dynamics GP”

  1. Linda,

    Thank you for reading closely. I hope the following answers are helpful:

    1. Without our software, this monthly count will not be automatically generated.

    Absent a system enhancement formatted for reporting of ACA calculations, you will have to get this count manually for each month of the year. It will be the sum of full-time employees and full-time equivalents. You will know the number of full-time employees by finding everyone who worked at least 130 hours in a month. (GP will allocate a 40-week for each salaried employee.) To get the number for full-time equivalents in a month, you’ll calculate the total hours for all those who did not work at least 130 hours in a month and then divide that number by 120.

    There are some gotchas, though, that complicate manual calculations. You will need to look at hours of service vs. hours of work. You will have to credit people for FMLA, sick time, military deployment, jury duty. Though these hours may be non-dollar, you still will have to credit them to every employee.

    2. Under the Affordable Care Act, you have to offer coverage, but the employee is not obligated to accept coverage. There are codes that are applicable to the range of scenarios listed in #14 and #16. The ACA pegs accountability for "affordable" to self-only coverage, which is employee only. That’s why it’s a good idea to separate deductions between employee and dependents.

    Many companies will be offering a variety of plans. You should set up a benefit code per plan. For deductions, you only need one deduction for the employee portion and another for the family portion, regardless of the benefit.

    Doing it this way allows you to see what plan the employee is enrolled in and how much the employee-only coverage costs each month. In Dynamics, then, without an ACA enhancement, you can get reporting on deductions broken down by month.

    3. You are correct that, with what we have learned since this post was published, dependent coverage is only needed for self-insured plans. Insurance companies will be providing their own reporting via Form 1095-B and, yes, that will detail dependents being covered.

    This post was accurate as of its publication date, August 11, 2014. At that point – more than two weeks before the IRS released instructions for the ACA draft forms it had issued in late July – we did not have the fine-tuning of information that came with the release of draft-form instructions on August 28, 2014.

    4. Absent our ACA system enhancement for GP Payroll, there is no one place to find this information in Dynamics.

    Your best bet without our software is to set up each plan separately so that you can at least isolate which employee you associate with which plan. Plans cannot discriminate with the type of coverage offered, so being able to isolate each plan will go a long way in assisting you in what code to use.

    This is the main reason you want to create different benefit codes per plan. For most companies, the code is 1A - Qualifying Offer. If you set up a different benefit code per plan, you will know what the code should be. Remember, it is what was offered – which is different from what was accepted.


  2. 1. Form 1094-C calls for a count of full-time employees for each month of the year. How will this be tallied in Microsoft Dynamics? Will there be a count generated each month for the number of people classified at that time as Full-time Regular?
    2. Form 1095-C #15 merely requests the employee share of the lowest cost monthly premium for self-only minimum value coverage. I fail to understand how benefit or deduction codes would provide this information, particularly in cases where employees haven't opted for coverage. Would this be the standard lowest premium charged to this employee if they were to opt for coverage that month? Is so, where in Dynamics would this information be gleaned?
    3. You indicate in your item #5 that 1095-C requires a report of dependent coverage. Doesn't this only apply for self-insured plans? If an employer has a fully insured plan, wouldn't the insurance carrier be providing this information instead of the employer reporting it in 1095-C Part III?
    4. Where in Dynamics would the information reside to answer items needed in 1095-C #14 (Offer of coverage)?

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons