EPF,ESI calculation in excel format

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

esi,epf calculation in excel

134 Responses to “EPF,ESI calculation in excel format”

  1. KAVITA says:

    Plz send me details of EPF,ESI CALCULATION IN EXCEL FORMAT.

  2. Pankaj says:

    Its rea;;y very helpful tool…

    THanks a lot..

  3. priyanka says:

    thanks,

    really no tension at all

  4. Pinaki DAs says:

    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.

  5. venkatesan G says:

    How are You Nituvalli????

    Also get the details of Annual statements.

  6. sanjiv says:

    ok u will get it ,go through the bHR books

  7. Neeru Sharma says:

    awsome and very helpful…

  8. PRAVI.T.K says:

    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

  9. RAVI says:

    awesome thanks a lot dear sir…..

  10. nisar says:

    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

  11. Ajeet says:

    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

  12. ganapathi perumal says:

    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

  13. send the link and send esic software

  14. N.A.Dhass says:

    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.

Leave a Reply

© 2014 Accountinghead. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie