Attendance Register Format: Free Excel, PDF, State Rules

Attendance Register Format: Free Excel, PDF, State Rules

Payal SharmaUpdated: 6 min read
PS
Payal Sharma
Product Lead, AttendFirst

Payal focuses on leave management and compliance workflows for Indian businesses.

TL;DR: An employee attendance register is the dated record of who worked on which day that an Indian employer keeps for inspection. The state Shops and Establishments Act sets the form, and the 2025 labour codes did not replace it. Download a generic register below as Excel or PDF, then check the form name your state uses.

This page is for employers: a shop, an office, a clinic, a small factory, or a restaurant that has to keep a register and show it when an inspector asks. It does not cover school attendance registers. It is also not legal advice, so confirm the form for your state with your state labour department before you use it.

Download: free attendance register template

Template Best for Download
Attendance register (Excel) Typing marks on a computer, totals calculate on their own Download .xlsx
Attendance register (PDF) Printing, A4 landscape, 18 employees a page Download .pdf

You do not need to give an email address. The Excel file counts P, A, HD, L, WO, and PH marks into the totals columns for you. The layout is generic, so if your state prescribes a named form, copy the same data into it. If you would rather not keep a register by hand, start your team’s record and let phone check-ins fill it in.

What columns does an attendance register have?

An attendance register has a header for the establishment, one row for each employee, one column for each day of the month, monthly totals, and a signature block. Each column holds the following.

Column What goes in it
Header Name and address of the establishment, nature of business, registration number and Act, employer or manager, month and year
Sl No, employee code Serial number and the code you use for payroll
Name, designation Full name as on the ID, and the role
Weekly off The day the employee is off each week
Days 1 to 31 One mark per day: P, A, HD (half day), L (leave), WO (weekly off), PH (public holiday)
Totals Present, half days, absent, leave, weekly offs and holidays, days payable
Remarks Late arrival, overtime, or a note on a correction
Signature block Prepared by, and checked by the employer or manager, with the date

Mark each day on that day. An inspector checks whether entries were made when the work happened, and a week of marks written in on Friday shows they were not.

Which law requires an attendance register?

For a shop, office, clinic, or restaurant, your state’s Shops and Establishments Act and the rules under it require the register. The Act sets the duty to keep registers, and the rules name the form.

The four labour codes came into force on 21 November 2025 and repealed 29 central laws. They did not repeal the state Shops and Establishments Acts, so your state register duty is unchanged. If you are a factory or use contract labour, read attendance registers under the labour codes for what moved.

Attendance register form by state

The table lists the Act and, where the rules name one, the prescribed register for eight states.

State Act Register and form named in the rules
Karnataka Karnataka Shops and Commercial Establishments Act, 1961 Combined Muster Roll-cum-Register of Wages in Form T (Rule 24(9-B) of the 1963 Rules)
Maharashtra Maharashtra Shops and Establishments (Regulation of Employment and Conditions of Service) Act, 2017 Muster-Roll cum Wages Register in Form Q (Rule 26 of the 2018 Rules). Entries may be authenticated digitally or manually, in Marathi or English
Tamil Nadu Tamil Nadu Shops and Establishments Act, 1947 Register of Employment in Form V, plus Forms U, W, and X (Rule 16(1) of the 1948 Rules, as amended in 2022). May be kept electronically or manually
Delhi Delhi Shops and Establishments Act, 1954 Register of employment and wages in Form G (Rule 14(1) of the 1954 Rules). Bound, with numbered pages
Gujarat Gujarat Shops and Establishments (Regulation of Employment and Conditions of Service) Act, 2019 Check your state’s rules
Telangana Telangana Shops and Establishments Act, 1988 Check your state’s rules
Uttar Pradesh Uttar Pradesh Dookan Aur Vanijya Adhishthan Adhiniyam, 1962 Check your state’s rules
West Bengal West Bengal Shops and Establishments Act, 1963 Check your state’s rules

Karnataka and Maharashtra combine attendance and wages: the prescribed form is a muster roll and a wage register in one. If you already keep a muster roll, it may already satisfy the rule.

Tamil Nadu’s 2022 amendment replaced the older Forms P and Q with Forms U, V, W, and X. A page that still tells you to use Tamil Nadu Form Q is out of date.

Delhi’s Rule 14 requires a bound register with serially numbered pages, entries made the same day, and registers kept to the end of the following year. A loose printout may not meet it. Rule 14A lets the government approve your own register if it carries the particulars of Forms G, H, or I.

Attendance register vs muster roll vs monthly sheet

An attendance register covers every employee and carries the establishment’s registration details. A muster roll covers workers paid by days worked. A monthly attendance sheet is a payroll summary with no legal form behind it.

