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: Go to Tools > Payroll Items. Go to Deduction. Click + Add New. Enter the Code, Description and select the Employees to be assigned. 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. Click Save. Go to Payroll > Employee Maintenance. Locate the employee and click the pencil icon. Go to Addition & Deduction and click + Add Payroll Item. Select the newly created Deduction item and click Add. Click Save changes. Ensure Time Attendance data has been imported into the system. Go to Payroll > Process Payroll. Click Run Payroll. Select the Payroll Type, Payroll Period, and Employee then click Preview. The deduction will be applied accordingly. 

The IF ELSE condition in allowance formulas is used to apply different calculation rules based on employee conditions such as attendance, working days, or employee group. Steps to Use IF ELSE Condition in Allowance Formula: Go to Tools > Payroll Items. Go to Allowance.  Locate an Allowance Item and click the pencil icon. Example 1: Attendance Allowance (Prorated Based on Working Days) Scenario: Full attendance – RM100 allowance will be given Partial attendance – prorated amount based on worked days will be given Formula:  IF (Working Days = Worked Days) 100 ELSE (Worked Days / Working Days * 100) Example 2: Allowance Based on Employee Group Scenario: Management Level Staffs – RM200 allowance will be given Other Staffs – No allowance will be given Formula: IF (Employee Group Equal By MANAGEMENT LEVEL) 200 ELSE 0

This formula is used to ensure that overtime rates are calculated and displayed with two decimal places. Steps to Make Overtime Rate Rounding to Two Decimal Points: Go to Tools > Payroll Items. Go to Overtime. Locate the overtime and click the pencil icon. Enter the Code and Description. Click + Add Detail. Enter the Title and define the OT rate formula using rounding: Apply formula ROUND((...), 2) to ensure two decimal precision. Example for 1.0x OT rate: ROUND ((Basic Rate / 26 / 8), 2 ) Click Apply. Go to Payroll > Employee Maintenance. Locate the Employee and click the pencil icon. Go to Employment Details, select the created overtime rule and click Save changes. Go to Payroll > Process Payroll. The overtime rate will now be calculated and displayed with two decimal places.

This setup is used to create a deduction based on employee lateness duration, where different deduction amounts are applied depending on how late the employee is. Step to Set Lateness Formula using IF ELSA Function in Deduction: Go to Tools > Payroll Items. Go to Deduction. Click + Add New. Enter the Code, Description and determine the settings. Enter the formula as below.  IF (Lateness Time <= 30 AND Lateness Time < 60) 100 ELSE IF (Lateness Time >= 60 AND Lateness Time < 90) 200 ELSE 0 Click Save. Ensure Lateness Time has been properly extracted in Time Attendance Import. Process the employee’s payroll. The deduction should be reflected.

This setup is used to calculate an allowance based on overtime hours, where a fixed threshold and hourly rate are applied using a system formula. Steps to Convert Overtime Hour to Allowance Using Fixed Hourly Rate: Go to Tools > Payroll Items. Go to Allowance. Click + Add New. Enter the Code and Description of the item. Enter the Formula as below:  IF (OT for Worked Days > 104) (OT for Worked Days – 104) * 5 ELSE 0 The threshold limit of overtime hours is 104 hours. Only overtime hours above 104 hours will be considered. Each eligible overtime hour is paid at RM 5 per hour. If OT ≤ 104 → Allowance = 0 If OT > 104 → Allowance = (Excess OT Hours) × 5 Click Save.

This setup is used to calculate Baitulmal deduction based on employee basic salary range, where different fixed deduction amounts are applied according to predefined salary brackets. Steps to Set up Baitulmal Deduction Formula: Go to Tools > Payroll Items. Go to Deduction and click + Add New. Enter the Code and Description. Enter the formula as below. IF(Basic Rate >= 300 AND Basic Rate < 1000) 1 ELSE IF (Basic Rate >= 1000 AND Basic Rate < 2000) 2 ELSE IF (Basic Rate >= 2000) 4 ELSE 0