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
Thanks a lot sir…it,s simply super…
[Reply]
Sir,
Thank you very much for sharing payroll, ESIC, PF calculation, but in calculation TDS not deducted automatically in payroll. How to applicable formula for deducting TDS in Salary ?
Thanking You
Sanjay Mohite
[Reply]
Dear Sir,
Thanks a lot for this pf calculator, if you could add the formula to calculate the salary on days basis. It could be more helpful.
rgds.,
ATR
[Reply]
thanks sir / madam…..
[Reply]
Dear Sir,
This sheet will helpful for new comers. Thank You
Nisar Khan 07503168188
[Reply]
Dear Sir,
Your excel sheet is excellent but you have nowhere mentioned employee’s share of 12% of EPF in your excelsheet. KIndly reply.
[Reply]
Hi,
i need to know how to calculate esi, pf, tds and professional tax in the excel
[Reply]
Dear Sir,
Kindly add the formula to calculate the salary & EPF & EPS contribution on earned salary on attendance basis than it will be total helpful.
Thanks
SS
[Reply]
in the EDLI %is 0.05 % mentioned , actually it is 0.50% kindly verify at your end
Thanks
V.Bala
[Reply]