How to Import your Clock In and Clock Out in PayrollHero

1. Create an excel spreadsheet with the following details and format:
   
   • Employee ID: This is the ID of the employee on our system not the employee’s internal number if you have them.
     
     You can easily get the employee ID (EID) of all employees by exporting the Multi Insert Tool – Employee Enrollment Update
   • Clocking Time: This is the time and date of the clocking the format must be:
     YYYY-MM-DD HH:MM:SS
   • Timezone: This is which timezone the clockings occurred in.  Type in the name of the timezone from the timezone we support here. If all your employees are in the Philippines just use “Singapore”.
   • Clocking Kind: This is the type of clocking they must be in this format:
     • clock_in
     • clock_out
     • break_in
     • break_out
2.  Once you have the spreadsheet with all the details above. You must have access to the Settings page in order to import clockings.
   • Click on Settings
   • Scroll at the bottom of the page and click on “Import Clockings”
     
   • Upload the file and click on “Import”
   • You’ll then see the loading screen.
     
3. Once that’s done, you’ll be able to see the clockings via the ATTENDANCE page or via the Review page of the employee.

NOTE: Imported Clockings will automatically go through the account’s thresholds settings.

• So let’s say that there is a threshold set up to resolve attendance automatically except for the employee’s UNDERTIME and UNSCHEDULED WORK.
• If the employee clocked in and out based on their schedule, then the attendance automatically goes to the “Perfect” status. There is no resolution needed.
• If the employee worked more or less than their scheduled hours, as per the threshold, then it’ll either go to the undertime or unscheduled work attendance status.