# Nursery and school fees tracker (Excel) (free Excel)

> Fees by stage, an installment plan with dates, sibling discounts, payments per student, amount due to date versus paid to show arrears, and a collection…

Source: https://softwiro.com/templates/nursery-school-fees
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Nursery and school fees tracker (Excel)

A free Excel sheet for nursery and school fees. You enter the fees for each stage, the installment schedule and the sibling discount rates, then record your students and their payments. The sheet calculates each student's net fees, what has fallen due to date, what they paid and what is overdue, and shows a list of parents in arrears and a collection summary by stage.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-nursery-school-fees.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-nursery-school-fees-blank.xlsx)

Excel file (.xlsx) · 196 KB · 8 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

| كود الطالب | الطالب | المرحلة | صافي المصروفات | المستحق حتى اليوم | المدفوع | المتأخر | الموقف |
| --- | --- | --- | --- | --- | --- | --- | --- |
| S01 | ليلى أحمد | حضانة | 12,000.00 | 6,000.00 | 6,000.00 | 0.00 | مسدد حتى اليوم |
| S02 | يوسف أحمد | تمهيدي KG1 | 16,200.00 | 8,100.00 | 4,050.00 | 4,050.00 | متأخر |
| S03 | مريم خالد | تمهيدي KG2 | 18,000.00 | 9,000.00 | 10,000.00 | -1,000.00 | دفع مقدمًا |
| S04 | عمر سمير | أولى ابتدائي | 22,000.00 | 11,000.00 | 5,500.00 | 5,500.00 | متأخر |
| S05 | سلمى سمير | حضانة | 10,800.00 | 5,400.00 | 5,400.00 | 0.00 | مسدد حتى اليوم |
| S06 | ندى سمير | تمهيدي KG1 | 15,300.00 | 7,650.00 | 3,825.00 | 3,825.00 | متأخر |
| S07 | آدم هشام | أولى ابتدائي | 24,000.00 | 12,000.00 | 12,000.00 | 0.00 | مسدد حتى اليوم |
| S08 | جني طارق | تمهيدي KG1 | 0.00 | 0.00 | 4,500.00 | -4,500.00 | منسحب |
| S09 | كريم ياسر | تمهيدي KG2 | 18,000.00 | 9,000.00 | 0.00 | 9,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 discount rate for the second and for the third and later siblings, and the installment schedule (up to 8 installments) with each installment's date and its percentage of the fees. It shows the total of the percentages (which must be 100%) and the percentage due to date.
- "المراحل" (Stages): Each stage's name and annual fees. The example has four stages: nursery 12,000, KG1 and KG2 at 18,000, and Grade 1 primary 24,000. The table holds 40 stages.
- "الطلاب" (Students): Student code, family code, name, parent, phone, stage, an extra discount as an amount and status (enrolled or withdrawn). The sheet calculates annual fees, sibling order and sibling discount, net fees, due to date, paid, overdue, remaining for the year, standing, last payment and follow-up order.
- "الدفعات" (Payments): Each amount a parent pays with its date, student code and payment method; the student's name appears automatically, and a code that is not recorded is flagged.
- "للمتابعة" (Follow-up): Students in arrears, largest overdue amount first, with code, parent, phone, amount overdue, last payment and stage. It holds the first 50 in arrears.
- "الملخص" (Summary): The number of students, enrolled and withdrawn, fees before discount, sibling discounts, extra discounts, net fees, due to date, paid, arrears, advance payments and collection rate, with a table of enrolled students, net fees and arrears for each stage.
- "ابدأ هنا" (Start here): How to use the sheet, what the colours mean and notes on the calculations.

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

## What makes it different

Open "للمتابعة" (Follow-up) and you find which parents to call and how much each owes, without comparing the installment book with the cash book. From the summary you see what the school should have collected to date and how much of it has actually been collected.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY()), the discount rate for the second and for the third and later siblings, and the installment schedule: each installment's date and its percentage of the fees.
2. In the "المراحل" (Stages) sheet, enter each stage and its annual fees.
3. In the "الطلاب" (Students) sheet, enter for each student a code, a family code (one for all siblings), name, parent, phone, stage, and any extra discount as an amount.
4. Write "withdrawn" in the status cell of a student who has left, and their fees become zero.
5. In the "الدفعات" (Payments) sheet, record each amount a parent pays: date, student code, amount and payment method.
6. The "الطلاب" (Students) sheet calculates net fees, due to date, overdue and status. Open "للمتابعة" (Follow-up) to find those in arrears, largest first, and "الملخص" (Summary) for collection by stage.

**Before you start:**

- Due to date = the student's net fees × the total percentage of the installments whose due date has arrived (dated today or earlier).
- The sibling discount is applied by the order in which siblings appear in the "الطلاب" (Students) sheet within the same family: the first gets no discount, the second gets the second-sibling rate, and the third and later get the third rate. List the sibling with the highest fees first if you want the discount to fall on the lower fees.
- Net fees = annual fees − sibling discount − extra discount, and never less than zero.
- Overdue = due to date − paid. A negative number means the parent paid in advance, and their status shows "paid in advance".
- The installment percentages must total 100%; otherwise the total cell in "الإعدادات" (Settings) turns red.
- The sheet holds 500 students, 2000 payments, 8 installments and 40 stages, and the "للمتابعة" (Follow-up) list shows the first 50 in arrears. The names and numbers are fictional examples.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-nursery-school-fees.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-nursery-school-fees-blank.xlsx)

Excel file (.xlsx) · 196 KB · 8 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: nursery and school fees (1/3)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-1.jpg)[![Cheat sheet: nursery and school fees (2/3)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-2.jpg)[![Cheat sheet: nursery and school fees (3/3)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-school-fees/en-3.jpg)

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 sheet | In 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](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## 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)

## Frequently asked questions

### How is the amount due to date calculated?

Due to date = the student's net fees × the total percentage of the installments whose due date has arrived, meaning those dated today or earlier. Today's date is read from the "الإعدادات" (Settings) sheet.

### How is the sibling discount applied?

By the order in which siblings appear in the "الطلاب" (Students) sheet within the same family, meaning students with the same family code: the first gets no discount, the second gets the second-sibling discount rate, and the third and later get the third rate. A withdrawn student is not counted in the order.

### What happens to a withdrawn student?

Write "withdrawn" in their status cell and their net fees become zero and their standing shows "withdrawn". Their payments stay recorded, and if they had paid anything you will see the amount in the "الطلاب" (Students) sheet so you can decide what to do with it.

### What if the installments are not equal?

Change each installment's percentage in the installment schedule as you like, provided the total is 100%; otherwise the total cell turns red.

### 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](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](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Schools and students

## More free templates

- Gradebook Template for Excel (Weighted Categories, Letter Grades)
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Tutoring center manager (Excel)
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)
- Homework and behavior tracker for teachers (Excel)
- School bus subscriptions tracker (Excel)
- University applications tracker (Excel)
- Complete nursery management sheet
- Private school management sheet
- Lending library management sheet
- Graduation project manager sheet: tasks, team, phases and deliverables
- Poultry farm cycle tracker (Excel)
- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet
- Wedding and event budget planner (Excel)
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- Car showroom accounts sheet
- Freelancer projects, hours and invoices tracker

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
