Page History

...

Enter the source columns with the add button

Image RemovedImage Added

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,002,04/13/2019,102,12,25

W,001,002,04/14/2019,101,,,700

W,001,002,04/15/2019,102,8,25

W,003,002,04/13/2019,101,,,1000

W,003,002,04/14/2019,102A,8,40

Column Description:

1. Record identifier "W"
2. Employee ID
3. Department
4. Work Date
5. Payroll Category Code
6. Quantity of hours
7. Rate
8. 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

Image RemovedImage Added

Ensure the pay category is used for the job cost: Setup > Payroll settings > payroll categories > select the pay category and review the Flag section. If not selected, the import will not show the pay categories.

...