Free template template · Word

Overtime Calculation Sheet

An overtime calculation sheet converts approved overtime hours into amounts for payroll. For each employee it lists approved OT hours, the wage base and the rate that applies under law or company policy, and the resulting amount, so HR and payroll can cross-check before salary is paid.

Editable Word (.docx)
Made for India
18 fill-in fields highlighted
Free, no sign-up

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[Company Logo][Company Name]

OVERTIME CALCULATION SHEET

Company:: [Company Name]
Payroll Month:: [Month Year]
Department:: [Department]
Standard Hours per Month:: [No.]

Basis: Hourly rate = [Wage base as per applicable law/policy] ÷ [Standard hours per month]. OT amount = Approved OT hours × Hourly rate × [Applicable OT rate as per law/policy]. Overtime is paid as per applicable law and company policy.

Employee ID	Employee Name	Approved OT Hours	Wage Base (₹)	Hourly Rate (₹)	Applicable OT Rate	OT Amount (₹)	Approval Ref.
[Employee ID]	[Employee Name]	[Hours]	[Amount]	[Amount]	[As per law/policy]	[Amount]	[Reference Number]
[Employee ID]	[Employee Name]	[Hours]	[Amount]	[Amount]	[As per law/policy]	[Amount]	[Reference Number]
[Employee ID]	[Employee Name]	[Hours]	[Amount]	[Amount]	[As per law/policy]	[Amount]	[Reference Number]
[Employee ID]	[Employee Name]	[Hours]	[Amount]	[Amount]	[As per law/policy]	[Amount]	[Reference Number]
[Employee ID]	[Employee Name]	[Hours]	[Amount]	[Amount]	[As per law/policy]	[Amount]	[Reference Number]

Department Summary

Total OT Hours	Total OT Amount (₹)	Previous Month (₹)	Change
[Hours]	[Amount]	[Amount]	[+/-]

Checks before Payroll

All hours match approved overtime forms
Wage base matches salary master
Rate applied as per current law/policy
Calculation checked by second person

Prepared by
[Payroll Executive]
Date: [Date]

Checked by
[HR Name]

Approved by
[Finance Head]

Download Word (.docx) — free

What this template includes

Approved OT hours only – from the approval form
Wage base used – as defined by applicable law/policy
Hourly rate derivation – transparent formula placeholder
Applicable OT rate – entered as per law or policy, not assumed
Amount per employee – payroll figure
Department total – cost visibility
Checker sign-off – four-eyes control

When to use it

Monthly payroll processing for overtime-eligible staff
Cross-checking overtime calculated by payroll software
Responding to an employee query about OT pay
Budgeting overtime cost by department

How to customise this template

1Enter the wage components that form the OT base as per your applicable law/policy
2Set your hourly rate formula (e.g. monthly base divided by standard hours)
3Fill the applicable OT rate as per law or policy
4Link to your payroll month

HR tips

Never calculate OT on unapproved hours
Document the formula in the sheet so it is consistent each month
Have a second person check calculations
Keep the sheet with the payroll records for the month

This template is a starting point. Review it against applicable labour laws, state Shops & Establishments or Factories rules, your standing orders and the overtime wage rules applicable to your employees, and consult a legal adviser where needed.

For HR & hiring managers

Experienced and fresher candidates across India — blue, grey and white collar. Post a job in 5 minutes and start receiving applications.

Post a job free See plans

Post in 5 minutesDescribe the role in one line — we write the job description.
Verified applicantsEvery applicant has a verified mobile number.
Resume databaseSearch experienced candidates by skill, city and experience.

Frequently asked questions

How is overtime calculated?+

Approved overtime hours are multiplied by the hourly rate derived from the wage base and the overtime rate applicable under law or company policy. The sheet records each step so it can be checked.

Which salary components are included for overtime?+

This depends on the applicable law and your policy definition of wages. Confirm the components before calculating.

Is overtime taxable?+

Yes, overtime is part of salary income and is included in taxable income and TDS calculation.

All 50 attendance & time management →

[Company Logo][Company Name]

MONTHLY ATTENDANCE SHEET

