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.



Records also can check through attendance report.






Prepared By By ChenOng 240912, Azirah 240912



Go to menu

  AutoCount Accounting 2.0 & 2.1


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations