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 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, with a guide article (Arabic). This sheet is the whole nursery.
How it works, step by step
- 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.
- 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.
- In المفوضون بالاستلام (Authorised pick-up) write, per child, the people the guardian named, with relation and phone.
- 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".
- Record payments in المدفوعات (Payments), spending in المصروفات (Expenses), and each staff member, group and salary in الموظفون (Staff).
- 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.
Your next step
Download the sheet from its page, 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.





