Help Toolbar   (select a button to browse other online help sections)

Home  Index  Tutorials  Resources  Search  Tabs & Menus  Button Bar  Table & Data Display

Importing Employee Work Hours

eNETEmployer provides two methods for importing work hours:

As mentioned above, the following tutorial will use the "Work Hours" import method to import the employee work hours. We will import hours for three sample employees using a comma delimited spreadsheet file (.CSV).



To Import Employee Work Hours:

  1. Choose the Employee - Earning Items menu command. This opens the Earning Items screen where you can import the hours that your employees have worked for the pay period.

    Earning Items Help Screen...

    Example: In our example below, we have used the Customized View feature to reshuffle the columns for easier viewing. For this import lesson, we will focus on the Hours cell for Regular earning type (as shown in the highlighted rows for our three hourly employees below). In our example, notice how the Total Amount cells show $0.00 because the hours for these three employees have not yet been entered.

    Fig. 01: Three hourly employees with their regular hours ready for import.
    Fig. 01: Three hourly employees with their regular hours ready for import.
  2. Select the Browse button from the Button Bar above the table and when the Open dialog box appears, navigate to the location where your .CSV work hours file is stored. In our example below, the import file is located in the "my payroll data" folder on our C: drive.
  3. Fig. 02: Navigate to the location of the .CSV file.
    Fig. 02: Navigate to the location of the .CSV file.
  4. Select the desired import file from the Open dialog box, and then choose the Open button. This places the name of the import file into the cell that is adjacent to the Import button as shown below.
    Fig. 03: The import file name is shown as a reference beside the Import button.
    Fig. 03: The import file name is shown as a reference beside the Import button.

    The Work Hours Import Format: The required format of the work hours file is : <employee#>, <earning#>, <hours>. In plain text form, the sample .CSV file for our three employees is formatted as follows:

    001,1,80.00
    003,1,80.00
    005,1,65.00

    Click here for detailed instructions on the import file format.


  5. Select the Import button to complete the process. Once the data is imported, a message appears on the screen indicating how many rows were successfully processed, as shown below.
  6. Fig. 04: A message indicates the number of rows that were successfully imported.
    Fig. 04: A message indicates the number of rows that were successfully imported.
  7. Move to the Hours column and review the data that was imported. In our example below, we see that the Hours cells (that were previously empty) now show values for the three employees. You will also notice that the Total Amount column for the employee is updated to reflect the resulting income amounts.
  8. Fig. 05: The imported data is shown and the Total Amount columns are updated accordingly.
    Fig. 05: The imported data is shown and the Total Amount columns are updated accordingly.

    This completes the tutorial on importing employee work hours.



See Also: