How to Calculate ESI | ESI Calculation In Excel

You can download this file from the below mentioned link
https://docs.google.com/spreadsheets/...

My Channel
   / @uexcelinmsoffice4323  

Excel Time & Motion study template - Calculate bench mark & productivity & set the targets
   • Excel Time & Motion study template - ...  
EMI - Housing/Home Loan - How to repay loan quickly/faster - repayment - Save interest amount
   • EMI - Housing/Home Loan - How to repa...  
Excel short video - Calculate revised price - Percentage increase
   • Excel short video - Calculate revised...  
Short excel video - Calculate percentage change
   • Short excel video - Calculate percent...  
How to use Roman function in excel/Convert a number to Roman numeral in excel
   • Shorts  
How to use Auto Correct Option/Feature In excel for time saver tips - Correct misspelled words
   • Видео  
Calculate Gratuity in excel -Employee eligible under Gratuity act 1972-Gratuity calculation in excel
   • Calculate Gratuity in excel -Employee...  
GST calculation both inclusive and exclusive tax
   • Shorts  
How to calculate profit margin in excel - Easy trick - Profit margin on sales
   • Shorts  
FTE CALCULATION IN EXCEL - RPA AUTOMATION FTE RELEASE - FULL TIME EQUIVALENT - BUSINESS TRANSITION
   • FTE CALCULATION IN EXCEL -RPA AUTOMAT...  
How to calculate Work Experience in Excel - using Datedif function/formula
   • How to calculate Work Experience in E...  
How to calculate Recurring deposit(RD) in excel - RD calculator - Quarterly & Monthly interest pay
   • How to calculate Recurring deposit(RD...  
How to Calculate ESI | ESI Calculation Tutorial
Employee State Insurance Act 1948 (ESI Act) Explained with Calculation & Example
How to calculate ESI in Excel
आसान भाषा में | ESI And PF Calculations in hindi | Contribution rates with example #epfo #esic
Calculation of ESI in Hindi - Employee State Insurance Act 1948
How To Calculate ESI? || How ESI Is Calculated? || HR Tutorials India || ESI Calculation || ESIC
Employee State Insurance (ESI) Act | Calculation, Benefits, Applicability in 10 minutes
Customer or Vendor Ageing report in excel - Accounts Receivable or Accounts Payable ageing report
   • Customer or Vendor Ageing report in e...  
How to protect the formula's in excel by locking the cells - No option to delete or edit formulas
   • Видео  
#Employee Productivity and Rating for the #Annual Appraisal in Excel
   • #Employee Productivity - Rating  #Ann...  
How To Create Marks Sheet in MS Excel Step by Step
   • How To Create Marks Sheet in MS Excel...  
Calculate #Marks Percentage In Excel Short Video
   • Calculate #Marks Percentage In Excel ...  
EMI Calculator For Car And Bike In Excel - EMI Calculation formula
   • EMI Calculator For Car And Bike In Ex...  
Calculate Attrition Percentage In Excel - Excel Short Video
   • Shorts  
#Short Excel Video - How to Calculate Sales Price After Discount in Excel
   • Shorts  
How to Create Email Address in Excel - Excel Short Video - Smart Trick In Excel
   • How to Create Email Address in Excel ...  
How to Calculate Percent Change - #Short - Find percentage difference between two numbers - In Excel
   • Shorts  
ESI calculation is done on the basis of the wages paid to the employee.

The ESI or Employees State Insurance Scheme is an insurance cover provided to the workers to aid them in uncertain and challenging times. It is a contributory fund governed by the Employee State Insurance Corporation and comes under the ESI Act, 1948
ESI calculation
What are the benefits of ESI?
What is the ESI limit?
How do I calculate ESI?
How is ESI calculated from salary?
Collection of ESI contribution
Automate ESI calculation & filings
How to calculate ESI with an example
Let’s say the calculated wages of Mr X as per the ESI Act, 1948 is INR 20,000. Then the contributions will be calculated using the ESI calculation formula as below.

Particulars Calculation Amount
Employer’s Contribution (@3.25%) 20,000*3.25% 650
Employee’s Contribution (@0.75%) 20,000*0.75% 150
Total Contribution — 800
The ESIC act, 1948, has fixed the percentage contribution of the employer at 3.25% of the wages and that of the employee at 0.75% of the wages.

ESI calculation formula