How good are you at 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
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.
Jessi, I would love a copy of your excel attendance tracker!
Send me an email through my contact page and I’ll send the file right over!
Jessi, is it possible for me to get a copy of this so I can give it to all my music teachers at school? My email address is jnorris@shoreschool.org. THANK YOU! :)
HI
Can you send me the excel attendance
This is awesome! Can I also ask for an excel copy please?
Hi Ms. Vandagriff,
Would you kindly email me an excel file of your “Attendance & payment tracker?” It looks great! Thank you!!
Thank you for offering this! I would like the excel file as well please.
Hi there. Thank you so much for making this available. It will help us so much!
Oh yes, may I get an email of the excel file? boopsloops@gmail.com
Thanks for sharing! Can I also receive a copy of the file, please? ShanFlynnMusic221@gmail.com.
Really appreciate you offering to share this. I would love a copy of your excel file.
Thank you.
This is exactly what I’ve been looking for. Can I also receive a copy of this file?
Hi! I’ve been looking for something like this- would you be able to send me a copy of the file? Thank you!
We would love to utilize this in our music store! If possible, please send to team@gorgecommunitymusic.com
I would like to have a copy of your excel file. Here is my email bibiewilson0993@gmail.com
Thank you! :)
This is very nice. Do you have an updated one now or are you still using this file? I would love to get a copy of it. stacysimpson8@ymail.com
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!
This looks great! Been trying to set up a lesson tracking system. Can you forward a copy of your file? Thank you very much.
Could you send me the excel file for this? thanks!
This looks great. Can you please send me the excel files also. Thank you!
Hi there, I am also having trouble in keeping track on my classes and I found info about yours. It looks great and would love to have a copy of it to have a try,
I’ve emailed it. :)
This looks great, thanks for sharing. Could I request a copy too please? Thanks!
Is a copy of this still available? Thanks!
I’ve emailed you. Thanks!
Love the template! Could you send me over one please? andyncharlotte@yahoo.com
Hi Jessi,
This is wonderful, thank you for sharing! Can you please also send me an excel copy? Thanks so much!
Hello! May I please have the excel version of this tracker? It looks great & easy to use :)
Hi Jessi,
Could I please have a copy of this spreadsheet for my guitar teacher. He needs something like this. He is so busy he forgets who has paid and who hasn’t.
Thanks,
Nick
Hi Jessi,
Can I have a copy of this please? My email address is reena_dosanjh@hotmail.com
thanks
Hi! Could you please send me the template?
cheers
Hi, Could you please send me this great template? Thanks in advance!
Yes,
I’d love it, too.
Thanks!
Vera
Hi, if this is still available, could you please send me a copy of your excel spreadsheet.
I’ve sent it to your email. :)
Hello–could I have a copy of the excel attendance tracker? Thanks so much :)
Hi this attendance sheet is perfect for what I’m looking for. Please send me a copy to mariame2@aol.com. Thank you so much!
Thank you for sharing your creative solution to a common problem. And I see it has stood the test of time…you originally posted some 5 years ago! I would be very grateful if i could receive a copy
Hello
This really looks great and helpful. If there is no bother, I wish to have a copy of the excel sheet. This is my email, aishaharrar@gmail.com
hello this really look helpful. Can please get a copy, my email address is kidsarehebest@yahoo.com
Hello! This lesson tracker looks perfect for my situation. Please send a copy to mshewan12@gmail.com. Thank you!
Sorry for the delay! I have emailed it to you. Enjoy!
I would love to have a copy of the excel sheets my email is bettrmusik@gmail.com
Hi, This is good. I would like to have a copy of the excel file. Thanks you so much. My e-mail is qiyong12@gmail.com
Hi, Can I have a copy of the excel file too? Thanks you. My email is qiyong12@gmail.com
Could I possibly get a copy of your attendance tracker too? Thanks!
My email is raquelmerritt28@gmail.com
I would love a copy of the excel file! This looks great!
I’ve emailed it to you. Sorry for the delay!
Hi! I am excited to use this for my private tutoring sessions. Please send it to me.
Thanks
Hello Jessi Vandagriff,
This is wonderful!
May I get a copy of this as an excel file?
My email is: williamwhittenmusic@gmail.com
Thank you so much for considering,
Best,
Will
Could I get a copy of this excel file for the attendance tracker?
leechenbd@gmail.com
thanks!