Attendance Sheet Format in Excel 2026 — Free Monthly Download | AttendancePay Attendance Sheet Format in Excel 2026 — Free Monthly Download | AttendancePay
Skip to main content

Attendance Sheet Format (Excel) — Free Monthly Template

Choose the month, weekly offs and number of employees. Download a ready-to-use Excel muster roll with dropdown codes and automatic Paid Days, or print a blank sheet.

Sheet settings

Weekly off
Weekly-off days are shaded and pre-filled with WO.
Download Excel (.xlsx)

The Excel file has formulas for Present, Half Day, Absent, Leave, Week Off, Holiday and Paid Days, a dropdown on every day cell, frozen headers and landscape print setup. Nothing you type here is stored.

Company name: ____________________

Attendance Register — November 2026

Days: 30 · Weekly off: Sunday (5 days) · Department / Site: __________ · Prepared by: __________

SrEmployee NameEmp IDDesignation123456789101112131415161718192021222324252627282930PHDALWOHPaid Days
SuMoTuWeThFrSaSuMoTuWeThFrSaSuMoTuWeThFrSaSuMoTuWeThFrSaSuMo
1WOWOWOWOWO
2WOWOWOWOWO
3WOWOWOWOWO
4WOWOWOWOWO
5WOWOWOWOWO
6WOWOWOWOWO
7WOWOWOWOWO
8WOWOWOWOWO
9WOWOWOWOWO
10WOWOWOWOWO
11WOWOWOWOWO
12WOWOWOWOWO
13WOWOWOWOWO
14WOWOWOWOWO
15WOWOWOWOWO
16WOWOWOWOWO
17WOWOWOWOWO
18WOWOWOWOWO
19WOWOWOWOWO
20WOWOWOWOWO

Legend: P = Present · A = Absent / unpaid leave · HD = Half day · L = Paid leave · WO = Weekly off · H = Paid holiday · Paid Days = P + 0.5 × HD + L + WO + H

Prepared by (HR): ____________________    Verified by: ____________________    Date: __________

How to keep a monthly attendance register in India

An attendance register — also called a muster roll or attendance sheet — is the record of who worked on which day of the month. It is the starting point for payroll: every rupee of salary, overtime, leave encashment and loss-of-pay deduction is worked out from it. Labour inspectors, auditors and PF/ESI officials also ask for it, so it needs to be complete, consistent and kept for the period your state's rules require.

What the format above includes

  • Employee details — serial number, name, employee ID and designation, one employee per row.
  • One column per day of the selected month, with the weekday under each date so the week rhythm is visible.
  • Weekly offs shaded and pre-filled with WO. Pick any combination — Sunday only, Saturday + Sunday, or a Friday off.
  • Standard codes: P (present), A (absent), HD (half day), L (paid leave), WO (weekly off) and H (paid holiday). In the Excel file each day cell has a dropdown, so nobody types "Pr" or "Absnt" and breaks the totals.
  • Automatic totals — Present, Half Day, Absent, Leave, Week Off, Holiday and Paid Days per employee, plus a column total at the bottom.
  • Sign-off line for the person who prepared the sheet and the person who verified it.

How Paid Days is calculated

The template uses Paid Days = P + 0.5 × HD + L + WO + H. A half day counts as half a paid day, approved paid leave and paid holidays count in full, and weekly offs are paid because a monthly salary already covers them. Absent days are not paid. To work out salary, divide the monthly gross by the number of days in the month (or by a fixed 26 or 30 if that is your policy) and multiply by Paid Days. You can check the result with our LOP calculator.

Step by step

  1. Download the sheet for the month at the start of the month and add every employee — including those who join mid-month.
  2. Mark national and festival holidays as H across all rows on day one, so they are not forgotten later.
  3. Mark attendance daily, not from memory at month end. For late arrivals, follow your policy — for example a half day after a set number of late marks.
  4. Enter approved leave as L. Unpaid leave or loss of pay is A, so it does not count as a paid day.
  5. At month end, check Paid Days against leave approvals, get the sheet verified and signed, and send it to payroll.

India-specific points to keep in mind

  • Most establishments must maintain a register of attendance in the form prescribed by the labour laws and state Shops and Establishments rules that apply to them. Registers can generally be kept electronically. Check your state's prescribed form and retention period.
  • For daily-wage or contract workers paid only for days worked, weekly offs may not be paid — remove WO from the Paid Days formula if that matches your wage terms.
  • Overtime hours are recorded separately from presence; use a separate column or our overtime calculator.
  • Keep holiday lists aligned with your state's notified festival holidays and any national holidays your establishment must observe.

Common mistakes

  • Filling the sheet at month end from memory — the most common source of salary disputes.
  • Mixing codes such as "CL", "SL" and "L" without updating the formulas, so leave silently drops out of Paid Days.
  • Marking unpaid leave as L, which overpays the employee.
  • No record of late arrivals, leaving no basis for a warning letter for late coming later.
  • No sign-off — an unsigned register is weak evidence if an inspector or employee questions it.

The paper version of what AttendancePay does automatically

This sheet is exactly the format AttendancePay produces on its own. Employees punch in with GPS, selfie, face recognition or a biometric device; leaves, holidays and weekly offs are applied automatically; and the product's Attendance Register report exports this day-wise muster to Excel from real punches, ready for payroll — no manual marking, no formula errors.

Frequently asked questions

What is the format of an attendance sheet?⌄

A monthly attendance sheet (muster roll) has one row per employee — serial number, name, employee ID and designation — and one column per day of the month. Each day is marked with a code such as P (present), A (absent), HD (half day), L (paid leave), WO (weekly off) and H (holiday), and the last columns total each code and the paid days for payroll.

How are paid days calculated from an attendance sheet?⌄

In this template, Paid Days = Present + 0.5 × Half Days + Paid Leave + Weekly Offs + Paid Holidays. Absent days and unpaid leave are not paid. Monthly salary is then usually divided by the days in the month (or a fixed 26/30 if your policy says so) and multiplied by paid days.

Should weekly offs be counted as paid days?⌄

For monthly-salaried employees, weekly offs are normally paid — the monthly salary already covers them — so the template counts WO as a paid day. For daily-wage workers paid only for days worked, remove WO from the Paid Days formula or follow your wage agreement.

How do I mark unpaid leave in the sheet?⌄

Use A (absent) for unpaid leave or loss of pay, and L only for approved paid leave such as casual, sick or earned leave. That keeps the Paid Days total correct without changing any formulas.

Is a manual attendance register legally required in India?⌄

Most establishments must keep a register or muster roll of attendance under the labour laws and state Shops and Establishments rules that apply to them, in the form those rules prescribe, and keep it for the period they specify. The register can usually be kept electronically. Check the form and retention period for your state and type of establishment.

Stop filling attendance sheets by hand

AttendancePay records attendance from GPS, face and biometric punches, applies leave, holidays and weekly offs, and exports this exact register — then runs payroll from it.

Disclaimer: These templates are general formats for Indian workplaces, provided for convenience. They are not legal advice. Leave rules, attendance registers and disciplinary procedures depend on your company policy, standing orders and the labour laws and state rules that apply to you — have HR or a legal advisor review a letter before issuing it.