Skip to content
By invitationRequest an inviteRequest an invite
Request an invite
Request an invite

Free template · Excel · updated 30 Sep 2026

Monthly attendance sheet format where the days add up.

A monthly attendance sheet in Excel: a dropdown for every day, a late flag, holidays marked, and formulas for loss of pay and payable days. Filled here with September 2026 at Paiteq. On every row, payable days plus LOP make the 30 days of the month.

Download Excel (.xlsx)Request an invite

attendance-sheet-template · filled example

Attendance · September 2026

Paiteq Technologies · Bengaluru · 30 days · 21 working days

Month
Sep
Year
2026
Company
Paiteq Technologies

StatusPPresentAAbsent, unpaidHDHalf dayLPaid leaveWOWeekly offHHoliday

No.Name1Tu2We3Th4Fr5Sa6Su7Mo8Tu9We10Th11Fr12Sa13Su14Mo415Tu16We17Th18Fr19Sa20Su21Mo22Tu23We24Th25Fr26Sa27Su28Mo29Tu30WePresentHalf daysLateLOPA + 0.5 × HD1PayableP + 0.5×HD + L + WO + H2CheckPayable + LOP3
01Meenal JoshiPPPPWOWOPPPPPWOWOHPPPPWOWOPPPPPWOWOPPP210003030
Late?
02Asha RaoPPPPWOWOPPPLLWOWOHPPPPWOWOPPPPPWOWOPPP190003030
Late?
03Vikram Nair7PPPPWOWOPPPPPWOWOHPPPPWOWOPPPPPWOWOPPP210203030
Late?YY
04Rohan Das5PPPPWOWOPPPPPWOWOHPHDPPWOWOPPPPPWOWOPHDP192012930
Late?
05Priya MenonPPPPWOWOPPPPPWOWOHPPPPWOWOPPPPPWOWOPLL190003030
Late?
06Karthik IyerPPPPWOWOPPPPPWOWOHPPPPWOWOPA6PPPWOWOPPP200012930
Late?
Team119222178180
  1. 1because a full unpaid absence is a whole day of loss of pay and a half day is half of one: LOP = A + 0.5 × HD.
  2. 2because paid leave, weekly offs and holidays are paid days without a punch, and a half day pays half.
  3. 3because every day is either paid or loss of pay, so the two make 30. A smaller number means a day was left unmarked.
  4. 4because Mon 14 Sep, Ganesh Chaturthi, is a Karnataka holiday for the Bengaluru team, so it is H on every row.
  5. 5because Rohan's half days on 16 Sep and 29 Sep make 1 day of LOP in the calendar month. Payroll reads 26 Aug – 25 Sep, so only the 16 Sep half day reaches September pay.
  6. 6because Karthik took Tue 22 Sep without pay, so it is marked A: one day of LOP.
  7. 7because a late mark is a flag on a present day, so Vikram's two late days stay P and are counted on the Late? row.
Design preview · sample data · Paiteq Technologies · as at the close of Wed 30 Sep 2026

because a sheet you can check in one line (payable plus LOP equals the days in the month) is a sheet payroll can trust.

No. 01

How to use it

because a dropdown cannot be mistyped, and a formula cannot miscount.

Three cells to set, then one status a day.

The .xlsx has one sheet for fifteen people. Copy the sheet for each month, or change the month and year cells and clear the grid.

  1. 1

    Set the month

    Pick the month, type the year and the company name. The day numbers and weekday labels follow, and short months hide the days they do not have.

  2. 2

    Mark the company calendar

    On the company calendar row, mark weekly offs WO and holidays H from your state and company holiday list. Copy the same marks onto each person's row.

  3. 3

    Mark each day

    P, A, HD or L for every working day. Leave without pay is A. A late arrival stays P, with Y on the Late? row under it.

  4. 4

    Read the summary, then check it

    Present, half days, late marks, LOP and payable days count themselves. The check column must equal the days in the month; if it is lower, a day is blank.

No. 02

Column by column

because each column answers one question payroll will ask.

What each part of the sheet counts.

Status dropdown
Every day cell accepts only P, A, HD, L, WO or H. A stray word cannot break the counts.
Late? row
A Y/N row under each person. Late is a flag on a present day, not a seventh status.
Company calendar row
Weekly offs and holidays for the whole team. The working-days figure at the top comes from it.
Present and half days
Counts of P and HD. A half day is counted on its own, never as an absence.
LOP days
=COUNTIF(A) + 0.5 × COUNTIF(HD). The one column that turns attendance into loss of pay.
Payable days
P + 0.5 × HD + L + WO + H. Paid leave, weekly offs and holidays are paid. For daily-rated staff, whether a weekly off is paid depends on state law, so mark it A if yours is unpaid.
Check
Payable plus LOP. It equals the days in the month when every day is marked.
Holiday table
Date and name, below the grid. It ships empty: holidays differ by state and by company, and a list without a source would only mislead.

No. 03

The law behind it

because the sheet is the evidence behind a deduction.

