Life events

Home tuition fees: tracking sessions paid and missed classes

Home tuition fees tracking made simple: log each session, payment mode and missed-class adjustment so the monthly payment matches a calendar of sessions.

Editorial illustration for Home tuition fees: tracking sessions paid and missed classes

To track home tuition fees properly, keep a calendar of sessions and a short payment log side by side. Mark each class as held, missed by the teacher, or missed by your child, work out the monthly payment from the sessions actually held and the agreed rate, and note how you paid. When the payment ties to the calendar, there is nothing left to argue about at the end of the month.

What should you agree with the tutor first?

Most disputes about tuition fees are really disputes about rules that were never said aloud. Settle these in a simple message, and keep the message:

  • The fee: monthly, or per session, and for how many sessions a week.
  • What happens when the teacher cancels, and whether a make-up session is given.
  • What happens when your child misses a class, with and without notice.
  • What happens in exam weeks, holidays and festival weeks.
  • When and how you pay: UPI, cash or bank transfer, and on which date.

These terms are between you and the tutor, and what matters is that both of you understand them. Write them in plain words and send them to each other.

What does the session log look like?

DateStatusMake-up?Note
3 JunHeldNoFractions
5 JunMissed by teacherYesRain
7 JunHeldNoRevision
12 JunMissed by child, no noticeNoFamily function
14 JunHeld (make-up for 5 Jun)NoAlgebra

The statuses should be a short fixed list, so that you can count them with a formula. Five or six statuses are enough.

How do you calculate the monthly payment?

Say the agreed fee is ₹4,500 a month for 12 sessions, so the rate is 4,500 / 12 = ₹375 a session. In a month where the teacher held 10 sessions, missed 2 and gave 1 make-up (which counts as a held session), 11 sessions were delivered. The payment is 11 x 375 = ₹4,125, or you can carry the unused balance forward if you agreed that instead.

A spreadsheet formula for the number of sessions held is =COUNTIFS($B$2:$B$40,"Held*"), where the star matches 'Held' and 'Held (make-up...)'. The amount due is that count multiplied by the rate in a cell: =COUNTIFS($B$2:$B$40,"Held*")*$F$1. If you agreed a policy for child-missed classes, such as counting them as delivered, add another COUNTIFS for that status.

What if there is a disagreement?

Start by laying the log next to the tutor's own count, because the two are usually off by a class or two, and the difference is easy to find. If the rule itself is unclear, such as whether a class missed with notice should be paid, decide it together and write it down for next time. Staying calm and specific works better than arguing from memory. If the same gap appears every month, it usually means the log is being filled in too late, so agree that the tutor and you each note a class on the day it happens, and compare once a week rather than once a month.

Where do you keep the record?

A shared calendar or a simple sheet works. Many families put the session calendar on the fridge or in a notes app and keep only the payment in an expense record. SpendixAI can keep the payments under a Tuition category, from an uploaded bank or card statement for UPI and transfers, with cash payments entered by hand, so the yearly total is easy to see.

Month-end checklist

  1. Count sessions held, missed by teacher, and missed by child.
  2. Apply the agreed rule for each status.
  3. Calculate the amount due and share the working with the tutor.
  4. Pay by the agreed mode and record the date.
  5. Carry forward any unused sessions or make-ups into next month's log.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports