Search results
It is been calculated on the basis of Gross salary per month and the maximum ceiling is 10000 Rs./Month. The contribution from both the sides is as below-. Employee Side- 1.75% of gross/month. So if gross of an employee is 8000/month then. ESI contribution would be 8000*1.75% = 140 Rupees.
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 →.
so, as 1.75 %, 13548*1.75%=237.09 but as i told you earlier it will be calculate upon next higher rupee so it will be 238.00 and just that Employer Contribution 4.75 %, 13548*4.75%=643.53 but for esic it will be 644.00. and just total them and make challan of it and deposit it. PF.
May 17, 2018 · JudeGR. 55. 2. ESI is on gross without considering ESI contribution. Your first calculation is the right one. 17th May 2018 From India, Chennai. Puranik Rahul. 3. Esic always calculet on your earning gross which is 21,000/- So Your Employee whomes Earning gross is under 21,000/- you have to deduct esic.
Jul 18, 2022 · 1. Salary Sheet with ESIC and EPF Challan calculation. 18th July 2022 From India, Noida. Attached Files (Download Requires Membership) salary sheet format.xlsx (19.7 KB, 443 views) Add Reply → Start New →. k-arumugasamy. 2. You can add conveyance allowance and Washing allowance.
Nov 8, 2018 · As you are aware, the existing wage limit for coverage under the Act is Rs.21,000/- per month (w.e.f. 01/01/2017), and in your case, the employee is drawing more than wage limit for coverage i.e. Rs.21,000/- per month. Therefore the employee will not be eligible for ESI coverage. For more details about the coverage, please access this link ...
Dec 23, 2007 · Sir, no "leave salary" is paid by ESIC. 2. Sickness Benefit is paid by ESIC in case the insured person is sick and there is abstention from work and on the basis of sickness certificate issued by the appropriate ESI dispensary to which the insured person is attached. The claimant insured person must be eligible for such payment of sickness benefit.
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.
ESIC @ 1.75 % on total salary but excluding washing allowance subject salary and wages < 15000/-. CTC : Cost to the Comapny means all cost which is invested to the employees including PF 12 %, ESIC 1.75%, Gratuity 4.81 %, LTA, Medical (As per company policy), cost towards Leave (Paid Leave). Hope this will help you to understand the issue.
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)
