Skip to content
English
BrioHR Website
  • There are no suggestions because the search field is empty.

Prorated Salary Calculation: Understanding the Basics in BrioHR

Learn how to calculate prorated salaries using BrioHR's formulas for Malaysia Payroll. Explore detailed examples and understand the impact of different calculation bases like fixed days, working days, and all days in the current month.

Audience & Scope

Audience: HR Admin

Module: Payroll

Country: Global

Pre-requisites: Payroll Manager access to required payroll center

 

In BrioHR, there are three formulas to calculate the basis of prorated salary:

  1. Fixed Number of Days
  2. Working Days in the Current Calendar Month
  3. All Days in the Current Calendar Month

Understanding how the daily rate is calculated for each formula is crucial.

If you're looking for instructions on how to set up the basis of prorated salary calculation, please refer here.

NOTE:

The final overtime earnings will be rounded to the nearest figure.

1. Fixed Number of Days (Working Days Based on Work Schedule)

Formula:

Salary / (Number of fixed days set in the system) = Daily Rate

Daily Rate x Number of working days in the month = Prorated Salary

Example:

  • Salary: RM 3000
  • Prorated Fixed Days set in the system: 26
  • Join Date: 11 September 2023
  • Number of Days Employee Worked: 15 days (excluding weekends)

Calculation:

RM 3000 / 26 = RM 115.38 (Daily Rate)
RM 115.38 x 15 days worked = RM 1,730.77 (Prorated Salary)

NOTE:

The system calculates an employee's number of working days based on the "working days" set in the Work Schedule. If you select 5 days (e.g., Mon - Fri), the system excludes unselected days.

To access the Work Schedules, click into Settings > Schedules & Shift > Work Schedule. You can then assign employees to their respective schedules.

5rdRSpYbnLKmZqx0FpXY5DNfrNl6SFUVVQ.png?1712286932

NOTE:

Public holidays will be captured as working days using this setting.

2. Working Days in the Current Calendar Month (Excluding Weekends)

Formula:

Salary / (Total days in the month - Total weekends in the month) = Daily Rate
Daily Rate x Number of days worked in the month = Prorated Salary

Example:

  • Salary: RM 3000
  • Join Date: 11 September 2023
  • Working Days in September 2023: 21 days
  • Number of Days Employee Worked: 15 days (excluding weekends)

Calculation:

RM 3000 / 21 working days = RM 142.86 (Daily Rate)
RM 142.86 x 15 days worked = RM 2,142.86 (Prorated Salary)

eA30O3quP4QIk7TeCjvylNjAv7zG3EG9xA.png?1681697080

NOTE:

The system calculates the number of working days based on the "working days" set in the Work Schedules. Public holidays will be captured as working days using this setting. This formula is applied only when 'Working Days in the Current Calendar Month' is selected as the basis for prorated salary calculation.

lCks0QECY6oh7lT0rR13BdRdRcYXDw24Ag.png?1705456100

NOTE:

Public holidays will be captured as working days using this setting.

3. All Days in the Current Calendar Month (Including Weekends)

Formula:

Salary / (All days in the calendar month) = Daily Rate
Daily Rate x Number of days worked in the month = Prorated Salary

Example:

  • Salary: RM 3000
  • Join Date: 11 September 2023
  • Total Days in September 2023: 30 days
  • Number of Days Employee Worked: 20 days (including weekends)

Calculation:

RM 3000 / 30 days = RM 100.00 (Daily Rate)
RM 100.00 x 20 days worked = RM 2,000.00 (Prorated Salary)

0QDHiKO_W0GhSk_dPIo7OSjRmIfTu_bpag.png?1681697162

 

 

Ownership

Last updated by : Arveena