Dear All,
Our company has a policy to calculate a day wages by multiplying gross salary by 12 and dividing it by 365, but i am facing problems with the months where the total days are 32.
for Eg. if employee A has a gross salary of 12,000 and he is to be paid for 31 days only out of 32 days in a particular month...then, as per this policy, it becomes,
Salary for 31 days = (12000*12/365)*31 = 12231 (which is even greater than the gross salary)
Please suggest...
Regards,
Preeti
From Nepal
Our company has a policy to calculate a day wages by multiplying gross salary by 12 and dividing it by 365, but i am facing problems with the months where the total days are 32.
for Eg. if employee A has a gross salary of 12,000 and he is to be paid for 31 days only out of 32 days in a particular month...then, as per this policy, it becomes,
Salary for 31 days = (12000*12/365)*31 = 12231 (which is even greater than the gross salary)
Please suggest...
Regards,
Preeti
From Nepal
Don't understand as how you are calculating the 32 days for salary for a month...as there are max you can go is for 31 days!!
However, it looks that you are still managing your salary process manually and that's why you are facing such problem. Better if you implement some advanced HR or Payroll software, that will help you to avoid such complications and manage your all salary and payroll process very easily. You can try SaralPayroll that comes with its free version as well as money back guarantee.
From India, Lucknow
183However, it looks that you are still managing your salary process manually and that's why you are facing such problem. Better if you implement some advanced HR or Payroll software, that will help you to avoid such complications and manage your all salary and payroll process very easily. You can try SaralPayroll that comes with its free version as well as money back guarantee.
From India, Lucknow
Hi Preethi,
I just want to know why do you want to go for a long procedure of counting daily wages?
Each month has either 30 or 31 day max. only one month has 28 days.
Per Day Wage = Salary / No. of days
If u take Salary = 12000 per month. September has 30 days.
Per day wage = 12000/30 = 387.10
If u multiply this again with 30 days u will get 12000.
In case if he takes 5 day leave and u need to deduct that amount then = per day wage x No. of days worked = 387.10 x 25 = 9677.42 (If it is more than 50 paise u can add Rs.1/-, if less than 50 paise minus that and make it round off)
In feb u need to take 12000/28 days = 428.57
that's all dear....
regards,
Rose
From India, Bangalore
I just want to know why do you want to go for a long procedure of counting daily wages?
Each month has either 30 or 31 day max. only one month has 28 days.
Per Day Wage = Salary / No. of days
If u take Salary = 12000 per month. September has 30 days.
Per day wage = 12000/30 = 387.10
If u multiply this again with 30 days u will get 12000.
In case if he takes 5 day leave and u need to deduct that amount then = per day wage x No. of days worked = 387.10 x 25 = 9677.42 (If it is more than 50 paise u can add Rs.1/-, if less than 50 paise minus that and make it round off)
In feb u need to take 12000/28 days = 428.57
that's all dear....
regards,
Rose
From India, Bangalore
Dear preeti,
I can not understand yr post and that y not able to suggest or reply. So if possible kindly put yr post with specific words.
waiting for yr post again. or mail me
Jasmin Ratanpara,
From India, Surat
I can not understand yr post and that y not able to suggest or reply. So if possible kindly put yr post with specific words.
waiting for yr post again. or mail me
Jasmin Ratanpara,
From India, Surat
Which month of the year has 32 days ?
Did we change the calander system ?
In any case, your approach is wrong.
What you are required to do is pay 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 gross monthy wage / salary by 26
From India, Mumbai
Did we change the calander system ?
In any case, your approach is wrong.
What you are required to do is pay 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 gross monthy wage / salary by 26
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
SALARY SHEET CALCULATION.xls
Company Profile.ppt