Homeschool Planner Spreadsheet, Homeschool Attendance Tracker, Hours Log, Homeschool Record Keeping, Gradebook, Transcript, Google Sheets

A homeschool planner spreadsheet for one to four children. The school year, lessons, attendance, hours, grades, books and records are in one file.

🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/1R46E0FP4WFj7PDSEYTMaEVkDwr5W8seCulfVUkHzOMs/edit?gid=1575893288

Log what you did each day, and the file counts school days and hours toward your state's goal, like 180 days or 1,000 hours.
One spreadsheet you keep, not a yearly app subscription.

📊 WHAT IT DOES

✓ School Year: the first day, your school week, up to 4 children and a calendar of breaks, sick days, half days and field trips.
✓ Lesson Log: one line for each lesson: the date, the child or All kids, the subject and what you did. Minutes fill in for you.
✓ Attendance: the school year on one page for each child, with school days, half days, days off and breaks marked.
✓ Subjects: the plan for each child and subject: lessons in the book, lessons a week, what is done, the pace and the finish date.
✓ Week: one child's subjects across the week, planned and done side by side.
✓ Report Card: one child and one term on a page, with grades, lessons, hours, school days and books.
✓ Transcript: high school courses with credits and final grades, and the GPA, plain and weighted.
✓ Year Summary: school days, hours and core hours for each child, and hours by subject.
✓ Reading Log, Portfolio and Budget: books read, work samples by term, and school costs with money waiting to be paid back.
✓ Home: one card for each child with school days, hours, this week, subjects behind pace and the grade average.

📂 WHAT'S INSIDE: 14 TABS AND 36 CHARTS

✓ Start with these three: Start here, School Year, Lesson Log
✓ Look: Home, Attendance, Week, Report Card, Year Summary
✓ Keep a record: Subjects, Reading Log, Portfolio, Budget, Transcript
✓ Set up once: Settings

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On School Year, fill in three cells: the first day, a child's name and the grade. The file lays out 180 school days.
3. On Lesson Log, add a line for each lesson. The date and the subject are enough.
4. On Settings, set your state's goal: school days, hours or core hours. Add breaks and days off on School Year.
5. Everything else fills in by itself. Home shows each child's school days, hours and subjects behind pace.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel on Windows or Mac
✓ A filled example to look around, and a blank copy for your own data
✓ A PDF guide: a picture of every tab and your first five minutes, step by step
✓ A video guide for this planner (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. Nothing to install, no subscription.
✓ Formulas are protected, so you can't break anything by accident.
✓ Attendance your way: a day counts when a lesson is logged, or every calendar school day counts and you mark only days off.
✓ All kids: log a family lesson once and it counts for every child.
✓ Room for 4 children, 2,500 lesson lines, 40 subject plans, 300 books, 300 portfolio items, 300 costs and 60 courses.
✓ Terms split your school days evenly: 4 quarters, 2 semesters or 3 trimesters.
✓ Amounts show in dollars. The formulas work the same in any currency.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for quick entries on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas.
✓ On a Mac? Use free Google Sheets or Excel for Mac.
✓ Free updates for life.

This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.
This planner keeps your own records. It is not legal advice, and homeschool laws differ by state. Check what your state asks for.