Formula use in excell for the deductions of PF and ESI in the salary
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Talk To Seniors

anju.sharmasas@gmail.com 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 ..

thanks
anjna

Amit Insha -  Member Since: Oct 2009
Dear Anjna, Find the attached herewith Excel sheet, hope this is helpful for you.


Attached FilesProvided by community member Amit Insha. Join us to learn and grow with your peers.
File Type: xls formula use in excell for the deductions of PF and ESI in the salary.xls (23.0 KB, 9767 views)
anju.sharmasas@gmail.com -  Member Since: Feb 2011
Dear amit, thanks a lot to share me my questions . am well understand in excell sheet . thanks anjna sharma

anju.sharmasas@gmail.com -  Member Since: Feb 2011
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

ommygautam -  Member Since: Nov 2007
Quote:
Originally Posted by anju.sharmasas@gmail.com View Post
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

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

M.Sayeed -  Member Since: Jun 2010
Please review attached. Thanks,


Attached FilesProvided by community member M.Sayeed. Join us to learn and grow with your peers.
File Type: xls SALARY(1).xls (23.5 KB, 2679 views)
anju.sharmasas@gmail.com -  Member Since: Feb 2011
M.SAYEED AM UNDERSTAND G5 BUTin k5 which one digits come under and next things is that this : sign means divide thanks anjna

M.Sayeed -  Member Since: Jun 2010
K5 - Is special allowanance 250rs, if employee work less days then it dedected, where K5 shows 234, which means employee is off for 2 days, rs 16 dedected. : = addition of multiple cell. Thanks

kukimon -  Member Since: Nov 2008
Is any Govt rule on Basic, DA & other allowance? who will get the Education allowance, Medical Allowance

jeevarathnam -  Member Since: Aug 2007
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




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    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.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network