Payroll Data Validation Report for Mexico

Run the Payroll Data Validation Report to validate your HR and payroll data. Use this report to verify if the required data setup for all workers for the payroll run or process is complete.

As a payroll manager, you can run this report and make relevant corrections to complete the payroll-related data. This is a prerequisite task to check for any missing data before running all the payroll processes.

Run Payroll Data Validation Report

1. From the home page, navigate to My Client Groups > Payroll > Flow Submission and Results > Submit a Flow.

2. Select a Mexico legislative data group.

3. Select the Run Payroll Data Validation Report from the list of processes or reports.
4. Enter the required Payroll Flow name for the process that’s being run. Enter a value each time the process is run.
5. Select the Schedule.

6. Use the Effective As-of Date field to specify the effective date of the payroll process to include in the report. The data status is verified as of the selected effective date.

7. Select the Payroll Statutory Unit for which the report is to be run.

8. Click Submit and then click Refresh to view the task completion status.
9. When the status is Completed, click the Payroll Data Validation Report.pdf link to download and save the report.

10. The report generates data with the following details:

    • Missing CFDI data in the legislative data group and legal entity.

    • Missing tax reporting unit data

    • Missing payroll statutory unit data

    The messages for a payroll statutory unit on missing data setup for social security management are sorted by territory, social security type, and contribution type.

Legislative Data Group (LDG) Validation Criteria

The LDG data validation checks all the CFDI keys and CFDI concepts as listed here:

1. The CFDI key must not exceed 15 characters.

2. The CFDI concept must not exceed 100 characters.

   Note: A validation message is displayed for invalid CFDI key or concept information.

Legal Entity (Payroll Statutory Unit) Validation Criteria

The payroll data validation checks the legal entity for the criteria as listed here:

1. The CFDI PAC confirmation key exists.

2. The CFDI Fiscal Regime is entered.

3. A Social Security Work Risk Classification is selected for the LE.

   Note: A validation message is displayed for each criteria that isn't met in the validation report.

Tax Reporting Unit(TRU) Validation Criteria

The TRU data validation checks include the criteria as provided here:

1. The legal employer's registration(TRU RFC) exists. This is required for social security reporting.

2. The legal employer's registration has a valid check digit (TRU RFC).

3. The TRU waybill number exists in the TRU, if set to yes

4. If the Transmitter TRU exists (if set to yes), the transmitter TRU name needs to be blank.

5. If the Transmitter TRU isn't added (if set to No), the waybill number need to be empty and transmitter TRU name is required.

   Note: A validation message is displayed for each criteria that isn't met in the validation report.

Employee Validation Criteria

The employee validation checks include the criteria as listed.

1. The date of birth is available.

2. A valid work location is specified.

3. A valid national identifier (CURP) is entered.

4. The first name and/or paternal last name is available.

5. A new hire date and/or an adjusted service date for rehired employees is specified.

6. An assignment category is selected.

7. A social insurance salary type is selected.

8. The element entry for Average SDI is added.

9. A reduced working week value is selected for the employee.

10. A leaving reason needs to be entered for employees with a terminated work relationship.

11. For employees who have a change in TRU, a leaving reason is entered on the employee tax card.

12. The TRU association has been created on the employee tax card.

13. The association details are linked to an assignment.

14. The fiscal regime is selected for the employee.

15. The legal address is set for the employees.

16. The disabilities data is specified that are related to more than one absence.

17. Disability ID needs to be included on the Absences card entry for the associated absence.

18. For employees with a terminated work relationship, a valid termination date exists.

19. Each person have a feed to the DBC balance.

    Note: A validation message is displayed for each criteria that isn't met.