Free template template · Word

Monthly Attendance Sheet

A monthly attendance sheet consolidates each employee's presence, leave, late marks and overtime for one calendar month on a single page. Team leads or HR fill it at month-end so payroll can compute paid days and deductions accurately.

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

Download Word (.docx) — free

Preview of the template

[Highlighted] = fill in

[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.

Submitted by
[Reporting Manager]
Date: [Date]

Checked by
[HR Name]

Payroll
[Payroll Executive]

Download Word (.docx) — free

What this template includes

Week-wise columns – easier to spot patterns than a 31-column grid
Late mark count – supports a fair, documented late-coming policy
Overtime hours column – passes approved hours to payroll
Leave type split – distinguishes paid and unpaid leave
Loss of pay (LOP) days – avoids disputes in salary slips
Remarks column – captures exceptions like on-duty or training

When to use it

Closing attendance at month-end before salary processing
Sharing a team-wise attendance view with department heads
Consolidating attendance from multiple branches into one format
Checking leave balances against actual absence before appraisal

How to customise this template

1Enter the month, department and cut-off date in the header
2Change week ranges to match your payroll cycle (e.g. 26th to 25th)
3Remove the overtime column if your staff are not eligible
4Add a column for night shift or field days if relevant
5Lock the final version as PDF once approved

HR tips

Agree a fixed cut-off date for attendance so payroll is not delayed
Only include overtime that has written approval
Share the sheet with employees for confirmation to reduce salary queries
Keep the daily source records; this sheet is a summary

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 do I calculate paid days in a monthly attendance sheet?+

Paid days are usually present days plus paid leave, weekly offs and paid holidays. Loss-of-pay days are subtracted from the total days of the month as per your payroll policy.

What is the difference between an attendance register and a monthly attendance sheet?+

A register records daily marks; a monthly sheet summarises them for the month. Most companies use the register daily and the sheet for payroll.

Should late marks appear on the monthly sheet?+

Yes, if your policy links repeated late coming to leave adjustment or counselling. Recording the count transparently helps employees see how the policy applies.

All 50 attendance & time management →

[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]

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]

Compliance Documents Attached

Wage register / payment proof for the month
PF challan and ECR
ESI challan
Attendance sheet signed by contractor supervisor

Template · Word

Contractor Attendance Sheet

Download .docx

[Company Logo][Company Name]

MEETING ATTENDANCE SHEET

Meeting:: [Meeting Title]
Date / Time:: [DD/MM/YYYY], [HH:MM] to [HH:MM]
Venue / Link:: [Venue / Online Link]
Chairperson:: [Name]
Organiser:: [Name]

Sr. No.	Name	Designation / Department	Organisation (if external)	Mode (In-person / Online)	Time In	Signature
1	[Name]	[Designation]	[Organisation]	[In-person / Online]	[HH:MM]	[Signature]
2	[Name]	[Designation]	[Organisation]	[In-person / Online]	[HH:MM]	[Signature]
3	[Name]	[Designation]	[Organisation]	[In-person / Online]	[HH:MM]	[Signature]
4	[Name]	[Designation]	[Organisation]	[In-person / Online]	[HH:MM]	[Signature]
5	[Name]	[Designation]	[Organisation]	[In-person / Online]	[HH:MM]	[Signature]

Apologies / Absent

Name	Designation	Reason (if informed)
[Name]	[Designation]	[Reason]
[Name]	[Designation]	[Reason]

Quorum

Members required for quorum
Members present
Quorum met (Yes / No)

Template · Word

Meeting Attendance Sheet

Download .docx

[Company Logo][Company Name]

MONTHLY ATTENDANCE SUMMARY REPORT

Company:: [Company Name]
Month:: [Month Year]
Prepared by:: [HR Name]
Date:: [Date]

1. Headline Figures

Metric	This Month	Last Month	Change
Employees on roll	[No.]	[No.]	[+/-]
Attendance %	[%]	[%]	[+/-]
Unplanned absenteeism %	[%]	[%]	[+/-]
Total late marks	[No.]	[No.]	[+/-]
Total overtime hours	[Hours]	[Hours]	[+/-]

