Attendance is often one of the first questions people ask about homeschooling. A district office, umbrella school, or evaluator may want to know how many days of instruction you completed, even if nobody asks to see your lesson plans in detail. A simple, consistent record removes guesswork when you need to explain your year.
This homeschool attendance sheet is a yearly record for one student. The top area holds the school year, the name of your homeschool or program, and the person preparing the record. Below that, the grid lists twelve months with numbered rows for the dates. Each small box corresponds to one calendar day. Along the bottom, built-in formulas total the days for each month and keep a running cumulative count for the year, so you can see progress toward any required number of school days.
You can keep the sheet in Excel or Google Sheets, print it for a binder, or use both. It works as a log you can refer to when planning and can sit alongside other documents, such as portfolios or grade reports, when someone asks for attendance information.
How to Use the Homeschool Attendance Sheet
This section walks through the steps for setting up the sheet, recording each day of instruction, and reading the totals so your attendance record stays consistent throughout the year.
Enter the school year and header details
Start with the header. Type the school year at the top in the format that suits your records, such as “2094–2095” or simply “2095.” In the small fields on the right, you can keep the default labels or change them to match your situation. Many families use the Department field for a homeschool name, umbrella school, or co-op, and the Prepared by field for the parent, guardian, or primary teacher.
If you report to a specific program that prefers certain wording, match their terms here so the sheet lines up with their forms and letters. This small adjustment can make your attendance record feel consistent with the rest of your paperwork.
Decide what will count as a school day
Before you begin marking the grid, decide which activities you plan to count. Homeschooling often blends formal lessons with field trips, co-op days, service projects, and independent reading. Local rules may focus on days, on hours, or on a general standard of regular instruction.
Review any guidance from your state or umbrella school and then set a simple rule for your home. For example, you might treat any day that meets a minimum set of subjects or hours as a school day, and treat some lighter days as enrichment or review. Once you have that decision in mind, it becomes easier to mark the sheet without hesitation.
Choose a marking style for each day
Next, decide how you will mark attendance in each box. The grid does not force a particular code, so you can keep things simple. Many parents choose one symbol for instruction days and leave non-school days blank. Others use short letter codes to capture common patterns such as sickness or holidays.
You might enter a check mark or X on school days, use “P” for present and “A” for absent, or write small letters such as “S” for sick and “H” for holiday. If you expect an evaluator or administrator to read the sheet, it is helpful to keep the code short and easy to interpret. You can write a small legend in a corner of the sheet or on a cover page in the same workbook.
Record attendance in the grid
Once your marking style is chosen, you can start using the grid. Each column represents a month and each numbered row represents the date. When a day meets your standard for instruction, place your symbol in the corresponding box.
Some families update the sheet at the end of each day. Others prefer a weekly routine, such as sitting down every Friday to mark the days that counted as school. Regular updates prevent you from having to reconstruct a whole month from memory and make the totals more trustworthy.
You can record learning on weekends, holidays, or evenings if those days fit into your plan and local guidelines. The grid is neutral, so you decide which dates belong in your attendance count.
Review monthly and cumulative totals
At the bottom of the grid you will see two summary rows. One row totals the recorded days in each month. The other row shows a cumulative count from the beginning of the year through that month.
As you record attendance, glance at these totals from time to time. They show how quickly your days are adding up and how close you are to any yearly requirement, such as 160 or 180 days. If you notice that you are far ahead or falling behind, you can adjust breaks and busy periods while there is still time to change your schedule.
If you change your marking system during the year, test a few entries to confirm that the formulas still count your symbols correctly. In many versions of this sheet, any non-blank entry is counted as a day.
Adapt the sheet for more than one student
If you are teaching more than one child, you can adapt the file while keeping the layout familiar. A common pattern is one worksheet tab per student. Duplicate the original sheet and rename each tab with a student’s name. That approach keeps each record separate for reporting, while still storing everything in one file.
If you prefer a combined view, you might keep one sheet per student for official records and an additional sheet that notes family-wide attendance patterns. That combined sheet can guide your planning, while the individual sheets serve as the records you would print or submit if someone asks for student-specific documentation.
Save and print your records
At the end of the year, save a copy of the file with the student’s name and school year in the filename. Many families also export a PDF version and store it in a folder with other homeschool documents.
Printed copies are useful during reviews or meetings. You can print the completed sheet, sign and date it, and place it in a binder with work samples, reading lists, or grade summaries. Electronic copies stored in cloud storage give you a backup in case a printed binder is misplaced.
FAQs
In some regions, a parent-kept attendance log is exactly what programs expect, especially when combined with a signed statement. In other places, the log is one part of a broader set of records that may include subject plans, grades, or test results. This sheet gives you a clear day count that you can share or copy into official forms, but you should still read your state law or umbrella school handbook to see what else they require.
The grid is arranged around days, but you can adapt it if you need to show partial instruction. Some families use different symbols for full and partial days or write short notes such as “3 hrs” in the box. For very detailed hour tracking, you might keep a separate time log and use this sheet only to mark dates that included instruction of any length. The two records then work together when you explain your schedule.
This homeschool attendance sheet is available in Excel and Google Sheets and uses simple data validation in the daily cells so you can quickly mark each day and keep your entries consistent.
