Private tutor lesson hours spreadsheet from calendar bookings
Recurring lessons look simple until someone cancels twice and reschedules once. Export after the calendar tells the truth—not after your memory approximates it.
Written for Tutors and educators. Updated 2026-08-02.
Three families and one agency portal
Month-end: a math tutor needs a lesson log for three families and one agency portal. The recurrence still shows a canceled Wednesday that everyone forgot to remove.
Recurrences lie after cancellations
Counting from memory undercounts makeup lessons and sometimes bills canceled ones that still sit on a recurrence like ghosts.
Clean, then export
Update cancellations in Apple Calendar, export the month, spot-check the list for duplicates, then send or upload the right format to each party.
Month-end lesson log
Clear canceled instances
Walk the month in Apple Calendar and remove lessons that did not happen.
Export the tutoring calendar for the month
Avoid mixing personal events into the selection.
Skim for duplicate reschedules
Two events for one makeup session is a common mess—fix before sending.
Send the right format to the right party
XLSX for families, CSV when a portal insists.
Recurrence is convenient until it lies
If a family cancels, remove or cancel that instance. An export will happily include phantom lessons that still look “on the calendar,” and you will be the one apologizing.
Families vs agencies want different packaging
Parents often like a simple XLSX they can open on a phone. Agencies may want CSV. Same hours, different envelopes—do not force one format on every recipient out of habit.
Student names in titles
If the recipient should not see full names, use privacy mode. Operational calendars can stay detailed on your device. Attachments travel further than you think.
What I tell new tutors about recurrences
Recurring events are a gift until someone cancels. Spend two minutes walking the month before you generate the file. That is less painful than a parent email about a lesson that did not happen.
Teaching-side admin
- Cancellations must hit the calendar before export.
- Makeup lessons need single clean events.
- Privacy depends on who receives the file.
- Format follows the audience, not habit.
Questions people ask
How do I turn tutoring bookings into an hours spreadsheet?
Clean the month in Apple Calendar, select that calendar in Calendar2XL, export Excel or CSV, then review cancellations once more in the file.
Are recurring lessons handled?
Instances available to the system calendar are reported, with deduplication of repeated results. Canceled recurrences you leave active will still look real.
Can parents get a simple lesson log?
Yes—a short reviewed XLSX usually works. Use privacy mode if full names should not appear.