Attendance register Muster roll Monthly attendance sheet
Built for All staff of an establishment Workers paid by days worked Salaried staff
Header Establishment, registration, employer Site, contractor, nature of work Company and month
Totals Present, absent, leave, days payable Total days worked Present, absent, leave
Signature Employer or manager Worker or thumb impression Optional
Use it when A state Act asks for a register Site or contract labour Month-end payroll input

If your workers are paid per day, use the muster roll format. If you need a month-end summary for payroll, the attendance sheet in Excel is the lighter record. Many businesses keep the register for the inspector and the sheet for payroll. To count present days, half days, and loss of pay in that sheet, use the attendance formulas for Excel.

Can the attendance register be electronic?

Yes, in several states. Maharashtra lets you authenticate entries digitally or manually. Tamil Nadu says the registers may be maintained electronically or manually. Delhi lets the government deem your own register valid if it has the particulars of the prescribed form. The labour codes also provide for electronic records.

In any format, the record must identify each employee, show presence day by day, be made when the work happened, and be available when an inspector asks. A spreadsheet or an app that meets those conditions works as a register. If your state names a form, keep the data in a layout you can copy into it.

When is a register book enough?

A register book is a reasonable choice when:

  • You have one location, a small team, and a supervisor who marks it every day.
  • Your state, like Delhi, calls for a bound book.
  • Your staff do not have smartphones or reliable mobile data.

The book runs into trouble once the business grows. It sits at one site, so a second branch needs a second book. Someone fills in Thursday’s marks on Friday. Leave is agreed in a WhatsApp thread, so the “L” marks are guesses. And counting the month’s totals takes someone an afternoon.

Move the attendance register to phone check-ins

A digital check-in record holds the same information as the register book, plus a timestamp for every entry. In AttendFirst, employees check in by GPS, selfie, or QR code. Each check-in is stored with the time and location, and the daily and monthly reports are built from those check-ins. Leave is part of the same record, so an approved day off shows as leave instead of a blank.

For the inspector, an admin exports attendance for any date range as a CSV file that opens in Excel. Days with no check-in appear as absent rows. The export is a record of presence by date, not a copy of Form T, Form Q, Form V, or Form G. If your state names a form, copy the figures across. The attendance register app guide covers the switch itself, and attendance and leave in one record covers what that changes at month end.

Teams of 4 to 10 pay a flat ₹3,000/year, ₹499/employee/year beyond that, and up to 3 employees costs nothing. No payment required to start.

Start your team’s record

Check your state’s form before you print

States revise their rules and rename forms. Before you print a new register, confirm the current form with your state labour department.

Frequently asked questions

What is the format of an attendance register?

An attendance register has an establishment header (name, address, registration number, month, and year), then one row per employee with serial number, employee code, name, and designation. Next come one column for each day of the month, marked P for present or A for absent, and then monthly totals for present, absent, leave, and days payable. A signature line for the employer or manager closes the page. The downloadable template on this page follows that layout.

Which law requires an attendance register in India?

For most shops, offices, clinics, and restaurants, the state Shops and Establishments Act and its rules require it. Each state has its own Act and its own form names. Factories and sites that use contract labour read the duty from the Occupational Safety, Health and Working Conditions Code, 2020, which replaced the Factories Act 1948 and the Contract Labour Act 1970 on 21 November 2025. This page is not legal advice, so confirm the form name with your state labour department.

Do the 2025 labour codes replace the Shops and Establishments Act?

No. The four labour codes consolidated central laws. A state Shops and Establishments Act is state legislation and still applies as before, including its register requirements. Some states are revising their rules, so check your state labour department for the current form before you print a new register.

What is the difference between an attendance register and a muster roll?

A muster roll is the monthly grid for workers paid by days worked, usually with a total that feeds wages. An attendance register is the employer's record of attendance for all staff, with an establishment header and a signature block. In some states, such as Karnataka and Maharashtra, the prescribed register combines the muster roll with the wage register in one form.

Can I keep the attendance register electronically?

Several states allow it. Maharashtra's 2018 Rules let the employer authenticate entries digitally or manually. Tamil Nadu's Rule 16(1) says its employment registers may be maintained electronically or manually. Delhi allows the government to deem an employer's own register valid if it carries the particulars of the prescribed form. Whatever the format, it must show each employee, each day, and be producible at inspection.

How long do I keep attendance registers?

It depends on the state rules. Delhi's Rule 14 says the registers for a calendar year are kept until the end of the following year. Many employers keep three years of records because wage disputes and inspections often look back that far. Check the retention rule in your state's rules.

Share:WhatsAppLinkedIn

Get attendance tips for Indian businesses

One practical guide per week. No spam.

Put attendance and leave in one record

Indian holidays and weekly offs come already loaded. Setup takes 5 minutes, and no payment is required to start.

Attendance + leave, one record

Every feature, every plan