Whose basic salary is 35000, and he wants to adopt the minimum PF contributions on the maximum PF limit of Rs. 15000, so it's Rs. 1800/-. If he presents for 7 days out of 26 days, then how much PF is deducted from his salary. If he presents for 15 days out of 26 days, then how much PF is deducted from his salary. If he presents for 20 days out of 26 days, then how much PF is deducted from his salary.
If they want to deduct PF on full basic, then it's Rs. 4200/-. If they want to not deduct PF, then it's Rs. 0.
But who agrees that if anyone adopts Option 1, then Rs. 1800 is reduced based on attendance? Generally, PF Rs. 1800 is not reduced up to their basic reduced up to Rs. 15000.
1. =(ROUND(IF($DT48="F",(Basic)*12%,IF($DT48="N",0,IF (AND($DT48="Y",(Basic)>14999),1800/26*(7/15/20),(Basic)*12%))),0)
2. =(ROUND(IF($DT48="F",(Basic)*12%,IF($DT48="N",0,IF (AND($DT48="Y",(Basic)>14999),1800,(Basic)*12%))), 0)
Give your true inputs for the same. If possible, provide an EPFO circular that defines it clearly with examples. Which formula is right, formula 1 or formula 2?
Thanks
From India, Indore
Acknowledge(0)
Amend(0)
If they want to deduct PF on full basic, then it's Rs. 4200/-. If they want to not deduct PF, then it's Rs. 0.
But who agrees that if anyone adopts Option 1, then Rs. 1800 is reduced based on attendance? Generally, PF Rs. 1800 is not reduced up to their basic reduced up to Rs. 15000.
1. =(ROUND(IF($DT48="F",(Basic)*12%,IF($DT48="N",0,IF (AND($DT48="Y",(Basic)>14999),1800/26*(7/15/20),(Basic)*12%))),0)
2. =(ROUND(IF($DT48="F",(Basic)*12%,IF($DT48="N",0,IF (AND($DT48="Y",(Basic)>14999),1800,(Basic)*12%))), 0)
Give your true inputs for the same. If possible, provide an EPFO circular that defines it clearly with examples. Which formula is right, formula 1 or formula 2?
Thanks
From India, Indore
Acknowledge(0)Amend(0)
If the PF is restricted to 12% on Rs 15,000, then 15,000 should be taken as wages, and any deduction for absence should be made from 15,000. Then only the contribution will equate to the number of days present. Therefore, if the employee has worked only for 7 days out of 26 days, the PF contribution should be 15,000/26 x 7 = 4038 x 12% or Rs 485. If the employee has worked for 15 days, then the PF qualifying wages should be Rs 8654 and not Rs 15,000, though the actual salary is Rs 20,192. However, the EPF authorities demand contribution on Rs 15,000, saying that it is the PF qualifying salary for the month, but they don't give any answer if you ask them, "Can an employee who has non-contributory days of 15 days be given a pension contribution of Rs 1250?"
From India, Kannur
Acknowledge(0)Amend(0)
4761From India, Kannur
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls