The Reconciliation Report provides a complete itemized list of the discrepancies found between employees' projected and actual hours and rates per earnings code. The report also lists the adjustments necessary to reconcile each employee's received pay (based on projected data) with his/her actual worked hours. These automatically generated adjustments are not posted to employee's records until a practitioner approves them. The Reconciliation Report also indicates whether each adjustment has been accepted or rejected.

This report can help you verify the accuracy of your payroll exports and reconciliation processes.

Note: The Reconciliation Report can only be run for the previous pay period, so it is important that you run this report during every pay period.

To run the Reconciliation Report (if your company has only one pay cycle):

  1. From the Reports menu, select Time & Attendance Reports.

    Note: If the Time & Attendance Reports option is not visible, make sure that you have selected Practitioner in the Role Selector.

  2. In the Report Categories section of the Reports page, click Administrator Reports.

  3. In the list of Administrator Reports, click the View Report button for the Reconciliation Report. The report is displayed in a separate window.

    Note: If the Reconciliation Report does not appear in the list of Administrator Reports, it may be in another report group, such as Projected Payroll Reports. If you cannot find the report in any of the report groups to which you have access, contact your ADP Time & Attendance Representative.

  4. To save the report as a PDF file, use your browser's Save button or Save menu item.

  5. To print the report, use your browser's Print button or Print menu item.

  6. Close the report window.

To run this report (if your company has more than one pay cycle):

  1. From the Reports menu, select Time & Attendance Reports.

    Note: If the Time & Attendance Reports option is not visible, make sure that you have selected Practitioner in the Role Selector.

  2. In the Report Categories section of the Reports page, click Administrator Reports.

  3. In the list of Administrator Reports, click the Edit Report button for the Reconciliation Report. The report is displayed in a separate window.

    Note: If the Reconciliation Report does not appear in the list of Administrator Reports, it may be in another report group, such as Projected Payroll Reports. If you cannot find the report in any of the report groups to which you have access, contact your ADP Time & Attendance Representative.

  4. In the Name field on the Edit Report page, add more information about the pay cycle for which you are preparing the report. For example, "Reconciliation Report - Biweekly Pay Cycle."  

    Tip: Since you will save this report format to be used repeatedly, do not include the specific date.

  5. In the Report Title field, add more information about the pay cycle for which you are preparing the report. For example, "Reconciliation Report - Biweekly Pay Cycle."

  6. In the Select Filed drop-down box in the Create a New Filter section, select Pay Cycle.

  7. In the Selected Values field, click the Add Item button.

  8. In the Pay Cycle Lookup window, select the pay cycle for which you are creating the report.

  9. Click the Add Filter button.

  10. Click the Save and Preview button. The report is displayed in a separate window.

  11. To save the report as a PDF file, use your browser's Save button or Save menu item.

  12. To print the report, use your browser's Print button or Print menu item.

  13. Close the report window.

    Note: The report now appears in the My Reports section of the Reports page. The next time you need to run this report, you can simply click the View Report next to the report name you created for the report.