How to Manage Attendance & Fees for Offline + Online Batches in India

A practical system for Indian tutors running hybrid batches — attendance that works, fee tracking in Sheets and a reminder routine.

Last reviewed 2026-01-03 · 7 min read · By the Software Today desk.

Who this is for

Tutors running a mix of offline and online batches who want one reliable system before spending on software.

Quick summary

• One register per batch — physical or a Sheet — updated during class, not after.
• Fees go in a single Sheet with three columns that matter: due date, paid date, balance.
• A fixed weekly reminder routine beats any app you’ll abandon.

What you’ll need

• One Google Sheet (or register) per batch for attendance
• One master fee Sheet with student, batch, due date, paid date, balance
• WhatsApp broadcast lists per batch
• A fixed 15-minute weekly admin slot

The attendance habit

Mark attendance during the first five minutes of class — online or offline. For online batches, the meeting tool’s participant list is your register; paste it into the Sheet after class. The rule that makes any system work: never let attendance wait until evening.

The fee Sheet that actually works

• Columns: student, batch, monthly fee, due date, paid date, balance, last reminder sent
• Filter by “balance > 0” every Sunday — that’s your reminder list
• Send one polite WhatsApp reminder with a UPI link; note the date in the Sheet
• Second reminder after five days; pause-new-material rule after fifteen

Pros & cons

Pros

• Zero cost, zero learning curve
• Works identically for offline and online batches
• Your data stays yours — easy to move into software later

Cons

• Manual upkeep every week, without fail
• No automatic receipts or parent app

Our recommendation

Run this system for one full month. If you keep it up easily, you may never need paid software; if you slip, that’s your signal to buy a tool like Teachmint.