Search results
9-Leave Calculation sheet. 10-ESI Calculation (Set Your Requirements) 11-P.F Calculation. (Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%. Second is 12% of Basic) 12-Pension Scheme (not more than 541 rs submission) 13-TDS Calculation. 14-Annual Salary statement of Employee and Employer.
Jun 3, 2017 · 23. 2. Hi Anusha, Refer the attached sheet for claculating PF and ESI. 8th June 2017 From India, Bengaluru. Attached Files (Download Requires Membership)
Apr 30, 2011 · Salary sheet format in Excel EPF AND ESIC - Download - CiteHR. jitendra-kumar3422569. 1. Salary sheet format in Excel EPF AND ESIC. 6th October 2023 From India, Indore. Attached Files (Download Requires Membership) wages_sheet_xvii.xls (159.5 KB, 40 views) Add Reply → Start New →.
Mar 28, 2007 · The formula is: Employees' Share- Gross Salary x 1.75/100. Employer's Share- Gross Salary x 4.75/100. Total ESI contribution= Employee's Share + Employer's Share. Note: Gross Salary= All the monthly cash components (Inclusive of incentives) Should you need any further clarification dont hesitate to ask.
hi dear chandrakanth i forgot to mention about the wage limit i. if the wages is less than 6500 then the formula will be calculated as (basic+da)*12% and if it is greater than 6500 it will be fixed as 780 apart from that employer provident fund wii be 780*3.67/12 and family pension fund is 780*8.33/12. madhavi.
First you need to calculate the gross salary of the employee i.e. CTC minus PF and ESI. But here we want to calculate ESI itself so do one thing apply this formula. (CTC-PF)*4.75/104.75. And Here I am attaching a CTC for 8000/- it can help you. this time I am not able to give you detailed guidance but if you dont understand the calculation I ...
May 21, 2012 · Penal Interest under section 7Q: # No.of days delayed in making payment x 12% p.a. Penal Damages under section 14B: # No.of days delayed in making payment x 5% p.a (Less than 2 months) # No.of days delayed in making payment x 10% p.a (2 months and above but less than 4 months)
Feb 19, 2010 · The total number of questions answered is calculated. e. Calculate the MAXIMUM TOTAL SCORE which is the TOTAL (pt. d) * 5. ESI = (TOTAL SCORE RECEIVED / MAXIMUM TOTAL SCORE) * 100. If anybody understand then explain it with example. Is there any other formula for ESI calculation.
Sep 7, 2011 · I have no idea about EPF calculation. The Rule for Employer contribution is. 1) 3.67% of Basic towards PF. 2) 8.33% of Basic towards Pension scheme or 541 whichever is lesser. The excess of which will be added to PF. If you have noticed the same amount of 541 is used under the pension calculation formula.
Nov 14, 2015 · I hope the enclosed tool will help you to prepare salary statement & ESI & PF calculations. Regarding ECR tool using excel already there are lots of discussions. If you are unable to find out then I can share the link. If need any assistance you can reach me. 16th November 2015 From India, Bangalore. Attached Files (Download Requires Membership)
