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. 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.

 

7 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!!

Leave a Reply

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