[Version 2.0] Calculation Of Overtime Claim Automatically In Payroll (Overtime Automatic In Payroll)
The MySyarikat system will help in calculating the amount of Overtime Claims applied for by employees in salary processing. HR/Admin needs to set this function in System Setting > Payment > Overtime Setting
The MySyarikat system allows the HR/Admin to make a choice whether the Overtime Claim amount goes into Payroll only, Payment Voucher only or both
It should also be noted that the basic salary amount of the staff on the Employee Salary Table needs to be set as well. If the basic salary amount is not set, the Overtime Claim application will be RM0.00
Any Overtime Claim application will continue to be counted in the payroll which will be included in the Additional Item section
For Overtime Claims in Version 2, there are 3 types of calculation that HR/Admin can choose.
Note: From Application is according to the Overtime Claim applied by the staff
Note: By Policy is according to the Overtime rate that has been set by HR/Admin. The system will display all the fixed Overtime Claim rate & custom Overtime Claim rate that HR/Admin has created in System Setting > Claim > Overtime
Note: Custom is a manual calculation. HR/Admin can enter the Overtime Claim value manually
Overtime Calculation Formula In MySyarikat System
Here is the formula for calculating the Overtime Claim in the MySyarikat system:
Get the total hourly wages
Formula:
= Basic or Gross Salary / 26 days / Total working hours (8 or 7.5 hours)
Note: The amount of 26 days can be referred to in the Overtime working days in month section
Note: The total working hours can be referred to in the Standard Working Hours section
Calculate the amount of Overtime
Formula:
= Total Hourly Wage multiplied by Total Overtime Hours multiplied by Overtime rate (1.5, 2.0, 3.0, etc)
Note:
1.5 = Working days
2.0 = Rest day
3.0 = Public holiday
Overtime Claim
Setup
For Overtime Claim setup, HR/Admin can refer to the following steps:
Step 1: Click System Settings
Step 2: Click Payment
Step 3: On the Count approved Overtime into Payroll button
Step 4: In the Wage Calculation column, HR/Admin can select Basic Salary or Gross Salary
Note 1: If Basic Salary is selected in the Wage Calculation column, the system will calculate the amount of Overtime according to the staff's basic salary
Note 2: If Gross Salary is selected in the Wage Calculation column, the system will calculate the Overtime amount according to the staff's gross salary (Basic Salary + all allowances)
Step 5: Fill in the information on the Overtime Cut-off Date section
Note: This section is the most important. We recommend that HR/Admin set the Overtime cut-off date based on the company's payroll cycle. Any setting that does not comply with this setting will be ignored
Example:
a) If the amount in the Overtime Cut-off Date column is entered on the 31st day of the month, for the November payroll, the cycle cut-off date that will be included in the payroll is from 31/10/2023 to 30/11/2023
b) For a month that has a total of 30 days such as September, if the amount in the Overtime Cut-off Date column is entered as 31 days of the month, for the October payroll, the cycle cut-off date that will be included in the payroll is from 30/9/2023 to 30 /10/2023
Step 6: In the Compensation Rounded column, HR/Admin can select No Round, Round Up, Round Down
Note 1: No Round refers to the Overtime value will not be rounded. Example: Overtime value is RM5.45 will not be rounded to another value, will remain at RM5.45
Note 2: Round Up refers to the value of Overtime will be rounded to the upper value. Example: Overtime value of RM5.45 will be rounded to RM5.50
Note 3: Round Down refers to the Overtime value that will be rounded down to a lower value. Example: Overtime value of RM5.45 will be rounded to RM5.40
Step 7: Fill in the information in the Overtime working days in month column
Step 8: Click Save Changes
Step 9: In the Standard Working Hour column, enter the desired amount
Additional Notes for HR/Admin
For the amount of Overtime entered in the payroll automatically:
Staff need to apply for Overtime first
HR must approve the Overtime according to the Overtime cut-off date cycle.
- To check the cut-off date in the system settings you can follow the steps below:
i. Click System Settings
iii. Click Payment
iii. Check on Overtime Settings
iv. Click and check on the Overtime Cut-off Date
Example:
a) If the amount in the Overtime Cut-off Date column is entered on the 31st day of the month, for the November payroll, the cycle cut-off date that will be included in the payroll is from 31/10/2023 to 30/11/2023
b) For a month that has a total of 30 days such as September, if the amount in the Overtime Cut-off Date column is entered as 31 days of the month, for the October payroll, the cycle cut-off date that will be included in the payroll is from 30/9/2023 to 30 /10/2023
Payroll is generated after all Overtime is approved in the Overtime cut-off date cycle
If the payroll is generated and Overtime is applied and approved, the Overtime amount is not included in the payroll
The Overtime amount must be entered manually in the payroll
How to Update Overtime Amount in Staff Payroll
To update the Overtime Claim amount in payroll, HR/Admin can refer to the following tutorial link:
https://mysyarikat.crisp.help/en/article/version-20-how-to-updateedit-overtime-claim-in-staff-payroll-edit-overtime-payroll-141178c/
The MySyarikat system allows the HR/Admin to make a choice whether the Overtime Claim amount goes into Payroll only, Payment Voucher only or both
It should also be noted that the basic salary amount of the staff on the Employee Salary Table needs to be set as well. If the basic salary amount is not set, the Overtime Claim application will be RM0.00
Any Overtime Claim application will continue to be counted in the payroll which will be included in the Additional Item section
For Overtime Claims in Version 2, there are 3 types of calculation that HR/Admin can choose.
Note: From Application is according to the Overtime Claim applied by the staff
Note: By Policy is according to the Overtime rate that has been set by HR/Admin. The system will display all the fixed Overtime Claim rate & custom Overtime Claim rate that HR/Admin has created in System Setting > Claim > Overtime
Note: Custom is a manual calculation. HR/Admin can enter the Overtime Claim value manually
Overtime Calculation Formula In MySyarikat System
Here is the formula for calculating the Overtime Claim in the MySyarikat system:
Get the total hourly wages
Formula:
= Basic or Gross Salary / 26 days / Total working hours (8 or 7.5 hours)
Note: The amount of 26 days can be referred to in the Overtime working days in month section
Note: The total working hours can be referred to in the Standard Working Hours section
Calculate the amount of Overtime
Formula:
= Total Hourly Wage multiplied by Total Overtime Hours multiplied by Overtime rate (1.5, 2.0, 3.0, etc)
Note:
1.5 = Working days
2.0 = Rest day
3.0 = Public holiday
Overtime Claim
Setup
For Overtime Claim setup, HR/Admin can refer to the following steps:
Step 1: Click System Settings
Step 2: Click Payment
Step 3: On the Count approved Overtime into Payroll button
Step 4: In the Wage Calculation column, HR/Admin can select Basic Salary or Gross Salary
Note 1: If Basic Salary is selected in the Wage Calculation column, the system will calculate the amount of Overtime according to the staff's basic salary
Note 2: If Gross Salary is selected in the Wage Calculation column, the system will calculate the Overtime amount according to the staff's gross salary (Basic Salary + all allowances)
Step 5: Fill in the information on the Overtime Cut-off Date section
Note: This section is the most important. We recommend that HR/Admin set the Overtime cut-off date based on the company's payroll cycle. Any setting that does not comply with this setting will be ignored
Example:
a) If the amount in the Overtime Cut-off Date column is entered on the 31st day of the month, for the November payroll, the cycle cut-off date that will be included in the payroll is from 31/10/2023 to 30/11/2023
b) For a month that has a total of 30 days such as September, if the amount in the Overtime Cut-off Date column is entered as 31 days of the month, for the October payroll, the cycle cut-off date that will be included in the payroll is from 30/9/2023 to 30 /10/2023
Step 6: In the Compensation Rounded column, HR/Admin can select No Round, Round Up, Round Down
Note 1: No Round refers to the Overtime value will not be rounded. Example: Overtime value is RM5.45 will not be rounded to another value, will remain at RM5.45
Note 2: Round Up refers to the value of Overtime will be rounded to the upper value. Example: Overtime value of RM5.45 will be rounded to RM5.50
Note 3: Round Down refers to the Overtime value that will be rounded down to a lower value. Example: Overtime value of RM5.45 will be rounded to RM5.40
Step 7: Fill in the information in the Overtime working days in month column
Step 8: Click Save Changes
Step 9: In the Standard Working Hour column, enter the desired amount
Additional Notes for HR/Admin
For the amount of Overtime entered in the payroll automatically:
Staff need to apply for Overtime first
HR must approve the Overtime according to the Overtime cut-off date cycle.
- To check the cut-off date in the system settings you can follow the steps below:
i. Click System Settings
iii. Click Payment
iii. Check on Overtime Settings
iv. Click and check on the Overtime Cut-off Date
Example:
a) If the amount in the Overtime Cut-off Date column is entered on the 31st day of the month, for the November payroll, the cycle cut-off date that will be included in the payroll is from 31/10/2023 to 30/11/2023
b) For a month that has a total of 30 days such as September, if the amount in the Overtime Cut-off Date column is entered as 31 days of the month, for the October payroll, the cycle cut-off date that will be included in the payroll is from 30/9/2023 to 30 /10/2023
Payroll is generated after all Overtime is approved in the Overtime cut-off date cycle
If the payroll is generated and Overtime is applied and approved, the Overtime amount is not included in the payroll
The Overtime amount must be entered manually in the payroll
How to Update Overtime Amount in Staff Payroll
To update the Overtime Claim amount in payroll, HR/Admin can refer to the following tutorial link:
https://mysyarikat.crisp.help/en/article/version-20-how-to-updateedit-overtime-claim-in-staff-payroll-edit-overtime-payroll-141178c/
Updated on: 16/03/2024
Thank you!