lamp.
ResourcesPricingAbout
4 min readBy

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.

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
C1Every working day has an entry for every employeePick 5 employees and count the days entered against the days in the monthDaily attendance sheet or registerReviewer
C2Blank days were resolved, not defaulted to presentList blank days found on day 25 and trace each to a leave, absence or correctionLeave approval and correction notesReviewer
C3Leave taken matches approved leaveMatch 5 leave days on the sheet to signed requestsLeave approval forms or messagesReviewer
C4Overtime was authorised before it was workedMatch each overtime entry above 2 hours to a prior approvalOvertime authorisation slipReviewer
C5The period carries a named approver and a lock dateRead the lock record for the monthMonthly lock sign-offReviewer
C6Nothing changed in the locked month except through regularisationCompare the locked copy with the copy used for salaryLocked copy, salary sheetReviewer
C7Late changes carry a reason and approverTrace every post-lock change to a regularisation entryRegularisation recordReviewer

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

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
C4Overtime was authorised before it was workedSampled EMP-014, EMP-022, EMP-031 for OctoberOvertime authorisation slipsMeera (accounts)Fail. EMP-022 shows 6 hours (₹1,800) on 12 Oct with no slipPlant 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.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →