Guide
A practical attendance record for classes and private lessons, with a free CSV you can start using today.
A student attendance tracker is one record that shows who attended each class or lesson, when it happened, and how the session affects a package or plan. Mark each session immediately using consistent statuses such as present, absent, excused, or make-up. Use the free CSV below, or keep the same record in Coach Journal from your phone.
Written by Sardorbek Rakhimov, founder and developer of Coach Journal
Download a blank CSV you can open in Excel, Google Sheets, or Numbers. It gives each attendance record one row and keeps package and payment context beside the attendance status. Illustrative example: after Maya attends a maths lesson on 12 September, record Present and change her 10-session package balance from 8 to 7; a cancelled lesson is not attendance, so only record a charge if your written cancellation policy says it is charged.
| Field | What to record |
|---|---|
| Date | The date the class or lesson happened. |
| Student | The student or client name. |
| Class or Session | The group, class, or lesson name. |
| Attendance Status | Present, Absent, Excused, or Make-up. |
| Package or Plan | The package, pass, or plan tied to the session. |
| Sessions Remaining | The balance after the session, when applicable. |
| Payment Status | Paid, Due Soon, or Overdue. |
| Notes | A short factual note about the session. |
Attendance breaks down when the student list itself is scattered across group chats, notebooks, and memory. Maintain one list of currently active students, and update it when someone joins, pauses, or leaves.
The reliable moment to mark attendance is the two minutes after class ends, while faces are fresh. Attendance reconstructed at the end of the week is guesswork, and guesswork compounds when parents or students dispute a count.
Decide on a small set of statuses — present, absent, excused, make-up — and use them the same way every time. Consistency is what makes the record usable later, when you need to count sessions used against a package.
Each attended session should count against something: a monthly plan, a 10-session package, or a per-lesson rate. When attendance and packages live in the same record, the question of who owes what answers itself.
A weekly scan of attendance shows problems while they are still small: a student who quietly stopped coming, a group that is shrinking, a make-up backlog building up. Irregular attendance is usually the first sign of churn.
Parents ask how many lessons their child attended. Students dispute how many sessions remain. An attendance record with dates settles the conversation in seconds — keep it in a form you can pull up or export on the spot.
Coach Journal turns this into a tap-per-student habit. Your roster lives in the app, attendance is marked right after class from your phone, and every attended session is automatically part of that student's history.
Because attendance, packages, and renewal status share one profile, you can see at a glance which students are low on sessions or overdue for a renewal — no cross-referencing sheets.
Attendance history and student records export whenever a parent, gym, or your own bookkeeping needs them.
Record the session date, student, class or lesson, attendance status, package or plan, sessions remaining when relevant, payment status, and a short note. Keeping these fields together makes the attendance record useful for renewals and parent questions, not just a list of names.
Mark it immediately after each lesson in one consistent place. For a handful of students, paper or a spreadsheet works; for recurring lessons with packages and make-ups, an app that links attendance to each student's package keeps the count accurate.
Yes. The same system works for both: one roster, consistent statuses, marked right after the session. Coach Journal handles individual lessons, small groups, and class-style attendance in the same student profiles.
Track the missed session with its own status (absent or excused) and log the make-up as a session when it happens. What matters is that the total sessions used stays accurate against the student's package or plan.
Coach Journal tracks clients, sessions, renewals, and payments so you do not have to. Free to start on iPhone and iPad.