Good Afternoon to all,
I am working in an IT startup company as an HR executive. I have been given the task of calculating the salary of employees. Some of them have joined in the middle of the month. How should I calculate their salary? Being a fresher, I do not have a clue about it.
Please help me out. This is my email Id jhanvi.appswebsol@gmail.com.
From India, Mumbai
Acknowledge(0)
Amend(0)
2I am working in an IT startup company as an HR executive. I have been given the task of calculating the salary of employees. Some of them have joined in the middle of the month. How should I calculate their salary? Being a fresher, I do not have a clue about it.
Please help me out. This is my email Id jhanvi.appswebsol@gmail.com.
From India, Mumbai
Acknowledge(0)Amend(0)
Salary Structure for Employees
There should be a salary structure for all employees.
Create an Excel sheet with the employee codes, names, date of joining (DOJ), PAN, PF number, and salary breakdown.
Consider the leaves for the month based on the defined pay cycle (e.g., 15th-15th or 30th-30th).
Calculate the monthly compensation, including additional variable pay or deductions for leaves or any other reasons, for each employee individually.
Take into account their individual savings before tax calculations (I will provide the Excel format for these calculations if needed).
Deduct the taxes and calculate the net payable amount.
Process the payment.
From India, Delhi
Acknowledge(1)
Amend(0)
There should be a salary structure for all employees.
Create an Excel sheet with the employee codes, names, date of joining (DOJ), PAN, PF number, and salary breakdown.
Consider the leaves for the month based on the defined pay cycle (e.g., 15th-15th or 30th-30th).
Calculate the monthly compensation, including additional variable pay or deductions for leaves or any other reasons, for each employee individually.
Take into account their individual savings before tax calculations (I will provide the Excel format for these calculations if needed).
Deduct the taxes and calculate the net payable amount.
Process the payment.
From India, Delhi
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.
SALARY SHEET CALCULATION.xls
Salary calculation.doc
Salary & Compensation Guidelines.zip