You may need to update many employee payment details which takes time. Use the timesheet to update multiple employee payment details at one go and have it imported to payroll. Download timesheet template based on the frequency. The timesheet already has the employee and the payment details. You can update details in the timesheet and have it imported to the payroll. Depending on certain conditions, the payroll details are updated based on the timesheet.

To download the timesheet, complete the following steps.

1. On the Settings page, under the Payroll heading, click Generate Timesheet Template.

2. The Generate Timesheet Template window appears. It displays the timesheet purpose and provides a button to generate the timesheet.

Timesheet is generated for the active frequencies that have active employees only.

3. On the Generate Timesheet Template window, select the applicable frequency and click Generate. The timesheet is downloaded to the pre-specified location on the local disk.

Timesheet is generated in the excel format only and will not work if the format is changed or any default column is updated.

4. Enter or update the required data in the template and save the changes. You are now ready to populate payroll data just by importing the timesheet.