lamp.
ResourcesPricingAbout
4 min readBy

Hire-to-retire: control and audit worksheet

This worksheet helps someone other than the HR or accounts person who handled the people records test whether the hire-to-retire process really worked. An owner, an accounts head or an outside reviewer uses it to pick a few employees, trace them from offer to exit, and see whether the paperwork and approvals are there. It tests the controls, not the people.

When to use it

Use it once a quarter on a small sample, and straight away after a dispute over joining terms, a pay complaint or an exit settlement that was reopened. Also run it when the person who normally handles joining and exit formalities changes, because gaps tend to show up in the first months of a new handler.

The template

Pick at least one new joiner, one employee whose pay changed and one leaver in the period. Keep one worksheet per review.

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
H1Vacancy or replacement was approved before the offerTrace the sampled joiner to the approval for the postManpower approval note or messageReviewer
H2Offer terms match the joining recordCompare designation, pay and joining date in bothOffer letter, joining formReviewer
H3Identity, address and qualification papers are on fileOpen the employee file and tick each paper against the checklistEmployee file, document checklistReviewer
H4Every pay change has a named approver and an effective dateTrace the changed pay on the salary sheet to a signed change notePay revision note, salary sheetReviewer
H5Probation outcome was recorded on timeRead the confirmation or extension note against the joining dateProbation review noteReviewer
H6Resignation or termination is in writing and accepted by the right personRead the notice and the acceptanceResignation letter, acceptance replyReviewer
H7Handover and asset return are signed offMatch issued assets to returnsAsset issue list, clearance noteReviewer
H8Final settlement was calculated and approved before paymentRecompute dues and recoveries, compare with amount paidSettlement sheet, bank recordReviewer

How to fill it

  • Ref: keep the numbers fixed so results can be compared between reviews.
  • How to test: write the employee codes you sampled, so another person can repeat the test.
  • Evidence to check: note the file name, page or message date, not just "seen".
  • Tester: the person who did the test. It must not be the person who prepared the records.
  • Result and note: write Pass or Fail and one line on what you saw. A pass with a worry still deserves a note.
  • Corrective action: name the person and the date, and say if money must be recovered or paid.

Notice periods, statutory registers, provident fund, insurance and gratuity treatment, and final settlement timing come from labour law and your own written terms. Check the current rule on the official portal or with your CA before acting.

Example row

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
H8Final settlement was calculated and approved before paymentSampled EMP-017, left 30 SeptemberSettlement sheet, bank recordMeera (accounts)Fail: ₹4,200 of advance was not recovered; settlement paid ₹38,600 against ₹34,400 dueRakesh to recover ₹4,200 from the next payment or by written request by 20 November

Review and sign-off

  • The owner or an independent reviewer signs the worksheet, not the person who maintains the employee files.
  • Review quarterly, plus after any disputed joining, pay change or exit.
  • Escalate to the owner at once when a payment was made without approval, when papers for a working employee are missing, or when the same failed control appears in two reviews in a row.

Keeping it up to date

  • Keep each completed worksheet with the sampled employee codes for the period your CA or the law requires.
  • Add a control row whenever a new problem is found, and keep the old rows so earlier reviews stay comparable.
  • Review the control list once a year, and after any change in your pay structure or approval rules.
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 →