Most schools can tell you roughly what they are owed. Far fewer can produce, on demand, a list of which families owe it and for which months — and that gap is where fee collection quietly fails.
The total is easy. It is the breakdown that decays, because a balance moves through three events that a fee register kept by hand does not survive.
The three places a balance goes missing
1. A family pays part of a challan
A challan for 8,000 is paid 5,000 in cash at the counter. What happens to the remaining 3,000 depends entirely on how the receipt was written. If the register records “paid”, the balance is gone. If it records the shortfall in a margin, it survives exactly as long as anyone remembers to read that margin.
Part payment has to be a first-class event, not an exception handled in pen. The challan stays open, the amount paid is recorded against it, and the remainder is still attached to the month it was billed for.
2. A student is promoted
This is the one that surprises schools, and it is worth being concrete. If your records find a student’s dues by looking at their current class, then the moment they move from Grade 4 to Grade 5, last year’s unpaid challans are filed under a class they are no longer in.
The balance has not been cancelled. It has become unfindable, which in practice is the same thing — it surfaces two years later when somebody asks for a leaving certificate.
The fix is structural: a charge belongs to the year and class that billed it, permanently, not to wherever the child sits now.
3. A sibling discount changes mid-year
Two children, one family, a discount that applied to the second child until the eldest left. Unless the discount is recorded as a rule with a date rather than a number typed into a challan, every recalculation afterwards disagrees with the receipts already issued.
Carrying arrears forward — and the trap in it
The natural next step is to roll last term’s balance into the new challan so a family sees one number. That is right, and it introduces a hazard worth naming because it is easy to build wrong:
once a balance is carried into a new bill, the original challans are still open. Add them up and you have counted the same money twice — once where it was billed and once where it was carried. A school doing this by hand usually discovers it when the total owed exceeds anything plausible.
So a carried-forward balance needs two things:
- The source charges are marked as carried, so any total knows to skip them.
- They are not deleted, so the record of what was originally unpaid survives. Deleting them “tidies” the ledger by destroying the only evidence of what the family was actually billed for.
What to chase, and in what order
A defaulters list ordered by size is the wrong list. Chase by age first: a family three months behind is a different conversation from one who missed last week’s due date, and treating them identically loses the first and annoys the second.
Practically, for most schools here:
- Under 30 days — a WhatsApp message with the amount and the challan number. Most of this bucket is genuine forgetfulness.
- 30–90 days — a call, and an offer to split the balance. A school that will not accept 2,000 a month against a 10,000 balance usually collects nothing instead.
- Over 90 days — a meeting, with the family’s full history in front of you. This is where the year-by-year breakdown earns its keep; “you owe 46,000” is arguable, and “you owe 46,000, made up of these eleven challans” is not.
Before a promotion run
Check arrears before you promote a class, not after. A promotion is the event that makes an old balance hard to find, so the sensible order is:
- Produce the arrears list for the class as it stands.
- Settle, agree a plan, or deliberately carry forward.
- Promote.
Our own system blocks a student in arrears from a bulk promotion and reports them by name, so the decision is made rather than defaulted into. It can be overridden per student, deliberately — a school often promotes a family it has already agreed a plan with.
What this looks like when it is working
You can answer, in under a minute and without opening a ledger:
- what the school is owed in total, and for which months;
- which families owe it, oldest first;
- what any one family was billed, paid, and still owes, across every year they have been at the school;
- and what a part-paid challan actually has left on it.
If any of those takes longer than a minute today, the balance is not lost — it is just not reachable, and that is a fixable problem.