Versions Compared

Version Old Version 4 New Version 5
Changes made by

Stephanie Smith

Stephanie Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Description: In this topic the user will learn how to reconcile payroll batches. Payroll batches can be reconciled in DCI after the employee has been paid. This helps track which entries have been paid out. Additionally, it is necessary to reconcile dollar-based entries in a payroll batch in order to give a billable amount to the entry.

...

  1. With the Batch Details screen open, once a Batch has been approved, the green button displays Reconcile and the Batch Details status displays Transmitted.

  2. Scroll to the tabs located under the Batch Details information and click the Attachments tab.

  3. Locate the file name that starts with RawPayrollDump.

    1. Following the name there will is an underscore followed by numbers to create a unique identifier for each Raw Payroll Dump file.

  4. Click the Download dropdown and select CSV for the file type.

  5. Click the blue Download Arrow Icon to start the download.

  6. Click the downloaded file to open the RawPayrollDump in Excel.

...

  1. PayrollEntryID

    1. The Payroll Entry ID as listed in DCI. Create one row per payroll entry.

    2. You must include every payroll entry in the batch.

    3. Required field.

  2. PayrollSystemReferenceID

    1. The ID from the payroll engine

    2. Required field.

  3. PayrollRefCheckId

    1. The check number that the entry was paid out on

    2. Optional field.

  4. UnitAmount

    1. The unit amount as entered on the punch entry. This must match the punch exactly.

    2. Required field.

  5. NetPay

    1. The net amount paid to the employee.

    2. Required field.

  6. PayDate

    1. The date the employee was paid.

    2. Required field.

  7. PayrollBurden

    1. The actual payroll burden for the entry.

    2. Required for dollar based entries.

...

The system will start the reconciliation process. The batch status will update to ReconciliationInProcess. Once complete, the user can see the results file under the Reconcile Function. If all entries were successfully reconciled, the batch status will update to Reconciled.

  • If any entry failed reconciliation, the Results file will display the Reconciliation status and the reason for failure.

  • If entries were successfully reconciled, the results file will list Success as the Reconciliation Status and the entry status will update to Paid.

...