ACA Missing Check

ACA Reporting

If you are using Enterprise or Beyond to track ACA information, we have a few report options for auditing, reviewing, or pulling out important information. Keep in mind that you can also create your own custom options utilizing a custom ACA Search. Check out Auditing Employee Records with ACA Searches for more information on search options available in your system. 

Looking for a list of all ACA Report options available? Check out ACA Reports Manual

Looking for the full reports manual? Check out Full Reports Manual.

Locating ACA Reports

ACA reports are listed in their own category under all options > reports in Enterprise: 

*Note* Reports in Enterprise require you to have specific security permissions. You will need to have access to the Affordable Care Act reports category in order to see or run any ACA related reports. Check out Enterprise - Security Roles for more information or talk to your admin if you are not seeing the reports you are expecting to. 


ACA Missing Check

Purpose: This report is meant to help you identify employees that have ACA related benefit adjustments active but are not receiving a check this week and therefore will not be contributing to their benefit costs. You may use this to identify employees that may have additional amounts withheld the next time they are paid. 

This report displays a list of employees who have a specific adjustment setup on their employee record and did not receive a pay check between the entered date range. 

Parameters

 Parameter Description
Start DateThis is the starting date the report will use to report check and adjustment information: 
  • Keep in mind this report runs off Weekend Bill Date. If you enter a date that is not Sunday it will pull information based on the Sunday following the date selected.
End DateThis is the end date the report will use to report check and adjustment information:
  • Keep in mind this report runs off Weekend Bill Date. If you enter a date that is not Sunday it will pull information based on the Sunday following the date selected.
BranchSelect which branches you want to include on this report 
  • Keep in mind that you will only see branches available at your current hierarchy level so we recommend running this report at System, Subsystem, or Entity level to ensure the report pulls all applicable information.
Adjustment TypeSelect which benefit adjustments that the employee must have on their file.
  • Because you may have multiple benefit plan options, etc., you may have multiple benefit adjustments available to choose from. Select the adjustments you want to show on the report.
Group ByBy default, this report will be set to "No Grouping" which will show all employees matching the report criteria in a single list.
If you would like the employees to be grouped by specific criteria, select one of the options in the Group By drop down.
ShowBy default, the show option will display all employees who meet the criteria for this report. However, if you want to limit the employees that appear on this list further, select or deselect some of the show options available in the drop down.
  • Employees on Active Assignments
  • Employees Not on Active Assignments
  • Active vs. Inactive Adjustments: 
  • Active vs. Inactive Employees:
  • Assigned vs. Unassigned Employees
Employee FilterIf you are looking to review one employee's missing checks and adjustment amounts, you can use this optional filter to limit by employee's name. Remember to type last name, first name


Report Breakdown

The following sections review and define the columns of information on this report:

Employee & Adjustment Information 

  • Employee: Name of Employee
  • Employee ID: System identifier for employee record (also referred to as AIdent) 
  • SSN: Employee's social security number on file
  • Adjustment: Name of the benefit adjustment 

Last Check Prior to X Date

  • Will display the check information for the last check processed for this employee prior to the start date used on the report parameters 
  • Adj Amount: Amount taken from the check for the related benefit adjustment named in the column before
  • Check Date: the date listed on the last check that was processed
  • Check Number: the number listed for this check for lookup purposes 
  • Weekend Date: The date showing the last day worked for the hours being paid on the check
  • Sunday following weekend date: (Also known as the Weekend Bill Date) the Sunday of the processing week - may be the same as the weekend date

Related Articles