...
Create Reconcile Text File
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 Burden Multiplier on the RawPayrollDump file
Save as a Text (TXT) file to import
*Please note: The headers must be spelled exactly as listed above and in the same sequence as listed above or there will be an error when trying to import the text file.
...