How is loss of pay deducted from salary?

The deduction may not exceed the share of the month's wages that the days absent bear to the days the employee was required to work that month. That is the Code on Wages, 2019, s.20, in force since 21 Nov 2025. This template counts calendar days; a fixed 26-day divisor can over-deduct in a month with 27 working days.

A deduction for absence is capped: days absent ÷ days required to work
from 21 Nov 2025

Code on Wages, 2019, s.20 (deductions for absence from duty); earlier under the Payment of Wages Act, 1936 (repealed)

Paid days and deductions shown on a wage slip
from 21 Nov 2025

Code on Wages, 2019, s.50 and the Central Rules (notified 8 May 2026)

Holidays within annual leave, or prefixed or suffixed to it, are not counted as leave
from 21 Nov 2025

OSH Code, 2020, s.32, for the workers it covers

Holidays, casual and sick leave
set by each state

OSH Code, 2020, s.32 and each state's Shops & Establishments Act and rules

Code on Wages, 2019 and OSH Code, 2020, in force 21 Nov 2025 · checked by the LekhaHR team, 30 Sep 2026

No. 04

Common mistakes

because each of these shows up as a paid-days argument on payday.

Five ways an attendance sheet stops adding up.

  1. LOP that ignores half days

    Counting only A as loss of pay drops half of every half day. Payable plus LOP then falls short of the month. LOP is A + 0.5 × HD.

  2. Holidays left blank

    A blank holiday reads as a missing day. Mark it H, on every row.

  3. Unpaid leave marked L

    L is paid. Leave without pay is A, or it is paid by mistake.

  4. Late marks as pay cuts

    A late mark is a flag. Deducting for it needs a policy, and a deduction for absence is capped by the days actually absent.

  5. Two months mixed

    The sheet counts the calendar month. If payroll reads a cutoff window, days after the cutoff belong to next month's run.

No. 05

In LekhaHR

because a day status with its reason attached needs no second sheet to explain it.

Every day decides itself, and says why.

LekhaHR reads punches, shifts, leave and holidays and writes each day's status with its reason. Regularisations have a cutoff, the month locks before payroll reads it, and paid days arrive in the run already explained.

Request an inviteRead about attendance

Rohan Das · 16 Sep

Paiteq · day status

Status
Half day

because no regularisation filed before the regularisation cutoff on 20 Sep

September LOP
0.5 day

because payroll reads 26 Aug – 25 Sep

Design preview · sample data

No. 06

Questions

Statutory answers carry the date the rule took effect.

What people ask about attendance sheets.

How do I make a monthly attendance sheet format in Excel?

Download the template, set the month, year and company name at the top, and mark weekly offs and holidays on the company calendar row. Then pick a status for each person and day from the dropdown: P, A, HD, L, WO or H. The summary columns count themselves.

What is LOP in salary?

LOP, or loss of pay, is the pay deducted for days an employee was absent without paid leave. Under the Code on Wages, 2019, s.20 (in force 21 Nov 2025), the deduction may not exceed the share of the month's wages that the days absent bear to the days the employee was required to work in that wage period.

How is LOP calculated?

LOP days = A + 0.5 × HD; in the file, =COUNTIF(days,"A")+0.5*COUNTIF(days,"HD"). These templates divide by calendar days: pay = monthly rate × paid days ÷ days in the month. Whatever divisor you use, the deduction may not exceed wages × days absent ÷ days required to work, so a fixed 26-day divisor can over-deduct in a 27-working-day month.

How should holidays be marked?

Mark the holiday H on the company calendar row and on every person's row, as Mon 14 Sep (Ganesh Chaturthi) is marked here. A holiday is a paid day. The list of holidays comes from your state and your own policy, so the file ships the holiday table empty for you to fill.

Are weekly offs paid for daily-rated staff?

It depends on the state. The sheet counts WO as a payable day, which is right for monthly-paid staff. For daily-rated workers, whether the weekly off is paid is set by state law, so check your state's rules and mark an unpaid weekly off A.

Does a late mark cut pay?

Not on this sheet. Late marks are counted on their own Late? row and never change the day's status. Under the Code on Wages, 2019, s.20 (in force 21 Nov 2025), a deduction for absence is capped by the days actually absent out of the days required to work, so turning late marks into pay cuts needs care.

Is the template free, and does it calculate salary?

It is a free .xlsx download, with no email and no account. It counts days: present, half days, late marks, LOP and payable days. It does not calculate pay; paid days and LOP days go into the salary slip template.

About Paiteq's September sheet

Calendar month or payroll cutoff?

The sheet counts the calendar month. Many payrolls read a window instead: Paiteq's September salary reads 26 Aug – 25 Sep. That is why Rohan's sheet shows 1 day of LOP for September while his September slip carries 0.5: his 29 Sep half day falls after the cutoff and is read in October's run.

Code on Wages, 2019 and OSH Code, 2020, in force 21 Nov 2025 · checked by the LekhaHR team, 30 Sep 2026