Databus Logo
Blog Login →
Free tool · Fee dues & receivables · India

Fee receivable aging calculator. See which dues are recent, which are slipping.

Bucket outstanding fees into current, 30, 60 and 90+ day bands, so reminders go to the dues that are slipping away — not the ones a parent will pay this week anyway.

Receivable aging groups unpaid fees by how overdue they are — Current, 1-30, 31-60, 61-90 and 90+ days — using the standard accounts-receivable convention. This is a reporting tool: it shows you where to follow up first. It doesn't collect money, and an overdue fee is a finance matter to resolve with a parent — never a reason to lock a student out of class.
Standard 30/60/90 bands Oldest dues first No sign-up

Age your fee dues

Add each pending amount.

Enter each due by

What each aging band means

The standard accounts-receivable bands, in plain words.

Band
Days past due
What it usually means
Current
Not yet due
Expected; no action needed yet.
1–30 days
1 to 30
Usually a reminder away from being paid.
31–60 days
31 to 60
Needs a direct follow-up, not just an SMS.
61–90 days
61 to 90
At risk; a conversation with the parent.
90+ days
More than 90
Hardest to recover; chase these first.

These are the standard 30/60/90 accounts-receivable aging bands used across finance. The reference point is the due date of each fee against today.

A worked example, end to end

Five pending fees on one batch — and where the risk actually sits.

A centre has ₹74,000 in pending fees across five students, aged against today:

₹9,000  due in 8 days  → Current
₹12,000 due 18 days ago → 1–30
₹15,000 due 44 days ago → 31–60
₹16,000 due 75 days ago → 61–90
₹22,000 due 130 days ago → 90+
────────────────
Current ₹9,000 · 1–30 ₹12,000 · 31–60 ₹15,000 · 61–90 ₹16,000 · 90+ ₹22,000

The total is ₹74,000, but the story isn't the total — it's that ₹22,000 (30%) sits in the 90+ band, the hardest to recover. A single "₹74,000 pending" figure hides that. Aged, it tells the office exactly where to start: the ₹22,000 and ₹16,000 dues need a call today, while the ₹9,000 Current and ₹12,000 recent dues will likely clear with a normal reminder.

Aging is a report — collection is a separate, fair step

This tool tells you where to look. How you act on it matters just as much.

This tool — the report

  • Sorts dues into standard 30/60/90 bands.
  • Shows where the money is recent vs long overdue.
  • Takes no money and stores nothing.
  • Free, runs entirely in your browser.

Acting on it — fairly

  • Reminders go through consent-based DLT-registered channels.
  • Payments settle to the institute's own account via an RBI-authorised gateway.
  • The software records; it does not hold funds.
  • A pending fee is resolved with the parent, never used against the child.

The point of aging isn't pressure — it's focus. Chase the dues that are actually slipping, and leave the recent ones to a normal reminder.

How aging is worked out

For each outstanding fee, the tool counts the days between its due date and the reference date (today, unless you change it). A due date in the future means the fee is Current — expected, not late. Once the due date has passed, the number of days overdue decides the band: 1-30, 31-60, 61-90, or 90+.

If you already know how many days a fee is overdue, you can type that directly instead of a date. Either way, the tool totals each band, works out its share of the total outstanding, and orders the report so the oldest, riskiest money is at the top.

It uses the standard 30/60/90 accounts-receivable convention, so the output reads the same way a finance team or an accountant would expect. Everything runs in your browser; the amounts and dates are not uploaded.

Who uses a receivable aging report

Coaching owners and accounts staff use it at month-end to turn the pending-fees pile into a short list of who to call. A tutor running their own classes uses it to spot the one or two families whose dues have quietly drifted past 60 days. It applies to any institution carrying receivables — coaching centres, tuition classes, training institutes — because the aging maths is universal; only the amounts change.

It is also a planning lens: a growing 90+ band month over month is an early signal that the collection process needs tightening, well before it shows up as a cash-flow problem.

Why bands beat a single pending total

