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.

Plz send me details of EPF,ESI CALCULATION IN EXCEL FORMAT.
Its rea;;y very helpful tool…
THanks a lot..
thanks,
really no tension at all
DEAR SIR
I COULD NOT OPEN THE FILE USING EXCEL 2003 , IT IS SHOWING THAT THE TEXT IS IN UNRECOGNIZABLE FORMAT . PLEASE HELP ME.
THANK YOU
PINAKI DAS.
How are You Nituvalli????
Also get the details of Annual statements.
ok u will get it ,go through the bHR books
awsome and very helpful…
Sir,
I saw your Calculator,it work wounderfully, I have some doubt please help
How can calculate Arrears of PF ESI in that calculator please help
thank you
awesome thanks a lot dear sir…..
It’s really useful tool. Very much user friendly & appreciated that you have not protected it by password. Just keep it updated with timely changes. THANKSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
do you have a calculator which can calculate about your yearly salary increament 11% your pf contribution and corpus after 25 year i mean till the retirement, where both the value will be added like month wise your contribution and your anual revised increment , if so please share and caluculate for an example my basic salary is Rs 17000.00 where rs 2040 will go into pf every month then if next year 11% salary increased onwards for 25 years then what will be the final value or corups the fund
any one calculate us and send me
Hi,
Thanks for your kind information for ESI and EPF. it was very helped me to equip my self thanks a lot..
Regards
Ganapathi perumal
send the link and send esic software
Dear Creator of the ESI, EPF Calculator,
I appreciate your work.
The EDLI Charges is calculated @ 0.05 % . But it is originally, 0.5% of the Salary.
Pls. Correct the same.
Users who were already downloaded the calculator also required to change the same.
N.A.Dhass.