Finance
The Fee Defaulter Report That Shows How Old the Debt Is
Every school keeps a defaulter list, and most of them answer the same question: who owes us money, and how much? It is the wrong question to stop at. Two families can each owe PKR 20,000 and be completely different problems. One forgot to pay last month and will clear it with a reminder. The other has not paid since March, and every month that passes makes it less likely you will see the money at all. A defaulter list shows them side by side as equals. The age of the debt is what tells them apart.
What a defaulter list leaves out
The amount owed tells you the size of the problem. The age tells you how likely it is to be solved. Debt gets harder to collect the older it gets: the family has moved on in their minds, the amount has grown, and the conversation has become awkward for both sides. A list sorted only by amount sends the office after the largest balances, which are often the oldest and least collectable, while this month's easy recoveries go unchased.
Aging, bucket by bucket
Aging sorts what is owed by how long it has been overdue. Each bucket calls for a different response.
Not yet due
Nothing to chase. This is simply fees billed and not yet payable, and it belongs in the report so the total adds up.
1 to 30 days
Usually forgetfulness or a late salary. A reminder, by WhatsApp or SMS, clears most of it. This bucket is where collection is cheapest, so it should never wait.
31 to 60 days
Now it needs a person. A phone call, from someone who can ask what is going on and agree a date. Many families in this bucket have a reason worth hearing.
61 to 90 days
A meeting, and a payment plan agreed in writing. At this age a debt is becoming a habit, and the goal is to stop it growing while it is still recoverable.
Over 90 days
A decision. Either a firm plan to collect, or a write-off with a reason. Debt this old rarely comes in full, and leaving it on the books as though it will makes the school look richer than it is.
Age it by family, not only by student
Arrears often run across siblings. A family with three children, each a little behind, can owe more than any single student on the list, and it is one conversation rather than three. Aging by family shows you the real size of each household's debt and stops three members of staff ringing the same parent about three different children.
Two numbers to watch over time
- Collection efficiency: of everything that was collectible so far this year, the share that has actually been collected
- The share of what is owed that is over 90 days old. If it is growing, the office is chasing new arrears while old ones harden
Writing off, properly
A write-off is not forgetting a debt. It is a decision, recorded with a reason, that the school will stop pursuing an amount. Done properly, it keeps the books honest, stops reminders going to a family about money you have agreed to let go, and leaves a log that shows exactly what was given up and why. Done by quietly ignoring an old balance, it leaves the school counting money it will never receive.
Where Edflo fits
Edflo's receivables aging report sorts fees owed into not yet due, 1–30 days, 31–60 days, 61–90 days and over 90 days, grouped by class, section, fee type or family. The defaulters report ranks who owes what, with days overdue and the date of the last payment. The collections report shows collection efficiency, days to collect, a recovery curve and the write-off log, and a write-off needs a reason and stops the reminders for that amount. The owner's dashboard flags it when more than 15% of what is owed is over 90 days old, and as critical past 30%.
Key takeaways
- A defaulter list shows who owes; aging shows which debts you will still collect.
- Chase the 1 to 30 day bucket first: it is where collection is cheapest.
- Debt over 90 days old needs a decision: a firm plan or a write-off with a reason.
- Age arrears by family as well as by student, so each household is one conversation.
- Watch collection efficiency and the share of debt over 90 days old, not just the total owed.
Frequently asked questions
What is fee aging?
Sorting unpaid fees by how long they have been overdue, usually into not yet due, 1 to 30 days, 31 to 60, 61 to 90, and over 90 days. It shows not just how much is owed but how likely it is to be collected, because older debt is harder to recover.
When should a school write off unpaid fees?
When it has decided, after a documented attempt to collect, that it will not pursue the amount. Recording that as a write-off with a reason keeps the books honest; leaving it as owed makes the school look as if it has money it will never receive.
Should fee arrears be tracked by student or by family?
Both. By student for the records, and by family for collection, because siblings' arrears add up and a household is one conversation. Aging by family often reveals the largest debts on the list.
What is collection efficiency?
The share of everything that was collectible over a period that was actually collected. Tracked year to date, it shows whether the office is keeping up with what is falling due or slowly falling behind.