A3.255 : Tools : How to set OT calculation rate formula for basic rate max cap at certain amount?

A3.255 : Tools : How to set OT calculation rate formula for basic rate max cap at certain amount?

Question : How to set OT calculation rate formula for basic rate max cap at certain amount?

Example:

Overtime formula = Basic salary rate max cap at RM 2,000.

When calculate OT rate, if salary is more than RM 2,000, the maximum of RM2,000 will be used.

If salary is less than RM 2,000, actual basic salary amount will be used.


Answer :


1. Go to Tools > General Maintenance > Overtime > Add New (as in Figure 1)

OTFormula1.png

Figure 1


2. Type in Code, Description, Rounding Method

Key in Type, Unit, Quantity, Statutory Contribution and rate ( as in Figure 2)


OTFormula2.png

Figure 2


3. Click on rate, then key in the formula : MIN (Basic rate,2000)/26/8*1.5 (as in Figure 3)

OTFormula3.png

Figure 3


4. Click on Save button to save the changes (as in Figure 4).

OTFormula4.png

Figure 4

Remark: do the same for all details under this Overtime code.


5. A new OT rate formula is set (as in Figure 5)

OTFormula5.png

Figure 5


6. Then go to Employee > Employee Maintenance > Select employees that you wish to change his/her OT rate formula > Edit > Employment Detail > Overtime > Select Rate 2000 and Save . (as in Figure 6)


OTFormula6.png

Figure 6


7. Now, this employee will be using new OT rate formula when calculating OT.


--Source from AutoCount Wiki --

    • Related Articles

    • A3.185 : How to set lateness formula in deduction?

      Question : How to set lateness formula in deduction? Scenario I wish to set lateness deduction formula in hourly rate based on employee’s basic rate. Answer : 1) Go to Tools > General maintenance > Deduction 2) Click on Add New 3) Fill in Code, ...

    • A3.84 : How to change unpaid leave daily rate formula?

      Question : How to change unpaid leave daily rate formula? Effective 01st January 2023, Malaysia government has suggested the formula to calculate employee’s unpaid leave by using All Days in Calendar. You are advised to make the following payroll ...

    • A3.143 : How to set HRDF contribution rate?

      Question : How to set HRDF contribution rate? Answer : 1) Go to Tools > Company Profile 2) Select Basic Information, then select ‘HRDF Contribution Percentage’ 3) You may enter the number of percentage without the percentage symbol. Example 1%, enter ...

    • A3.187 : Formula: How to set up formula for Baitulmal deduction?

      Question : Formula: How to set up formula for Baitulmal deduction? Answer 1) Go to Tools > General Maintenance > Deduction> Add New > Baitulmal 2) Key the formula as below. Save after done. 3) Now formula for Baitulmal is set. --Source from AutoCount ...

    • A3.97 : How to set formula in claim type example for mileage?

      Question : How to set formula in claim type example for mileage? Answer : 1) Go to Tools > Claim Type 2) Click on Add New button to add new claim type for Mileage Claim. 3) Key in the claim code and description then click on Add Detail button to add ...