Started The Discussion:
Dear seniors,

am currently face a interview in which interviewers asked me a questions how am deducted the PF& ESI in the salary what formula use in excel l sheet in which automatically deductions of the PF and ESI of each employees in the salary .kindly pls told me the formula use ..

13th May 2011 From India, Chandigarh

Dear Anjna, Find the attached herewith Excel sheet, hope this is helpful for you.
13th May 2011 From India, Delhi
Attached Files
Shared By Cite.Community Member "Amit Insha"
File Type: xls formula use in excell for the deductions of PF and ESI in the salary.xls (23.0 KB, 19661 views)
Dear amit, thanks a lot to share me my questions . am well understand in excell sheet . thanks anjna sharma
13th May 2011 From India, Chandigarh
ommy thanks , pls tell me one thins that all deductions in gross salary or basic salary means basic salary gross salary and net salary what is difference between these thanks , anjna
13th May 2011 From India, Chandigarh

if u don't mind then i think if u will discuss with me on phone then i can clear u more effectivly.

Basic Means it is decided by state govt. for workers and DA means dearness allowence. so toal basic means ( Basic+ DA)

gross menas his total monthly salary ( how many salary is made for per month) where part of salary is Basic, HRA, Conveyance, Education All. Special Allowence

Net menas after deduction of PF, Esic ( If Applicable) and other deduction as per company policy
13th May 2011 From India, Rudarpur
Please review attached. Thanks,
19th May 2011 From Kuwait, Hawalli
Attached Files
Shared By Cite.Community Member "M.Sayeed"
File Type: xls SALARY(1).xls (23.5 KB, 6194 views)
M.SAYEED AM UNDERSTAND G5 BUTin k5 which one digits come under and next things is that this : sign means divide thanks anjna
19th May 2011 From India, Chandigarh
Is any Govt rule on Basic, DA & other allowance? who will get the Education allowance, Medical Allowance
19th May 2011 From India, Delhi
Dear Sayeed In your attachment PF is been deducted only from Basic but it should be on total of Basic & DA. Kindly check it Regards
20th May 2011 From India, Bangalore
Hi this is shekar valeru, its my first time the posted the qustion, my question is what you have given salary formula is very dificult to me give me clarity,tq.
20th May 2011 From India, Hyderabad


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network