Company:: [Company Name]
Department / Team:: [Department]
Month:: [Month Year]
Attendance Cycle:: [DD/MM/YYYY] to [DD/MM/YYYY]
Total Days in Cycle:: [No.]

Employee ID	Employee Name	Week 1	Week 2	Week 3	Week 4	Week 5	Late Marks	OT Hours (Approved)	Paid Leave	LOP Days	Paid Days	Remarks
[Employee ID]	[Employee Name]	[Days present]	[Days present]	[Days present]	[Days present]	[Days present]	[No.]	[Hours]	[No.]	[No.]	[No.]	[Remarks]
[Employee ID]	[Employee Name]	[Days present]	[Days present]	[Days present]	[Days present]	[Days present]	[No.]	[Hours]	[No.]	[No.]	[No.]	[Remarks]
[Employee ID]	[Employee Name]	[Days present]	[Days present]	[Days present]	[Days present]	[Days present]	[No.]	[Hours]	[No.]	[No.]	[No.]	[Remarks]
[Employee ID]	[Employee Name]	[Days present]	[Days present]	[Days present]	[Days present]	[Days present]	[No.]	[Hours]	[No.]	[No.]	[No.]	[Remarks]
[Employee ID]	[Employee Name]	[Days present]	[Days present]	[Days present]	[Days present]	[Days present]	[No.]	[Hours]	[No.]	[No.]	[No.]	[Remarks]

Leave Breakup

Employee Name	Casual Leave	Sick Leave	Earned Leave	Comp-Off	On Duty
[Employee Name]	[No.]	[No.]	[No.]	[No.]	[No.]
[Employee Name]	[No.]	[No.]	[No.]	[No.]	[No.]
[Employee Name]	[No.]	[No.]	[No.]	[No.]	[No.]

Notes for Payroll

Paid days = present days + paid leave + weekly offs + paid holidays.
Overtime is paid as per applicable law and company policy, only for hours approved in writing.
Any correction after submission must be raised through an attendance regularisation form.

Template · Word

Monthly Attendance Sheet

Download .docx

[Company Logo][Company Name]

EMPLOYEE ATTENDANCE SHEET

Company:: [Company Name]
Employee Name:: [Employee Name]
Employee ID:: [Employee ID]
Designation:: [Designation]
Reporting Manager:: [Reporting Manager]
Month:: [Month Year]
Standard Shift:: [09:30] to [18:30]

Date	Day	In-Time	Out-Time	Break (mins)	Net Hours	Status (P/L/H/WO/HD)	Remarks
[DD/MM/YYYY]	[Day]	[HH:MM]	[HH:MM]	[Mins]	[Hours]	[Status]	[Remarks]
[DD/MM/YYYY]	[Day]	[HH:MM]	[HH:MM]	[Mins]	[Hours]	[Status]	[Remarks]
[DD/MM/YYYY]	[Day]	[HH:MM]	[HH:MM]	[Mins]	[Hours]	[Status]	[Remarks]
[DD/MM/YYYY]	[Day]	[HH:MM]	[HH:MM]	[Mins]	[Hours]	[Status]	[Remarks]
[DD/MM/YYYY]	[Day]	[HH:MM]	[HH:MM]	[Mins]	[Hours]	[Status]	[Remarks]

Monthly Totals

Item	Total
Days present	[No.]
Leave days (type)	[No. / Type]
Total net hours	[Hours]
Late arrivals	[No.]

I confirm that the entries above are a true record of my attendance for the month.

Employee
[Employee Name]
Date: [Date]

Verified by
[Reporting Manager]
Date: [Date]

Template · Word

Employee Attendance Sheet

Download .docx

[Company Logo][Company Name]

OVERTIME REQUEST FORM (PRIOR APPROVAL)

Company:: [Company Name]
Department:: [Department]
Request No.:: [Reference Number]
Date of Request:: [Date]

1. Overtime Details

