Hi Senior,
I have recently joined an IT company as an HR executive. I am from a recruitment background, so I don't have deep knowledge of HR generalist profiles. The problem is that I have to prepare a salary sheet for the month of January 2014. Therefore, I need a salary sheet format that includes a working hour column, as our company calculates salary based on the working hours in a month.
Another issue is that it is a five-day working week, so I am confused about whether to calculate the salary based on a 30-day, 26-day, or 22-day month. Please help me as I am facing this problem.
Regards, Nish
From India, Gurgaon
Acknowledge(0)
Amend(0)
2I have recently joined an IT company as an HR executive. I am from a recruitment background, so I don't have deep knowledge of HR generalist profiles. The problem is that I have to prepare a salary sheet for the month of January 2014. Therefore, I need a salary sheet format that includes a working hour column, as our company calculates salary based on the working hours in a month.
Another issue is that it is a five-day working week, so I am confused about whether to calculate the salary based on a 30-day, 26-day, or 22-day month. Please help me as I am facing this problem.
Regards, Nish
From India, Gurgaon
Acknowledge(0)Amend(0)
Please try to update the following info so that somebody can give the best advice:
1. Total number of employees
2. How do you get the number of worked days - do you take calendar days worked or use some formula (e.g., Total hours worked / 9)
3. Salary shall always be payable against the wage period - typically, this shall be calendar month-based (Jan, Feb, Mar... Dec)
4. If there are any loss of pay days, then you need to deduct the corresponding number of days' salary.
5. How do you currently process payroll - manually using Excel or use any software?
From India, Bangalore
Acknowledge(0)Amend(0)
1. Total number of employees
2. How do you get the number of worked days - do you take calendar days worked or use some formula (e.g., Total hours worked / 9)
3. Salary shall always be payable against the wage period - typically, this shall be calendar month-based (Jan, Feb, Mar... Dec)
4. If there are any loss of pay days, then you need to deduct the corresponding number of days' salary.
5. How do you currently process payroll - manually using Excel or use any software?
From India, Bangalore
Acknowledge(0)Amend(0)
In our team, we have 15 people who are working on a new project. Our daily working hours are 9 hours, which means we have to work 45 hours in a week, i.e., in a month we have to work 180 hours. We mainly use a manual payroll system.
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
I am waiting for your reply, senior. At least you should give me a suggestion. If you are unable, then let me know. I will not post any query on this site. How many times have I posted a query, but every time I am disappointed? I am tired of this. Why does this site have a query option if these seniors are unable to resolve my issues? Thank you, senior, for your valuable replies.
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
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.
SALARY SHEET CALCULATION.xls
No more working till late hours.doc