Advance Search Feature
Available Downloads - Page 1
Search Result For "Excel Formula Of Pf Deducting Fixed 1800" - Page 1
If the amount is equal to 15000, then we use the formula = sum(Basic + DA) * 12% in the salary statement or payroll statement in Excel.What is the formula if Basic + DA is less or greater than 15000? Can anybody please answer me?
Dear mahanty68,We know that the ceiling amount for the deduction of PF is ₹6,500, i.e., it is the basic salary of an employee. However, if a person is receiving a basic salary higher than the ceiling amount, they are given the choice to opt for the opportunity. ...
1\. Design LTA rules for a manufacturing company where the basic range is from 2000 pm to 100000 pm. How can you provide maximum benefits to an employee while considering income tax provisions?2\. Draw a table of prevailing state-wise minimum basic wages. Additi...
Dear Akhi,Please update your knowledge in Labour Laws. ESI is not applicable for employees whose monthly gross salary is above Rs 21,000/-.With regard to EPF, you have to issue EPF Form #11 to all EPF-excluded employees to determine their eligibility for coverag...
Dear Srinath sir,Our company is covered under the PF & ESIC acts. However, our advocate has informed me that we cannot deduct PF & ESIC for employees whose basic salary exceeds 25,000 rupees, and professional tax is not applicable in Uttar Pradesh. Therefore, we...
If the employee is getting ₹1 lakh in hand per month, then he has to pay income tax. Therefore, your company will be liable to pay the same along with a penalty for not deducting TDS. An alternative is to gross up the salary to include tax and pay the differenti...
Dear Sir,I have an employee, and I will pay him 1 lakh fixed in hand without deducting any tax or PF. Kindly suggest how I can issue him a salary slip. Please share any format if available.Thank you.
Dear Akhi,How can you pay a 1 Lakh salary to an employee without deducting TDS? Is it a consolidated salary? Is your company covered under the EPF Act? Is profession tax applicable to your company?
Hi Team,I have one doubt about the PF contribution. If an employee joins for the first time in any organization after 01-Sep-2014 and his basic salary is more than 15000/month (i.e. 23000) at the time of joining, and the organization decides to fix his PF contri...
In the scenario described, the Employee Pension Scheme (EPS) eligibility and applicability are crucial considerations. Here's a detailed response to address the query:**Understanding EPS Eligibility in the Given Scenario**- The EPS eligibility is determined base...