Homeschool Planner Spreadsheet, Attendance and 180 Day Log for Excel & Google Sheets

Keep your homeschool year organized in one simple spreadsheet.

The Homeschool Planner & Attendance Tracker gives you one place for attendance, hours by subject, lessons and grades for up to 4 students. Mark attendance each day, log hours by subject, and track assignments. Each child's dashboard shows how many days they've attended toward your goal, how their subject hours compare with your weekly targets, and their average grade.

WHAT'S INCLUDED
• Student dashboard: pick a child to see days attended, days to go, attendance rate, total hours, lessons done, average grade and overdue lessons, plus a days-attended progress bar, hours by subject vs. target (with progress bars and an on-pace check), average grade by subject, and an hours-by-month chart
• Attendance log: 200 day rows (a 180-day year plus room for make-up days) with date, day number and a status for each student: P present, F field trip / co-op, A absent, S sick. Daily hours fill in from the Hours Log
• Hours log: one row per student per day, with hours for up to 12 subjects and notes on what you did
• Lessons & assignments (400 rows): student, subject, assigned and due dates, status, score, % and letter grade. Overdue lessons turn red
• Overview: every student side by side, hours by subject for each child (with a chart) and month-by-month days and hours
• Setup: school year, first day, number of school days (180 to start, change it to yours), weeks in the year, an optional yearly hours goal, up to 4 students, up to 12 subjects with weekly hour targets for each student, and an editable grade scale
• Start Here guide
• Two files: a blank planner and a filled-in example

A NOTE ON STATE REQUIREMENTS
Many families keep attendance and hour records for their state. Requirements are different in every state, so please check your state's requirements. This planner helps you keep organized records, but it is not legal advice and doesn't guarantee you meet any state's rules.

WORKS WITH
• Microsoft Excel (2010 or later, Windows and Mac, and Excel online)
• Google Sheets (free): upload the file to Google Drive and open it with Google Sheets

HOW IT WORKS
1. Purchase and download instantly from your Etsy Purchases page.
2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets.
3. Fill in the Setup tab, then mark attendance and log hours as you go.

PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• One school year per file. Keep a blank copy for next year.
• For personal use. Please don't resell or share the file.

How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed.

Questions? Send us a message. We usually reply within a day.