Bulk Upload or Clone Timesheets

Modified on Fri, 17 Oct at 9:17 PM

The Bulk Upload and Clone features allow Employees, Managers, and Timesheet Admins to efficiently complete or manage monthly timesheets. These tools simplify the process, minimize manual entry, and help save valuable time.

Bulk Uploading Timesheets

The Bulk Upload feature lets you import a spreadsheet of time entries, reducing the need for manual input and minimizing errors.

1. Go to Timesheet > Team Timesheets > All Time Attendance Data.

2. Search for the employee and click on their account.

3. Select the month you wish to upload the timesheet for. You may view the data by Month or Week.

4. Click More Actions, then select Bulk Upload.

5. Click the Import Time Attendance Data tab to access the import page.

6. Choose one of the available templates:

Blank Template – create a new timesheet from scratch.
Template with Existing Timesheet Data – update or adjust existing entries.

7. Download the selected template and fill in the following fields:

Employee: Auto-filled with your name. Do not edit this field.
Assignment: Select the appropriate assignment from the drop-down list.
Date: Pre-filled for the selected month. Avoid making changes to prevent errors.
Start Time: Enter your start time in 24-hour format (e.g., 09:00, 18:00).
End Time: Enter your end time in 24-hour format (e.g., 09:00, 18:00).
Break Time: Enter the break duration in hh:mm format (e.g., 01:00 for 1 hour, 01:30 for 1 hour 30 minutes).
Note: Break time will be deducted from the total working hours. For example, working from 09:00 to 18:00 with a 1-hour break results in 8 working hours.
Remarks: Optional. Add comments or notes as needed.

8. Refer to the attached sample for guidance, then save the completed template.

9. Once your file is ready, upload it by clicking Click here to upload files or simply drag and drop it into the upload area.

10. Once uploaded, you'll be redirected to the Process Status page to monitor the progress.

11. When complete, all entries will appear in the employee’s timesheet with the status Draft.

Cloning Timesheets

The Clone feature allows you to duplicate the timesheet from the previous month, making it easy to replicate recurring schedules or projects.

1. Go to Timesheet > Team Timesheets > All Time Attendance Data.

2. Search for the employee and click on their account.

3. Select the month to populate the timesheet entries.

Example: If you select October, the system will clone entries from September to October.

4. Click More Actions, then select Clone Timesheet.

5. A confirmation pop-up will appear, showing the month being cloned from. Click Save to proceed.

Important Note: You can only clone the previous month's timesheet.
Caution: Cloning will overwrite all existing timesheet entries in the current month.

7. Once cloning is complete, you'll see identical entries in the employee's timesheet with the status Draft, marked as “Auto created from clone timesheet.”