WhatsApp
Pinterest
Student Attendance Register with % and Defaulter List (Excel)
A monthly attendance register for any class: mark each day from a drop-down and see present days, attendance percentage and the students below your minimum, ready for parent notices.
₹84₹399Save ₹315 (79%)
Inclusive of all taxes · One-time payment · Instant download
See a free sample (PDF) Diwali Sale: 25% off, ends 09 Nov, 12:00 AM
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
Class teachers in schoolsCollege faculty tracking the 75% ruleCoaching and tuition centres
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use
Get the whole Mega BundleCareer, Skills & Money Mega Bundle: Resume, Study, AI, Office & Tax Tools · ₹3,549 · you save ₹9,846See →
Frequently bought together
This item: Student Attendance Register with % and Defaulter List (Excel)₹84
School Result & Marksheet Generator: Grades + Rank (Excel)₹149
School Timetable Maker with Teacher Clash Check (Excel)₹149All three: ₹382Sale prices
Class teachers spend the last day of every month counting ticks and working out percentages. This register does it as you mark, and tells you who is falling below the minimum before it is too late.
What it does
- 31 day columns with a drop-down: P present, A absent, L leave, H holiday or Sunday
- Counts present, absent, leave and working days (holidays excluded)
- Attendance % and a status: OK or Defaulter below your minimum (75% by default), in red
- Summary: students, class average, number of defaulters and the eight lowest with a chart
Who it suits
Class teachers in schools, coaching institutes, colleges tracking the 75% rule, and tuition centres that send monthly attendance reports to parents.
What's inside
Everything you get
01
Register
31 days with drop-downs for up to 70 students
02
Attendance %
With a defaulter status
03
Summary
Average, defaulters, lowest eight
04
Blank + sample
Sample month for 25 students
Files in your download
- XLSXStudent_Attendance_Register.xlsx23 KB
- XLSXStudent_Attendance_Register_SAMPLE.xlsx24 KB
How to use
Start in 5 simple steps
A step-by-step guide is also included inside your download.
- 1
Set the minimum %
On Settings
- 2
Add students
Roll and name
- 3
Mark every day
P, A, L or H
- 4
Check red rows
Defaulters
- 5
Inform parents
From the Summary
FAQ
Questions about this product
Do holidays count?
No. H days are left out of working days, so they do not lower the percentage.
Is approved leave counted as present?
In this register, leave counts as a working day but not present. If your school counts approved leave as present, change the Present formula to include L.
Can I keep the whole year?
Make one copy of the sheet per month, or one file per month. The student list stays the same.
Can I change 75%?
Yes. Set Minimum attendance % on Settings.
Does it work on a phone?
Yes, in Google Sheets or the Excel app, which makes marking in class quick.
How do I get the files after payment?
A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.
Can I use it on my phone?
Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.
What if something does not work?
Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.
Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set
Goes well with this
Excel & Sheets
House Help Salary & Attendance Register (Excel): Maid, Cook, Driver, Nanny
Sale₹74₹24970% off
