Salary Break Up For PF ESI PT

Hai all cite HR Family members,
Here I am attached one file for salary break up PF ESI PT,I hope this file is use full for all,
If there is any mistakes is there Please give me message for me.
cheers,
Venkat.

Hai biswajitpnt
ESI Challana also is there in this file, go to esi account sheet
In that sheet total how many members are we are paid esi amount, and what is the employee contribution, and employer contribution entire you can find.
cheers,
venkat.

I have started a firm recently employing 30 staffs. All are having salary more than 6500 Rupees. Can my establishment be exempted from PF?

Mr.Venkat,
Kindly help me with this problem.In our company we do not deduct gratuity.Also instead of DA, medical allowance is given. and there are no other allowances.Can you please modify this sheet accordingly or else pls let me know how to calculate it so that I will try to modify it.Can you pls mail me the updated one to [Login to view], if you dont mind.
I will be eagerly waiting for your reply.
Regards
Revathi Pillai

Dear Venkat,
Thanks for providing such a useful attachment, but one thing i found mistake in gratuity calculation, actually it has to be calculated on the basis of Basic & D.A only. but you have calculated on total salary seems to be..
kindly correct it.
Regards
Vengadesh