Monday, ten to eight. In the kitchen, there is a new cook replacing the head cook for two weeks and asks the most obvious question: "Can you give me the list of allergies?" The coordinator opens the spreadsheet prepared in September. Then she remembers that Giulia, who is lactose intolerant, joined in October, and that no one has updated that sheet. She corrects it by hand, prints it out, and hopes it is the final version.
There are many lists in a 0-6 facility, and they change continuously: who has allergies, who has had which vaccines, who attends during a certain period, with which contact details. The problem is not creating them once; it's recreating them every time something changes. In this article, we will see how Easy.School's custom reports in Excel work: templates that are built once and regenerated with a click from the always updated data of the records.
The Lists Needed Every Week
When we talk about reports, we immediately think of the requests from the municipality, which we discussed in Reports for the Municipality: what data is requested and where to find it. But most of the lists are needed within the facility, in everyday life:
- the list of allergies and intolerances for the kitchen or for the catering company;
- the list of children in a section with birth dates and parents' contact details, for the trip or for the substitute;
- the vaccination status when a summary is needed;
- the summary of attendance for a period, for an internal check or for a family that requests it.
Each of these lists, if created from a copy and paste, becomes outdated the next day. If it comes from the children's records, it is updated every time you generate it.
A Report is a Template, Not a File
The starting point is the Reports option in the coordinator's sidebar menu. With + New, you create a template: you give it a descriptive name, like "List of Children with Birth Dates," and choose the data you want to see. In the left column, you find all the fields from the children's and family records; with the + symbol, you move them between the visible fields in the report and reorder them by dragging. Then you save.
From that moment, the template remains in the list of reports. When you need it, click on the Create XLSX icon, choose the sections or individual children, and download the Excel file. The template can be modified, deleted, or duplicated: convenient when you need a variant, for example, the same list with additional family contact details, without touching the original.
The template can also be built starting from the list of all children, not just from the sections: this way, you can include registered children who are not yet attending. The step-by-step guide is how to create reports based on children's and family records.
Allergies and Vaccines: Health Data in One Sheet
In each child's record, there is a section dedicated to health information, with the pediatrician, allergies and food intolerances, and vaccinations received. If this information is filled out correctly, the list for the kitchen stops being a separate document: it becomes a report with first name, last name, section, and allergies, which regenerates every Monday or whenever a new child joins.
For vaccines, there is a ready-made report. From the Children List page, the Vaccines button at the top right creates an Excel file with last name, date and city of birth, residential address, and for each vaccine listed in the health information, the indication "YES" or "NO." Being an Excel file, you can complete it with the facility's data or remove the columns you don't need.
A practical tip: before generating the allergy list for the first time, check that the records are complete. The report shows exactly what is written, no more, no less.
Delegations: The Right Place is the Record, Not the Sheet
For authorized persons for pickup, the logic is different. In the child's record, there is a Delegations section, with the name and surname of each delegate and an attached document, usually the ID card or the signed form. Families can also enter their delegates from the Easy Family app.
Here, the printed list is less useful than it seems. Educators consult the delegates and the document directly from the record, from the browser or from the Easy Staff app, at the time of pickup. It is safer than a sheet on the door, which becomes outdated and remains visible to anyone passing by. We discussed this in Delegations for Pickup: how they are collected and why they should be written down.
Attendance and Daily Register in Excel
Alongside the reports on the records, there are those on daily registrations:
- Daily Register. From the educator's side, in Registers → Educator Register, the printer icon next to the date opens a window where you choose the day, one or more sections, and the items to include: entry, exit, absence, need, nap, activity, lunch, snack. The Excel file has the names of the children on the left and a column for each item. The guide is how to create a daily register report in Excel.
- Attendance for up to 12 months. On the children's attendance page, the XLS detail button generates a file for a chosen period of up to twelve months, with a sheet for each month.
- Annual Attendance. A report for the year, with the months and the total attendance and absences per month. Both this and the attendance report can include the tax code and a custom field.
Custom Fields: When the Data You Need is Not There
Sooner or later, the list arrives that the standard records do not provide: who uses the pre-school service, who has a plain diet on Fridays, who has brought the certificate for swimming activities. This is why custom fields exist. From Settings → Custom Fields, you create a field, choose whether to add it to the children's, families', or staff records, and define up to five selectable values.
For each field, you also decide the visibility: for staff, for parents, in the pre-registration form. Once filled out, the field appears among the filters of the advanced search in the children's list, and you can use it in reports. The details are in the guide how to add custom fields to records.
An Excel File is Still Data to Protect
A list with allergies, vaccinations, or contact details contains personal data, some of which are health-related. Generating it in a click is convenient, but the downloaded file leaves the management system and should be treated with the same care:
- Only the necessary fields. The kitchen needs to know who has an allergy, not the residential address. A template for each use is better than a list with everything.
- The file is not kept. If the report regenerates when needed, there is no reason to keep ten versions in a shared folder or in the mail.
- Prints are collected. The sheet for the trip returns to the office at the end of the day, it does not stay in the substitute's backpack.
In Summary
With custom reports, the facility's lists stop being files that need to be manually updated. Build a template for each use, choose fields and order, and regenerate it in Excel when needed, by section or for individual children. The vaccine report is already ready, attendance can be extracted for up to twelve months, the daily register comes out in a sheet, and custom fields cover what the standard records do not provide. Delegations, on the other hand, are better placed in the child's record, consultable at the time of pickup.
Do you want to have always updated lists without recreating them every time? Try Easy.School for free.