ACA Track provides several checks to help ensure your employee and dependent data is accurate. Along with our three-step file inspection process, we also make a Data Quality Report available to each client. This report provides several additional checks on your plan and division setup and compares those to the data files you uploaded for your employees and their dependents.

 

While reviewing your Data Quality Report is not a required step in filing your 1095/1094 data, we highly recommend that all clients take this additional step to reduce their risk of errors before submitting your final data for filing.


To view your Data Quality Report, go to the Data Management Module and open the Data Review tab.  Under Data Quality Report, press the "Click to View Report" button.


Before you can generate your report, you need to select which batches to include in the report. Select:

  • The type of batches (Inspection, Actual, or Correction)
  • The reporting months

The DQR generator will pull all batches that match the chosen criteria and compile them into a single report. If there are duplicates between batches, it will use the most recently uploaded data.


Note: If you select Actual or Corrective batch types, you may not be able to choose any months - this is because Actual and Corrective batches can only be created for December data.



Skip to a specific report:

 

ETL Batches Included in This Report

Each Data Quality Report lists the batches that were used to compile the report, when each batch was uploaded, the type of batches they were, and the time period they covered.



When there are multiple batches, the data is combined for the report. If there are duplicate employees (for example, an employee is listed in more than one batch), the information from the most recent batch will be used for the report.


Employee Level Data Inspection Results

This section provides a broad overview of each division’s employment records for the year: 

 

GMfR2T7v4L69KKLuehHjLnfjHAol8YCFug.PNG

 

Understanding Each Field

  • Number of Employees – This is the total count of individuals employed by the division over the course of the reporting year.  This number will likely be higher than any of your monthly counts—because of mid-year terms and hiring. If there is a “0” in any row, this means your Employee Datasheet did not contain any employees working for that division during the year. This should only happen if you are not reporting on that division.
  • Employees Waiving Coverage – This is the total number of employees in the data for that division that were reported with waived coverage during the reporting year.
  • Employees Terminated – This is the total number of employees in the data for that division that were reported as terminated during the reporting year.
  • Employees with Coverage End Date -The number of employees in the data who ended their insurance coverage during the calendar year.
  • Any Zeroes should be reviewed. A zero is not necessarily a mistake, but should be double-checked, since normally most divisions will have entries in each of these columns.

 

Summary of Client Hiring and Term Activity

This chart displays the number of employees that joined and left your company during each month of the year. Reviewing this information against your HR records and data can help identify any potential errors with the dates listed in your employee file, or with missing employee data.

 

eLdnqHPvZyichILVhrXOj2t_apMMPU723g.PNG


Note: This chart is intended to provide a quick, at-a-glance snapshot to help reveal blocks of missing information.

 

Plan Level Data Inspection Results

This report contains several key details regarding your plan setup and reporting. When reviewing this information, red results may mean some information is missing or incorrect. You should pay particular attention to these fields; however, it is important to review all fields for accuracy.


 

Understanding Each Field

  • Meets Minimum Value – This field will issue a warning if you selected "No" when setting up your plan.
  • Meets Affordability - This field will issue a warning if you selected "No" when setting up your plan.
  • Employee Count – This represents the number of employees who elected this plan throughout the year, according to your Employee Datasheet. If the Employee Count is 0, you should confirm that this plan was not used during the reporting year. If it was, you will need to adjust your Employee Datasheet and reload as necessary.
  • Spouse Coverage Check – This field will issue a warning if you selected “Conditional” for spouse coverage.
  • Plan Cost Time Period Check – A warning in this field indicates that you have not provided cost data to cover the entire time this plan was available during the current reporting year. A response of “N/A” means the system cannot perform this check, because the plan cost varies by employee.
  • Monthly Employee Required Contribution – A warning in this field indicates we are missing your Monthly Employee Required Contribution amount, or that your Monthly Employee Required Contribution amount was greater than $350. A response of “N/A” means the system cannot perform this check, because the plan cost varies by employee.
  • Monthly Employee COBRA Rate – A warning in this field indicates that we are missing your Monthly Employee COBRA Rate, or that the rate you provided is less than $250 or more than $1,000. A response of “N/A” means the system cannot perform this check, because the plan cost varies by employee.

  

Company and Division Data Mapping Inspection Results

 

This report contains several key details regarding your division setup and reporting. When reviewing this information, red results may mean some information is missing or incorrect. You should pay particular attention to these fields; however, it is important to review all fields for accuracy.

 

 

Understanding Each Field

  • Unused Division Reference Codes(s) – If any Division Codes are listed here, you have mapped those codes to the division, but they were never used in your Employee Datasheet. This is not necessarily a mistake, but you should review each code to ensure accurate reporting.
  • Unused Coverage Type Codes(s) – If any Coverage Type Codes are listed here, you have mapped those Standard Coverage Type codes for this division, but they were never used in your Employee Datasheet. This is not necessarily a mistake, but you should review each code to ensure accurate reporting.
  • Unused Job Status Codes(s) - If any Job Status Codes are listed here, you mapped these Job Status Codes for this division, but they were never used in your Employee Datasheet. This is not necessarily a mistake, but you should review each code to ensure accurate reporting.
  • Aggregated ALE Test - If you have a warning here, there are multiple divisions within the company, but you have indicated ALE=No for this division, or there is only one division within the company, but you have indicated that ALE=Yes. This should be reviewed and corrected as necessary.
  • Contact Information - If you have a warning here, you are missing Contact details for the division. We must have a complete name (first and last) and a phone number listed for each division.

 

Plan and Data Employee/Dependent Inspection Results

 

This report is meant to notify you of any possible discrepancies between your Plan setup information and the reports you submitted. When reviewing this information, red results may mean some information is missing or incorrect. You should pay particular attention to these fields; however, it is important to review all fields for accuracy.

 

 

Understanding Each Field

  • Dependent Coverage Check – A warning in this field indicates the plan is self-insured AND the plan definition states it covers Spouse and/or dependents, but no dependents have been reported. An “N/A” in this field indicates the plan is listed as fully-insured, and you are not required to report dependent coverage through this process.
  • Self-insured & COBRA Coverage – A warning in this field indicates the plan is self-insured AND you reported no employees with COBRA Coverage. This does not mean there is an error in your reporting, but it should be reviewed, as most self-insured plans will have at least some employees with COBRA coverage. An “N/A” in this field indicates the plan is listed as fully-insured; therefore, you are not required to report COBRA Coverage for termed employees through this process.
  • Coverage Effective Date – A warning in this field indicates the Plan Coverage Effective Date was listed as the “First of Month,’ but you have employees with Coverage Begin Dates other than the first day of the month. You should review your data to see if any adjustments are necessary.
  • Coverage Termination Date – A warning in this field indicates the Plan Coverage Termination Date was listed as the “End of Month,’ but you have employees with Coverage End Dates other than the last day of the month. You should review your data to see if any adjustments are necessary.
  • Termination/ Coverage End Date check – If you have a warning here, your Employee Datasheet lists a termination date for an employee with no associated coverage end date during the same time period. You should review your data to see if any adjustments are necessary.
  • Cobra Waived After Termination – A warning here means that one or more employees had the coverage type “COBRA Waived” for a time period after their termination. Cobra Waived should not be used for termed employees.


Plan and Data Employee/Dependent Inspection Results Details

This final section lists the individual employees or dependents that received warnings. You should carefully review the data for each individual and correct any mistakes before uploading your Actual Batch or processing your 1095 forms.



The following information is provided for each employee:

  • Full name
  • Division
  • What discrepancies or possible errors were identified

For security reasons, Social Security numbers are not included in this report.