To track overtime properly, log every extra hour as it happens, with the date and the reason, then compare the total with the overtime line on your next payslip. If the two differ, you have a clear, dated list to take to payroll. The same log also shows what an extra hour is really worth once travel and meals are deducted.
What should the log contain?
| Date | Hours | Reason | Approved by |
|---|---|---|---|
| 3 Mar | 2 | Month-end close | Team lead |
| 7 Mar | 3 | Client release | Manager |
| 14 Mar | 4 | Weekend support | Manager |
| 18 Mar | 3 | Audit preparation | Manager |
| 21 Mar | 3 | Vendor handover | Team lead |
| 28 Mar | 3 | Weekend support | Manager |
| Month total | 18 across 6 days | - | - |
Keep approvals in writing, such as an email or a message, and note where they are. Overtime that nobody can show was approved is the easiest to lose. Whether and how your role is eligible depends on your contract and company policy, so check those rather than assuming.
How do I work out what the extra hours should pay?
Ask HR for the overtime rule in writing: what rate applies, and whether it is calculated on basic pay or a wider base. As an example, say basic pay is ₹30,000, the month counts 26 working days of 8 hours (208 hours), and the policy pays twice the hourly rate. These are assumptions for the example, not a standard.
- Hourly rate: ₹30,000 / 208 is about ₹144.23.
- Overtime rate: ₹144.23 x 2 is about ₹288.46.
- For 18 hours: ₹288.46 x 18 is about ₹5,192.
In a sheet, with basic pay in B1 and the monthly hours in C2:C32, the formula =ROUND(B1/(26*8)*2*SUM(C2:C32),0) gives the same ₹5,192. Change the 26, 8 and 2 to match your policy.
What if the payslip pays less?
Say the payslip shows ₹4,300 under overtime. The difference is ₹5,192 minus ₹4,300, which is ₹892. Overtime is sometimes paid a month late, so first check whether the next payslip includes the balance. If not, write to payroll with your log, the approvals and your calculation. Keep the tone factual: here are the dates and hours, here is the rule, can you check the difference.
What is an extra hour really worth?
Overtime has costs. Say those 6 days involved ₹900 of extra cab fares and late meals. Net gain is ₹4,300 minus ₹900, which is ₹3,400, across 18 hours: about ₹189 an hour, compared with the ₹288 headline. This is the number to compare against your time and energy. If you categorise your spending, the late-night cab and food lines show these costs without extra effort. SpendixAI can categorise imported card and bank rows, so you can see them by month.
Should I plan on overtime pay?
Treat it like variable pay: do not let regular bills depend on it. Use it for goals or the buffer, because it can stop when workloads change.
Should I track comp-offs and time off in the same log?
If your employer gives time off in place of pay, add a column for it. Note whether each extra hour is paid, converted to leave, or neither, and keep the dates by which a comp-off must be used. Otherwise hours quietly disappear. A single line per day, with the hours and the form of compensation, is enough to see whether your extra work is being recognised at all.
A short checklist
- Log date, hours, reason and approver the same day.
- Get the overtime rate rule in writing.
- Compute the expected pay before the payslip arrives.
- Compare with the payslip, remembering a possible month's lag.
- Raise any difference with the log in hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


