Get HR Software

No Tags Found!


How Do You Calculate ESIC Contributions for Salaries Above or Below 21000?


Please help with the ESIC contribution calculation by using if condition. with formula for < or > 21000.
From India, New Delhi
Acknowledge(0)
Amend(0)

Please find attached file with formulas.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls ESIC Formula.xls (39.0 KB, 913 views)

Acknowledge(1)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant
Understanding esic contribution and wage calculation regulations
Dear all i have a query regarding esi: currently the esi contribution is deducted on upto rs.10000/ wages. there is provision in the esi act that the if an employee...
17 Replies 1 Files 17 Participants
Automated seniority allowance computation with excel if condition
Hi please i need your help. i wanted to automate seniority allowance computation with an if condition as per the attached sheet but i am not clear about the formula....
2 Replies 2 Files 1 Participants
About epf.esic caluculation and actual contribution
Hello sir i am altaf sayyed. i have completed mpm. please tell me about esic and epf form numbers. what is the procedure for filling out these forms and what...
5 Replies 1 Files 5 Participants
Understanding esic contribution calculation and case studies: a comprehensive guide
Request for esic case studies 1 kindly share case studies about i need to add them as a part of the presentation. clarification on esic calculation 2 please...
2 Replies 0 Files 3 Participants
Esic-should conveyance allownce be considered as part of wages
Dear seniors should we consider conveyance allowance as part of wages for esic contribution calculation purposes? please clarify. regards...
5 Replies 0 Files 5 Participants
Esic contribution and hra calculation for vocational training: guidelines and compliance
Dear all seniors i m dinesh working in a 5 star company. i have a few questions for you. here students come for vocational training for a period of fewer...
5 Replies 0 Files 2 Participants
Esic percentage while calculating monthly salary of an employee
Hi i have seen one of your comments related to salary breakup in which you explained through one example. in that example you showed the formula for calculating monthly esic...
3 Replies 0 Files 2 Participants

Related Files & Downloads Shared By Members
 ESIC Calculation.zip
 ESIC-Contributi on-Transfer-For m.pdf
 Official gazatte notification for revision of ESIC contribution reduction July 2019 (1).pdf


Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 591414)

India, New Delhi
01 November 2017 08.23.57 PM
Views: 3304 Replies: 1 Appreciations: 2

TOP ENTRIES ON SUBJECT

ESIC Contribution
Form No.7, Form No.5, Form No.3, Form No. 01-A In ESI
Esi If Salary More Than 15000/ On Increments - PDF Download
ESI New Ip Contribution Transfer To Old Id No.(if Employee Has 2 Esi No.) Pdf Download
Wrongly Transfrer Of Monthly ESIC Contribution
Maternity Leave On Probation Period - DOCX Download
ESIC Ceiling Limit Increase Notification And Implementation Details

Calculation
Comprehensive Discussion On Payslip Formats, Deductions, And HRA Calculation
Re: Pf Calculation Sheet In Excel - Xls Download
Understanding Cost To Company (CTC) Calculation And Gratuity In Employee Benefits
Pf Calculation & Challan Sheet - Xls Download
Attrition Rate Calculation - Formula Which Gives A Reliable Figure?
Need Formula/procedure For EPF / PF Calculation Excel File

If Condition
CTC Structure Format On The Basis Of IF Conditions?





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.