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
Step 2: Click on
Step 3: Search for the employee's name and click on the icon.
Step 4: You will be brought to that staff's Pay Information page. Please click on button.
Step 5: Under the tab, scroll down and look for the work week field
Step 6: Assign the correct workweek, then click
*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
Step 2: Also click the pay element settings.
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.
*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
Step 2: Click on
Step 3: Look for the tab at the top
Step 4: Search for the employee's name, and click on the icon to view the details.
In the image shown below, there are overlapping Effective Dates: This will cause the proration to be inaccurate.
To delete double entries or overlapping effective dates, click on the button under the Actions column and then add in the correct entry if necessary.