Free Lesson Payment and Attendance Sheet Template
A management sheet that records tuition payments in a student-by-month matrix, along with attendance for each lesson and the dates makeup lessons arise, expire, and get used. Made for teachers who run a piano, language, or dance studio on their own. Available as Excel and a print-ready PDF.
What it's for
- When you want to see at a glance who has paid this month's tuition and who has not
- When you want to record attendance for each lesson, along with the reason for any absence
- When you want to track when each makeup lesson arose, when it expires, and when it was used, so they never pile up
- When you want a start-of-month and end-of-month habit of reviewing your studio's money and schedule in one sitting
What's included
FAQ
Can I use this if my students pay different fees or take different numbers of lessons?
Yes. The roster side has fields for each student's monthly fee and course, so different rates and lesson counts fit on a single sheet. Combined sibling payments work too: note the combined payment in the memo field, then fill in one cell per child.
How should I record makeup lessons?
In the makeup list, give each makeup one line with three dates: the absence that created it, its deadline, and the date it was actually used. Recording when a makeup arises and when it is used as a pair means you can count the outstanding ones at any moment, and answer a parent's question with the record in front of you.
When should I use the Excel version versus the PDF?
If you prefer managing things on a computer or tablet, use the Excel version. If you would rather print it and write by hand, the PDF is the one. Some teachers keep the printed sheet in the same folder as their cash envelopes, so they can fill in the cell the moment a payment is handed over.
Notes on managing with paper or Excel
- Because every payment is written in by hand, entries get postponed on busy lesson days and gaps creep in.
- Totals such as outstanding tuition or this month's expected income have to be counted up by hand each time.
- Makeup deadlines only surface when you remember to look, so they can catch you off guard right before they expire.
- If you lose the paper or the file, your payment and makeup records can disappear all at once.
Why an app makes it easier
- Marking a payment as received takes a single tap, so you can update records between lessons, right on the spot.
- This month's expected income and outstanding payments are totaled automatically on the home screen, so there is nothing to count by hand.
- Today's lessons and the makeups still remaining are visible at a glance, so nothing slips through.
- Your records all stay together on your device, so you can manage the studio without worrying about lost sheets or copying errors.
Apps
Apps related to this template
Guides