This guide will assist you in setting up lateness formula using the IF ELSE function in for the deduction purposes. To setup a lateness deduction formula using the IF ELSE function, go to Tools > General Maintenance > Deduction. Click on the Add New button. Maintain the Deduction Code, Description and determine the statutory setting and then click on Formula to set the formula. You may set the formula as below. EXAMPLE:  IF (LATENESS TIME <= 30 AND LATENESS TIME < 60) 100 ELSE IF (LATENESS TIME >= 60 AND LATENESS TIME < 90) 200 ELSE 0.   Fill in all the necessary details and click on Save once done to save the changes made. The deduction for lateness is set and ready to use. Ensure that you have extracted the Lateness Time in Time Attendance Import. Process the employee’s payroll and the deduction should reflect inside. END OF GUIDE

This guide will assist you in using the IF ELSE condition in allowance formula.  Scenario 1: To set Attendance Allowance to be a prorated based on employee working days If an employee has full attendance, he gets RM 100. Else, the allowance will be prorated based on worked days. Users may set a formula like this,     EXAMPLE:      IF (WORKING DAYS = WORKED DAYS) 100 ELSE (WORKED DAYS /                     WORKING DAYS x 100) Scenario 2: To set Allowance to be given on specific Employee Group If an employee is a Management Level of the employee group, he will get RM200, else will be 0. User may set a formula like this,     EXAMPLE:     IF (Employee Group Equal By MANAGEMENT LEVEL) 200 ELSE 0 END OF GUIDE  

This guide will assist you in setting up a formula that will set the overtime rate to round to the nearest 2 decimal point. To set the overtime rate rounding, go to Tools > General Maintenance > Overtime. Users may select the overtime that you wish to edit and click onto the pencil icon to edit. After that, users may select By Formula and input the formula as below and save. You need to add the ROUND ((XXXX),2) in each OT rate.     Example 1.0x daily rate     ROUND ((BASIC RATE/26/8) , 2 ) Next, go to Payroll > Employee Maintenance > Employment Detail > Overtime and select the overtime that you created just now. Lastly, users may go to Payroll > Payroll Management > Process Payroll > Overtime and now the rate will be showing in two decimal points. END OF GUIDE  

This guide will assist you in setting up a lateness formula in deduction. To setup the lateness formula in deduction, go to Tools > General Maintenance > Deduction. Users may click onto the Add New button. After that, set a specific deduction Code and Description for the respective deduction. Once done, click on Formula to setup the formula. Then fill in the formula as desired. Example:  IF (LATENESS TIME < 15) 0 ELSE (BASIC RATE / 26 / 8 /60 x LATENESS TIME) Explanation of deduction formula:  - If the staff has a lateness time of less than 15 minutes, then there will be no deduction. However, if there is a lateness time of more than 15 minutes, then there will be a deduction, and the deduction amount will vary depending on the lateness time and the basic rate of the staff due to the reason that the formula states that the deduction amount will be calculated based on the employee’s salary by the minute. Once done, click on Save at the top right corner to save the changes made. To test the lateness deduction, ensure that the lateness deduction has been assigned to the employee in their respective profile. Then ensure that there are time attendance details imported into the system. Then process the payroll by going to Payroll > Process Payroll under Payroll Management. Select New Payroll Process Select the Payroll Type, Payroll Period, Employee then select Next. Then click Process Deduction will be applied accordingly, click onto the amount to see the breakdown. The calculation should be:  RM4100 / 26 / 8 / 60 x 20 = RM6.57 END OF GUIDE

This guide will assist you in converting the overtime hour to allowance using a fixed hourly rate. To convert the overtime hour to allowance using a fixed hourly rate, go to Tools > General Maintenance > Allowance. Click onto the Add New button. After that, set a specific allowance Code and Description on the columns that are given and then click on Formula to set Allowance Formula. Users may set the formula as below.         IF (OVERTIME FOR WORK DAYS > 104) (OVERTIME FOR WORK DAYS – 104) x         5 ELSE 0   END OF GUIDE

  1. Go to AutoCount HRMS and key in the Email and Password accordingly and click on ‘Log In’.   2. Upon logging into HRMS, user will be directed in the ‘Services’ page. From here, click on the desired company to access into the company    3. Once the client has already accessed into a company. Clients may go to ‘Tools’ > ‘General Maintenance’ > ‘Deduction’ > ‘Add New’ > ‘Baitulmal’   4. Users may key in 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     Once done, click on ‘Save’ to save the changes made.