How to set up a monthly attendance lock
A monthly attendance lock is a cut-off after which a closed month's attendance cannot be changed quietly. This guide explains how a small factory or office can close the month cleanly, hand a firm record to payroll, and deal with late corrections in the open. It matters because pay disputes usually start with attendance that someone changed after the fact.
Why this matters
A bakery-equipment factory in Pune has 85 workers on three shifts. The timekeeper keeps the muster, supervisors send changes by phone, and pay is processed on the 3rd. Last month a worker's absence was corrected on the 6th, after salary had been paid, so the next month's pay needed an adjustment that surprised the worker and took two days to explain. With a lock, every change after the cut-off has a name, a reason and an approval.
Before you start
- A daily attendance record for every employee, whether from a register, a punch machine report or a sheet.
- A leave policy in writing, with the leave types, who can approve and how long before the date a request must be made.
- An overtime rule: who can authorise it, in what form and up to what limit.
- The calendar of the month's holidays and weekly offs, so days can be laid out correctly.
- A fixed lock date each month, agreed with payroll, such as the 2nd working day of the next month.
Step by step
- The timekeeper prepares the month's sheet on the last working day, listing each employee and each day with a status: present, absent, leave, weekly off, holiday or half day. Days with no entry are highlighted instead of being assumed present.
- The HR approver goes through the highlighted days with supervisors. Each one is settled as present, absent or approved leave, and every leave has an approval from the right person and the date it was given.
- The payroll officer reviews all overtime and exceptions, such as late marks, double shifts and work on holidays. Each overtime entry must match a written authorisation, and anything without one goes back to the supervisor before it is counted.
- The timekeeper confirms that the month has no missing days, no unapproved overtime and no unresolved leave. The HR approver then approves the period, the timekeeper locks it, and the lock record shows the date, time and the person who locked it.
- The payroll officer processes pay only from the locked record. If something is wrong, payroll does not edit the attendance. It asks for a regularisation.
- If a change is needed after the lock, the supervisor raises a regularisation with the employee, the date, the correct status, the reason and any proof. The HR approver approves or rejects it, and the effect is shown in the next payroll cycle.
- At the start of the next month, the HR approver reviews the list of regularisations from the last month and asks the supervisors who raised the most why.
Overtime pay, leave entitlements, and the deductions linked to attendance are governed by labour and social security rules that change and differ by state and by type of establishment, so keep to your own policy and your adviser's guidance on the legal side. Check the current rule on the official portal or with your CA before acting.
Who does what
| Role | What they do | Record they own |
|---|---|---|
| Timekeeper | Lays out the month, chases gaps, locks the period | Daily attendance and monthly lock |
| HR approver | Settles unrecorded days and leave, approves the lock, decides regularisations | Leave approval and regularisation |
| Payroll officer | Checks overtime and exceptions, processes pay from the locked record | Overtime authorisation |
Common mistakes
- Treating blank days as present because the worker "must have come".
- Approving overtime verbally on the shop floor and trying to document it after the month ends.
- Locking the month before leave requests are settled, which forces many corrections later.
- Letting supervisors send changes directly to payroll without HR, so records differ between teams.
- Allowing the lock to be undone informally, so it is a lock in name only.
How to tell it is working
- Missing days. On the lock date, count the employee days that still have no status. Divide by the total employee days in the month. It should be zero before locking.
- Unapproved overtime. Count the overtime hours claimed without a written authorisation and divide by all overtime hours. Anything above zero should be explained before pay is processed.
- After-lock corrections. Count the regularisations raised after the lock for that month and divide by the number of employees. If this is high or concentrated in one team, the closing step is being rushed.
Questions people ask
Who owns attendance lock?
The HR approver owns the lock decision, because that person decides what counts as leave or a correction. The timekeeper prepares and applies the lock, and the payroll officer relies on it. If there is no HR person, the owner or a senior manager should take that role.
What is the minimum record for attendance lock?
Keep daily attendance for each employee, the leave approvals, the overtime authorisations, the lock record with date and name, and every regularisation with its reason. These let you rebuild what pay was based on at any time.
When should a case stop?
An exception stops when it is settled and recorded: the day is given a status, the leave is approved or refused, or the overtime is authorised or rejected. A regularisation stops when the HR approver decides and the effect is passed to payroll.
Can a spreadsheet support this stream?
Yes, for a modest headcount. Use one sheet per month, protect it after the lock, and keep the regularisations on a separate sheet so changes stay visible. Avoid keeping several copies by email.
What should the owner review?
The owner should look at the count of missing days at lock, the overtime without authorisation, the regularisations and who requested them. A short monthly summary of these three numbers is enough.