Softwiro
Free Excel template

Private school management sheet

A free Excel sheet for running a private school. Enter your classes and their capacity, and the sheet shows how many students each class has and whether it is over capacity. Enter each student with their grade and discount, and it shows their tuition fees, instalments, what has fallen due, what has been paid and what is overdue. Allocate teachers' lessons to see each teacher's teaching load, enter monthly attendance for each class and record expenses. The summary shows income against expenses in charts.

Excel file (.xlsx) · 162 KB · 11 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.
الكودالطالبالفصلالصفالصافي بعد الخصمالمستحق حتى اليومالمدفوعالمتأخرالموقف
S001أحمد محمودKG1 أKG118,000.0012,600.0012,600.000.00مسدد
S002محمد هشامKG1 أKG118,000.0012,600.0012,600.000.00مسدد
S003يوسف سامحKG1 أKG118,000.0012,600.0012,600.000.00مسدد
S004عمر هانيKG1 أKG116,500.0011,550.0011,550.000.00مسدد
S005زياد تامرKG1 أKG118,000.0012,600.0012,600.000.00مسدد
S006كريم إسلامKG1 أKG118,000.0012,600.007,200.005,400.00متأخر
S007آدم أيمنKG1 أKG118,000.0012,600.007,200.005,400.00متأخر
S008مصطفى وائلKG1 أKG118,000.0012,600.003,600.009,000.00متأخر
S009ياسين ياسرKG1 أKG118,000.0012,600.0014,400.00-1,800.00دفع مقدمًا
S010حمزة رضاKG1 أKG118,000.0012,600.000.0012,600.00متأخر
S011ليلى ناصرKG2 أKG218,500.0012,950.0012,950.000.00مسدد
S012مريم خالدKG2 أKG220,000.0014,000.0014,000.000.00مسدد
S013سلمى طارقKG2 أKG220,000.0014,000.0014,000.000.00مسدد

Example from the “الطلاب” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الإعدادات: Settings: today's date, the report month, the first month of the income table, the teacher's required load and the low-attendance threshold, the instalment schedule (date and percentage), the grade levels with their annual fees and the expense categories.
  • الفصول: Classes: each class with its grade, capacity and teacher. The sheet shows the number of students, seats available, occupancy and status (available, full or over capacity) and weekly lessons. Holds up to 20 classes.
  • الطلاب: Students: student code, name, class, parent, mobile, status and discount. The sheet shows the grade, annual fees and net fees, the amount due to date, the amount paid, the overdue amount and the position. Holds up to 300 students.
  • المدفوعات: Payments: each payment with its date, student code, amount, payment method and receipt number. The student's name appears automatically. Holds up to 2,000 payments.
  • المعلمون: Teachers: each teacher's name, subject, mobile and salary. The sheet shows weekly lessons, their share of the required load and the position (over, adequate or low). Holds up to 40 teachers.
  • توزيع الحصص: Lesson allocation: for each class and subject, the teacher and number of lessons per week, with a warning for a class or teacher that does not exist. Holds up to 300 rows.
  • الحضور الشهري: Monthly attendance: for each class and month, the school days and total days of absence. The sheet shows the attendance rate and a warning if it falls below the threshold.
  • المصروفات: Expenses: each payment with its date, category (from a list), description and amount, such as salaries, rent, utilities, books, transport and maintenance.
  • الملخص: Summary: students, occupancy and classes over capacity, tuition fees, overdue amounts and collection rate, the month's income, expenses and net, attendance rate, teachers and their loads, expenses by grade, instalment position and income against expenses for six months, with four charts.

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

What makes it different

Students, classes, instalments and teachers in one file. The sheet links each student to their class, grade and fees, and each teacher to their lessons, so occupancy, overdue fees and teaching load all come from the same figures.

