...
Open Excel and create a file with the following column headers:
PayrollEntryID
Listed as Entry Id on the RawPayrollDump file
Create one row for each payroll entry in the batch
PayrollSystemReferenceID
ID generated from the organization's payroll system/engine, external to DCI.
PayrollRefCheckId (optional)
Check number on which the entry was paid, generated from the organization's payroll system/engine.
UnitAmount
Unit amount as entered on the punch entry. This must match the punch exactly.
Listed as Pay Units on the RawPayrollDump file
NetPay
Net amount paid to employee, generated from the organization's payroll system/engine.
PayDate
Date the employee was paid, generated from the organization's payroll system/engine.
PayrollBurden
Actual payroll burden for the entry
Required for dollar-based entries, optional for all other units.
Listed as Estimated Payroll Burden
on the RawPayrollDump file
PayrollEntryID
PayrollSystemReferenceIDPayrollRefCheckId (optional)
UnitAmount
NetPay
PayDate
PayrollBurden
Save as a Text (TXT) file to import
...
Select Payroll from the main menu
Select Reconcile from the submenu
Search for the file by typing the reconcile text file name into the search filters and clicking Search
Click anywhere on the row in the attachments table to open the results file
In the Attachment Details widget, next to the name field, click the blue download arrow icon to start the download.
Open the downloaded TXT file
Review the results file
First row is headers
Subsequent rows are results for each line on the payroll reconcile file
Each row will state Failure or Success at the end of the row (see ReconcileStatus header)
- Failures will include a failure reason (see Reconcile Reason header)
Reconcile Multiple Payroll Batches
...
Create the Reconcile Text File using the steps above
Select Payroll from the main menu
Select Reconcile from the submenu
From the attachments table, select one or more files to reconcile.
Click Actions
Select Upload File
The reconcile text file will include the entries from the selected batches
Complete the Reconcile File form wizard
Enter a Ref Reconcile Id - Choose any reference number
File Name - The name that will appear in the attachments Attachments tab describing the reconcile file
Click Add Attachment to attach the reconcile text file discussed in the previous steps
Click Save
...