Page History

...

1. Open Excel and create a file with the following column headers:

1. PayrollEntryID

1. Listed as Entry Id on the RawPayrollDump file

2. Create one row for each payroll entry in the batch

2. PayrollSystemReferenceID

1. ID generated from the organization's payroll system/engine, external to DCI.

3. PayrollRefCheckId (optional)

1. Check number on which the entry was paid, generated from the organization's payroll system/engine.

4. UnitAmount

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

2. Listed as Pay Units on the RawPayrollDump file

5. NetPay

1. Net amount paid to employee, generated from the organization's payroll system/engine.

6. PayDate

1. Date the employee was paid, generated from the organization's payroll system/engine.

7. PayrollBurden

1. Actual payroll burden for the entry

2. Required for dollar-based entries, optional for all other units.

3. Listed as Estimated Payroll Burden Multiplier on the RawPayrollDump file

2. Save as a Text (TXT) file to import

...