Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Prepare forms 1094-C and 1095-C

Affordable Care Act (ACA) worksheet reports

ACA reporting is mandatory for employers that meet certain criteria. Use the following worksheet reports to determine if ACA reporting is optional or mandatory.

Average Full-Time Employees Worksheet

The Average Full-Time Employees Worksheet report calculates the average number of full-time employees. It lists the following items:
  • Number of full-time employees
  • Number of full-time equivalent (FTE) employees
  • Total number of full-time employees for each month of a selected date range
  • Average number of full-time employees across a selected date range
The reports uses information entered in Accounting CS to determine if employees are full-time or part-time. To display employment status of an employee, select
Setup
,
Employees
, the
Personal
 tab, then
Employment status
 field in the Affordable Care Act Information section.
Employment status options include:
  • Full-time
    : the employee is included in the full-time employees count for every month they have received a check.
  • Exempt
    : the employee isn't included in any count total.
  • Variable hour
     (default): the report determines if the employee is full-time based on the hours worked.
    • 130 or more work hours: the employee is considered full-time and included in the full-time employees count for the month.
    • Less than 130 work hours: the employee is considered part-time and their hours worked included in the calculation of full-time equivalents for the month. To calculate full-time equivalents for a month, the sum of part-time employee hours (capped at 120 hours per employee) is divided by 120.
  • The report adds the number of full-time employees and the number of full-time equivalents to calculate the monthly total.
  • The report adds all of the monthly totals, divides that number by the number of months included in the specified date range, and truncates the decimal from the final result to provide the number of full-time employees.

Average Hours Worksheet

The Average Hours Worksheet report calculates the average hours worked per week or month by each employee. It lists the average number of hours worked for all or selected employees, including:
  • Beginning date of the measurement period
  • Ending date of the measurement period
  • Number of weeks or months in the measurement period
  • Number of hours worked
  • Average number of hours worked per week or month.
The report prints the total number of hours worked for each employee in the date range as follows:
  • Average hours per week (default): the employee's total hours divided by the number of weeks.
    • Full-time employment status: the report indicates that the employee full-time.
    • Exempt employment status: the employee isn't included in the report.
    • Variable hour employment status (default): the report determines if the employee is full-time based on hours worked. Employees are considered full-time their average hours per week is greater than or equal to 30 hours.
  • Average hours per month: the employee's total hours divided by the number of months.
    • Full-time employment status: the report indicates that the employee full-time.
    • Exempt employment status: the employee isn't included in the report.
    • Variable hour employment status (default): the report determines if the employee is full-time based on hours worked. Employees are considered full-time their average hours per month is greater than or equal to 130 hours.

This article applies to:

  • Product: Accounting CS
  • Subject: Payroll tax forms

Related content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close