Search

[Support]

Problem

The employees hours are logged using an electronic time clock system. You want to be able to import the data from the time clock into Payroll4.

Solution

Payroll4 is installed with a TimeClock Wizard ("Reports" > "Report" > "Overviews" > "Time Clock") which is able to import and process export files of time clock systems. This file must use the following specifications:

1) The file format is CSV.

2) The file contains for each employee and for each different wage code a separate row.

3) The file must contain at least the following columns:

   - The employee number (Numeric)
   - The wage code (Character, max 4)
   - The number of hours, or an amount (Numeric)

Note:

1) The file may contain additional columns.
2) Columns may be placed in any order.
3) The columns may contain a heading.
4) The employee number should match an employee number in Payroll4*.
5) The wage code should match a wage code in Payroll4.


* The employee number can be entered in Payroll4 on the "Employee" tab at "Nr."

[Support]

Example CSV file:

1, NOR, 40 (employee 1, Normal work hours, 40 hours)
1, 150, 6.5 (employee 1, Overtime 150%, 6.5 hours)
2, NOR, 20 (employee 2, Normal work hours, 20 hours)
etc.