How to Import Rate using Job Cost

Create the Import Interface

  1. Go to Configuration > Interfaces > Job cost import interfaces
  2. Click the “+” button.
    image2019-6-3_16-22-57.png
  3. Use the add button to add the target fields.

Create the Import File

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.

Selecting the Batch Mode

  1. Go to Payroll > Process job cost entries > Batch job cost entries.
  2. Import job cost from file and select the Import interface from the drop-down list. Then click Next.
  3. Browse for the file to be imported then click Finish.
  4. The import information will be display on the information window. Click on OK.

Review or modify imported data

  1. Go to Payroll > Process job cost entries > Edit job cost entries.
  2. Any correction must be completed prior to creating the employee paycard.

Paycard Creation

There are two options for creating for the paycard.

Option 1: 

  1. Go to Payroll > Process payroll > Batch payroll.
  2. Make the selection for the payroll processing steps and click Next.
  3. Click Run Payroll to complete the process.

  4. To see the paycards : Payroll > Process payroll > Edit paycard > select employee.

Option 2: 

  1. Go to Payroll > Process payroll > Batch payroll.
  2. Go to Edit paycard > select employee.
  3. Click the "+", the paycard will be created and the values imported from file will be visible in the paycard.
  4. Now you can follow the normal steps to Process the payroll.
Be the first to review this article