Dear All,

Please find enclosed a Workmen's Compensation Calculator for the calculation of compensation in case of death, Permanent Total Disablement, and Permanent Partial Disablement (covered under Schedule I and not covered under Schedule I) with a WC Insurance Premium Calculator.

Kindly enter only the Serial Number mentioned against the List of Injuries Sheet in place of NATURE OF INJURY AS PER LIST OF INJURY SHEET (ENTER SL.NO ONLY).

Feel free to ask for any further queries related to the use of this calculator.

Regards,
Jawed Alam

From India, Dhanbad
Attached Files (Download Requires Membership)
File Type: xls Workmen Compensation Calculator.xls (53.5 KB, 20389 views)

Acknowledge(6)
MC
HR
VE
KY

+1 more

Amend(0)

Good effort. But I have a doubt. As per the Workmen's (Employees) Compensation Act, there is a minimum compensation of Rs. 120,000 for death and Rs. 140,000 in case of permanent total disability. Similarly, the salary is subject to a maximum of Rs. 8,000, and there is a provision for calculating compensation based on the statutory minimum rates of wages. I think the sheet takes into account the actual salary and not the minimum compensation. Please correct me if I am wrong.

Regards,
Madhu.T.K

From India, Kannur
Acknowledge(0)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is [B]correct[/B]. Thank you for sharing your insights. (1 Acknowledge point)
    0 0

  • Thank you very much for the suggestions you provided. I have tried to include all those which you pointed out. I hope it is correct now. Please, I need suggestions from all viewers if they have any further doubts about the new calculator.

    Once again, thank you Madhu.T.K, and I look forward to further suggestions from your end.

    Regards,
    Jawed Alam

    From India, Dhanbad
    Attached Files (Download Requires Membership)
    File Type: xls Workmen Compensation Calculator1(NEW).xls (47.0 KB, 6932 views)

    Acknowledge(0)
    Amend(0)

    Dear Javedalam, good efforts. One more change is required: if an employee has a disability in the middle ring finger, middle finger, and index finger, then the total of this should be included in the formula, which is currently not being accounted for. Please check.

    Also, please explain the "Category of compensation."

    Regards, Madhukar

    From India, Aurangabad
    Acknowledge(0)
    Amend(0)

    Dear R. Parveen Kumar, The changes suggested by Mr. Madhu T. K have already been incorporated in this new "Workmen's Compensation Calculator1 (New).xls". Please check this new file.

    Category of Compensation

    Dear Madhukar, "Category of compensation" = in case of Permanent Total Disablement (60%), in case of death it is (50%) just for calculation purposes.

    If an employee has a disability in the middle ring finger, middle finger, and index finger, then that disablement will not come under Schedule I and will be treated as Permanent Partial Disablement (Not covered under Schedule I). The doctor will decide the % of loss of earnings. This calculation is also incorporated in the 2nd sheet "COMPENSATION PPD BY DOCTOR". Please check it.

    Regards, Jawed Alam

    From India, Dhanbad
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The information provided in the user reply is accurate regarding the Workmen's Compensation Calculator and the categories of compensation. No amendments are needed. (1 Acknowledge point)
    0 0

  • Dear all, Find simple and user friendly Calculation Sheet For Employees Compensation Calculator Regards
    From India, Vijayawada
    Attached Files (Download Requires Membership)
    File Type: xls Workmen Compensation Calculation.xls (36.5 KB, 3072 views)

    Acknowledge(1)
    PR
    Amend(0)

    My son, who is a Mechanical Engineer, met with an industrial accident while working in a factory. He sustained a pelvic fracture, urinary bladder rupture, and compression in his L5. As a result of this accident, he is unable to walk normally. His current health status includes partial sensory loss in the right leg fingers, sciatica with right leg foot drop. I would like to inquire if he is entitled to compensation and, if so, how much. He is currently earning a salary of 18,000/- per month, and he is 24 years old.

    Regards,
    P. Govind

    From India, Karur
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The employee is entitled to compensation under the Workmen's Compensation Act for the industrial accident. The compensation amount will be calculated based on the extent of disability and salary. The specific calculation can be done using the Workmen's Compensation Calculator provided. It's crucial to follow the guidelines and procedures outlined in the Act for a fair assessment. (1 Acknowledge point)
    0 0

  • Anonymous
    Dear All, can anyone tell me how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know about slab rates. Will the slab differ for different states? Kindly reply.
    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    Calculating Compensation Benefits Manually

    Can anyone tell me how to calculate compensation benefits manually using formulas? Mr. Javed Alam's calculator is really very useful, but I want to know about slab rates. Will the slab differ for different states? Kindly reply.

    Regards

    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    If any Managerial cadre employee or Supervisor cadre employee met with fatal accident/permanent disable accident, then is he eligible for any type of compensation under any act? Please repply
    From India
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The Managerial cadre or Supervisor cadre employees are also eligible for compensation in case of fatal or permanent disable accidents under the Workmen's Compensation Act. (1 Acknowledge point)
    0 0

  • Employees Compensation Act has not restricted the compensation to workmen as defined in ID Act and as such all employees are covered under the Act. Madhu.T.K
    From India, Kannur
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The Employees' Compensation Act does cover all employees, not just workmen as defined in the ID Act. Madhu.T.K's response is correct. (1 Acknowledge point)
    0 0

  • Dear Mr. Javed Alam,

    The calculation sheet is really very useful; thank you very much for sharing. I have noticed that you have not included point (d) where temporary disablement, whether total or partial, results from the injury: a half-monthly payment of the sum equivalent to 25% of the monthly wages of the employee. This is in the case of the injured employee's monthly salary to be paid.

    Regards,
    Kaushik Vyas

    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    I have a doubt related to Workmen's compensation. One of my friends constructed a house in a rural area of Tamil Nadu in 2010, and he is an agriculturist. With a lot of difficulty, the housework was completed. He had given the construction work to a contractor, and he had no formal agreement with the contractor. One of the employees employed by the contractor met with an accident due to high-power electric current and lost his hand below the elbow. Medical charges were taken care of by both my friend and the contractor. Unfortunately, it is of no use. Now, as per the Workmen's Compensation Welfare Commission, he has to pay 5.95 Lakhs and an interest of 12% from the date of the accident. So, the total amount to pay is 10L. He is an agriculturist and built the house with a lot of difficulty, and he also has debts. In fact, the cost of the house construction is less compared to the compensation amount he has to pay. He spent only 6L on the house. Please advise on the procedure. He is not in a position to pay this lump sum amount under any circumstances. Is there any way to pay a lesser amount or any partial/yearly payment options available? Your help is greatly appreciated.

    Thanks,

    Seethalakshmi P

    From India, Bengaluru
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The Workmen's Compensation Act applies to the situation described. Your friend can request the commission for a structured payment plan to settle the compensation amount. (1 Acknowledge point)
    0 0

  • Excellent work done ! Really helpful to caliculate EC quickly and accurately. Request you to attach similar Xl files for various statutory caliculations/ compliances. Sarisri.
    From India, Mumbai
    Acknowledge(0)
    Amend(0)

    can u please clarify if the monthly wage is less than 8000/- then we have to take the actual wages or rs. 8000 for calculation purpose.

    Acknowledge(0)
    Amend(0)

    In case the actual wages is less than 8000, you can take the actual wages. But the actual wages should not be less than the statutory minimum wages. Madhu.T.K
    From India, Kannur
    Acknowledge(0)
    Amend(0)

    Respected Sir,

    Could you please help me to find out the compensation for the worker who was injured at my father's factory? Details are as follows:

    My father is a sole proprietor with a manufacturing unit that employs more than 20 workers. The worker was injured at work, resulting in his arm being amputated at the elbow.

    Details of the worker:
    - Salary: $5500
    - Age: 55
    - Years of service: 1

    Please reply soon. Thank you in advance.

    From India, Delhi
    Acknowledge(0)
    Amend(0)

    Mr. Jawed Alam, This calculator is really useful for every one. Good work done. Please keep posting likewise. Thanks & Regards, Sridharan.K
    From India, Madras
    Acknowledge(0)
    Amend(0)

    Anonymous
    247

    The Excel sheet is very helpful. I have calculated based on the following details:

    Calculation Details

    Employee's age: 35 years
    Factor: 197.06
    Salary: Rs. 9500/- (for calculation purposes, the maximum limit is Rs. 8000/-)
    Nature of injury: Permanent partial disablement as mentioned in Part II of Schedule I, serial no. 35 (ring or little finger - whole) with a percentage of loss of earning capacity as 7%

    As per the calculation from the Excel sheet (NEW), it is showing Rs. 82,765/- under the heading "compensation ppd by doctor."

    Can anybody tell me what is the formula/basis of the calculation, and is it right? Thanks in advance.

    From India, Kolkata
    Acknowledge(0)
    Amend(0)

    can any one plese how to calculate the workmen compensation and maximum amount 8000/- or not
    From India, Hyderabad
    Acknowledge(0)
    Amend(0)

    Calculation with factor dear all here attach wc calculation with factor as per employee comp. Act ( wc act )
    From India, Mumbai
    Attached Files (Download Requires Membership)
    File Type: xls factor.xls (34.5 KB, 308 views)

    Acknowledge(0)
    Amend(0)

    Wage Calculation for Workmen's Compensation

    S.No. Designation No. of persons Months Wages (in Rs) Total wages (in Rs)

    01. Skilled 5 4 15,600/- 3,12,000/-

    02. Unskilled 20 Nos. 4 15,000/- 12,00,000/-

    Total 25 Nos. 15,12,000/-

    How to calculate WCP premium amount

    From India, Coimbatore
    Acknowledge(0)
    Amend(0)

    Dear Sir,

    If a worker is attending duty an average of 15 to 16 days every month due to health issues, and now has had an accident resulting in permanent disability, how do we calculate the compensation wages? Additionally, should we include HRA, conveyance, LTA allowance, etc., in the wages?

    I need your help.

    From India
    Acknowledge(0)
    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.







    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.