Hi, I work in a small firm. It's been 5 months since I joined this company. We basically have software for the calculation of employees' attendance. For all the months, we used a formula to calculate the salary, which is fixed salary divided by the number of days in a month multiplied by the number of days present for the employees. As it is the month of February, I am in a dilemma on how to calculate the salary for 28 days. I tried using the same formula by changing the number of days to 28. However, the salary to be paid is showing more than the fixed salary. Can anyone help me out with this?
Thank you in advance.
From India, Bangalore
Acknowledge(0)
Amend(0)
Thank you in advance.
From India, Bangalore
Acknowledge(0)Amend(0)
First, could you please tell me whether you work 5 days a week or 6 days a week? As part of calculating the salary, typically, 30 days are considered in a month, and the salary is paid for 26 days regardless of the number of weekends and the total number of days in a month.
From India, Bangalore
Acknowledge(0)Amend(0)
662From India, Bangalore
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.
SALARY SHEET CALCULATION.xls
Salary calculation.doc