Dear All,
Our company has a policy to calculate daily wages by multiplying the gross salary by 12 and dividing it by 365. However, I am facing problems with the months where the total days are 32.
For example, if Employee A has a gross salary of $12,000 and is to be paid for 31 days out of 32 days in a particular month, then as per this policy, it becomes:
Salary for 31 days = (12000 * 12/365) * 31 = $12,231 (which is even greater than the gross salary)
Please suggest any solutions or alternatives.
Regards,
Preeti
From Nepal
Acknowledge(0)
Amend(0)
Our company has a policy to calculate daily wages by multiplying the gross salary by 12 and dividing it by 365. However, I am facing problems with the months where the total days are 32.
For example, if Employee A has a gross salary of $12,000 and is to be paid for 31 days out of 32 days in a particular month, then as per this policy, it becomes:
Salary for 31 days = (12000 * 12/365) * 31 = $12,231 (which is even greater than the gross salary)
Please suggest any solutions or alternatives.
Regards,
Preeti
From Nepal
Acknowledge(0)Amend(0)
I don't understand how you are calculating the 32 days for salary for a month, as the maximum days in a month are 31! However, it seems that you are still managing your salary process manually, which is why you are facing such a problem. It would be better if you implement some advanced HR or Payroll software. This will help you avoid such complications and manage all your salary and payroll processes very easily. You can try SaralPayroll, which comes with a free version as well as a money-back guarantee.
From India, Lucknow
Acknowledge(0)Amend(0)
191From India, Lucknow
Acknowledge(0)Amend(0)
Hi Preethi,
I just want to know why you want to go through the lengthy process of calculating daily wages. Each month has either 30 or 31 days at max, with only one month having 28 days.
Per Day Wage = Salary / No. of days
If you take Salary = 12000 per month and September has 30 days, then:
Per day wage = 12000 / 30 = 387.10
If you multiply this by 30 days, you will get back to 12000. In case someone takes a 5-day leave and you need to deduct that amount:
Per day wage x No. of days worked = 387.10 x 25 = 9677.42 (If it is more than 50 paise, you can add Rs. 1/-; if less than 50 paise, deduct that and round it off).
In February, you need to calculate 12000 / 28 days = 428.57.
That's all, dear.
Regards,
Rose
From India, Bangalore
Acknowledge(0)Amend(0)
I just want to know why you want to go through the lengthy process of calculating daily wages. Each month has either 30 or 31 days at max, with only one month having 28 days.
Per Day Wage = Salary / No. of days
If you take Salary = 12000 per month and September has 30 days, then:
Per day wage = 12000 / 30 = 387.10
If you multiply this by 30 days, you will get back to 12000. In case someone takes a 5-day leave and you need to deduct that amount:
Per day wage x No. of days worked = 387.10 x 25 = 9677.42 (If it is more than 50 paise, you can add Rs. 1/-; if less than 50 paise, deduct that and round it off).
In February, you need to calculate 12000 / 28 days = 428.57.
That's all, dear.
Regards,
Rose
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Preeti,
I cannot understand your post, and that's why I am not able to suggest or reply. If possible, kindly put your post with specific words. I am waiting for your post again, or you can email me.
Jasmin Ratanpara
Email: jasmin_0584@yahoo.in
From India, Surat
Acknowledge(0)Amend(0)
I cannot understand your post, and that's why I am not able to suggest or reply. If possible, kindly put your post with specific words. I am waiting for your post again, or you can email me.
Jasmin Ratanpara
Email: jasmin_0584@yahoo.in
From India, Surat
Acknowledge(0)Amend(0)
Which month of the year has 32 days?
Did we change the calendar system?
In any case, your approach is wrong. What you are required to do is pay the full salary for a month where the employee has been present on all working days (or has taken approved leave). In other months, you need to deduct salary for absence based on a daily rate computed by dividing the gross monthly wage/salary by 26.
From India, Mumbai
Acknowledge(0)Amend(0)
Did we change the calendar system?
In any case, your approach is wrong. What you are required to do is pay the full salary for a month where the employee has been present on all working days (or has taken approved leave). In other months, you need to deduct salary for absence based on a daily rate computed by dividing the gross monthly wage/salary by 26.
From India, Mumbai
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Tangent HR Solutions.ppt
SALARY SHEET CALCULATION.xls