Everything in the teacher's phone
It is the first week of the month. A student says she paid on the 3rd. You scroll the UPI history, find an amount, a name that is not hers and a gap. Her husband paid from his account. The pack is not on the sheet. She is polite, you are tired, and the sheet is wrong. The sheet was fine in January with eleven students. In March there are thirty.
The sheet: one row per student
| Column | What goes in it | Why |
|---|---|---|
| Name, mobile, batch | As given at joining | Who they are and which group |
| Plan | Monthly, 10-class pack, drop-in, trial | What they bought |
| Start date and end date | Pack validity or month end | Expiry is the main source of arguments |
| Amount paid, date, UPI reference | Copy from the receipt | A trace for every rupee |
| Classes attended | A tick per class on a second tab | Who is fading |
| Next due date | Formula: end date plus one | Whom to message |
| Notes | Level, preferences, no health detail | Keep health details in the intake form, not here |
- Make one sheet the single record; do not copy to another one.
- Give edit rights to one other person at most, and keep a back-up copy once a month.
- Use conditional formatting for next due dates in the next seven days.
- Keep an attendance tab: one row per class, one tick per student.
UPI: a business QR and a reference
Take fees on a business UPI QR or a payment link, not the teacher's personal account, so that income is recorded in one place. UPI payments up to ₹2,000 are free to the payer and the receiver by law, and a small merchant receiving up to ₹1,00,000 a month a month through a UPI QR pays no charge on any payment. Check the current position on UPI and payments, because a charge on larger payments was announced and its start date was postponed.
- Ask students to put their name and batch in the payment note.
- Copy the UPI reference into the sheet the same day.
- Send a receipt on WhatsApp, with the pack validity.
- Do not accept cash without writing it down.
A payment gateway or link adds a platform fee of about 2% of the transaction, plus 18% GST on the fee; see collecting monthly fees.
GST and the sheet
GST on yoga and fitness classes is 5% GST, without input tax credit. You must register once your yearly turnover from services crosses ₹20 lakh (a lower limit applies in a few special-category states; check yours). From the day you register, each receipt becomes a tax invoice with your GSTIN, and the sheet needs a column for the tax. Registration is covered in GST registration. A sheet can hold this until you are issuing many invoices a day; after that, software is easier.
WhatsApp: one group per batch
Use one admins-only group per batch for timings and cancellations; the rules for keeping it quiet are on WhatsApp groups for yoga batches. Use WhatsApp Business for one-to-one replies, with a greeting and quick replies for the price, the timings and the trial class.
Where it breaks, and when to move
- You cannot tell in two minutes who has paid, who attended and whose pack is about to expire.
- A second teacher or a second room starts sharing the sheet.
- You are sending more than thirty reminders a week by hand.
- Students ask to book and cancel online.
- You need to issue many GST invoices.
At that point, look at yoga studio software. Moving is easier from a clean sheet: keep the columns above, and the export is a file you already have.
Privacy and records
A sheet with student names and numbers is personal data. Keep it private, share it with as few people as possible and do not leave it open to anyone with a link. Keep health forms separate. The main data-protection duties start on 13 May 2027. Keep your payment records for the period your CA advises.
What usually goes wrong
- Payments to a personal account, with no record of what they were for.
- Two copies of the sheet, with different numbers.
- No expiry date on packs, then a dispute about unused classes.
- Health details in a shared sheet.
- Waiting until thirty students to start tracking.
Apply it to your studio
Copy the columns above into a new sheet today and fill in your current students. Switch your UPI to a business QR if it is still personal. Tell us how many students and batches you run and how you take fees, and we can tell you whether it is time to move.
Questions people ask
Is a Google Sheet enough for a small yoga studio?
Yes, for one teacher and two or three batches, if it is the single record and you keep a back-up. Move to software when you cannot see who has paid and attended.
Can I take fees on my personal UPI?
It works, but a business QR or payment link keeps income in one place and makes tax filing easier. Record every payment in the sheet.
When do I have to charge GST on my yoga classes?
Once your yearly turnover from services crosses the registration limit, the rate is 5% without input credit. A lower limit applies in a few states, so check yours.
Where these numbers come from
- UPI payment size up to which no bank or payment provider may charge the payer or the receiver: ₹2,000 (all India, by notification of 14 September 2026 under section 10A of the Payment and Settlement Systems Act 2007; applies per payment). Official source: Gazette of India, Ministry of Finance notification S.O. 5067(E), 14 September 2026, checked 9 November 2026.
- UPI QR receipts a month up to which a small shop pays no UPI charge on any payment: ₹1,00,000 a month (all India; the person-to-person-merchant (P2PM) category, a QR paying into the owner's own account; zero charge continues under the new framework; above this for 3 months in a row, the shop moves to the ordinary merchant category; GST registration not needed). Official source: NPCI, FAQs on Merchant Discount Rate (MDR) on select UPI (P2M) transactions, 15 September 2026, checked 9 November 2026.
- Payment gateway fee on a standard plan: 2% of the transaction, plus 18% GST on the fee (India; UPI has no merchant discount rate but the platform fee is still charged; UPI Autopay on request; payment links have no separate rate). Reported: Razorpay, pricing (2% plus 18% GST on the fee; UPI is zero MDR but the platform fee still applies), checked 13 November 2026.
- GST on gym, fitness-centre, health-club and yoga services: 5% GST, without input tax credit (all India; applies to memberships and personal training from 22 September 2025. 2.5% CGST plus 2.5% SGST within a state. Charging the old 18% with credit is not allowed). Official source: Ministry of Finance, Notification No. 15/2025-Central Tax (Rate), 17 September 2025, effective 22 September 2025, checked 10 November 2026.
- Turnover above which GST registration is compulsory (services, or goods and services): ₹20 lakh (all India except Manipur, Mizoram, Nagaland and Tripura (₹10 lakh there); turnover in a financial year). Official source: CBIC, CGST Act 2017, section 22, checked 7 November 2026.
- Date your obligations as a data fiduciary under the DPDP Act start: 13 May 2027 (all India; consent notices, security safeguards, breach notification, erasure and children's data. The Data Protection Board is already in place). Official source: Gazette of India, MeitY notification G.S.R. 843(E), 13 November 2025: commencement dates of the DPDP Act, checked 10 November 2026.
Fees, rates and rents change. Check the official source before you pay or sign anything.
Operations · Yoga studio
More on operations for a yoga studio
18 pages on this. You are on number 4.
- Which software runs a yoga studio's bookings and memberships in India, and what does it cost?
- A yoga student hurt her back and blames me. What now, legally and with my insurer?
- Can a small yoga studio run on WhatsApp, Google Sheets and a UPI QR?
- How do I collect monthly yoga fees automatically: UPI Autopay, payment links, gateway charges?
- How do I handle a student with a heart, back or other condition, and when do I say no?
- How do I record classes with students' consent and stop recordings being shared?
- My mid-day and evening batches are empty. Cut them, change them or market them?
- Only two students came to my 6 am class. Should I cancel it?
Reading about it is one thing; doing it in your yoga studio is another. If you'd like a hand running it smoothly day to day, tell us where you are and a person will reply, free.
Get help with this ↓What now?
Where are you?
One tap, and we point you to the right next step.