Attendance lock: control and audit worksheet
This worksheet lets someone other than the person who prepared the month's attendance test whether the monthly lock really worked. It is used by an owner, an accounts head or an outside reviewer who wants proof that each locked month holds complete, approved attendance before salaries are calculated. It tests the controls, not the employees.
When to use it
Use it once a month, after the period is locked and either before the salary sheet is released or just after it is paid. Run the full version in the first month you start locking attendance, and again after any change of timekeeper, HR approver or payroll officer. Also run it when a salary dispute shows that locked attendance was altered afterwards.
The template
Test each control on a small sample of employees and record what you found. Keep one worksheet per month.
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| C1 | Every working day has an entry for every employee | Pick 5 employees and count the days entered against the days in the month | Daily attendance sheet or register | Reviewer | ||
| C2 | Blank days were resolved, not defaulted to present | List blank days found on day 25 and trace each to a leave, absence or correction | Leave approval and correction notes | Reviewer | ||
| C3 | Leave taken matches approved leave | Match 5 leave days on the sheet to signed requests | Leave approval forms or messages | Reviewer | ||
| C4 | Overtime was authorised before it was worked | Match each overtime entry above 2 hours to a prior approval | Overtime authorisation slip | Reviewer | ||
| C5 | The period carries a named approver and a lock date | Read the lock record for the month | Monthly lock sign-off | Reviewer | ||
| C6 | Nothing changed in the locked month except through regularisation | Compare the locked copy with the copy used for salary | Locked copy, salary sheet | Reviewer | ||
| C7 | Late changes carry a reason and approver | Trace every post-lock change to a regularisation entry | Regularisation record | Reviewer |
How to fill it
- Ref: keep the numbers fixed so month-to-month results can be compared.
- How to test: write down the sample you actually used (names or employee codes), so another person can repeat the test.
- Evidence to check: note the file name, page or message date you looked at, not just "seen".
- Tester: the person who did the test. It must not be the person who prepared the attendance.
- Result and note: write Pass or Fail, then one line on what you saw. A pass with a worry is still worth a note.
- Corrective action: name the person and date. If the fix needs a salary change, say so.
Overtime rates, leave entitlements and the registers you must keep come from labour law and your own written policy. Check the current rule on the official portal or with your CA before acting.
Example row
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| C4 | Overtime was authorised before it was worked | Sampled EMP-014, EMP-022, EMP-031 for October | Overtime authorisation slips | Meera (accounts) | Fail. EMP-022 shows 6 hours (₹1,800) on 12 Oct with no slip | Plant manager to sign a late approval or payroll officer to remove the hours; due 8 Nov |
Review and sign-off
- The owner or accounts head reviews the completed worksheet, never the timekeeper who prepared the month.
- Review it every month for the first quarter after you start, then every month or every second month once results are steady.
- Escalate to the owner the same day if any Fail affects pay already released, or if the same control fails two months running.
Keeping it up to date
- Add a control whenever a new kind of problem appears, such as a new shift pattern or a second site.
- Keep each month's worksheet with the lock record and the salary sheet for the period your CA or the law requires.
- Review the sample sizes each year and raise them if the number of employees has grown.