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 (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 fits you better.
How it works, step by step
- 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.
- 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.
- In الطلاب (Students) write each student with a code, group and parent phone. Students with the same parent phone are siblings.
- 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.
- In الاختبارات (Quizzes) type the marks, and in التكاليف (Costs) the other expenses.
- 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. To track your students' marks with different weights, try the teacher 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.





