Home Statutory EPF,ESI calculation in excel format

EPF,ESI calculation in excel format

811 days ago by SAJU ( ADMIN) 100

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

Tags: excel calculator, Featured

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

Ashima Nayak says:

September 24, 2011 at 12:04 pm

Thank you sir……………..

[Reply]
Sachin More says:

October 12, 2011 at 7:34 am

Thanks a lot, its more easier and clear now.
Thank you for sharing

[Reply]
RESHMA says:

October 14, 2011 at 9:19 am

thanks alot for sharing this….. it helped to learn more..

[Reply]
Radha kumari NK says:

November 13, 2011 at 4:47 am

Thank you for sharing information sir, it helped me a lot….plz share the things like this only.

[Reply]
Sharon says:

November 16, 2011 at 3:18 pm

How much will a pern get paid pm though esic permament disability scheme where he lost his 3 fingers in the right hand while working in a factory , this persons avg salary is 6000 , please give advice , this person is in real need of help …

Thanks in Advance,

Regards,
Sharon

[Reply]
Reshma says:

November 21, 2011 at 7:24 am

I need the excel format of esi

[Reply]
rahul says:

November 22, 2011 at 4:10 am

really helpful sir

[Reply]
bala says:

November 28, 2011 at 4:20 pm

Thx for information

[Reply]
mohamadsaeid says:

December 8, 2011 at 6:55 pm

please let me know that can i use my previous esi no in present company please reply

[Reply]
shakti says:

December 13, 2011 at 10:53 am

Thanks you.

[Reply]
Hameed Ali says:

December 15, 2011 at 10:23 am

Thanks for the excel. it was very useful to me. thanks once again.

[Reply]
bala says:

December 27, 2011 at 11:39 am

thank you for excel calculator

[Reply]
Kiran says:

January 10, 2012 at 5:39 am

as i am a beginner it really helps me out
thank u

[Reply]
R. Ravi says:

January 19, 2012 at 6:11 am

while calculating esic deduction on works contract, can the service tax be included?
Pl advice.

[Reply]