What are the things to consider to make sure that system prorates the basic salary?

Introduction

The system calculates proration based on the total number of working days in a month and the specific number of days the employee was actively working.

To ensure accurate salary proration when an employee joins or leaves the company, check the following:

A) Work Week 

Please make sure that the correct work week is assigned to the employee. To do so, please follow the steps below:
Step 1: Go to PAYROLL.png
Step 2: Click on admin.png
Step 3: Search for the employee's name and click on the pencil_icon.pngicon.
Step 4: You will be brought to that staff's Pay Information page. Please click on view_details.pngbutton.
Step 5: Under the employee_info.pngtab, scroll down and look for the work week field
Picture1.png
Step 6: Assign the correct workweek, then click save.png

*Note: The prorated basic salary formula is Basic Pay / Number of working days in a month * Number of days the employee worked. So it is important that the workweek of the employee is correctly assigned.

B) Basic Pay (Pay Element)

This can be checked inside Employee Pay Information under Additions.

Step 1: Make sure the Basic Pay in the box is BasicPay (one word) as this is a syntax and will pick up the data from the Salary Progression page 

Picture2.png

Step 2: Also click the pay element settings.
Picture3.png

It will open the Pay Element Details. On the Criteria field, make sure that the Prorated option is ticked. You may hover your mouse pointer to the ? to see the meaning.

Picture4.png

*Note: If the 'CPF Payable' option is ticked, for employees joining mid-month, both basic pay and CPF contributions will be prorated. If a Permanent Resident (PR)'s start date falls mid-month, CPF will be prorated according to the first-year CPF rate for their age group.

C) Joined Date or Cessation date

Please make sure that the correct Joined Date and/or Cessation Dates of the staff are in the system. This will be used as a basis for the prorated calculation as well.

D) Salary Progression page

Please ensure that there are no overlapping dates for the salary progression of the staff. This will cause the system to miscalculate the proration. If there are overlapping dates or several lines with the same effective dates, please delete, then add the salary progression of the staff again. This can be seen by following the steps below:
Step 1: Go to PAYROLL.png
Step 2: Click on admin.png
Step 3: Look for the salary_progression.pngtab at the top
Step 4: Search for the employee's name, and click on the eye.png icon to view the details.
In the image shown below, there are overlapping Effective Dates: This will cause the proration to be inaccurate.
Picture5.png
To delete double entries or overlapping effective dates, click on the x_button.pngbutton under the Actions column and then add in the correct entry if necessary.

Was this article helpful?
2 out of 4 found this helpful