Fee Defaulter List: Format and How to Use It

Most coaching centres have a defaulter list. Very few use it, because the list they have is a column of names and an amount, which tells you nothing about what to do next.

A defaulter list is a work queue. If it does not tell you who to call first and what was said last time, it is a record of a problem rather than a way out of it.

The columns that matter

Name and amount are the obvious two, and on their own they are the least useful.

• Student name and roll number
• Batch, because collection rates differ enormously between batches and you want to see that
• Amount due
• Due date, and days overdue calculated from it — this is the column you sort by
• Instalment number, if fees are split — "2 of 4" reads very differently from a single missed payment
• Last contact date and what was said
• Promised date, if the parent gave one
• Parent phone

The two that turn a list into a system are days overdue and last contact. Sorting by days overdue tells you where the money is. Filtering on last contact tells you who has slipped through without a call.

Sort by age, not by amount

The instinct is to chase the biggest balance first. It is the wrong order.

A fee thirty days overdue is usually a forgotten payment. At ninety days it is a decision the family has made, and no amount of calling changes it. The probability of collecting falls sharply with age, so the same hour spent on recent defaulters returns far more than an hour spent on old ones.

Work the list oldest-first only when you are writing things off. Work it newest-first when you are collecting.

What counts as a defaulter

Decide this once and write it down, because otherwise the list changes shape depending on who built it.

A workable rule: a student appears on the list when a payment is more than seven days past its due date. Before that it is a late payment and a reminder message handles it. After thirty days it moves to a second list that gets a different treatment — a printed notice rather than a phone call.

Whatever you choose, apply it to everyone. A list where some families are quietly exempted stops being usable by anyone but the person maintaining it.

The follow-up order that works

Four steps, escalating, with a record of each.

1. Day 3 after due date — a short message with the amount and the due date. No tone at all. Most payments arrive here, because most were simply forgotten.
2. Day 10 — a phone call. This is where you learn whether it is forgetfulness or difficulty, and those need entirely different responses.
3. Day 21 — a printed notice handed to the student or posted, stating the amount, the period and what happens next.
4. Day 30 — a conversation about a revised plan, or about stopping.

The step people skip is the phone call, because it is uncomfortable. It is also the only step that tells you which of your defaulters can pay and which cannot — and that distinction is the whole point of the exercise.

Offer an instalment before you offer a discount

When a parent genuinely cannot pay, the reflex is to reduce the fee. That is the expensive option and it is rarely what they need.

Splitting the outstanding amount across the remaining months usually solves it, keeps the full fee intact, and does not set a precedent that travels around the parent group by evening. A discount granted once is quoted back to you by three other families within a fortnight.

Free tool

Fee Instalment Plan Calculator

Split a course fee into instalments with due dates, after any discount and admission payment. Prints a clear payment schedule to hand the parent.

Use it free

Keep the list where the collection happens

A defaulter list in a notebook in a drawer is consulted once a month. One that opens on the phone you are already holding gets worked daily.

That matters more than the format. The centres that collect well are not the ones with the best-designed register — they are the ones where checking the list is a two-minute morning habit rather than a monthly exercise in dread.

What to review each month

Once a month, look past the individual names at the shape of the list:

• Total outstanding, and whether it is growing or shrinking
• Average days overdue — rising means follow-up is slipping, regardless of the total
• Which batch the defaults cluster in — often it is one batch, one timing, or one fee level
• How many are repeat defaulters versus first-time

The last one decides policy. If the same eight families default every month, the problem is your due date or your instalment structure, not those families.