Statutory registers (India)
Overtime register template
Most overtime findings are not about the rate — they are about the running quarterly total nobody was tracking. This template computes both.
Opens in Excel, Google Sheets, Numbers and LibreOffice — no conversion needed.
Preview of the actual columns — green cells are formulas
What is in the file
These are the actual columns in the download, with a filled sample row so you can see the expected shape. Cells beginning with an equals sign are formulas and compute when the file opens.
| Column | Sample value | Notes |
|---|---|---|
| Date | 2026-08-03 | |
| Employee ID | EMP-014 | |
| Employee name | Priya Sharma | |
| Normal hours worked | 9 | |
| Overtime hours | 2 | |
| Ordinary hourly rate | 144.23 | |
| Overtime rate | =F2*2 | Twice ordinary rate in most states |
| Overtime wages | =ROUND(E2*G2,2) | |
| Date of payment | 2026-08-31 | |
| Quarter to date OT hours | 18 | Track against your state's cap |
How to use it
- →Compute the ordinary hourly rate as monthly wages divided by 26 days, then by standard daily hours.
- →Check your state's overtime multiplier — most apply twice the ordinary rate, but Rajasthan applies 1.5×.
- →Watch the quarter-to-date column: overtime caps are cumulative, commonly 50 to 144 hours per quarter depending on state and recent amendments.
Before you rely on it
Overtime caps and multipliers are set by the Act applicable in your state and have been amended in several states during 2025 and 2026. Verify the current figure for your state before relying on this.
When the spreadsheet stops scaling
A template is the right answer until the reconciliation between sheets costs more than the sheets save. Workclave records the same data as work happens, applies your policy automatically, and produces the register, the payroll input and the client hours statement from one source. Free for up to 3 users.
Votre équipe travaille. Commencez à comprendre comment.
Rejoignez les équipes qui suivent des sessions, pas seulement des heures. Gratuit jusqu’à 3 utilisateurs — sans carte bancaire, sans minimum, sans engagement.