Help Toolbar (select a button to browse other online help sections)Home Index Tutorials Resources Search Tabs & Menus Button Bar Table & Data Display
eNETEmployer allows you to import time sheet records from third party systems via a comma-separated values spreadsheet (.CSV). Time sheet data can be applied to all earning types (hourly, salary, commissions, etc.) and can be split between different departs using the Distributions feature.
The required format of the work hours file is : <employee#>, <earning#>, <hours>.
In a spreadsheet, a sample import file would appear as follows (where the first column is the employee number, the second column is the earning number, and the third column is the work hours to be applied).
0001 2 72.00 0002 2 72.00
In plain text form, the .CSV file would be appear as follows:
In the examples above, the import file will apply 72 hours to earning number 2 for two employees.
Note: The values shown above are alphanumeric. They must match each column exactly. For example, of your employee number is 001 in the payroll, entering "1" in your import file would be incorrect.
You can also allocate the hours to different departments using the Distributions feature. The required format is : <employee#>, <earning#>, <hours>, <distribution name>.
For example, the following import file will result in employee number 0001 having a total of 72 hours applied to earning number 1 while splitting the cost allocation between two different departments.
If an earning appears more than once, the results will be added together. For example, the following import file will result in employee number 0001 having a total of 80.5 hours (72.00 + 8.5 = 80.5)
Each time a file is imported, it will overwrite the pre-existing hours. Therefore, importing the same file multiple times will have no effect.
This can also be useful if you need to make corrections to a file. For example, if employee 0001 needed a correction, you would simply make the changes as needed and then import the entire file once again. Employee 0001 would have the corrected hours applied and all of the other employees would see no change (i.e. their hours would be replaced with the same hours as the previous file import).