I am seeking information related to HR policies, specifically concerning salary deductions based on late arrivals and early departures in our office. Below are the outlined details:

1) General Timing:
- Monday to Saturday: In Time - 9:30 AM, Out Time - 6:00 PM.
- Sunday/declared holidays: 6 hrs of work is compulsory for a full day's salary.

Salary Deduction:
- Arrival after 9:30 AM up to 11:30 AM, after 11:30 AM up to 2:00 PM, after 2:00 PM, or after 4:00 PM results in a deduction of 1/4, 1/2, 3/4, and full day's salary respectively.
- Departure after 4:00 PM, after 2:00 PM up to 4:00 PM, before 2:00 PM, or before 11:00 AM results in a deduction of 1/4, 1/2, 3/4, and full day's salary respectively.

2) Peak Months (July, September & December for CP Office and July, September & March for PG Office)
- Monday to Saturday: Out Time - 8.00 PM (Married Female Out Time - 7.00 PM).
- Sunday/declared holidays: 9 hrs of work is compulsory for a full day's salary (Married Female minimum 7 hrs is compulsory).

Salary Deduction:
- Similar deductions as in general timing but with out time pushed to 8:00 PM.

3) Half Day:
- Timing: 9:30 AM to 2:00 PM on 2nd and 4th Saturday.
- No half day allowed during peak months (July, September, December & March).

4) Short Leave Policy:
- Timing: 9:31 AM to 10:00 AM.
- Maximum 4 times allowed in a month. After that, normal salary deductions apply.

5) Intermittent Leave (Personal Work Leave): Up to 2 hrs within office hours allowed twice a month.
- More than 2 hours but less than 3 hours, more than 3 hours but less than 4 hours, or more than 4 hours results in a deduction of 1/4, 1/2, and full day's salary respectively.

6) Casual Leave: One per month allowed (Can be carried forward till February end, otherwise it lapses).
- At least 20 days presence (except Sunday) in a month is required, otherwise, no casual benefit will be given.
- No Casual Leave is provided to any staff in the first three months.

7) Mr. Gopal Kumar Kedia & Mrs. Santosh Kedia are our Directors, so there will be no deduction according to punching, hence your software will always show them present in attendance.

8) Nitin's normal shift is 8.45 AM to 9.00 PM, but if he completes a total of 12 hours working in one day, no deduction will be marked.

9) Ishwar Kant Mishra, Kamlesh, Bimla Devi, & Anil have their respective shift timings but no deduction will be marked if they are present for the day.

10) Ram Singh, Shailendra Kumar, Suresh Kumar work in Shift No 3 (8.30 AM to 7.00 PM), but a grace time of 15 minutes is given to them, after 8:45 AM, salary deductions will start.

Location: Mumbai, India.
Tags: City-India-Mumbai, Country-India, shift timings, salary sheet, HR policies.

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

Based on your question, I understand that you need assistance in creating a salary sheet that includes deductions for late arrivals and early departures along with other HR policies.

Firstly, the policies you've mentioned are quite detailed and cover a lot of aspects. However, you need to be aware of the Shops and Establishments Act that governs working hours, spread over, rest interval, opening and closing hours, closed days, national and religious holidays, overtime work etc. in your location.

For creating a salary sheet, you can use Microsoft Excel or Google Sheets, or any other spreadsheet software you prefer. Here's a step-by-step guide:

1. Open a new sheet and make columns for Employee Name, Employee ID, Designation, Days Worked, Late Arrivals, Early Departures, Casual Leaves, Short Leaves, and Intermittent Leaves.
2. Under each column, input the details for each employee for a particular month.
3. Calculate the salary deductions based on the late arrivals, early departures, and leaves. You can use the IF function to calculate the deductions based on the conditions you have defined.
4. After calculating the deductions, subtract them from the employee's total salary to get the final payable salary.
5. Repeat this process for each employee.

Remember, you need to ensure that these policies are clearly communicated to all employees and are also documented in your company's employee handbook. Also, these policies should be consistently implemented to ensure fairness and transparency.

For putting the leave approval on software, you can use any HRMS software that provides this feature. The process usually involves the employee applying for leave on the software, the manager approving it, and then it gets recorded in the system which can be used for payroll processing.

However, I would also recommend consulting with a local HR expert or legal counsel to ensure that your policies are compliant with local labor laws.

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

Join 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.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.