Lesson Attendance Sheet & Payment Tracker

FREE attendance and payment tracker for music teachersHow good are youat  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.

 

25 thoughts on “Lesson Attendance Sheet & Payment Tracker

  1. Reply
    Nancy Calkins - June 5, 2016

    Jessi, I would love a copy of your excel attendance tracker!

    1. Reply
      Jessi Vandagriff - June 6, 2016

      Send me an email through my contact page and I’ll send the file right over!

  2. Reply
    Michael - July 10, 2016

    HI

    Can you send me the excel attendance

  3. Reply
    Miaa Macadaan - September 1, 2016

    This is awesome! Can I also ask for an excel copy please?

  4. Reply
    Diana Colon - April 13, 2017

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

  5. Reply
    Merrilee McCain - August 6, 2017

    Thank you for offering this! I would like the excel file as well please.

  6. Reply
    A - October 16, 2017

    Hi there. Thank you so much for making this available. It will help us so much!

  7. Reply
    betty gavin - October 28, 2017

    Oh yes, may I get an email of the excel file? boopsloops@gmail.com

  8. Reply
    Shannon Flynn - December 27, 2017

    Thanks for sharing! Can I also receive a copy of the file, please? ShanFlynnMusic221@gmail.com.

  9. Reply
    Cat Griffin - January 20, 2018

    Really appreciate you offering to share this. I would love a copy of your excel file.
    Thank you.

  10. Reply
    Jacklyn Diffee - February 8, 2018

    This is exactly what I’ve been looking for. Can I also receive a copy of this file?

  11. Reply
    Vanessa - February 11, 2018

    Hi! I’ve been looking for something like this- would you be able to send me a copy of the file? Thank you!

  12. Reply
    Ursula - April 18, 2018

    We would love to utilize this in our music store! If possible, please send to team@gorgecommunitymusic.com

  13. Reply
    Elvina Lyna - August 23, 2018

    I would like to have a copy of your excel file. Here is my email bibiewilson0993@gmail.com
    Thank you! :)

  14. Reply
    Stacy - August 29, 2018

    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

    1. Reply
      Jessi Vandagriff - August 29, 2018

      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!

  15. Reply
    Elaine Keener - September 4, 2018

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

  16. Reply
    Cynthia Denio - October 12, 2018

    Could you send me the excel file for this? thanks!

  17. Reply
    Jamie McCrum - November 8, 2018

    This looks great. Can you please send me the excel files also. Thank you!

  18. Reply
    Kingsley Chen - December 16, 2018

    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,

    1. Reply
      Jessi Vandagriff - December 17, 2018

      I’ve emailed it. :)

  19. Reply
    Danny - December 26, 2018

    This looks great, thanks for sharing. Could I request a copy too please? Thanks!

  20. Reply
    Janis - December 31, 2018

    Is a copy of this still available? Thanks!

    1. Reply
      Jessi Vandagriff - December 31, 2018

      I’ve emailed you. Thanks!

  21. Reply
    CHARLOTTE FOSTER - January 7, 2019

    Love the template! Could you send me over one please? andyncharlotte@yahoo.com

Leave a Reply

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

Scroll to top