Free template · Attendance

Attendance sheet format (free Excel download)

A monthly attendance sheet for factory and office staff. Mark each day with a code and the sheet totals present days, leave, paid days and overtime for you.

Download free Excel template See the format

Free, no sign-up
Formulas included
Excel, Google Sheets & LibreOffice

Monthly attendance sheet · October 2026 · Plant 1

Employee	1	2	3	4	5	6	7	8	9	10	11	12	13	14	Present	OT hrs
Ravi PatilA	P	P	P	WO	P	P	P	P	L	P	WO	P	P	P	11	11
Sunita KaleGen	P	P	P	WO	P	P	P	P	P	P	WO	P	P	P	12	0
Imran ShaikhB	P	P	P	WO	P	P	P	P	P	P	WO	P	P	A	11	14
Meena DeshmukhNight	P	P	P	WO	P	P	P	P	P	P	WO	P	P	P	12	6

P Present A Absent L Leave WO Weekly off · first 14 days shown

Preview with sample data

What it includes

Employee name and shift
One column for every day of the month
Daily codes: present, absent, leave, half day, weekly off, holiday
Totals: present, absent, leave and half days
Paid days for salary
Overtime hours

How to use it

Add employee names and shifts.
Pick a code for each day from the drop-down list.
Enter overtime hours. Totals and paid days update automatically.

Download the Excel file

Mera Udyog

Mark attendance on a phone, not a sheet

Mera Udyog records attendance by shift across every plant and feeds it straight into salary, overtime included. See how

Questions

Good to know

How are paid days counted in this sheet?

Paid days = present days + leave + half days counted as 0.5 + weekly offs + holidays. Change the formula if your leave rules differ.

Can I track multiple shifts?

Yes. There’s a shift column for every employee. For many shifts and plants, Mera Udyog handles this automatically.

Does it include overtime?

Yes. Enter overtime hours for each employee. Use our overtime calculator to work out OT pay.

Done with paperwork?

Mera Udyog handles attendance, salary, quotations, invoices and HR records for you. Try it free for 7 days.

Book a Free Demo Start 7-Day Free Trial

7-day free trial · No credit card needed