# Private teacher groups Excel sheet: fees and attendance

> Free Excel sheet for a private teacher with several groups: attendance by session, fees with sibling discount, unpaid reminders and net income per group.

Source: https://softwiro.com/blog/teacher-study-groups-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Study groups sheet for a private teacher: students, attendance and fees (free Excel)

Know who has not paid, which group earns you money after hall and assistant, and who needs follow-up.

15 November 2026 5 min read

## In short

- Each group has its own fee type (monthly or per session), hall rent per session and assistant pay.
- Attendance is one letter per session (ح, غ, ع) in a 12-session grid per student per month.
- Due = the fee or attended sessions × price; the sibling discount applies to the second child onward by parent phone.
- The unpaid list gives each student a ready reminder message built by simple concatenation.
- Net income per group = collected − hall − assistant − the group's expenses, so a losing group shows up.

You are a private teacher with several groups at different places and times, and at the end of each month you want three answers: who has not paid and how much, how much you really earned from each group after hall and assistant, and who needs a follow-up on attendance or marks. The free [study groups management sheet for a private teacher](https://softwiro.com/templates/teacher-study-groups) (the page is in Arabic) answers from things you type: your groups, your students and one row per student per month.

## The problem: the numbers are split between a register, WhatsApp and memory

You take attendance in a notebook, remember who paid from WhatsApp messages, work out siblings from memory, and then find that one group costs more in hall rent than it collects. This sheet is for one teacher. If you are a centre with several teachers, halls and salaries, the [tutoring centre sheet](https://softwiro.com/templates/tutoring-center) fits you better.

## How it works, step by step

1. In الإعدادات (Settings) type any date inside the month you are working on, the sibling discount, and your name so it appears in the reminder message.
2. In المجموعات (Groups) write each group with its grade, days, place and hall rent per session, its fee type «monthly» or «per session» and amount, capacity and assistant pay.
3. In الطلاب (Students) write each student with a code, group and parent phone. Students with the same parent phone are siblings.
4. In الحضور والاشتراكات (Attendance and fees) write one row per student per month: a date inside the month and the code, mark each session ح (present), غ (absent) or ع (excused), and type what was paid and when.
5. In الاختبارات (Quizzes) type the marks, and in التكاليف (Costs) the other expenses.
6. Open المتأخرون (Unpaid) to copy reminder messages, المجموعات for each group's net income, and الملخص (Summary) for the month.

## What each sheet does

- Groups: sessions held in the month = the number of session columns where you marked attendance. Hall cost = sessions × rent and assistant pay = sessions × their rate. Net income = collected − (hall + assistant + the group's expenses).
- Students: the student's order in their family (by parent phone), the sibling discount, total due, paid and balance over all months, attendance rate and average mark, and a warning.
- Attendance and fees: due before discount = the fee (or attended sessions × session price), net = due − sibling discount, balance = net − paid, and a status: paid, partial or not paid.
- Unpaid: the unpaid students of the chosen month, each with a ready message built from the student's name, the month, the balance and your name.
- Quizzes, Costs and Summary: the percentage of each mark, each student's and group's average, the month's figures and the charts.

## A walk-through with the sample numbers

These numbers are sample data inside the sheet, not a real teacher: 4 groups and 15 students, the chosen month is October 2026 and the sibling discount is 10%.

- Due and collected: due 5,460 pounds after 60 of sibling discount, collected 4,430, and 1,030 outstanding from four students: Youssef Hassan 200, Omar Khaled 500, Ziad Essam 150 and Dina Amr 180. The collection rate is about 81%.
- Siblings: Nour Hassan is Youssef Hassan's sister (same parent phone), so her 300 fee becomes 270 after the discount. The same goes for Yasmin Waleed, Karim Waleed's sister.
- Per-session fee: the «Final review» group charges 60 a session, so Dina Amr attended 3 sessions and owes 180, unpaid, while Hossam Reda attended 5 sessions, owes 300 and paid it.
- Net income by group: «Second secondary A» collected 1,400 against costs of 1,320 (hall 800, assistant 400, handouts 120), a net of 80. «Third secondary B» nets 210. «Third prep» meets at the teacher's home with no rent, so it nets 720. «Final review» collected 810 against costs of 1,010 (hall 750, assistant 200, refreshments 60), a net of −200: it loses money.
- The whole month: group costs 3,620 plus 200 of general expenses make total costs 3,820, and the month's net income is 610.
- Attendance and marks: the month's attendance is 85.2% (92 sessions of 108) and the average mark is 77.8% over 38 recorded marks.

## Common mistakes

- Forgetting to mark a session in the attendance sheet, so the month's sessions shrink, hall and assistant costs look lower, and a per-session fee comes out lower.
- Typing the parent phone differently for two siblings, so they are not recognised and no discount applies.
- Spelling a group name in Students differently from Groups, so its fee does not appear.
- Leaving «paid» empty after you collected, so the student shows as unpaid.
- Forgetting to change the chosen month in Settings before reading Unpaid and Summary.

## When to move to a system

The sheet suits a teacher who records for up to a few hundred students personally. If you want messages sent to parents automatically, students or assistants to record attendance from their phones, or parents to see their child's attendance and marks, that is work for a [custom Softwiro program](https://softwiro.com/contact). To track your students' marks with different weights, try the [teacher gradebook](https://softwiro.com/templates/teacher-weighted-gradebook) sheet.

## Your next step

Download the sheet, write your real groups with hall rent and fee, then your students with their parents' phones, and add a row for each student for this month. At the end of the first week open Unpaid and send the reminders.

## Common questions

**Can I change the sibling discount?** Yes, in Settings; set it to zero if you do not give one.

**Does it work on a phone?** Yes, in Excel, Google Sheets and LibreOffice.

**Are these my prices?** No, they are examples, so type your own.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: study groups for a private teacher (1/3)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-1.jpg)[![Cheat sheet: study groups for a private teacher (2/3)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-2.jpg)[![Cheat sheet: study groups for a private teacher (3/3)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/teacher-study-groups/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How does the sheet work out a per-session fee?

Choose «per session» for the group and type the session price. Due = the sessions you marked ح for the student × the price. With «monthly» the due is the full fee whatever the attendance.

### How does it know siblings and apply the discount?

Students in the Students sheet with the same parent phone are treated as siblings. The second child onward (by their order in the sheet) gets the discount set in Settings; the first does not.

### How are hall cost and assistant pay worked out?

A group's sessions in the month are the session columns (1 to 12) where you marked one of its students in the chosen month. Hall cost = sessions × rent per session, and assistant pay = sessions × their rate.

### Where is the reminder message, and does it send itself?

It shows in Unpaid and in the last column of Attendance and fees for every row with a balance. You copy it and send it on WhatsApp yourself; the sheet sends nothing.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
