Cloud Payroll - User Guide for Upload Attendance Transaction Data via Excel Import

Question : User Guide for Upload Attendance Transaction Data via Excel Import

Missed attendance data can now be uploaded via excel import, Payroll Users with the access rights will be able to download the template and provide the attendance information with optional remarks.

The system can only recalculate the uploaded data at 12.00am, however if you require instant recalculation, kindly reassign the employee’s shift code under attendance transaction.

Go to Excel Import > Attendance Transaction to download excel template.

Input the attendance data into excel template, save and upload.

Click Import All to upload.

Go to attendance transaction > click on actual clocks > work hours to check result.

The system only recalculates the uploaded data at midnight, however if you require instant recalculation, kindly reassign the employee’s shift code under attendance transaction.

Look for shift code at attendance transaction, click it, will appeared delete button, click the x button, wait the code become empty column, then only reassigned the employee’s shift code.

Once done, status will be updated, calculation of attendance data will be immediately reflected under attendance transaction > shift status and scenario as well.