Formula : How to set the lateness formula in deduction?

Created by rotcana Choong, Modified on Sat, 6 Jun at 7:51 PM by rotcana Choong

Print

This setup is used to calculate salary deduction based on employee lateness, where deductions are only applied after a minimum lateness threshold, and the deduction is calculated based on the employee’s hourly or per-minute rate.


Steps to Set Lateness Formula in Deduction:

  1. Go to Tools > Payroll Items.

  2. Go to Deduction.


  1. Click + Add New.


  1. Enter the CodeDescription and select the Employees to be assigned.


  1. Enter the formula as desired. 

  • Example: IF (LATENESS TIME < 15) 0 ELSE (BASIC RATE / 26 / 8 / 60 x LATENESS TIME)

    • If lateness is less than 15 minutes, no deduction will be applied.

    • If lateness is 15 minutes or more, deduction will be calculated based on the employee’s salary per minute rate.


  1. Click Save.


  1. Go to Payroll > Employee Maintenance.

  2. Locate the employee and click the pencil icon.

  3. Go to Addition & Deduction and click + Add Payroll Item.


  1. Select the newly created Deduction item and click Add.


  1. Click Save changes.


  1. Ensure Time Attendance data has been imported into the system.


  1. Go to Payroll > Process Payroll.

  2. Click Run Payroll.


  1. Select the Payroll Type, Payroll Period, and Employee then click Preview.


  1. The deduction will be applied accordingly.