Most principals learn about fee problems the worst way: when salaries are due and the bank balance is short. By then, the problem is months old. The schools with the healthiest cash flow share one habit — the principal reviews a standard set of collection reports every month, and acts on what they show. Here are the six reports that matter.
Why Principals Must Read Collection Reports
Fee collection is your school's oxygen — typically 90%+ of revenue. Yet in many schools, the principal sees only a single number ("we collected Rs. X this month") with no insight into who is not paying, how long dues have aged, or where the leaks are. Reports turn a vague worry into specific, assignable actions. They also keep the accounts team accountable — what gets reviewed gets done.
1. Monthly Collection Summary
The headline dashboard: total billed vs total collected vs outstanding for the month, plus the collection percentage. A healthy school collects 92-97% of billed fees within the month. Below 90% consistently signals a systemic problem (weak reminders, no follow-up process). The summary should also split collection by payment mode (cash, bank, wallet, gateway) — a sudden shift can reveal process issues.
2. Aging Analysis (The Most Important Report)
This report buckets every rupee of outstanding dues by age: current month, 31-60 days, 61-90 days, 90+ days. It is the single most predictive report in school finance, because recovery probability collapses with age: dues under 30 days recover at 90%+, but 90-day-old dues often recover below 50%. Your target: 80%+ of outstanding should be in the "current month" bucket. A growing 90+ day pile means your escalation process exists on paper only. Every 90+ day account needs a named owner and a dated action.
3. Class-Wise Collection Report
Collection percentage broken down by class/section. This report routinely surprises principals — one or two classes often drag the whole school's numbers down. The cause is usually identifiable: a new class teacher not reinforcing fee messages, a cluster of hardship families, or a section where reminders are not reaching parents. Class-wise data lets you intervene surgically instead of blasting the whole school with stricter notices.
4. Defaulter List with Action Status
Not just names and amounts — every defaulter row needs: days overdue, last action taken, next action due, and owner. A list without action status is a wish list. Review rule: any account with "no action in 14 days" gets escalated immediately. This report feeds directly into your defaulter meeting schedule — the 30/60/90-day cases become this month's meeting calendar.
5. Discount & Concession Report
Every discounted student on one page: name, discount type and %, monthly value, reason, approver, and review date. As covered in our concessions guide, this report routinely surfaces discounts that should have expired — the easiest revenue recovery available to any school. Review it quarterly at minimum; monthly is better.
6. Collection Trend (6-Month View)
Month-by-month collection percentage over the last 6 months, ideally as a simple line chart. Trends reveal what snapshots hide: a slow decline from 96% to 91% over four months is an early warning no single month's report would flag. Annotate the trend with events (fee increase, new reminder system, staff change) to learn what moves your numbers.
The 3 Numbers
The 30-Minute Monthly Review Meeting
Reports without a review ritual gather dust. Hold a fixed 30-minute meeting in the first week of each month — principal, accounts head, and (optionally) vice-principal. Agenda: (1) last month's collection % vs target (5 min); (2) aging movement — did 90+ day dues shrink or grow? (10 min); (3) top 10 defaulters — action and owner for each (10 min); (4) one improvement to implement this month (5 min). End every meeting with written actions, owners, and dates. Schools that run this ritual see collection percentages climb steadily within two quarters — not because the reports are magic, but because attention is.
With fee management software, all six reports generate in one click — the meeting prep that used to take the accountant two days takes ten minutes. The principal's job shifts from asking for numbers to acting on them.