Managing salary calculations for employees during incomplete months can be a perplexing task. Whether you're onboarding new hires mid-month, managing no-pay leave, or facing other scenarios leading to incomplete salary periods, worry not! In this guide, we will equip you with the necessary knowledge to calculate an incomplete month’s salary with ease, ensuring accurate remuneration for your employees.
It is not uncommon for your employees to clock in an incomplete month of work. Here are some scenarios where partial months may occur:
According to the Ministry of Manpower (MOM), the formula to calculate salary for an incomplete month is:
(Monthly gross rate of pay) ÷ (Total number of working days in that month) x (Total number of days the employee actually worked in that month)
Let’s dive deeper into each key component and its respective definition:
Now that we’ve understood the definitions of the key components, let's consider a practical example to illustrate how the salary calculation formula works for an incomplete month.
Sarah is an employee working at a tech startup in Singapore with a 5-day work week. Sarah joined the company on 15 June 2023, and her monthly gross rate of pay is SGD 4,500. The month of June has 30 days, with 2 public holidays (2 June - Vesak Day and 29 June - Hari Raya Haji).
To calculate Sarah's salary for the incomplete month of June, here are the steps:
Step 1: Calculate the total number of working days in June 2023
The total number of working days in June 2023 is 22 days, including 2 public holidays.
Step 2: Calculate the total number of days Sarah actually worked in June
The total number of days Sarah actually worked = 11 days + 1 public holiday (29 June) = 12 days
Step 3: Calculate Sarah’s salary for the incomplete month of June
Salary for the incomplete month = (Monthly gross rate of pay) ÷ (Total number of working days in that month) x (Total number of days the employee actually worked in that month)
Sarah's salary for June = SGD 4,500 ÷ 22 x 12 ≈ SGD 2,454.55 (rounded to two decimal places)
Here’s a useful table that you can use to quickly determine the monthly total number of working days in 2024, depending on your company’s working schedule.
Total number of working days in the month | ||||||
Calendar Month | Calendar Days | Number of Sundays | Number of Saturdays | 5-day work week | 5.5-day work week | 6-day work week |
January | 31 | 4 | 4 | 23 | 25 | 27 |
February | 29 | 4 | 4 | 21 | 23 | 25 |
March | 31 | 5 | 5 | 21 | 23.5 | 26 |
April | 30 | 4 | 4 | 22 | 24 | 26 |
May | 31 | 4 | 4 | 23 | 25 | 27 |
June | 30 | 5 | 5 | 20 | 22.5 | 25 |
July | 31 | 4 | 4 | 23 | 25 | 27 |
August | 31 | 4 | 5 | 22 | 24.5 | 27 |
September | 30 | 5 | 4 | 21 | 23 | 25 |
October | 31 | 4 | 4 | 23 | 25 | 27 |
November | 30 | 4 | 5 | 21 | 23.5 | 26 |
December | 31 | 5 | 4 | 22 | 24 | 26 |
Total | 366 | 52 | 52 | 262 | 288 | 314 |
Notes:
We understand that calculating an incomplete month’s salary for your employees can be confusing and error-prone. This is why we’ve created a free Salary Proration Calculator to help you calculate your employees’ prorated salary for the month! It takes into account the following:
Need more complex calculations, especially if you are managing a large team of employees? Our Payboy payroll module is here to help! With our fully compliant, customisable, and integrated payroll processing module, you can automate the calculation of an incomplete month’s salary and also enjoy additional features that are designed to save you time and effort:
As a PSG-approved HRMS, Payboy provides a robust system to help you manage your HR tasks so that you can focus on your business and people!
With our wide range of modules, you can customise a solution to meet the specific needs of your business:
Payroll Processing | Leave Management | Claims Management | Applicant Tracking | Time Attendance | Shift Scheduling | Appraisal System | Inventory Management | Project Costing | Training Management | Benefits