How Can I Create an Effective Leave Register to Track Employee Attendance and Deductions?

Company Leave Policy

• 2 leaves each month. No EL/CL/PL leaves.
• Office timings: 10:00 AM to 6:30 PM (punching is only here).
• Short break: 20 mins (manual entry in register).
• Deduction on late coming:
- 10:00 AM - 6:30 PM: No deduction.
- 10:00 AM - 10:05 AM: Grace period.
- 10:06 AM - 10:15 AM: ¼ of salary deduction (or stay till 07:00 PM).
- 10:16 AM - 11:30 AM: ¼ of salary deduction.
- 11:30 AM - 02:00 PM: ½ of salary deduction.
• Half day: 10:00 AM - 1:30 PM.
• Second Saturday: Half day.
• If you leave at 4:30 PM on any day, ¼ of your salary will be deducted.

Request for Assistance

Please help me design a leave register for employees, where at the end I can determine:
1) Total number of working days of an employee.
2) Deduction of an employee.
3) Leave adjustment of an employee.

Regards

Dear Ms. Shilpi, To form a policy about leave, it is first required to know under which authority your establishment falls: Shop and Establishment or Factory. Both have different rules for leave, break hours, and working hours, etc. From your question, it seems that you might fall under S & E. It is better first to go through the S & E Act before drafting the policy. There should be a legal basis for the policy. What are the terms which are mandatory by the S & E Act? Please list them all and read carefully. Then, for each issue, you can think upon your own with the consultation of other senior officers. Hope this may help you. Mangesh Wakodkar

This is a good mode of system to control the late-coming employees. This has to be approved by the Standing Orders of the Company, which will have to be displayed at the entry of the establishment. Also, this system is according to the Industrial Employment (Standing Orders) Act. Please go through this act because we need to go through the respective act/rules before implementing a decision.