PF calculation Sheet in Excel - happy diwali Xls Download.. CiteHR
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Forms, Formats & Questionnaires

PF Calculation Sheet In Excel - Happy Diwali

payal80 Started The Discussion:

Dear All, It would be Greate help for me if some one can provide me calculation procedure of Pf,ESI& gratuity in Excel sheets. Thanks Payal

Amitmhrm - Contributing Member
Hi Payal,

ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.
The contribution from both the sides is as below-

Employee Side- 1.75% of gross/month
So if gross of an employee is 8000/month then
ESI contribution would be 8000*1.75% = 140 Rupees

Employer side- 4.75% of gross/month
ESI contribution would be 8000* 4.75% = 380 Rupees.

Where as PF is contributed @12% of basic salary only from both sides employee as well as employer..

Regards,

Amit Seth.

grhrm - Contributing Member
Hi friend, I am enclosing here with an Excell sheet with formulas and examples. It will helpe u to make a clear idea and also for ur work. Thanks GrHrm


Attached FilesProvided by community member grhrm. Join us to learn and grow with your peers.
File Type: xls esi__pf_calculation_191.xls (16.0 KB, 21369 views)
Kumar H P - Contributing Member
Dear Payal,

To the excell sheet provided by grhrm, please apply a condition that If Gross > 10000, ESI contribution is Zero. So that it can directly read Zero value for people having salary greater than Rs.10000


Truly Yours,
Kumar.H.P

Amith R Murthy - Contributing Member
Dear Amit,

I have a clarification about the below line as quoted by you, if i am not wrong wrong confirm me is this the Gross limit the maximum above which the employee can opt for PF i mean is it similar to the limit of basic salary of Rs 6500. Clarify me on the same.

PF is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.

Regards
Amith R.

Amitmhrm - Contributing Member
Dear Amith,

Please go through with the mention line once again..

ESI is contributed from both the sides Employee as well as Employer.
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month.

Hope now it must be clear at your end..

Regards,

Amit Seth.

manojkumar01 - Contributing Member
hi esic challan and calcul.for u


Attached FilesProvided by community member manojkumar01. Join us to learn and grow with your peers.
File Type: xls pf___esi_challan_and_calcu_299.xls (155.0 KB, 3146 views)
kasinaravikumar - Contributing Member
Dear Sir,


I've one doubt regarding pension. According to the formula the pension is calculated in this manner.

last drawn wages x no. of years of service / 70

But i would like to know about that 70.

Please clarify my doubt.

With Regards,


K. Ravi Kumar.
E-mail:
Ph: 09989111149

Amitmhrm - Contributing Member
Its ok Amith.. No issues.. wish you Happy Diwali.. :D Thank you Milan.. Regards, Amit Seth.

vinomba - Contributing Member
Hi,

PF & ESI Calculation

PF 12% of the Basics for BOth (Employer & Employee)
PF Calculation upto 6500 Only above 6500 should not calulate for rest of the BASIC SALARY.
Basics PF 12% (Employee & Employer Contribution Equal Level)
5000 600

ESI
Empoyee Contribution= 1.75%
Employer Contribution= 4.75%

Gross Salary ESI 1.75%(Employee) 4.75% (Employer)
10000 175 475

Above 10000 Gross Salary
They are not eligible for ESI

Regards,
Vinoth.R :lol:

Found This Useful? +Vote Up This Page 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.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.




Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


14
LIKES

51375
VIEWS

57
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


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

Share »

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