Attendance Sheet India: Excel Template + Faster Alternative (2026)

An attendance sheet is a table that records who was at work each day of the month. Indian businesses use it for payroll, leave tracking, and disputes. A workable monthly attendance sheet has one row per employee, one column per day, and cells marked P (present), A (absent), L (late), or LV (on leave). Below is a clean template your team can copy into Excel or Google Sheets today, and the point at which a sheet starts to cost more time than it saves.

What belongs on a monthly attendance sheet

A good attendance sheet answers four questions without a calculator:

1. Who showed up which day of the month
2. Who arrived late
3. Who was on approved leave vs unapproved absence
4. How many total working days each person attended

That means your sheet needs these columns:

Column	Purpose	Example
Employee Code	Short internal ID	EMP001
Name	Full name	Priya Reddy
Department	Team or function	Sales
Day 1 to Day 31	One column per calendar day	P / A / L / LV / H
Total Present	Auto-sum of P + L cells	24
Total Absent	Auto-sum of A cells	2
Total Leave	Auto-sum of LV cells	1
Working Days	Month working days minus holidays	26
Attendance %	Total Present / Working Days	92%

Shaded weekends, company holidays in a different colour, and a legend at the top telling readers what each single-letter code means. That is 90% of every Indian SMB attendance sheet in one format.

Copy-paste template for Excel or Google Sheets

Paste this header row into row 1 of a blank sheet. Add one row per employee below it.

Emp Code | Name | Department | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Present | Absent | Leave | Work Days | Attendance %

For the summary formulas, assuming employee data starts at row 2 and day columns are D to AH:

• Present (AI2): =COUNTIF(D2:AH2,"P")+COUNTIF(D2:AH2,"L")
• Absent (AJ2): =COUNTIF(D2:AH2,"A")
• Leave (AK2): =COUNTIF(D2:AH2,"LV")
• Work Days (AL2): Count of working days in the month minus holidays
• Attendance % (AM2): =AI2/AL2

Legend codes to put at the top of the sheet:

• P = Present
• L = Late (counts as present, flagged for review)
• A = Absent
• LV = Leave (approved)
• H = Holiday
• W = Weekly off

Format the weekend columns with a grey background. Format the holiday columns with a light red background. Format rows with Attendance % below 85% in red so late cases jump out.

How Indian businesses actually fill the sheet

Three patterns are common:

1. Owner marks the sheet from memory at end of day. Works for a 5-person shop. Breaks at 15 people.
2. A manager collects entries from a paper register and types them in every morning. Takes 30-45 minutes daily. Late entries get missed.
3. Each employee fills their own row at the end of their shift. Faster, but encourages buddy punching (one person filling for another).

All three depend on someone remembering to update the sheet. The first time an owner goes on leave or a manager quits, a week of data disappears.

Where a simple attendance sheet stops scaling

For 5-8 employees in one location, a monthly attendance sheet works. The problems start when any of these are true:

• Two or more locations. Now you maintain one sheet per store or site. Combining them for payroll takes hours.
• Field staff or delivery teams. You have no way to verify they actually reached the client site. The sheet trusts whatever they typed.
• Shift work or multiple check-ins per day. A single P/A/L code cannot represent a lunch break or a second shift.
• Salary disputes. Someone says they came 27 days, the sheet shows 24. You cannot prove either number. Without a GPS stamp or a timestamped photo, the argument drags into next month.
• CA asks for attendance data every month. Now you are also formatting the sheet for export, removing staff who exited, and renaming columns.
• Someone forgot to update the sheet for a week. Reconstruction from memory is unreliable. Backfill errors show up six months later in an audit.

If you run more than one location or have more than 15 employees, the sheet is no longer the tool. It is a bottleneck.

What replaces a sheet for Indian SMBs

The modern alternative is an attendance app where employees check in from their own phone with GPS verification and an optional selfie. The same data that took a manager 30 minutes a day to type is captured in 3 seconds by the employee. At month end, the app already has every check-in, every late mark, and every leave day; you export it to Excel with one click.

Specifically, an app solves the five problems above like this:

• Two or more locations. One dashboard, every site in one view.
• Field staff. GPS coordinates on every check-in. A photo if you turn selfie on.
• Multiple check-ins per day. Session tracking, with break time separated from work time.
• Salary disputes. Every entry has a timestamp and a location. Evidence, not memory.
• CA export. One click to Excel or CSV with the exact columns above, pre-formatted.

Attendance sheet vs attendance app: the honest comparison

Feature	Excel/Google Sheets attendance sheet	Attendance app
Cost	Free	Free for 10 employees, ₹299/emp/year after
Who updates it	Someone, every day	The employee, at check-in
GPS verification	No	Yes, built in
Selfie photo on check-in	No	Yes, optional
Multi-location	Separate sheet per site	Single dashboard, unlimited sites
Late / half-day rules	Manual, per-cell	Configurable shift rules, auto-applied
Leave balance tracking	Separate sheet	Built-in, auto-computed
Month-end reporting	1-3 hours	One click, 30 seconds
Disputes	Your word vs theirs	Timestamped GPS + photo
Payroll export	The sheet itself	CSV with company name, dates, hours, status

You can still get an Excel export

This is the part founders miss: moving off a sheet does not mean giving up Excel. AttendFirst produces a monthly attendance report with the same columns as the template above, plus a couple that a sheet cannot compute (total work hours, break hours, late minutes). You export it as a CSV that Excel on Windows opens correctly for Indian names. Your CA gets the same file shape they are used to, with zero typing from your side.

If you still want to use a sheet, here is how to do it well

If you are at 5 employees in one location, Excel is probably fine for another year. Make it less painful:

• Keep a separate tab per month. Do not scroll 6 months sideways.
• Put the holiday list on a second sheet. Reference it for the H cells with VLOOKUP.
• Use data validation on the day columns so only P, A, L, LV, H, W are accepted.
• Freeze the first three columns so names are always visible while you scroll days.
• Save the master sheet on Google Drive, not one person’s laptop.
• Decide now, in writing, who updates the sheet and when. “We will figure it out” is how weeks go missing.

Quick answer: when should you move off the sheet

• Staying on Excel: 1-8 employees, one location, no field work, CA is happy.
• Move to an app: 10+ employees, any second location, any field staff, or a single salary dispute in the last quarter.

You do not need to throw the sheet away the day you sign up. Run both for a month. If the app does not save you time or prevent one dispute, cancel and keep the sheet. If it does either, stop typing cells at 10 PM.

Try AttendFirst free

AttendFirst is free forever for the first 10 employees and includes GPS, selfie, QR check-in, leave management, Indian holidays pre-loaded, and a monthly attendance report that exports to Excel. No credit card, no app install for your team. Most SMBs are live in under 10 minutes.

Start free at attendfirst.com or read the attendance register app comparison for a closer look at what changes when you drop the paper book.