# Nursery management sheet Excel (free)

> Free Excel sheet to manage a nursery: children register, attendance with times, authorised pick-up alerts, fees and balances, staff, expenses and charts.

Source: https://softwiro.com/blog/nursery-management-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Complete nursery management sheet in Excel (free)

Children, daily attendance, who may collect each child, monthly fees and balances, staff and expenses in one file.

15 November 2026 5 min read

## In short

- The age group, monthly fee and amount due are worked out from each child's birth date and joining date.
- Daily attendance rows carry arrival and departure times; the Today sheet and a month grid show who was in.
- Each pick-up is checked against the child's authorised list and flagged "not authorised" when the name does not match.
- Balance = months due × monthly fee − payments; late, prepaid and settled show in colour.
- The summary gives occupancy, collection, attendance and income against spending with three charts.

You run a nursery and want to know at any moment which children are in today, who is about to collect each child and who is not allowed to, how much each guardian has paid and how late they are, and whether what you collect covers what you spend. The free [complete nursery management sheet](https://softwiro.com/templates/nursery-management) puts all of this in one file instead of an attendance notebook, a fee book and a slip of paper for pick-ups.

## The problem it solves

In a small nursery the information is scattered: allergies sit with the carer, fees in the manager's book, and the names of who may collect each child in someone's memory. So a stranger turns up asking for a child, or a child is served food they react to, or at month end you find three guardians have not paid. The sheet keeps it together and shows in colour what needs attention.

If you only need fees and instalments there is the [nursery and school fees sheet](https://softwiro.com/templates/nursery-school-fees), with a [guide article](https://softwiro.com/blog/nursery-school-fees-free-excel-online.html) (Arabic). This sheet is the whole nursery.

## How it works, step by step

1. In الإعدادات (Settings) type today's date, the report month and the closing time, then the age-group table: the month each group starts at, its fee and capacity, plus the expense categories.
2. In الأطفال (Children) write each child: code, name, birth date, joining date, guardian, phone and allergy. The sheet shows age in months, group, monthly fee and what is owed.
3. In المفوضون بالاستلام (Authorised pick-up) write, per child, the people the guardian named, with relation and phone.
4. Every day log in سجل الحضور (Attendance log) one row per child: present, absent or excused, with arrival and departure times. In سجل الاستلام (Pick-up log) write who collected the child and when; the sheet says "authorised" or "not authorised".
5. Record payments in المدفوعات (Payments), spending in المصروفات (Expenses), and each staff member, group and salary in الموظفون (Staff).
6. Open حضور اليوم (Today), شبكة الحضور (Month grid) and الملخص (Summary) to review.

## What each sheet does

- Settings: dates, closing time, groups and categories.
- Children: the group comes from the birth date; due, paid, balance and financial status are calculated; allergies are highlighted and children who left are shaded.
- Payments and Expenses: two simple logs; a payment shows the child's name automatically.
- Attendance log: a row per child per day with hours stayed, and a warning for duplicate or incomplete rows.
- Today: pick a day and every child appears with status and times, and who is not logged yet.
- Month grid: a monthly table of ✔, ✘ and ع marks per child, with attendance rate.
- Authorised pick-up and Pick-up log: who may collect, who actually did, and minutes late after closing.
- Staff: group and children in it. Summary: the big numbers and three charts.

## Walk-through on the sample numbers

The names and amounts below are sample data inside the sheet, not a real nursery. The example has 14 children (13 enrolled, one left) and today is 15 November 2026:

- Groups: infants 2, toddlers 5, juniors 3, seniors 3, out of a total capacity of 45, so occupancy is 28.9%.
- Age: Adam was born on 10 August 2025, so he is 15 months old ("1 year 3 months"), in the infants group at a fee of 2,800.
- Sibling discount: Ritaj and Karam are siblings with a 200 discount each, so their fees are 1,900 and 2,400.
- Late payments: Youssef owes 5,200 up to November and paid 3,900, so his balance is 1,300. Mariam paid 2,600 of 5,200, so she is 2,600 behind, and Salim is 1,100 behind. That is 5,000 over three children. Ziad paid 500 extra, so his status is "prepaid".
- Collection: guardians paid 57,600 of 62,100 due, which is 92.8%.
- Attendance: November has 130 rows, 124 of them present, so the rate is 95.4% and there are 6 absence days.
- Pick-up: 13 pick-ups, two of them "not authorised": "Reda Abdel Hamid" is not among Jana's authorised people, and "Mahmoud Rashad" is not on Salim's list. Four pick-ups were after 2 pm, the longest 30 minutes late.
- Income and spending: in October 30,700 was collected and 29,750 spent, so net is 950. In November 26,900 was collected and 8,950 spent, so net looks like 17,950 only because November's payroll is not logged yet in the sample, which is one of the mistakes below.

## Common mistakes

- A child with no attendance row: "Not logged" shows in Today. That is a prompt for you, not a fault.
- Typing the collector's name differently: if the list says one spelling and the log another, the result is "not authorised". Use the same spelling.
- No leaving date for a child who left: their fees keep counting.
- Logging salaries late: net looks higher than reality. Log all spending before reading net.
- Relying on the flag alone: "not authorised" helps staff but does not replace checking the collector's identity and calling the guardian.
- Collecting more data than needed: do not type ID numbers or medical details. A nursery normally needs name, birth date, guardian, phone and allergy.

## When to move to a system

The sheet holds 100 children and 4,000 attendance rows (about a month and a half for 100 children, so move old rows to an archive file each term). It is a file one person edits at a time. When carers want to log attendance from their phones at the same moment, or you want a message to reach the guardian on arrival and departure, Softwiro can [build you a system around your nursery](https://softwiro.com/contact).

## Your next step

Download the sheet from [its page](https://softwiro.com/templates/nursery-management), delete our examples in "الأطفال" and type your first ten children with their authorised people. Then log one day's attendance and pick-ups and open "حضور اليوم" to see the result.

## 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 management (1/3)](https://softwiro.com/uploads/cheatsheets/nursery-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-management/en-1.jpg)[![Cheat sheet: nursery management (2/3)](https://softwiro.com/uploads/cheatsheets/nursery-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-management/en-2.jpg)[![Cheat sheet: nursery management (3/3)](https://softwiro.com/uploads/cheatsheets/nursery-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/nursery-management/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 decide a child's group?

From the child's age in months today. The groups table in Settings lists the starting age of each group in ascending order, and the child goes in the last group whose starting age is not above their age.

### What does "not authorised" mean at pick-up?

The collector's name does not match any name listed for that child in the Authorised pick-up sheet. Check the spelling, call the guardian, and verify identity before handing the child over.

### Can I record a child who left?

Yes. Set the status to "منسحب" and type the leaving date; fees stop at the leaving month.

### How many children and attendance rows fit?

Up to 100 children and 4,000 attendance rows, about a month and a half for 100 children, so archive older rows each term.

### Does it keep ID numbers or medical files?

No, and it should not. Keep only what a nursery normally needs: name, birth date, guardian, phone and allergies, handled confidentially under local law.

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