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.
Written for Tutors and educators. Updated 2026-08-05.
Three families and one agency portal
Month-end: a math tutor needs a lesson log for three families and one agency portal.
Recurrences lie after cancellations
Counting from memory undercounts makeup lessons and sometimes bills canceled ones that still sit on a recurrence.
Clean, then export
Update cancellations in Apple Calendar, export the month, spot-check the list, then send or upload.
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.”
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.
Student names in titles
If the recipient should not see full names, use privacy mode. Operational calendars can stay detailed on your device.
What I tell new tutors about recurrences
Recurring events are a gift until someone cancels. If you leave the canceled instance on the calendar, the export will bill a lesson that never happened—and you will be the one apologizing. Spend two minutes walking the month before you generate the file. That is less painful than a parent email.
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.