Tutor Payment Tracker Template

Keep one row per lesson and record payments separately when the money actually arrives. That makes outstanding fees and advance credit easier to distinguish.

The free CSV above contains clearly labelled example rows that you can replace with your own records.

• • Student name
• • Lesson date
• • Lesson fee
• • Payment date and amount received
• • Paid, outstanding, or covered by credit
• • A short payment reference or note when needed

A separate payment date matters because the date you teach and the date a parent pays are not always the same.

1. 1. Record each completed lesson. Add the date and fee while the session is still fresh.
2. 2. Record money when it arrives. Keep the amount and payment date, rather than simply changing a lesson to paid.
3. 3. Match the payment. Apply it to the relevant outstanding lesson or keep the remainder as advance credit.
4. 4. Review once a week. Check the outstanding list and follow up before small gaps become difficult to trace.

If a parent pays for several lessons in one transfer, record that as one payment. Use the money against completed lessons first, then keep any amount left as student credit.

This avoids inventing payment dates for future lessons and makes the remaining balance much easier to explain.

A spreadsheet can work well for a small number of students. It usually becomes harder when students pay in advance, one payment covers several lessons, or lesson notes and payment records live in different places.

At that point, the useful change is not a more complicated spreadsheet. It is keeping lessons and payments connected so totals update from the records you already make.