Need formula/procedure for EPF / PF calculation excel file - ceiling limit
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Labor & Employee Relations

ptiwari2ki@gmail.com Started The Discussion:

kind send me the excel file containing formulas for calculation of EPF etc

madhavi47 -  Member Since: Oct 2007
DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH MADHAVI47@GMAIL.COM


Attached FilesProvided by community member madhavi47. Join us to learn and grow with your peers.
File Type: xls epf_607.xls (13.5 KB, 12121 views)
File Type: xls epf_105.xls (13.5 KB, 4567 views)
ptiwari2ki@gmail.com -  Member Since: Dec 2007
Quote:
Originally Posted by madhavi47
DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH
Dear Madhvai,

thanks for the reply. What i exactly need is some formula by which we can caculate how much amount will be accumulated at the year's end at a fixed epf rate (say 8.5%) on the combined monthly EPF shares of Employee and Employer (i.e 12% + 3.67% of {basic+DA})

i have sent the scenario in excel file (sheet2) at your email id.

thanks again


Attached FilesProvided by community member ptiwari2ki@gmail.com. Join us to learn and grow with your peers.
File Type: xls pf_calculation_686.xls (35.0 KB, 6550 views)
chandrakant -  Member Since: Jul 2006
Dear Sir,

Thanks for the formula sheet, but i suggest that the formula sheet provided by you have to be changed such as if an employees basic salary is more than 6500 then the maximum deduction to the pension should be Rs. 541 but as per you formula it is diffeerent .

Sir just change the formulla and get your statement revised.

Regards
Chandrakant V.
9820592842
(PF, ESI, COntract Labour and other labour law Consultant)

madhavi47 -  Member Since: Oct 2007
hi dear chandrakanth i forgot to mention about the wage limit i
if the wages is less than 6500 then the formula will be calculated as (basic+da)*12% and if it is greater than 6500 it will be fixed as 780 apart from that employer provident fund wii be 780*3.67/12 and family pension fund is 780*8.33/12


madhavi

narayanrao.mp -  Member Since: Sep 2007
hi, please find enclosed the excel sheet for the reference Regards,


Attached FilesProvided by community member narayanrao.mp. Join us to learn and grow with your peers.
File Type: xls epf_1__123.xls (13.5 KB, 3497 views)
kumar0510 -  Member Since: Jul 2008
Thanks for the calculations. Can u please help me to know the excel formulas to generate the 3A/6A reports through the said sheet regards kumar 9885576600

usha HR -  Member Since: May 2008
Thanks a lot
I am in the process of calcualating the PF amoutn for our employees I know the %s but I don't have the format. I was planning toprepare the formula format for PF but You made my work easy.

It helped me a lot.

Thanks
usha


Quote:
Originally Posted by ptiwari2ki View Post
Dear Madhvai,

thanks for the reply. What i exactly need is some formula by which we can caculate how much amount will be accumulated at the year's end at a fixed epf rate (say 8.5%) on the combined monthly EPF shares of Employee and Employer (i.e 12% + 3.67% of {basic+DA})

i have sent the scenario in excel file (sheet2) at your email id.

thanks again

ghosal -  Member Since: Dec 2008
please give a revised excel calculation sheet for pf with salary more than Rs.6500/- per month.

bhushanmutalik -  Member Since: Apr 2009
Dear Ms. Madhavi
M bhushan mutalik from pune. I want to know detail about PF rates chart, how to calculate. Will be very much thankful to you if u can send me on my id , u r free to call also 09730490839. Thanks in advance for ur help.

Bye
TC
Bhushan


Quote:
Originally Posted by madhavi47 View Post
DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH




 
 
 
 





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