Hi friend, please help me. This is the detail of an employee. I have to prepare an Excel sheet for this payroll. It's my assignment. Kindly help me, friends. I tried, but I don't know how to deduct HRA, etc., all the payroll deductions. If you can, please help me. My id is jai.sap(at rate of) yahoocom.
A. Head: 6 to 8 members - CTC is 600,000-800,000.
B. Assistant Manager: 12 members - 400,000-600,000.
C. Engineers: 12 members - 200,000-400,000.
D. Supervisor: 30 members - 100,000-200,000.
E. Unskilled: 20 members - less than 100,000.
Sir, I have done one payroll for A:
Gross salary is 50,000.
Basic: 15,000 (50,000*30/100).
HRA: 10,000 (50,000*20/100).
City Compensation: 15,000 (50,000*30/100).
Conveyance Allowance: 9,600 (800 per month).
Total: 99,600.
Deductions:
ESI Employee: 875 (50,000*1.75%).
ESI Employer: 2,375 (50,000*4.75%).
EPF Employer: 6,000 (50,000*12/100).
EPF Employee: 6,000 (50,000*12/100).
Net Salary: 84,350.
Is this correct, friends? Is this the way we put payroll for individuals?
From India, Karur
Acknowledge(0)
Amend(0)
A. Head: 6 to 8 members - CTC is 600,000-800,000.
B. Assistant Manager: 12 members - 400,000-600,000.
C. Engineers: 12 members - 200,000-400,000.
D. Supervisor: 30 members - 100,000-200,000.
E. Unskilled: 20 members - less than 100,000.
Sir, I have done one payroll for A:
Gross salary is 50,000.
Basic: 15,000 (50,000*30/100).
HRA: 10,000 (50,000*20/100).
City Compensation: 15,000 (50,000*30/100).
Conveyance Allowance: 9,600 (800 per month).
Total: 99,600.
Deductions:
ESI Employee: 875 (50,000*1.75%).
ESI Employer: 2,375 (50,000*4.75%).
EPF Employer: 6,000 (50,000*12/100).
EPF Employee: 6,000 (50,000*12/100).
Net Salary: 84,350.
Is this correct, friends? Is this the way we put payroll for individuals?
From India, Karur
Acknowledge(0)Amend(0)
Subject: Re: Ctc
Hi friend, please help me. This is the detail of the employee. I have to prepare an Excel sheet for this payroll. It's my assignment. Kindly help me, friends. I tried, but I don't know how to deduct HRA, etc., all the payroll deductions. If you can, please help me. My id is jai.sap(at rate of) yahoocom.
a. Head 6 to 8 members CTS is 600,000-800,000
b. Assistant manager - 12 members - 400,000-600,000
c. Engineers - 12 members - 200,000-400,000
d. Supervisor - 30 members - 100,000-200,000
e. Unskilled - 20 members - less than 100,000
Sir, I completed one payroll for A:
Gross salary is 50,000
Basic 15,000 (50,000*30/100)
HRA 10,000 (50,000*20/100)
City compensation 15,000 (50,000*30/100)
Conveyance allowance 9,600 (800 per month)
Total: 99,600
Deductions:
ESI employee 875 (50,000*1.75%)
ESI employer 2,375 (50,000*4.75%)
EPF employer 6,000 (50,000*12/100)
EPF employee 6,000 (50,000*12/100)
Net salary is 84,350.
Is this correct, friends? Is this the way we put payroll for individuals?
From India, Karur
Acknowledge(0)Amend(0)
Hi friend, please help me. This is the detail of the employee. I have to prepare an Excel sheet for this payroll. It's my assignment. Kindly help me, friends. I tried, but I don't know how to deduct HRA, etc., all the payroll deductions. If you can, please help me. My id is jai.sap(at rate of) yahoocom.
a. Head 6 to 8 members CTS is 600,000-800,000
b. Assistant manager - 12 members - 400,000-600,000
c. Engineers - 12 members - 200,000-400,000
d. Supervisor - 30 members - 100,000-200,000
e. Unskilled - 20 members - less than 100,000
Sir, I completed one payroll for A:
Gross salary is 50,000
Basic 15,000 (50,000*30/100)
HRA 10,000 (50,000*20/100)
City compensation 15,000 (50,000*30/100)
Conveyance allowance 9,600 (800 per month)
Total: 99,600
Deductions:
ESI employee 875 (50,000*1.75%)
ESI employer 2,375 (50,000*4.75%)
EPF employer 6,000 (50,000*12/100)
EPF employee 6,000 (50,000*12/100)
Net salary is 84,350.
Is this correct, friends? Is this the way we put payroll for individuals?
From India, Karur
Acknowledge(0)Amend(0)
If we look at the global economy, there are several developed countries where pension schemes have failed. For example, the California Public Employees Retirement System. We are also in a state of flux, transitioning from defined benefits to defined contribution due to factors like lack of transparency, infrastructure, etc. In developing countries, returns are higher compared to developed nations. For instance, the metro financing at 4% per annum, which also involves a moratorium until a critical point is reached. Mathematically, administrative charges can be added up, but the premise is faulty or inadequate as we do not account for other costs like IT, telecom, or process costs.
From India, Delhi
Acknowledge(0)Amend(0)
45From India, Delhi
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.