Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

LeadAfrik
← TemplatesSchools & churches

Free Class Attendance Register (Excel) — daily P/A/L, counts and percentages

Marking a register by hand tells you who came today, but not who is quietly slipping away. This free register fixes that. Type your class list once, then mark every learner P, A or L each day from a dropdown, and the register works out each learner's attendance percentage, a whole-class monthly summary and an absentee report that flags anyone below your threshold in red.

Download — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • Enter the class list once; names flow through to the whole workbook
  • Daily P/A/L grid with a dropdown in every cell, learners down and days across
  • Per-learner Present, Absent, Late, days marked and attendance percentage
  • Monthly summary: enrolment, marks, average attendance and overall rate
  • Absentee report that flags anyone below your threshold in red
  • Formulas locked; only the yellow cells accept typing; works on a phone

The tabs

  • Start Here (guide)
  • Class List
  • Attendance
  • Monthly Summary
  • Absentee Report

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • An attendance dashboard with a present-percentage bar for every learner
  • A per-day analysis showing which days had the most absences, drawn as bars
  • A printable monthly register (A4) you can file, sign or hand in
  • Kiswahili labels alongside English (Yupo, Hayupo, Amechelewa)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On the Class List tab, type your school, class and each learner's name once. On the Attendance tab, pick the month and mark each day P (present), A (absent) or L (late) from the dropdown in every cell. The Present, Absent, Late and Present percentage columns update on their own, so a full month of marks becomes a set of numbers you can act on.

The Monthly Summary counts enrolment, present and absent marks, average attendance and the overall rate for the class, while the Absentee Report lists every learner against a threshold you set (90 percent by default) and flags anyone below it as REVIEW in red. Yellow cells are the only ones you type in; every other cell is a locked formula. It opens in Excel, WPS or Google Sheets on a phone, with no macros.

Do it online instead

Turn your term marks into a printable transcript

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Request a custom template or Excel service →Email info@leadafrik.com

Frequently asked questions

Is the basic version really free?

Yes. Download the basic Class Attendance Register, keep it, and use it term after term at no cost. The premium upgrade, with an attendance dashboard, a per-day analysis and a printable register, is an optional KES 500.

How is the attendance percentage worked out?

For each learner it counts the P and L marks (present, including late) and divides by the total days marked (P plus A plus L). Blank days are ignored, so a learner is never penalised for days the register was not taken.

How does the absentee report work?

Set your threshold on the Absentee Report tab (90 percent by default). Every learner whose attendance falls below it is flagged REVIEW in red, so one glance tells you who to follow up.

Tools & templates you may need

Lesson Planner (CBC-aware) →CBC Grade Tracker →School Fees Management →Church Finance & Membership →Student Report Card Generator →School Inventory Tracker →Student Marks & Gradebook →Exam Analysis Dashboard →Teacher Timetable Generator →Private Tuition Income Tracker →All templates →

Available in English, with Kiswahili labels in the premium version. Need it in another language, or a custom build? Email info@leadafrik.com.