Step 1
Create the import interface: Configuration > Interfaces > Job cost import interfaces > “+”
Use the add button to add the target fields
Step 2
Create the import file with the following columns. The file can be a .txt file or a .csv file.
Sample of the import file:
W,001,102,10,11.55,
W,003,6688,,,777
Column Description:
1- Work Detail Identifier
2 - Employee ID
3- Payroll Category Code
4- Quantity of hours
5- Rate
6- Amount for salary
If importing for the hourly pay category then the amount can be zero or blank
If importing for salary then hours and rate can be zero or blank
Step 3
Payroll > Process job cost entries > Batch job cost entries
Select the batch mode: Import job cost from file and select the Import interface from the drop-down list and click > Next
Browse for the file to be imported > Finish
The import information will be display on the information window. Click on OK
To review or modify the imported data:
Payroll > Process job cost entries > Edit job cost entries
Any correction must be completed prior to creating the employee paycard
Step 4
Option 1
Create the paycards
Option 1: Payroll > Process payroll > Batch payroll > Make the selection for the payroll processing steps and click Next.
Click Run Payroll to complete the process
To see the paycards : Payroll > Process payroll > Edit paycard > select employee
Option 2
Payroll > Process payroll > Batch payroll > Edit paycard > select employee > “+” > the paycard will be created and the values imported from file will be visible in the paycard.
Now you can follow the normal steps to Process the payroll