I need everyone's advise on the following query:
In our company, the rule for leave without pay is to deduct the salary per working day. For example, if the salary of an employee is Rs 26,000 pm (break up is BASIC-13000, DA-4500, CONVEYANCE ALLOWANCE-1600, HRA-4000, MEDICAL ALLOWANCE-1300 AND SPECIAL ALLOWANCE-1600) and the total days in a month are 30 - if the employee takes Leave without pay for 3 days, 3 x 26,000/30 = 2,600 would be deducted. So i want the full break of the salary? Is there any formula? Basically I want to create salary slip. Please help
Thanks and await your response urgently

From India, Indore
The deduction will be for all the components. So all the components, will be divided by the no of days for that month and the salary will be calculated. No directly on the gross. So accordingly the deductions will also vary.
Also, the salary slip will show the present days, leave days and absent days. These total should be more than the no. of days for that month.

From India, Mumbai
Hi , The attached file will assist you with your query .
From India, Mumbai

Attached Files (Download Requires Membership)
File Type: xls Salary Example.xls (37.0 KB, 2412 views)

all the components will be processed on pro-rata basis. As statutory calculations are done on basic and Gross, hence statutory will be processed for 27 days only.
From India, New Delhi
@SHWETANAIR.11 Thanx for the help. There was one more thing i needed to know if there is a professional tax deduction of Rs 208 than how will the calculation be done. I mean to say that is first professional tax will be deducted from the total salary and after that deduction will be for all the components percentage wise or vice versa. Please reply urgent.
From India, Indore
Dear all,
In the payment slip there should not be any deduction of unpaid days. You have only to pay him on attended days plus weekly off etc. Secondly, profession tax slab is on gross salary earned and not on any deduction. Hence, do not show any deduction of unpaid days but pay according to actual paid days.

From India, Pune
You first need to arrive at the gross salary payable of the month. ( Gross salary is before any deductions)
Professional Tax deduction is basis gross salary slabs.
Then as per the gross salary you need to determine what Professional tax you will deduct.The same will differ for other states.
In my example I have shown the same for Mumbai Location. ( Gross Salary above Rs 10000/ has Professional Tax as 200)
So instead of Rs 200, you need to show the amount which is for your state.
Pls note than any deduction be it Professional Tax, PF , ESIC , TDS or any other deduction will always be done after we compute the gross salary of the employee basis payable days.

From India, Mumbai
Dear all,
From the query of sameer I understand that he wants to pay him full and show a deduction of 2600 which is wrong. He need to pay for 27 days and accordingly make all statutory deductions.

From India, Pune
How much should the medical allowance should be ? what are the breakups for medical allowances?
and is there any basic formula for HRA? i.e it should be 40% or 50% of Basic?
pl do let me know if there is anything like that.

From India, Vadodara
@shweta - In this case , how the tax calculation (TDS) will be done for this employee, who has been paid for only 26 days? Do we need to deduct TDS basis his gross salary or the net amount credited in his account (ie after adusting salary for absent days). Please advise.

From India, Pune

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHRô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server