Import Hours for a Payroll Batch — Timesheets

The timesheet import can be used in two ways:

• By exporting an Excel spreadsheet of hourly employees and employees eligible for overtime in the payroll batch, entering hours, and re-importing it.

• By creating a time import file definition for use with external time systems and then importing it.

Export & import employees in the payroll batch

1. While in the payroll batch, click on the Timesheets tab.

2. Click Export Time, and save the resulting payrolltime.xlsx file.

3. Open the spreadsheet, and enter hours as needed.

4. While in the Timesheets tab, click Choose File, navigate to the location of the file, and open it.

5. Leave the Import File Source set to WebSmart Excel File.

6. Click Upload File. You'll see a progress bar, and when the import is finished, you'll see the results in the bottom half of the window.

Clicking Reset Time will delete all records created by the import.

If you need to make changes/additions to the imported hours, edit the spreadsheet, and upload it again.

Clicking Reprocess Time will process the spreadsheet again.

Import a time file exported from another time system

1. While in the payroll batch, click on the Timesheets tab.

2. While in the Timesheets tab, click Choose File, navigate to the location of the file, and open it.

3. Select the time file format you created from the Import File Source pull-down list.

4. Click Upload File. You'll see a progress bar, and when the import is finished, you'll see the results in the bottom half of the window.

Return to Monthly Payroll Checklist