Child Care Attendance Sheet

Daily drop-off and pick-up log for a daycare, with authorised pickups, allergies and per-child attendance rates.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Attendance Sheets

Tables

Children, Attendance

Fields

24

Views

grid, form, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Children

12 fields · 5 sample rows

  • By room (Grid)
  • Enrol a child (Form)
ChildTextRoomSingle selectDate of birthDateAgeFormulaParent / guardianTextPhonePhoneAuthorised pickupsLong textAllergiesMultiple selectAttendanceLink to another tableDays recordedCountDays presentRollupAttendance rateFormula
Aarav MehtaToddlers19 Dec 202423 moKavita Mehta+91 98200 11223Kavita Mehta (mother), Raj Mehta (father)Peanuts18 Nov 2026, 19 Nov 202622100%
Lily ThompsonPreschool18 Jun 20233 yrsEmma Thompson+44 7700 900123Emma Thompson, Nanny: Rosa LopezNone18 Nov 2026, 19 Nov 202622100%
Zoya KhanInfants13 Jan 202610 moImran Khan+91 99300 44556Imran Khan, Sana KhanDairy18 Nov 2026100%
Kabir IyerPre-K25 Mar 20224 yrsLakshmi Iyer+91 98450 77889Lakshmi Iyer, Grandfather: S. IyerEggs, Gluten18 Nov 202611100%
Noah FernandesToddlers21 Aug 20242 yrsMaria Fernandes+91 98190 33445Maria FernandesNone19 Nov 2026100%
Field details
Child · Text
Room · Single select
Infants, Toddlers, Preschool, Pre-K
Date of birth · Date
Age · Formula
IF({Date of birth}, IF(DATETIME_DIFF(TODAY(), {Date of birth}, 'months') < 24, CONCAT(DATETIME_DIFF(TODAY(), {Date of birth}, 'months'), ' mo'), CONCAT(DATETIME_DIFF(TODAY(), {Date of birth}, 'years'), ' yrs')), '')
Parent / guardian · Text
Phone · Phone
Authorised pickups · Long text
Allergies · Multiple select
None, Peanuts, Dairy, Eggs, Gluten, Bee stings
Attendance · Link to another table
Links to Attendance
Days recorded · Count
Days present · Rollup
sum of Present via Attendance
Attendance rate · Formula
IF({Days recorded} > 0, {Days present} / {Days recorded}, BLANK())

Form view “Enrolment details” asks for: Child, Room, Date of birth, Parent / guardian, Phone, Authorised pickups, Allergies.

Attendance

12 fields · 7 sample rows

  • Daily register (Grid)
  • Today (Grid)
  • Calendar (Calendar)
  • Check in / out (Form)
DateDateChildLink to another tableRoomLookupStatusSingle selectDrop-offDurationDropped off byTextPick-upDurationPicked up byTextHours in careFormulaPresentFormulaParent signatureSignatureNotesLong text
18 Nov 2026Aarav MehtaToddlersPresent8:30Kavita Mehta17:15Raj Mehta8.751Napped 1.5 hrs, ate well
18 Nov 2026Lily ThompsonPreschoolLate9:40Rosa Lopez16:00Emma Thompson6.331
18 Nov 2026Zoya KhanInfantsSick0Fever reported by parent
18 Nov 2026Kabir IyerPre-KPresent8:05Lakshmi Iyer15:30S. Iyer7.421
19 Nov 2026Aarav MehtaToddlersPresent8:20Raj Mehta1
19 Nov 2026Lily ThompsonPreschoolPresent8:45Emma Thompson1
19 Nov 2026Noah FernandesToddlersAbsent0
Field details
Date · Date
Child · Link to another table
Links to Children
Room · Lookup
Room via Child
Status · Single select
Present, Late, Absent, Sick, Holiday
Drop-off · Duration
Dropped off by · Text
Pick-up · Duration
Picked up by · Text
Hours in care · Formula
IF(AND({Drop-off}, {Pick-up}), ROUND(({Pick-up} - {Drop-off}) / 3600, 2), BLANK())
Present · Formula
IF(OR({Status} = 'Present', {Status} = 'Late'), 1, 0)
Parent signature · Signature
Notes · Long text

Form view “Drop-off & pick-up” asks for: Date, Child, Status, Drop-off, Dropped off by, Pick-up, Picked up by, Parent signature, Notes.

Child Care Attendance Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates