You can collect fees online and offline without spreadsheets by keeping every payment, whatever the method, in one system that also knows who each student is and what they owe. Online payments come through a payment gateway and are recorded automatically; cash and bank transfers are entered by staff with a receipt. The result is a single record you can trust, instead of a sheet that is only as accurate as the last person who updated it.
Why spreadsheets break down for fee collection
Spreadsheets feel free and flexible, which is why most coaching centres start with one. The problems appear as the academy grows. A parent pays by bank transfer, the owner notes it on their phone, and the office assistant never updates the sheet. Two people edit different copies. A student who paid in cash is sent a reminder anyway, and the parent is understandably annoyed.
The deeper issue is that a spreadsheet does not connect to anything. It does not know when a student enrols, when a batch changes or when a payment arrives online. Every link between those facts depends on someone remembering to type it in. That is manageable for a handful of students and fragile for anything larger.
Start with a clear fee structure
Before choosing any tool, write down how you actually charge. Most academies use a mix of the following:
- One-time course fees for recorded or cohort-based programmes.
- Recurring monthly or term fees for ongoing batches.
- Memberships that give access to a set of classes or content.
- Instalment plans for longer or more expensive courses.
- Trial classes or introductory offers, sometimes with a coupon.
Once the structure is on paper, you can see which fees suit online checkout and which will still arrive as cash or transfer. Being honest about this matters: in many centres, some families will always prefer to pay at the front desk, and your process should respect that rather than fight it.
Online payments: let the gateway do the recording
For online fees, the aim is that nobody has to type anything. A student or parent pays through a checkout page, the payment gateway confirms the transaction, and the system marks the order as paid and records it against that student. A good setup checks the gateway's confirmation properly before treating an order as paid, so a failed or abandoned payment is never mistaken for a successful one.
A few practical points help here:
- Choose a gateway that suits your students. Learners in India may prefer local payment methods, while international students may need a gateway that handles other currencies.
- Send a receipt or invoice automatically, so parents never have to ask for one.
- Tie each payment to a specific course, batch or fee demand, so the money is matched to the right purpose from the start.
Offline payments: record them in the same place
Cash and bank transfers are where most fee records go wrong, because they happen outside any system. The fix is simple in principle: every offline payment is entered into the same place as online payments, by the person who received it, at the time it was received.
A sensible offline routine looks like this:
- The staff member receiving the payment records the amount, method and date against the student's account.
- A receipt is generated and shared with the parent or student straight away.
- For bank transfers, the entry notes the transaction reference so it can be matched against the bank statement later.
- At the end of each day or week, the owner reviews offline entries against cash in hand and bank credits.
When offline entries sit alongside online ones, your revenue and outstanding-fee reports show the full picture, not just the part that went through a gateway.
Fee demands and reminders instead of chasing
The most uncomfortable part of running an academy is often asking families for money. A fee demand makes this less personal. It is a clear request tied to a student, an amount and a due date, and the system can send reminders as that date approaches or passes. Staff then only step in for genuine exceptions, such as a family going through a difficult month, rather than chasing every overdue fee by hand.
Keep reminders polite and factual: what is due, for which course or batch, by when, and how to pay. Never send a reminder to someone who has already paid at the desk, which is one more reason offline payments must be recorded promptly.
Reconcile weekly, not at year end
Even with a good system, a short weekly check prevents surprises. Compare the payments report with your bank credits and gateway statements, look through the list of overdue fees, and review any refunds. When a refund is issued, make sure your reports reflect it so revenue is not overstated. A weekly habit takes little time and means your year-end figures are already clean when your accountant asks for them.
Where MBSGuru fits
MBSGuru records online payments through supported gateways such as Razorpay, Stripe and PayPal, and lets staff record cash and bank transfers with receipts in the same system. Fee demands, reminders and invoices are built in, and revenue, payment and invoice reports can be exported. See how payments connect to enrolment and reporting on the platform page, or start free to try it with your own fee structure.
