How does Prorate Calculation works for New Hired & Terminated Employees?

Created by Kamiworkforce Support Admin, Modified on Fri, 25 Aug, 2023 at 1:56 PM by Alaika Dimagiba

>>Payroll


Wages of newly hired & terminated employees are usually prorated on their First & Last payslips.


Let's learn more about how we can compute such wages on KAMI!


 


PRORATE BASIS


>>Payroll> Payment Configuration >Wage Days


Before running the payroll, make sure you selected the correct prorate basis for your company.


Prorate basis will determine the total number of days that will be used in calculating the prorate wages.


 


SAMPLE COMPUTATION OF EACH PRORATE BASIS


We prepared a simple scenario to help you understand the difference between the prorate basis options.


Scenario:


NEW HIRE EMPLOYEETERMINATED EMPLOYEE

  • Employee A was hired on November 4, 2022 (8 days of work)
    • Monthly Basic Salary = 24,000

  • The employee is required to work on Weekdays from 8 am to 5 pm
  • Payroll & Attendance Cut-off was November 1 - 15, 2022(Semi-Monthly payroll)
  • Employee A does not have any tardy or absent within the cut-off


  • Employee B was terminated on November 10, 2022 (8 days of work)
    • Monthly Basic Salary = 24,000

  • The employee is required to work on Weekdays from 8 am to 5 pm
  • Payroll & Attendance Cut-off was November 1 - 15, 2022(Semi-Monthly payroll)
  • Employee B does not have any tardy or absent within the cut-off




Calendar Days


NEW HIRE EMPLOYEETERMINATED EMPLOYEE

  • Total working days = 12 days (working days from the hired date including rest days)
  • Total day in the cut-off = 15 days (include all days in the cut-off)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 15
      • Prorate Wage = 9,600.00




  • Total working days = 10 days (working days & rest days until termination date)
  • Total day in the cut-off = 15 days (include all days in the cut-off)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 10 / 15
      • Prorate Wage = 8,000.00







Working Days


NEW HIRE EMPLOYEETERMINATED EMPLOYEE

  • Total working days = 8 days (working days from the hired date)
  • Total day in the cut-off = 11 days (will depend on Workdays/week of an employee)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 11
      • Prorate Wage = 8,727.27

    •  



  • Total working days = 8 days (until termination date)
  • Total day in the cut-off = 11 days (will depend on Workdays/week of an employee)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 11
      • Prorate Wage = 8,727.27







EEMR (Estimated Equivalent Monthly Rate)


NEW HIRE EMPLOYEETERMINATED EMPLOYEE

  • Total working days = 8 days (working days from the hired date)
  • Total day in the cut-off = 10.875 days (please based on the formula of EEMR then divide it into 2 to get semi-monthly days )
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 10.875
      • Prorate Wage = 8,827.59




  • Total working days = 8 days (until termination date. Holiday are included)
  • Total day in the cut-off = 10.875 days (please based on the formula of EEMR then divide it into 2 to get semi-monthly days )
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 10.875
      • Prorate Wage = 8,827.59





Fixed Monthly Days


NEW HIRE EMPLOYEETERMINATED EMPLOYEE

  • Total working days = 8 days (working days from the hired date)
  • Total day in the cut-off = 10.83335 days (Fixed monthly days / 2 to get semi-monthly days)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 10.83335
      • Prorate Wage = 8,861.54




  • Total working days = 8 days (until termination date)
  • Total day in the cut-off = 10.83335 days (Fixed monthly days / 2 to get semi-monthly days)
  • Prorate wage = Wage * Total Working days / Total days in the cut-off 

      • 12,000 * 8 / 10.83335
      • Prorate Wage = 8,861.54




  •  


 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article