Lesson Hearth / Free guides
Homeschool attendance tracker: a free printable monthly record
Many home-educating parents keep a simple record of school days. Some do it for their own planning, some to see the balance of the year, and some because local rules ask for it.
Requirements differ by state and country, and some places ask for nothing at all. Check what your local rules ask you to record. This sheet is a record-keeping aid, not legal advice.
Decide what counts before you start
- F, full day: a normal day of lessons.
- H, half day: decide now whether it counts as half.
- T, trip: museums, nature walks, co-op days.
- O, off: holidays, illness, rest days.
Free printable: monthly attendance record
Month: ______________ Year: ________
| Day | Child 1: ________ | Child 2: ________ | Child 3: ________ | Child 4: ________ | Notes |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 | |||||
| 11 | |||||
| 12 | |||||
| 13 | |||||
| 14 | |||||
| 15 | |||||
| 16 | |||||
| 17 | |||||
| 18 | |||||
| 19 | |||||
| 20 | |||||
| 21 | |||||
| 22 | |||||
| 23 | |||||
| 24 | |||||
| 25 | |||||
| 26 | |||||
| 27 | |||||
| 28 | |||||
| 29 | |||||
| 30 | |||||
| 31 | |||||
| Total |
Codes: F full day, H half day, T trip, O off.
Totalling days in a spreadsheet
If each child’s codes are in a column (for example B2 to B32), this counts full days plus half days as halves:
=COUNTIF(B2:B32,"F")+COUNTIF(B2:B32,"T")+0.5*COUNTIF(B2:B32,"H")
Change the formula if you count trips or half days differently. The point is to decide once and apply it the same way all year.
Tips
- Fill it in at the end of each day. It takes a minute, and a month is hard to remember.
- Keep a few work samples each term in the same folder.
- Keep your records somewhere safe, and back up digital copies.