Generate Employee Count for ACA Compliance

 

Expand/Collapse all  Show/Hide All

Expand/Collapse item  Overview

Use this procedure to determine your full-time and full-time equivalent (FTE) employee count and update the totals to the ACA Employer file so that they appear in the ALE Member Information - Monthly window. Your employee counts are calculated based on information in the perpetual payroll history files. You must have the Retain Perpetual Payroll History check box in Payroll Options selected to save the data used for the calculation.  

Note The ACA Applicable Large Employer Report is offered as a self-help tool for your independent use. Sage cannot and does not guarantee the report's accuracy or applicability to your circumstances. To comply with the Affordable Care Act, hours of service must be reported by calendar month. Because hours worked are tracked by pay periods in Sage 100 and pay periods may span more than one month, a calculation is performed to get an approximate monthly total. The total is an estimate and may not reflect the actual hours worked. For specific tax or legal advice, see a professional tax service provider or an attorney, as appropriate.

 

To generate full-time and FTE employee counts and update the ACA Employer file

  1. Select Payroll ACA menu > ACA Applicable Large Employer Report.

  2. Click Earnings to Exclude to specify which (if any) earnings codes you want to exclude from the report in the Earnings to Exclude window.

    Note Only earnings codes that use the Standard and Add Amount to Rate entry methods are included in the report calculation.

  3. In the Period End Date Range Starting and Ending fields, enter the date range for the report. For more information, see ACA Applicable Large Employer Report - Fields.

  4. Make any other selections as needed.

  5. Print and review the report. Change selections and reprint if needed.

  6. Close the task window.

  7. When the message appears asking if you want to update the ACA Employer file, click Yes.

The employee counts are updated to the ACA Employer file and appear in the ALE Member Information - Monthly window accessed from ACA Employer Maintenance.

Note Because of the need to prorate the hours worked for pay cycles that span multiple months, the report calculations will be more consistent when you generate the report for the maximum 12-month date range. If the report is generated for a shorter date range, the prorated hours for some months may not be reflected in the report totals.  

For information on how the employee totals are calculated, see ACA Applicable Large Employer Report Calculation.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks