Income and work

Home tutoring income: tracking cash, UPI and monthly-pack fees

A per-student fee tracker for home tutors that handles cash, UPI, advance monthly packs and cancelled classes, with a made-up example and simple formulas.

Editorial illustration for Home tutoring income: tracking cash, UPI and monthly-pack fees

A home tutor can track fee income with one row per student per month: classes held, fee due, amount received, how it was paid and what is still pending. Put cash and UPI in the same sheet, and record advance packs as money received for classes not yet taught. That way you always know who has paid, and what you still owe in classes.

What should each student's row contain?

  • Student name and subject.
  • Fee model: per class, or a monthly pack for a fixed number of classes.
  • Pack start date and number of classes in the pack.
  • Classes held, classes cancelled by you, classes cancelled by the student.
  • Fee due, amount received, date received and mode (cash or UPI).
  • Balance: received minus earned.

Use the same layout for every student, even if only some use packs. A per-class student is just a pack of one.

How do I handle an advance monthly pack?

Say a student pays ₹2,400 by UPI on the first for eight classes, which works out to ₹300 a class. On the 15th, five classes have been held. The fee you have earned so far is 5 × ₹300, which is ₹1,500. The remaining ₹900 is for three classes still to be taught. Write that ₹900 in a column called Owed in classes, so you remember it is not yet fully yours to treat as income.

If you cancel a class, it is yours to make up. If the student cancels with short notice, follow the rule you told the family at the start. Whichever rule you use, note it on the sheet, because it avoids arguments later.

What does a month look like with three students?

These figures are made up.

StudentModelClasses heldFee earnedReceivedBalance
Student APack of 8 at ₹3007₹2,100₹2,400 UPI₹300 advance
Student BPer class at ₹3006₹1,800₹1,800 cash₹0
Student CPack of 10 at ₹25010₹2,500₹2,000 UPI₹500 due

Fee earned across the three students is ₹2,100 plus ₹1,800 plus ₹2,500, which is ₹6,400. Received is ₹2,400 plus ₹1,800 plus ₹2,000, which is ₹6,200. The difference is ₹200: Student A's ₹300 advance in hand, less Student C's ₹500 due.

Which formulas help?

With classes held in D, rate per class in E and amount received in G, fee earned in F is =D2*E2 and balance in H is =G2-F2. A positive balance is an advance, a negative one is money due. If a student pays for the next pack before the current one is finished, add the new payment on a new row with its own start date, so the old balance does not get lost. To total what is pending for the month, use =SUMIF($H$2:$H$100,"<0"). To total all advances you are holding, use =SUMIF($H$2:$H$100,">0").

How do I keep track of cash?

Cash is easy to forget. When a parent hands over notes, add the row the same evening, with the date and an initial, "C" for cash. At month end, add the cash column and check that the amount matches what you have put aside from tuition. UPI payments will also be in your bank statement, so tick them off there.

Where can SpendixAI help?

If your bank statement is full of UPI credits from parents, you can upload it into SpendixAI, review the rows before saving, and label tuition credits so they are separate from other incoming money. Your per-student sheet remains the place for classes and balances.

End-of-month checklist

  • Count classes held and cancelled for each student.
  • Check every student's balance against the pack they bought.
  • Message families whose balance is due, in a polite standard text.
  • Match UPI entries with the statement and tally cash in hand.
  • Note whether anyone has dropped out and when their pack ends.
SPENDIXAI JOURNAL

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

Explore your reports