Audit Data for Payroll Overview

The Audit Data Tab includes utilities for auditing data between the HRIS and Payroll Application when EZSync is enabled.

Data Summary

The Data Summary Tab provides the ability to refresh the snapshot of Millennium payroll data for the selected dataset. Refreshing the data allows the other Audit Tabs to compare the HRIS data against the updated snapshot of payroll data. Depending upon the amount of data that exists in Payroll, this process can take up to 30 minutes to complete.

Once a dataset has been refreshed, the date/time of the last refresh will update in the Table that appears on this tab.

General Alerts

The General Alerts Tab displays a number of alerts that are produced when comparing data in the payroll snapshot against data from the HRIS Application. These alerts may be informational and may not always require action to correct the alert(s).

Employee Data

The Employee Data Tab includes the following two sub-tabs:

Record Comparison Tab

The Record Comparison Tab displays record count totals by Employer Code and Employee Status between the Payroll and the HRIS Application. The Difference column should equal zero in order to ensure that records are fully in sync between the two applications. The Discrepancies Tab can be used to identify any differences in specific records between the Payroll and the HRIS Application.

Record Discrepancies Tab

The Record Discrepancies Tab displays the specific records that are different between the Payroll and HRIS Application. This tab will include the following discrepancies:

  • Records that exist in Payroll but not in the HRIS
  • Records that are mapped to the same Employer Code and Employee ID but have a different Employee Status

The Load Selected Employer Mappings from Payroll button will load data from the Payroll Application into the HRIS Application in order to sync up data for the selected records. This should be used with caution and only when it is certain that the Payroll data reflects the correct data.

Note: It is important that Employee Data be fully in sync between the Payroll and HR Applications before other data sets are reviewed due to the fact that all other data is associated with the Employee Records.

IMPORTANT DATA NOTE: The data displayed on the Comparison or Discrepancy Tabs is valid only as of the last date and time that the data was refreshed from Payroll. It is not a real-time comparison of data. In order to compare the HRIS data to the most recent Payroll data, the appropriate data-set should be refreshed from the Data Summary Tab.

Deduction Data

The Deduction Data Tab includes the following two sub-tabs:

Record Comparison Tab

The Record Comparison Tab displays record count totals by Employer Code and Deduction Code between the Payroll and the HRIS Application. The Difference column should equal zero in order to ensure that records are fully in sync between the two applications. The Discrepancies Tab can be used to identify any differences in specific records between the Payroll and the HRIS Application.

Record Discrepancies Tab

The Record Discrepancies Tab displays the specific records that are different between the Payroll and HRIS Application. This tab will include the following discrepancies:

  • Records that exist in Payroll but not in the HRIS
  • Records that are mapped to the same Employer Code, Employee ID, and Deduction Code but have different Start Dates, End Dates, or Deduction Amounts.

IMPORTANT DATA NOTE: The data displayed on the Comparison or Discrepancy Tabs is valid only as of the last date and time that the data was refreshed from Payroll. It is not a real-time comparison of data. In order to compare the HRIS data to the most recent Payroll data, the appropriate data-set should be refreshed from the Data Summary Tab.

Compensation Data

The Compensation Data Tab includes the following two sub-tabs:

Record Comparison Tab

The Record Comparison Tab displays record count totals by Employer Code and Rate Code between the Payroll and the HRIS Application. The Difference column should equal zero in order to ensure that records are fully in sync between the two applications. The Discrepancies Tab can be used to identify any differences in specific records between the Payroll and the HRIS Application.

Record Discrepancies Tab

The Record Discrepancies Tab displays the specific records that are different between the Payroll and HRIS Application. This tab will include the following discrepancies:

  • Records that exist in Payroll but not in the HRIS
  • Records that are mapped to the same Employer Code, Employee ID, and Rate Code but have different Start Dates, End Dates, or Unit Rate Amounts.

IMPORTANT DATA NOTE: The data displayed on the Comparison or Discrepancy Tabs is valid only as of the last date and time that the data was refreshed from Payroll. It is not a real-time comparison of data. In order to compare the HRIS data to the most recent Payroll data, the appropriate data-set should be refreshed from the Data Summary Tab.

Tax Data

The Tax Data Tab includes the following two sub-tabs:

Record Comparison Tab

The Record Comparison Tab displays record count totals by Employer Code and Tax Code between the Payroll and the HRIS Application. The Difference column should equal zero in order to ensure that records are fully in sync between the two applications. The Discrepancies Tab can be used to identify any differences in specific records between the Payroll and the HRIS Application.

Record Discrepancies Tab

The Record Discrepancies Tab displays the specific records that are different between the Payroll and HRIS Application. This tab will include the following discrepancies:

  • Records that exist in Payroll but not in the HRIS
  • Records that are mapped to the same Employer Code, Employee ID, and Tax Code but have different Start Dates, End Dates, or Exemption Amounts.

IMPORTANT DATA NOTE: The data displayed on the Comparison or Discrepancy Tabs is valid only as of the last date and time that the data was refreshed from Payroll. It is not a real-time comparison of data. In order to compare the HRIS data to the most recent Payroll data, the appropriate data-set should be refreshed from the Data Summary Tab.

Direct Deposit Data

The Direct Deposit Data Tab includes the following two sub-tabs:

Record Comparison Tab

The Record Comparison Tab displays record count totals by Employer Code between the Payroll and the HRIS Application. The Difference column should equal zero in order to ensure that records are fully in sync between the two applications. The Discrepancies Tab can be used to identify any differences in specific records between the Payroll and the HRIS Application.

Record Discrepancies Tab

The Record Discrepancies Tab displays the specific records that are different between the Payroll and HRIS Application. This tab will include the following discrepancies:

  • Records that exist in Payroll but not in the HRIS
  • Records that are mapped to the same Employer Code, Employee ID, and Account Number but have different Start Dates or Deposit Amounts.

IMPORTANT DATA NOTE: The data displayed on the Comparison or Discrepancy Tabs is valid only as of the last date and time that the data was refreshed from Payroll. It is not a real-time comparison of data. In order to compare the HRIS data to the most recent Payroll data, the appropriate data-set should be refreshed from the Data Summary Tab.

Was this article helpful?
0 out of 0 found this helpful