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.