"₹2 lakh pending" tells you almost nothing useful. If most of it is Current or 1-30 days, it's healthy and will clear on its own. If a third sits in 90+, the centre is quietly losing money. The aging bands separate the two situations that the headline number hides, and they make follow-up efficient: effort goes to the dues most likely to be lost, not spread thinly across everyone.

The longer a fee ages, the lower the chance of recovery — which is why finance teams everywhere watch the 90+ band, not the total. The same logic that protects a company's cash flow protects a coaching centre's.

From a report to actually recovering the money

Knowing which dues are oldest is the start. Recovering them means a reminder before and after each due date, an easy way to pay, a receipt the moment they do, and a live view that updates as money comes in — so the aging report rebuilds itself instead of being a monthly manual exercise.

TutorDesk's fee collection keeps the aging live across every batch, sends staged UPI reminders on consent-based DLT-registered templates, and collects each due with an instant receipt. Payments go through an RBI-authorised gateway and settle to your own account. For the buyer's playbook on cutting defaults across a centre, that's fee & finance management. And if you're setting up a plan in the first place, the fee instalment planner builds the schedule the dues are aged against.

In short: this tool shows the aging; TutorDesk keeps it live and collects.

Don't rebuild this report every month

TutorDesk keeps the aging live across every batch, sends staged UPI reminders to the oldest dues, and collects with instant receipts. Funds settle to your own account. Built for Indian coaching centres and tutors.

No credit card needed · 20-minute walkthrough.

Frequently asked questions

Aging bands, the method, and what this tool does and doesn't do.

What is receivable aging? +

Receivable aging groups money owed to you by how long it has been outstanding. Each unpaid amount is placed in a band — Current (not yet due), 1-30 days, 31-60 days, 61-90 days, and 90+ days overdue — based on its due date. It shows at a glance how much is recent versus long overdue, so follow-up can target the oldest dues first.

How is a 30/60/90 aging report calculated? +

For each outstanding amount, count the days from its due date to the reference date (today). If the due date is in the future, it is Current. If it is 1-30 days past, it falls in the 30-day band; 31-60 in the 60-day band; 61-90 in the 90-day band; and anything beyond 90 days in the 90+ band. The tool totals each band and shows its share of the total outstanding.

Why does aging matter for a coaching centre? +

The longer a fee stays unpaid, the harder it is to recover. Aging tells you where the risk is: a large 90+ band means money is slipping away and needs immediate follow-up, while dues sitting in Current or 1-30 are usually a reminder away. It turns one big "pending fees" number into a prioritised action list.

What is the difference between current and overdue? +

Current means the due date has not arrived yet — the fee is expected but not late. Overdue means the due date has passed. The aging bands split the overdue amount by how late it is, so a 5-day-late due is treated very differently from one that is 120 days late.

Can I enter days overdue instead of a due date? +

Yes. For each due you can either type the due date and let the tool count the days, or type the number of days it is already overdue directly. Both feed the same aging bands, so you can use whichever you have on hand.

Does this tool collect the overdue fees? +

No. It only reports the aging. It does not take any money or send reminders. In a live system, fees are collected through an RBI-authorised payment aggregator and funds settle to the institute's own account. This tool simply tells you which dues to chase first.

Is the receivable aging calculator free? +

Yes. It is free, needs no sign-up, and runs entirely in your browser. The amounts and dates you enter are not uploaded — the report is built on your device.

How should I follow up on overdue fees fairly? +

Start with a polite reminder on the oldest dues, sent through consent-based channels, and keep a clear record of what was agreed. A fee being overdue is a finance matter to resolve with the parent — it should never be used to lock a student out of class or learning materials. TutorDesk's fee collection sends staged reminders and shows the live aging across every batch.

More free tools from Databus

Quick calculators for coaching centres and tutors.

Stop the dues from slipping past 90 days.

TutorDesk keeps the aging live, reminds the oldest dues first, and collects by UPI with instant receipts — for Indian coaching centres and tutors.

Per active student · No upfront fee · Built in Chennai for India.