Formulas: Attendance % = days present ÷ scheduled working days × 100. Unplanned absenteeism % = unapproved or same-day absence days ÷ scheduled working days × 100.

2. Department-wise Summary

Department	Headcount	Attendance %	Absenteeism %	Late Marks	OT Hours	Comp-Offs Earned
[Department]	[No.]	[%]	[%]	[No.]	[Hours]	[No.]
[Department]	[No.]	[%]	[%]	[No.]	[Hours]	[No.]
[Department]	[No.]	[%]	[%]	[No.]	[Hours]	[No.]
[Department]	[No.]	[%]	[%]	[No.]	[Hours]	[No.]

Report · Word

Monthly Attendance Summary

Download .docx

[Company Logo][Company Name]

ATTENDANCE REGISTER

Name of Establishment:: [Company Name]
Address:: [Company Address]
Registration No.:: [Registration Number]
Month / Year:: [Month] / [Year]
Department:: [Department]

Sr. No.	Employee ID	Employee Name	Designation	Days 1–15 (codes)	Days 16–31 (codes)	Present Days	Leave Days	Absent Days	Paid Days
1	[Employee ID]	[Employee Name]	[Designation]	[P/A/L codes]	[P/A/L codes]	[No.]	[No.]	[No.]	[No.]
2	[Employee ID]	[Employee Name]	[Designation]	[P/A/L codes]	[P/A/L codes]	[No.]	[No.]	[No.]	[No.]
3	[Employee ID]	[Employee Name]	[Designation]	[P/A/L codes]	[P/A/L codes]	[No.]	[No.]	[No.]	[No.]
4	[Employee ID]	[Employee Name]	[Designation]	[P/A/L codes]	[P/A/L codes]	[No.]	[No.]	[No.]	[No.]
5	[Employee ID]	[Employee Name]	[Designation]	[P/A/L codes]	[P/A/L codes]	[No.]	[No.]	[No.]	[No.]

Monthly Summary

Particulars	Count
Total employees on roll	[No.]
Total working days in month	[No.]
Weekly offs and holidays	[No.]
Employees with full attendance	[No.]

Certified that the above attendance has been verified against leave records and is correct to the best of our knowledge.

Attendance Register Format

Download .docx

[Company Logo][Company Name]

DAILY ATTENDANCE REGISTER

Establishment:: [Company Name]
Location / Gate:: [Work Location]
Date:: [DD/MM/YYYY]
Shift:: [General / A / B / C]
Shift Timing:: [HH:MM] to [HH:MM]

Sr. No.	Employee ID	Employee Name	Department	Time In	Signature (In)	Time Out	Signature (Out)	Remarks
1	[Employee ID]	[Employee Name]	[Department]	[HH:MM]	[Signature]	[HH:MM]	[Signature]	[Late / On Duty / Early Leave]
2	[Employee ID]	[Employee Name]	[Department]	[HH:MM]	[Signature]	[HH:MM]	[Signature]	[Late / On Duty / Early Leave]
3	[Employee ID]	[Employee Name]	[Department]	[HH:MM]	[Signature]	[HH:MM]	[Signature]	[Late / On Duty / Early Leave]
4	[Employee ID]	[Employee Name]	[Department]	[HH:MM]	[Signature]	[HH:MM]	[Signature]	[Late / On Duty / Early Leave]
5	[Employee ID]	[Employee Name]	[Department]	[HH:MM]	[Signature]	[HH:MM]	[Signature]	[Late / On Duty / Early Leave]

Day-end Summary

Total on Roll	Present	On Leave	Absent	Late Arrivals
[No.]	[No.]	[No.]	[No.]	[No.]

Instructions: Each employee must sign personally at entry and exit. Proxy signing is not permitted. Any missed entry should be reported to the supervisor the same day.

Shift Supervisor
[Supervisor Name]
Time: [HH:MM]

Received by HR
[HR Name]
Date: [Date]

Daily Attendance Register

Download .docx

Monthly Attendance Sheet

Preview of the template

Leave Breakup

Notes for 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