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.
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| H1 | Vacancy or replacement was approved before the offer | Trace the sampled joiner to the approval for the post | Manpower approval note or message | Reviewer | ||
| H2 | Offer terms match the joining record | Compare designation, pay and joining date in both | Offer letter, joining form | Reviewer | ||
| H3 | Identity, address and qualification papers are on file | Open the employee file and tick each paper against the checklist | Employee file, document checklist | Reviewer | ||
| H4 | Every pay change has a named approver and an effective date | Trace the changed pay on the salary sheet to a signed change note | Pay revision note, salary sheet | Reviewer | ||
| H5 | Probation outcome was recorded on time | Read the confirmation or extension note against the joining date | Probation review note | Reviewer | ||
| H6 | Resignation or termination is in writing and accepted by the right person | Read the notice and the acceptance | Resignation letter, acceptance reply | Reviewer | ||
| H7 | Handover and asset return are signed off | Match issued assets to returns | Asset issue list, clearance note | Reviewer | ||
| H8 | Final settlement was calculated and approved before payment | Recompute dues and recoveries, compare with amount paid | Settlement sheet, bank record | Reviewer |
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
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| H8 | Final settlement was calculated and approved before payment | Sampled EMP-017, left 30 September | Settlement sheet, bank record | Meera (accounts) | Fail: ₹4,200 of advance was not recovered; settlement paid ₹38,600 against ₹34,400 due | Rakesh 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.