Guide
Running school fees in Excel, and when it stops working
A spreadsheet is not the wrong tool for a small school. It is the wrong tool for a second person. This is where the line actually falls.
Almost every private school in India starts fees the same way: one workbook, one receipt book, and one person who understands both. That arrangement works, and it keeps working for longer than software companies like to admit. Then it stops, and it rarely stops gradually.
What follows is not an argument that spreadsheets are bad. It is the five specific points at which a school stops being able to answer the question what does this family owe today without asking a person.
Two people open the file
The accountant edits the master sheet while the front desk works from a copy sent on WhatsApp last Tuesday. Both are now right, and they disagree.
What it costs: Nobody can say what a family owes without asking a person. The answer changes depending on who you ask.
A receipt is written out of order
Receipt books are issued to more than one counter, or a spoiled leaf is torn out. The numbers now have gaps and duplicates.
What it costs: An auditor cannot follow the series, and neither can you. Proving no receipt is missing becomes a manual reconciliation.
A concession is agreed verbally
A principal tells a family their second child pays half. It reaches the sheet as an edited number, with no record of who approved it or why.
What it costs: At year end the collection total is short and no one can explain the gap without remembering a conversation.
Fees change mid-year
A revised transport charge goes into next month's sheet but not into the invoices already issued.
What it costs: Two families on the same route are billed differently, and the first one to notice tells the rest.
The person who built the sheet leaves
The formulas, the hidden columns and the one tab nobody touches were all in one head.
What it costs: The school keeps using it and stops trusting it, which is worse than either.
The test
One question tells you whether you have outgrown it
Ask two people in your office, separately, what a named family owes right now. If the answers match and both were reached without opening a second file or ringing anyone, your spreadsheet is still doing its job. Keep it.
If they differ, or if getting the answer required someone to remember something, the spreadsheet is no longer the record. It is a report on a record that only exists in people's heads.
Questions
Asked by schools mid-move
Is a spreadsheet actually wrong for a small school?
For 80 students it is genuinely fine, and anyone telling you otherwise is selling something. The break is not size, it is the second person. Once more than one person records money, a spreadsheet has no way to say which version is true.
What should a school move first?
Fee structures and invoicing, not attendance. Once what a family owes is computed by one system rather than typed, everything downstream stops disagreeing: receipts, outstanding lists, reminders and the year-end total.
What happens to the history already in Excel?
It gets imported, whatever shape it is in. Opening balances matter more than years of detail: what each family owes on the day you start is the number the new system has to agree with.
Can the fee counter still take cash?
Yes, and it should. The counter records the payment and issues a numbered receipt, and the day is closed by counting cash against what the system says was collected. The point is not to remove cash, it is to make the count checkable.
How long does moving take?
The data import is the short part. The part that takes time is agreeing who is allowed to change a fee, approve a concession or waive a late fee, because in a spreadsheet the answer was everyone.