Fee Collection Projection Tool
A fee collection projection estimates how much fee a school expects to collect in a term — from the student count, average fee and a realistic on-time payment rate — and shows the likely shortfall.
Set your assumptions, see the gap, and plan reminders and cash flow around it.
Use your own past terms' figure — the share of fees paid by the due date.
Of the overdue amount, the share you typically recover within a few weeks.
A what-if projection based on the rates you enter — not a statistical prediction of your school's collection. Use your own history for the most useful estimate.
A planning estimate, not a forecast engine
This tool does the arithmetic for an assumption you set. For a data-driven forecast built from each family's actual payment history, schools use SchoolDeck's fee prediction. To collect fees on UPI and reconcile them, see Fee Collection; to cut defaults and close books faster, see Fee & Finance Management. Quoting one parent a figure? Use the Late Fee & Concession Calculator.
How it works
Project your term collection in four steps.
-
1
Enter the number of students
Type how many students are billed for the term.
-
2
Enter the average fee
Add the average fee billed per student for the term — the tool gets the total billed from this.
-
3
Set a realistic on-time rate
Use the slider to set the share of fees you expect by the due date — base it on your past terms.
-
4
Read the projection
See the total billed, expected on-time collection, likely shortfall, and the recovery scenario after reminders.
How a fee collection projection is calculated
The projection is a chain of simple multiplications. Total billed comes from students and average fee; expected collection applies your on-time rate; the rest is the shortfall, part of which is recovered through reminders.
The formulas
Total billed = Students × Average fee
Collected on time = Total billed × On-time rate
Shortfall = Total billed − Collected on time
Projected total = Collected on time + (Shortfall × Recovery rate)
Worked example
A school with 500 students and an average term fee of ₹15,000 bills ₹75,00,000. At an 80% on-time rate, it expects ₹60,00,000 by the due date, leaving a ₹15,00,000 shortfall. If reminders recover 60% of that overdue amount (₹9,00,000), the projected total collected rises to ₹69,00,000 — about 92% of what was billed.
| On-time rate | Collected on time | Shortfall |
|---|---|---|
| 90% | ₹67,50,000 | ₹7,50,000 |
| 80% | ₹60,00,000 | ₹15,00,000 |
| 70% | ₹52,50,000 | ₹22,50,000 |
| 60% | ₹45,00,000 | ₹30,00,000 |
Based on 500 students at ₹15,000 average fee (₹75,00,000 billed).
Planning a term around what you'll actually collect
Every school budgets against the fee it bills, but the money rarely all arrives on the due date. Salaries, vendor payments and other commitments are due on a calendar; fee payments trickle in on their own schedule. The gap between what is billed and what has actually come in is a cash-flow problem, not necessarily a loss — and planning for it is far easier than reacting to it. This tool turns a few assumptions into a clear picture of that gap.
Billed is not collected
The single most useful distinction in school finance is between fees billed and fees collected. Billed is what is due from every student. Collected is what has arrived. On the due date these two numbers are almost never equal, because a share of families pay late for entirely ordinary reasons. The difference is the outstanding amount — and most of it is timing, recovered within a few weeks once reminders go out.
Why use your own on-time rate
There is no national or "correct" on-time payment rate. It depends on the fee level, the city, the kind of families a school serves and how actively the office follows up. That is why this tool asks you to set the rate rather than assuming one: the most useful projection comes from looking at what share of fees were paid by the due date in your own past two or three terms and using that figure. Run the projection at a few rates to see your best and worst cases.
Turning the shortfall back into cash
A projected shortfall is a to-do list, not a write-off. Schools close most of it with a few reliable habits: a reminder a few days before the due date, a gentle nudge just after, easy UPI payment so a parent can clear dues in seconds, and an instalment option for families who genuinely need to spread the cost. The small residue of persistent non-payers is best handled early and individually. To plan how an annual fee splits into instalments in the first place, use the Fee Instalment Calculator.
From a what-if to a real forecast
This tool deliberately keeps things simple: you choose the rate, it does the maths. That is perfect for a quick budget sanity-check. A school that wants to move beyond assumptions — to forecast collection from each family's actual payment history, flag the accounts most likely to fall behind, and project month-by-month cash flow — needs a data-driven model. Schools use SchoolDeck's fee prediction for that, and fee collection to actually bring the money in on UPI and reconcile it into the books.
For a quick projection right now, set your figures in the tool at the top of this page.
Frequently asked questions
Fee collection projection — FAQs
What is a fee collection projection?
+
A fee collection projection is an estimate of how much fee a school expects to actually collect in a term, compared with the total fee billed. It is calculated from the number of students, the average fee per student and a realistic on-time payment rate. The gap between what is billed and what is expected to come in on time is the projected shortfall.
How do I calculate expected fee collection?
+
Multiply the number of students by the average fee to get the total billed, then multiply that by your on-time payment rate. For example, 500 students at an average fee of ₹15,000 is ₹75,00,000 billed; at an 80% on-time rate, you would expect ₹60,00,000 collected on time, leaving a projected shortfall of ₹15,00,000 to recover through reminders.
What is a realistic on-time payment rate for schools?
+
It varies widely by school, location and fee level, so there is no single correct figure. The most reliable input is your own school's history — look at what share of fees was paid by the due date in past terms. Many schools see a large share paid on time and recover much of the rest within a few weeks of reminders, but you should use your own number rather than an assumed one.
What is the difference between fees billed and fees collected?
+
Fees billed is the total amount due from all students for the term. Fees collected is the amount that actually comes in. The two are rarely the same on the due date because some payments are late or pending. The difference is the outstanding amount or shortfall, much of which is usually recovered later through reminders and follow-up.
Is this a prediction of how much my school will collect?
+
No. This is a deterministic what-if projection based entirely on the on-time rate you enter — it does the arithmetic for the assumption you choose. It does not predict your collection statistically or use any data about your students. For a data-driven forecast based on each family's payment history, schools use SchoolDeck's fee prediction module.
How can a school reduce its fee collection shortfall?
+
The shortfall on the due date is mostly timing, not loss. Schools reduce it by sending reminders before and after the due date, offering easy UPI payment, allowing instalments for families who need them, and following up early with the small number of persistent defaulters. Most of the gap is recovered within a few weeks when reminders are consistent.
Is this fee collection projection tool free?
+
Yes. The tool is completely free, needs no sign-up, and runs entirely in your browser, so the figures you enter are never uploaded or stored. You can use it as often as you like on any phone or computer.
More free school tools
Plan, calculate, generate — all free.
Stop guessing the shortfall. Forecast it from real data.
SchoolDeck forecasts collection from each family's payment history, sends reminders before and after the due date, and collects on UPI — so the shortfall shrinks and your books close on time. Used by 500+ schools across India.