How to use it

  1. In "الإعدادات" (Settings) enter today's date, the report month, the first month of the income table, the weekly teacher load and the low-attendance threshold. Then add the instalment schedule (date and percentage of each), the grade levels with annual fees and the expense categories.
  2. In "الفصول" (Classes) enter each class with its grade, capacity and class teacher.
  3. In "الطلاب" (Students) enter each student's code, name, class, parent and mobile, and any discount as an amount. Enter "منسحب" (withdrawn) for a student who has left, and their fees become zero.
  4. Record in "المدفوعات" (Payments) every amount a parent pays, with the date and the student code.
  5. In "المعلمون" (Teachers) enter each teacher's subject and salary. In "توزيع الحصص" (Lesson allocation) enter, for each class and subject, the teacher and lessons per week, and each teacher's load appears.
  6. In "الحضور الشهري" (Monthly attendance) enter, for each class and month, the school days and total student absences, and record spending in "المصروفات" (Expenses). Open "الملخص" (Summary) to see occupancy, collection, overdue fees and income against expenses.

Before you start:

  • Amount due to date = the student's net fees x the total percentage of instalments already due (dated today or earlier). Overdue = amount due - amount paid. A negative figure means paid in advance.
  • Net fees = the annual fees for the student's grade - discount, never less than zero, and zero for a withdrawn student. The instalment percentages must add up to 100%, otherwise the total cell turns red.
  • Class occupancy = students enrolled in it / its capacity. If the count exceeds capacity, its status shows "over capacity".
  • A teacher's load = the total of their weekly lessons in "توزيع الحصص" (Lesson allocation). It shows "over" if it exceeds the load in the settings and "low" if it is under half of it. The required load is a number you set to match your school's system.
  • Attendance rate in "الحضور الشهري" (Monthly attendance) = 1 - absence days / (school days x number of students in the class). For daily attendance of each student, use a student attendance sheet.
  • The sheet holds 300 students, 20 classes, 8 grades, 8 instalments, 2,000 payments, 40 teachers, 300 lesson-allocation rows, 200 monthly attendance rows and 1,000 expenses. The names and numbers are made-up examples.

Excel file (.xlsx) · 162 KB · 11 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: private school management (1/3)Cheat sheet: private school management (2/3)Cheat sheet: private school management (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet holds the numbers of one class, typed in by one teacher. In the School Performance Management Platform, each student's grades, attendance and teacher notes come together, and reports reach parents.

In this sheetIn School Performance Management Platform
Every teacher has a sheet, and the administration collects the files.One dashboard for students, teachers and classes, with exam results tracking and a comparison of performance across terms.
A student's decline shows up in the end-of-term result.AI analyzes the student's grades, attendance and teacher notes, warns early about a possible decline, and suggests a development plan that the teacher decides on.
The parent learns about the problem late.Regular reports to parents on the student's level, teacher notes and the attendance record, plus direct contact with the school through the app.
Attendance lives in a notebook or a sheet per class.Attendance, absence and lateness are recorded for each student and turned into attendance reports and rates that the administration follows for each class.

See School Performance Management Platform · Ask for a demo

Frequently asked questions

How do I know if a class is over capacity?

Enter each class's capacity in "الفصول" (Classes). The sheet counts the students enrolled in each class and compares them with the capacity, showing the status "available", "full" or "over capacity".

How do I track overdue instalments?

Enter each instalment's date and percentage in "الإعدادات" (Settings). Amount due to date = the student's net fees x the percentages of instalments already due. Overdue = amount due - amount paid in "المدفوعات" (Payments).

How do I work out a teacher's teaching load?

In "توزيع الحصص" (Lesson allocation) enter, for each class and subject, the teacher and weekly lessons. The sheet totals each teacher's lessons and compares them with the required load in "الإعدادات" (Settings), showing "over", "adequate" or "low".

Does it record daily attendance for each student?

No. It takes the school days and total absences for each class in a month. For daily attendance use a student attendance sheet and copy the totals here.

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

More free templates for: Schools and students

More free templates

All templates · Free tools