I have created a combined ESI, EPF, Pay roll, calculator by using excel as many are visiting accountinghead.com in search of ESI,EPF calculation in excel format. You can also process payroll by using this calculator. This EPF, ESI excel calculator is free to edit. The sheet is not password protected. You can add, remove columns & rows edit text, insert new formula as you wish. The 
percentage of calculation can also be changed at your discretion. Be careful while editing, inserting rows, columns in the sheet as there is a chance of in applicability of formula at desired field. I am not guaranteeing its accuracy. If any inaccuracy found should bring in to my notice.
How to use this calculator
This calculator is very simple and user friendly.it simplifies your work of calculating EPF, ESI contributions. You need to enter only salary details in the first sheet named “Salary” the rest of the things will be done by the excel sheet itself. You don’t need to enter any thing in the ESI, EPF sheet.
In this calculator EPF ceiling limit is fixed to 6500.00. Employer contribution on EPS, EPF and other charges like, EPF admin, edli, edli admin charges are calculated based on that. If you don’t want to fix an upper limit for EPF and other charges calculation you must have to change the formula.
I wish to know your comment on this calculator that may help me to improve the functions. If you like this post, we request you to subscribe our newsletter that will keep you updated on latest news from us.
DOWNLOAD ESI,EPF ,PAY ROLL CALCULATOR
Dear sir,
Can I get the data in excel sheet on how to caluclate and filt PF , ESI , TDS returns. Please also tell me the percantages to deduct from the salary as i am a fresher it will be very needful to me.My mail add:prabhakaran_32@hotmail.com
Thank you,
Prabhakaran
[Reply]
It is very use full and very simple Thank
and also kindly explain is there any rule to fix basic salary? for example if one get 10000 /pm net how to calculate and how to deduct ESI AND PF pl help me
S.Chandramohan
scmohan41@gmail.com
[Reply]
Dear All,
Please send me salary sheet on excel with formulas i am fresher i really need to your help please send me ,
20june1985@gmail.com
[Reply]
Your explained formula is excellent.
[Reply]
sir,
kindly add days column of the employees who work on that month and that has to pay…and the same to be deduct in esi also….same to reflect in to esi page also…
kindly help me.
raju
[Reply]
Saju Reply:
August 2nd, 2011 at 3:00 am
Thank raju
good suggestion i will do it
[Reply]
thanks alot sir as u solved my problem and make my work so fast n easy
[Reply]
Hi
Thanks A lot, it was really grateful from you
Thank you
NAvaneesh
9008997880
[Reply]
it is really wonderfull…
[Reply]
Thanks for sharing.
[Reply]
thanks a lot for sharing this…
[Reply]
this is realy wery helpful for me.
[Reply]
thanks a lot.. i was breaking my head to calculate.. thanks a lot
[Reply]
your web sites is very helpful ,so i thank you .because you give hr question with examply file.
[Reply]
Very nice work done by you sir, i really appreciate your work. you have made my work neat & clean & faster too. Thanks a lot …
With Best Regards !
Gurjeet Singh
[Reply]
Sir,
your example calculate and details of calculation is very simple understand and very useful for employees & employers.
Thanking You,
V.MOHAN
TIRUPUR – 1
[Reply]