Employee ID	Employee Name	Designation	OT Date	From	To	Planned Hours
[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[HH:MM]	[HH:MM]	[Hours]
[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[HH:MM]	[HH:MM]	[Hours]
[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[HH:MM]	[HH:MM]	[Hours]

2. Justification

Work to be completed
Reason it cannot be done in normal hours
Customer / order / project reference
Cost centre

Planned peak workload
Breakdown / emergency
Covering absence
Statutory or audit deadline
Other: [Details]

Form · Word

Overtime Request Form

Download .docx

[Company Logo][Company Name]

OVERTIME APPROVAL FORM (ACTUAL HOURS)

Company:: [Company Name]
Department:: [Department]
Period:: [DD/MM/YYYY] to [DD/MM/YYYY]
Pre-approval Ref.:: [Reference Number]

Employee ID	Employee Name	OT Date	Planned Hours	Actual In–Out (system)	Actual OT Hours	Variance Reason	Pay / Comp-Off
[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Hours]	[HH:MM–HH:MM]	[Hours]	[Reason]	[Pay / CO]
[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Hours]	[HH:MM–HH:MM]	[Hours]	[Reason]	[Pay / CO]
[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Hours]	[HH:MM–HH:MM]	[Hours]	[Reason]	[Pay / CO]
[Employee ID]	[Employee Name]	[DD/MM/YYYY]	[Hours]	[HH:MM–HH:MM]	[Hours]	[Reason]	[Pay / CO]

Summary

Total Employees	Total Planned Hours	Total Actual Hours Approved
[No.]	[Hours]	[Hours]

Certification

I certify that the employees listed above worked the overtime hours shown, that the work was necessary and was completed, and that the hours match the attendance system records.

Form · Word

Overtime Approval Form

Download .docx

[Company Logo][Company Name]

Name of Establishment:: [Company Name]
Address:: [Company Address]
Month / Quarter:: [Month Year] / [Q1–Q4]

Sr. No.	Employee ID	Employee Name	Designation	Date	Normal Hours	OT Hours	Cumulative OT (Qtr)	Approval Ref.	Paid in Month	Employee Signature
1	[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[Hours]	[Hours]	[Hours]	[Reference Number]	[Month]	[Signature]
2	[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[Hours]	[Hours]	[Hours]	[Reference Number]	[Month]	[Signature]
3	[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[Hours]	[Hours]	[Hours]	[Reference Number]	[Month]	[Signature]
4	[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[Hours]	[Hours]	[Hours]	[Reference Number]	[Month]	[Signature]
5	[Employee ID]	[Employee Name]	[Designation]	[DD/MM/YYYY]	[Hours]	[Hours]	[Hours]	[Reference Number]	[Month]	[Signature]

Monthly Total

Total Employees with OT	Total OT Hours	Employees above [No.] hours this quarter
[No.]	[Hours]	[Names]

Note: Overtime recorded here is paid as per applicable law and company policy. Entries must be supported by an approved overtime form.

Maintained by
[Time Office In-charge]

Verified by
[HR Name]

Authorised Signatory
[Authorised Signatory]

Overtime Register

Download .docx

[Company Logo][Company Name]

WORK-FROM-HOME ATTENDANCE SHEET

Employee Name:: [Employee Name]
Employee ID:: [Employee ID]
Team:: [Department]
Month:: [Month Year]
Core Availability Hours:: [HH:MM] to [HH:MM]

Date	Mode (Office / WFH)	WFH Approval Ref.	Login Time	Logout Time	Check-in Method	Work Summary	Manager Initials
[DD/MM/YYYY]	[WFH]	[Reference Number]	[HH:MM]	[HH:MM]	[Email / Chat / VPN]	[Summary]	[Initials]
[DD/MM/YYYY]	[WFH]	[Reference Number]	[HH:MM]	[HH:MM]	[Email / Chat / VPN]	[Summary]	[Initials]
[DD/MM/YYYY]	[WFH]	[Reference Number]	[HH:MM]	[HH:MM]	[Email / Chat / VPN]	[Summary]	[Initials]
[DD/MM/YYYY]	[WFH]	[Reference Number]	[HH:MM]	[HH:MM]	[Email / Chat / VPN]	[Summary]	[Initials]
[DD/MM/YYYY]	[WFH]	[Reference Number]	[HH:MM]	[HH:MM]	[Email / Chat / VPN]	[Summary]	[Initials]

Monthly Summary

Office Days	WFH Days	WFH Limit as per Policy	Leave Days
[No.]	[No.]	[No.]	[No.]

WFH Conditions

Be reachable on phone and chat during core hours.
Follow information security and data confidentiality rules at home.
Inform your manager promptly of any connectivity or power issue.

Template · Word

Work-from-Home Attendance Sheet

Download .docx

[Company Logo][Company Name]

FIELD EMPLOYEE DAILY ATTENDANCE SHEET

Employee Name:: [Employee Name]
Employee ID:: [Employee ID]
Territory / Beat:: [Territory]
Area Manager:: [Reporting Manager]
Date:: [DD/MM/YYYY]

Start Location	Start Time	Start Message Sent To	Vehicle / Mode
[Location]	[HH:MM]	[Reporting Manager]	[Bike / Car / Public transport]

Visit Log

Sr. No.	Customer / Outlet	Area	Check-in	Check-out	Purpose	Outcome / Order Ref.	Km
1	[Customer Name]	[Area]	[HH:MM]	[HH:MM]	[Sales / Service / Collection]	[Outcome]	[Km]
2	[Customer Name]	[Area]	[HH:MM]	[HH:MM]	[Sales / Service / Collection]	[Outcome]	[Km]
3	[Customer Name]	[Area]	[HH:MM]	[HH:MM]	[Sales / Service / Collection]	[Outcome]	[Km]
4	[Customer Name]	[Area]	[HH:MM]	[HH:MM]	[Sales / Service / Collection]	[Outcome]	[Km]
5	[Customer Name]	[Area]	[HH:MM]	[HH:MM]	[Sales / Service / Collection]	[Outcome]	[Km]

End Location	End Time	Total Visits	Total Km
[Location]	[HH:MM]	[No.]	[Km]

I confirm that I was on field duty for the company on the above date and the visits listed are accurate.

Template · Word

Field Employee Attendance Sheet

Download .docx

[Company Logo][Company Name]

CONTRACTOR WORKERS ATTENDANCE SHEET

Principal Employer:: [Company Name]
Contractor:: [Contractor Name]
Work Order No.:: [Reference Number]
Nature of Work:: [Housekeeping / Security / Loading]
Month:: [Month Year]
Work Location:: [Work Location]

Sr. No.	Worker Name	Worker ID	UAN	ESI IP No.	Days Present	Weekly Offs	OT Hours (Approved)	Remarks
1	[Worker Name]	[Worker ID]	[UAN]	[ESI Number]	[No.]	[No.]	[Hours]	[Remarks]
2	[Worker Name]	[Worker ID]	[UAN]	[ESI Number]	[No.]	[No.]	[Hours]	[Remarks]
3	[Worker Name]	[Worker ID]	[UAN]	[ESI Number]	[No.]	[No.]	[Hours]	[Remarks]
4	[Worker Name]	[Worker ID]	[UAN]	[ESI Number]	[No.]	[No.]	[Hours]	[Remarks]
5	[Worker Name]	[Worker ID]	[UAN]	[ESI Number]	[No.]	[No.]	[Hours]	[Remarks]

Summary for Billing

Total Workers Deployed	Total Man-days	Total OT Hours	Invoice No.
[No.]	[No.]	[Hours]	[Invoice Number]

Overtime Calculation Sheet

Preview of the template

Department Summary

Checks before Payroll

What this template includes

When to use it

How to customise this template

HR tips

Frequently asked questions

Leave Breakup

Notes for Payroll

Monthly Attendance Sheet

Monthly Totals

Employee Attendance Sheet

1. Overtime Details

2. Justification

Overtime Request Form

Summary

Certification

Overtime Approval Form

Monthly Total

Overtime Register

Monthly Summary

WFH Conditions

Work-from-Home Attendance Sheet

Visit Log

Field Employee Attendance Sheet

Summary for Billing

Compliance Documents Attached

Contractor Attendance Sheet

Overtime Calculation Sheet

Preview of the template

Department Summary

Checks before Payroll

What this template includes

When to use it

How to customise this template

HR tips

Hire top talent from BetterJobs

Frequently asked questions

Related HR templates