...
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.
...
PayrollEntryID
The Payroll Entry ID as listed in DCI. Create one row per payroll entry.
You must include every payroll entry in the batch.
Required field.
PayrollSystemReferenceID
The ID from the payroll engine
Required field.
PayrollRefCheckId
The check number that the entry was paid out on
Optional field.
UnitAmount
The unit amount as entered on the punch entry. This must match the punch exactly.
Required field.
NetPay
The net amount paid to the employee.
Required field.
PayDate
The date the employee was paid.
Required field.
PayrollBurden
The actual payroll burden for the entry.
Required for dollar based entries.
...
With the Batch Details screen open, once a Batch has been approved, click the green button displays Reconcile.
The Reconcile from Payroll form wizard opens, complete the following fields:
Enter a Ref Reconcile Id (required) - this can be any reference number you choose.
File Name (required) - this name will appear in the attachments table to describe the reconcile file
Click Add Attachment to attach the Reconcile Text File discuss discussed in the previous steps.
Click Save.
...
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.
...