Lesson Attendance Sheet & Payment Tracker

FREE attendance and payment tracker for music teachersWe are a few weeks into the new school year. Have you been keeping track of your students’ tuition payments? How about their attendance?

I haven’t always been good at keeping track of tuition payments and attendance. I always think that I’ll be able to remember if I’ve been paid or not—and then I never can. I ended up teaching more than my promised 42 lessons this past school year due to bad record keeping. Oops.

It’s important for me to keep attendance records because I teach on a monthly tuition system. Some months I only teach two lessons per student. Some months I teach five, yet the parents pay the same for both. I need to be able to show my studio parents that over the course of the year, they get their promised number of lessons.

I’ve tried a few different methods for keeping track. I tried an app called Moosic Studio (no longer available). I didn’t love it for tracking attendance. I tried Joy Morin’s attendance tracker. I didn’t love it either. Too many wrong dates. Using the parts of those two attendance trackers that I did like (and a template from Excel), I made my own. Feel free to adapt it and use it. I just ask that you link back to my blog if you post it anywhere online.

Lesson Attendance Record Template

sample attendance record

Here is an example of how I fill it out. I write the date for any lessons that I teach. If a student cancels, I write “C”. If a student cancels within 24 hours of the lesson I mark it as a late cancellation (“LC”). I sometimes allow make-up lessons for those lessons that were cancelled well in advance.

I have a few every-other-week students. That’s why there are some dashes. Some students pay a semester at a time, so I fill in all the “$” boxes for the months they have paid for. The grey box shows that there aren’t five Thursdays in September this year.

I hope you find this helpful! If you’d like me to send you the actual Excel file so you can edit it more easily, just send me an email.


18 thoughts on “Lesson Attendance Sheet & Payment Tracker

  1. Hi Ms. Vandagriff,
    Would you kindly email me an excel file of your “Attendance & payment tracker?” It looks great! Thank you!!

    1. I’m still using the main template. I don’t go to the trouble of blacking out extraneous days of the month. I just do it with a pencil as needed. Watch your email. I’ll be sending the template over. Enjoy!

  2. This looks great! Been trying to set up a lesson tracking system. Can you forward a copy of your file? Thank you very much.

Leave a Reply

Your email address will not be published. Required fields are marked *