School fee collection: registers vs spreadsheets vs a school ERP
An honest comparison of the three ways Indian schools collect fees, with the point at which each one stops working.
On this page
Every school collects fees, but very few enjoy it. The accounts desk is crowded in the first week of every quarter, parents want receipts on WhatsApp, and the principal wants to know who hasn't paid before the management meeting. Whether you manage this with a register, a spreadsheet or school software, the right answer depends on your size and how many fee rules you have.
Here is how the three approaches compare, and the signs that it's time to move on.
The three ways schools collect fees today
Fee registers and receipt books are still common in preschools and small schools. They cost nothing, need no training and work during power cuts.
Spreadsheets are the usual next step. A class-wise sheet with a column per month or term makes totals easier, and most accountants already know Excel.
A school ERP records fees against each student's profile, generates receipts automatically, and connects fees to admissions, attendance and report cards.
Side-by-side comparison
| What matters | Register | Spreadsheet | School ERP |
|---|---|---|---|
| Time to issue a receipt | 2–3 minutes, handwritten | 1–2 minutes, then a separate receipt | Seconds, printed or sent on WhatsApp |
| Knowing who is overdue | Counting page by page | Possible with filters, if the sheet is up to date | Always current, class-wise and by amount |
| Concessions and sibling discounts | Remembered by the accountant | Manual formulas that break easily | Rules applied automatically to every bill |
| Reminders to parents | Phone calls | Copy-paste messages | Scheduled SMS or WhatsApp reminders |
| Audit trail | Overwriting and corrections are visible, but hard to trace | Anyone can change a cell without a record | Every change logged with user and time |
| Upfront cost | Almost nothing | Almost nothing | Monthly or yearly subscription |
| Effort to start | None | A few days to design the sheet | About a week, including data import |
When a register is enough
If you have fewer than about 100 students, one or two fee heads and parents who mostly pay in person, a well-kept register works. The weaknesses are dues tracking and the time it takes to answer a parent's question about past payments.
When spreadsheets start to break
Spreadsheets usually stop working somewhere between 300 and 500 students, or earlier if you have transport fees, hostel fees, sibling concessions or instalment plans. The warning signs are familiar:
- Two versions of the fee sheet, and nobody is sure which one is right.
- Receipts that don't match the sheet because they were written separately.
- Month-end totals that take a day to prepare.
- Only one person who understands the formulas.
What a school ERP changes
The biggest difference isn't speed at the counter. It is that fees stop being a separate record. When a student is admitted, their fee structure is created from the class and concessions. When a parent pays online or at the desk, the receipt, the dues report and the student's ledger all update together. Reminders go only to parents who actually owe money.
The trade-offs are real too: a subscription cost, a week of set-up, and staff who need a few days to get comfortable.
How to decide
Answer these five questions:
- How many students do you have, and how fast are you growing?
- How many fee heads and concession rules do you use?
- How long does it take to produce a list of overdue fees today?
- What would happen if your accountant left next month?
- Do parents ask for online payment and digital receipts?
If you answered "more than 300", "several", "more than an hour", "we'd struggle" or "yes" to two or more, a school ERP will likely pay for itself in staff time and better collections.
Switching in the middle of the academic year
You don't have to wait for April. Import each student's fee structure and what they have already paid this year, check the dues report against your current sheet for a few classes, and start issuing receipts from the new system on a Monday. Keep the old register or sheet read-only for reference until the year closes.
School ERP covers admissions, fees, attendance and report cards, and imports your existing fee sheet during onboarding.