ユーザーマニュアル

[2023 Version] Bulk timesheet import

In addition to the timekeeping methods employees can do themselves, authorized accounts can bulk import timesheet data for employees into the system through an Excel template file by following these steps:

Steps:
Company > Working & Leave > Working time > Timesheet import > Download template > Input timekeeping data into the template file according to the guideline > Upload file with data > Import

Steps detail:

Step 1: Access the timesheet entry screen

Company > Working & Leave > Working time > Timesheet import

Step 2: Download the timesheet template file and import the data

Download template > Input timekeeping data into the template file according to the guideline > Upload file with data > Import

Downloaded template file:

Annotation:

Column	Glossary	Explanation
A	client_employee_code	Enter the code of employees (as created in the system) whose timesheet data needs to be entered into the system
B	log_date	Entering work time data date Format: yyyy-mm-dd (Year/Month/Day)
C	check_in	Actual check-in time. Format hh:mm (hour:minute)
D	check_out	Actual check-out time. Format hh:mm (hour:minute)
E	working_hours	Total working hours for the day. Authorized accounts can manually enter this or allow the system to automatically calculate it based on the check-in/check-out times uploaded. However, it is necessary to contact the terra team to use the automatic calculation feature of the system.
F	overtime_hours	Total overtime hours for the day. Only enter if the employee has not submitted an overtime request in the system
G	next_day	Mark if the work shift extends to the next day Enter 0 if the work shift doesn't extend to the next day. Example: 8:30 - 17:30. Enter 1 if the work shift extends to the next day. Example: 20:00 - 6:00
H	note	Note for the working day (Optional)

Note:

The data is recorded by the system only when the imported file has a "Successfully" status

上に戻る