A flat monthly batch fee plus the odd drop-in looks like a fixed cost with small extras, and the real picture stays hidden. Add both amounts for the month and divide by the total number of classes you attended, and you get one honest cost per class.
What should the tracker record?
- Date of each class
- Type: batch or drop-in
- Teacher or studio, if you attend more than one
- Amount paid for that class, if it was a drop-in
- Monthly batch fee and the date it was paid
- Attended, missed or cancelled by the studio
Keep the batch fee in its own cell, so it is counted once, and not in the class rows. Drop-in classes go in the rows with their own price.
How do I work out what each class cost?
Say your monthly batch fee is ₹2,000 for the month, you attended 12 batch classes and took 3 drop-ins at ₹300 each. The figures are just an illustration.
| Item | Working | Amount |
|---|---|---|
| Batch fee | one payment | ₹2,000 |
| Drop-ins | 3 x ₹300 | ₹900 |
| Month total | 2,000 + 900 | ₹2,900 |
| Classes attended | 12 + 3 | 15 |
| Average cost per class | 2,900 / 15 | about ₹193 |
| Batch classes alone | 2,000 / 12 | about ₹167 |
The batch classes cost about ₹167 each and drop-ins ₹300, so the blended average sits in between. In a month when you miss most batch classes, the batch figure rises sharply, which is a useful nudge.
Which formulas help?
With the type in column B and the amount in column C, =SUMIFS($C$2:$C$60,$B$2:$B$60,"Drop-in") totals the drop-ins, and =COUNTIF($B$2:$B$60,"Batch") counts batch classes attended. Add the batch fee from its own cell to the drop-in total and divide by the total number of rows with an attended status.
What if I pay for a quarterly or festival batch?
Some studios sell a three-month batch or a short special series around a festival or a new year. Enter the amount on the day you paid and note the period it covers, then divide it across those months in your monthly view if you want a smoother number. A single large payment is easy to mistake for a spike in spending when it is really three months of yoga.
Is a drop-in ever cheaper than the batch?
It can be, in a month when you will attend only a few classes. With the same invented numbers, a ₹2,000 batch against ₹300 drop-ins breaks even at 2,000 / 300 = 6.67 classes, so you would need at least seven classes in the month for the batch to cost less per class. If you regularly go five or fewer times, the sums favour drop-ins; if you go more often, they favour the batch. Do this with your own fee and your own attendance.
Do not forget small extras: a mat, a bag, bolsters or a studio towel service. Log them under the same label so that the cost of the habit is not understated.
How does this appear in the household budget?
Yoga classes are a fitness or health expense, depending on how you categorise. Pick one and keep to it. If the studio takes UPI, the payments appear on your statement, and the drop-in payments can be matched with your attendance log. A tool such as SpendixAI will list them with the studio name once you import a statement, and cash payments can be added by hand.
A simple monthly routine
- Note each class the same day you attend
- Record the batch fee when you pay it
- At month end, add the drop-ins and the batch fee
- Divide by classes attended
- If the cost per class is climbing, look at which days you skipped and why
Useful ideas start with a clearer picture of your own spending.
Explore your reports


