Sync Cloud

1. Click on the ☁️ > Sync Cloud… > Time Attendance, press "Sync All"

   

2. After all necessary adjustments are made, click "Update Payroll"

   • Alternatively, user may click on the 'Update TMS' button under 'Update Payroll' dropdown to only update TMS data to server
   • After 'Update Payroll', all OT / Leave trans that has been assigned action will no longer appear on the grid. User may view it under Time Attendance Unassigned Listing report

info

The 'ETMS updated to dd/mm/yyyy' is the date of the latest TMS summary processed. Any attendance logs before the updated date will no longer allowed to be adjusted from SQL HRMS app.

The Log synced to dd/mm/yyyy hh:nn is the date time SQL Payroll will sync attendance log to. Any attendance logs before this time (due to manager clock on behalf) will no longer be synced to SQL Payroll

Scenario	Sync Up To
Before 9am on 24/09/2025	23/09/2025 23:59
After 9am on 24/09/2025	24/09/2025 08:59

Attendance Log Error

This dialog box will only prompt if there are any incomplete log pairs (missing clock in / clock out) that requires attention

• The logs are grouped by the date and employee with alternating green and white highlights
• Green cells: Missing time which needs to be filled in
• Editable columns:
  • Clock In
  • Clock Out
  • Is OT
  • Break Time
• 'Recalculate' button will enabled once changes are made to perform recalculation on the attendance logs
• Batch Edit: Ctrl + select the rows you want to edit then right click and select Batch Edit

  • Note that you can only select records with missing clock in / clock out time and only either one at a time

  • Supported column: Clock In / Clock Out (depends on the type of record selected)

    

    • The date will automatically follow the record's date

    • If the time belongs to the next day, then you'll need to check the 'Overnight' checkbox

      Selected Record Dates	Overnight	Result
      2/4/2025 31/7/2025	Not Checked	2/4/2025 06:00 PM 31/7/2025 06:00 PM
      3/4/2025	Checked	4/4/2025 06:00 PM

Log

This tab shows the processed TMS summary with employees' log details after processed

Location Map

User can click on the 'Map' button in tab to show the employee's log location (Clock In, Clock Out, Status Update) on a map

• Map icon identifier:

  Icon	Description
  	Clock In
  	Status Update
  	Clock Out

Edit Mode

Right-click on the grid, select "Edit"

• The logs are grouped by the date and employee with alternating green and white highlights
• Editable columns:
  • Clock In
  • Clock Out
  • Is OT
  • Break Time
• 'Recalculate' button will enabled once changes are made to perform recalculation on the attendance logs
• The 'Work Duration' calculated after the log is adjusted is the difference between the 'Adjusted Clock Out' and 'Adjusted Clock In'
  • An accurate 'Work Duration' will be calculated after the 'Recalculate' button is clicked
• Batch Edit: Ctrl + select the rows you want to edit then right click and select Batch Edit
  • Supported columns:
    • Is OT
    • Break Time

OT

• Editable columns:
  • Post Date
  • Remark
  • Break Time
  • Claimable
  • Action:
    • Unassigned
    • Overtime: Record will be posted to Pending Overtime
    • Cancelled: Record will be ignored
  • OT Code
• 'Show Log' button is to show all employee's attendance logs on that date
• Batch Edit: Ctrl + select the rows you want to edit then right click and select Batch Edit
  • Supported columns:
    • Post Date
    • Remark
    • Break Time
    • Claimable
    • Action
    • OT Code

Leave

• Editable columns:
  • Post Date
  • Remark
  • Deductible
  • Action:
    • Unassigned
    • Leave: Records will be posted to Leave Application
    • Unpaid Leave: Record will be posted to Leave Application
    • Cancelled: Record will be ignored
  • Leave Type: Value changes based on chosen action
• User need to assign a leave code in order to post it to Leave Application
• 'Show Log' button: Show all employee's logs on that date
• Batch Edit: Ctrl + select the rows you want to edit then right click and select Batch Edit
  • Supported columns:
    • Post Date
    • Remark
    • Deductible
    • Action

Generate Calendar Reminder

• A generate calendar reminder for next year will be prompted starting from October each year
• The reminder will be prompt on condition where there is work session assigned on current year
• Options:
  • Go To Calendar: User will be directed to Maintain Calendar
  • Generate Work Schedule without Session: System will generate a whole year of work days without session
  • Later: Nothing will happen and the reminder will prompt again the next time user Sync Cloud