Softwiro
Free Excel template

Study groups management sheet for a private teacher

A free Excel sheet for a private tutor who runs several groups (not a centre with several teachers). Enter your groups with their grade, days, venue, hall rent per session and fee (monthly or per session), and your students with a parent's phone number. Then add one row per student per month, with attendance for up to 12 sessions (one letter per session) and the amount paid. The sheet calculates the fee due, either monthly or by the sessions the student attended, applies a sibling discount from the second sibling onward, and shows the balance and a list of students who have not paid, each with a ready reminder message you can copy and send. Enter quiz marks to get each student's and each group's average, and enter expenses to get each group's net income after hall and assistant costs.

Excel file (.xlsx) · 359 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “الحضور والاشتراكات” tab (Arabic), with the numbers and formulas that are in the file.
الشهر (أي تاريخ فيه)كود الطالباسم الطالبالمجموعةحضرغابالمستحق قبل الخصمخصم الإخوةالصافي المستحقالمتبقيالحالة
46296S001أحمد سامحتانية ثانوي أ71400.000.00400.000.00مدفوع
46296S002مريم عادلتانية ثانوي أ80400.000.00400.000.00مدفوع
46296S003يوسف حسنتانية ثانوي أ62400.000.00400.00200.00جزئي
46296S004هنا طارقتانية ثانوي أ70400.000.00400.000.00مدفوع
46296S005كريم وليدتالتة ثانوي ب71500.000.00500.000.00مدفوع
46296S006سلمى ياسرتالتة ثانوي ب80500.000.00500.000.00مدفوع
46296S007عمر خالدتالتة ثانوي ب52500.000.00500.00500.00لم يدفع
46296S008ملك أشرفتالتة ثانوي ب71500.000.00500.000.00مدفوع
46296S009نور حسنتالتة إعدادي70300.0030.00270.000.00مدفوع
46296S010آية محمودتالتة إعدادي80300.000.00300.000.00مدفوع
46296S011زياد عصامتالتة إعدادي53300.000.00300.00150.00جزئي

Example from the “الحضور والاشتراكات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • "الإعدادات" (Settings): The month you are working on, the sibling discount percentage, the default full mark for a quiz, your name as it appears in the reminder message, the attendance threshold for warnings, and the list of expense types.
  • "المجموعات" (Groups): Name, grade, days, time, venue, hall rent per session, fee type and amount, capacity and the assistant's pay per session. The sheet calculates students, empty seats, sessions in the month, attendance rate, fees due, collected, balance, hall and assistant cost, expenses, net income and average marks. Room for 20 groups.
  • "الطلاب" (Students): Code, name, group, student's phone and parent's phone. The sheet calculates the student's rank within their family, sibling discount, total due, paid, balance, attendance rate, average marks and a warning (balance owed or poor attendance). Room for 200 students.
  • "الحضور والاشتراكات" (Attendance and fees): One row per student per month: a date inside the month and the code, then up to 12 sessions marked ح (present), غ (absent) or ع (excused), and the amount paid and its date. It shows the name, group, number present and absent, attendance rate, fee before discount, sibling discount, net, balance, status and reminder message. Room for 1,000 rows.
  • "المتأخرون" (Late payers): Students in the selected month who still owe money, with their group, parent's phone and the amount, and a ready reminder message beside each. It shows the first 100 students.
  • "الاختبارات" (Quizzes): One row per mark: date, student code, quiz name, mark and full mark. The name, group and percentage appear automatically. Room for 1,000 marks.
  • "التكاليف" (Costs): Other expenses: date, group (or blank for a general expense), type, description and amount. Room for 200 expenses.
  • "الملخص" (Summary): The month's students, fees due, collected, balance, collection rate and sibling discounts; halls, assistants, expenses and the month's net income; attendance rate and average marks; a table of groups; and three charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

Monthly or per-session fees are worked out from recorded attendance, the sibling discount is applied automatically at the percentage you set, and students who have not paid appear with their balance and a ready message. Each group's net income deducts the hall and the assistant for the sessions actually held, so you can see which group makes you money and which costs you.

How to use it

  1. In "الإعدادات" (Settings) enter any date inside the month you are working on, the sibling discount percentage, and your name so it appears in the reminder message.
  2. In "المجموعات" (Groups) enter each group with its grade, days, venue, hall rent per session, fee type (monthly or per session) and amount.
  3. In "الطلاب" (Students) enter each student with a code, group and parent's phone number. Students with the same parent number are treated as siblings.
  4. In "الحضور والاشتراكات" (Attendance and fees) add a row for each student each month: a date inside the month and the student code, then mark each session ح (present), غ (absent) or ع (absent with an excuse), and enter the amount paid and its date.
  5. Record quiz results in "الاختبارات" (Quizzes) and other expenses in "التكاليف" (Costs).
  6. Open "المتأخرون" (Late payers) to copy the reminder message for each parent, "المجموعات" (Groups) for each group's net income, and "الملخص" (Summary) for the month.

Before you start:

  • A monthly fee is fixed for each student for the month. A per-session fee = the number of sessions the student attended (ح) × the session price.
  • Sibling discount = the discount percentage from "الإعدادات" (Settings) × the student's fee. It applies to the second sibling onward (by their order in the "الطلاب" (Students) sheet) among students who share the same parent phone number.
  • A group's sessions in the month = the number of session slots (1 to 12) in which you marked any student of the group in that month. Hall cost = sessions × rent per session, and assistant pay = sessions × the assistant's pay per session.
  • Group net income = collected in the month − (hall + assistant + expenses entered under the group's name). Expenses with no group appear in "الملخص" (Summary) as general expenses.
  • Attendance rate = ح sessions ÷ (ح + غ + ع). Average marks = the student's mark ÷ the quiz's full mark (or the default full mark if you left it blank).
  • The sheet has room for 20 groups, 200 students, 1,000 monthly rows (a student in a month), 1,000 marks and 200 expenses, and "المتأخرون" (Late payers) shows the first 100 students.
  • This sheet is for a single teacher. If you run a centre with several teachers, halls and pay rates, use the tutoring centre sheet (tutoring-center).

Excel file (.xlsx) · 359 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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)Cheat sheet: study groups for a private teacher (2/3)Cheat sheet: study groups for a private teacher (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

How does the sheet calculate a per-session fee?

Set the group's fee type to "بالحصة" (per session) and enter the price per session. Amount due = the number of sessions you marked ح (present) for the student × the session price. With "شهري" (monthly), the amount due is the full fee whatever the attendance.

How does the sheet identify siblings and discount for them?

Students who share the same parent phone number in the "الطلاب" (Students) sheet are treated as siblings. The discount percentage from "الإعدادات" (Settings) is deducted for the second sibling onward (by their order in the sheet), and nothing is deducted for the first.

How are the hall cost and the assistant's pay calculated?

A group's sessions in the month are the number of session slots (1 to 12) in which you marked any of its students in the selected month. Hall cost = sessions × hall rent per session, and assistant pay = sessions × the assistant's pay per session.

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

It appears in "المتأخرون" (Late payers) and in the last column of "الحضور والاشتراكات" (Attendance and fees) for every row with a balance. You copy it and send it yourself, for example on WhatsApp. The sheet does not send anything.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up

More free templates for: Teachers

More free templates

All templates · Free tools