Show/Hide All

 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 payroll history files.

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.

 Before You Begin

If you want to exclude hours associated with particular earnings codes from the calculation used for the employee count, select the Exclude from ACA Report check box for the earnings code(s) in Earnings Code Maintenance.

 

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

 

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. 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.

3. Make any other selections as needed.

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

5. Close the task window.

6. 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.