Fee office

Fee defaulters list and daily collection report

Two reports decide whether a fee office runs on software or on a register: who has not paid, and what came in today. Ilham 360 produces both to the standard a Pakistani school accountant actually needs — arrears month by month, and a day that balances to the drawer.

Arrears tracked separately, not one lump figure
Month by month

Arrears tracked separately, not one lump figure

Lump-sum payments applied automatically
Oldest first

Lump-sum payments applied automatically

Defaulters split by class and section
Class-wise

Defaulters split by class and section

Excel export on every plan, uncapped
Free

Excel export on every plan, uncapped

The defaulters list

A defaulters list is only useful when it separates this month from everything before it. A parent who missed March and April but paid May is a different conversation from one who is a single month behind, and one combined "outstanding" column hides that difference entirely.

Ilham 360 keeps every month distinct. Dues carried over from before you started are entered as opening balances, so a student’s history does not begin on the day you signed up and the arrears printed on their challan are the real ones.

  • Class-wise and section-wise, not one long list
  • This month separated from each earlier month
  • Previous dues carried in as opening balances
  • Family-wise totals, so siblings are chased once
  • Partial payments shown as a balance, not as unpaid
  • Discounts and concessions applied before the figure you chase
  • Overdue ageing across 30, 60 and 90+ days
  • One click to Excel

The daily collection report

At the end of the day your accountant has a cash drawer and the software has a number, and the two have to agree. This report is built for that reconciliation rather than for a dashboard.

What the daily collection report shows
FigureDetail
Total collectedAny single date or date range
By methodCash, cheque and bank transfer separated
By classCollected against invoiced, with a collection rate
Receipts issuedCount and receipt numbers for the day
Still outstandingCurrent dues and overdue totals alongside intake
ExportExcel, for printing, signing and filing

One payment, several months

A parent hands over Rs 5,000 against three unpaid months. In most systems the clerk decides which invoice it belongs to, and that decision is where fee registers quietly go wrong.

Ilham 360 applies the payment oldest first across every outstanding invoice for that family and issues one receipt for the whole amount. The arrears clear in the correct order without anyone choosing, and the receipt shows each month it settled.

Who can see and do what

Your fee clerk collects money and prints receipts. They cannot change a fee structure, edit a student record or reach the rest of the school. That separation is enforced on the server for every request, not hidden in a menu.

  • Accountant login scoped to the fee module
  • Read access to students and classes, because a payment needs a lookup
  • Fee heads, structures and discounts stay with the school admin
  • Every query scoped to your school alone

Common questions

Does the defaulters list separate this month from older arrears?

Yes. Ilham 360 tracks arrears month by month, so a parent who missed March and April shows differently from one who is a single month behind. The list shows the current month and each earlier month separately rather than collapsing everything into one outstanding figure.

Can I bring in dues from before I started using the software?

Yes. Previous dues are entered as opening balances against each student, so a challan printed on your first day already carries the real arrears from your old register.

What happens when one parent pays a lump sum against several unpaid months?

The payment is applied oldest first across that family’s outstanding invoices and settled under a single receipt number. Your clerk never has to decide which invoice a payment belongs to.

Can the daily collection report be reconciled against the cash drawer?

Yes. It totals any date or date range, splits the day by cash, cheque and bank transfer, lists receipts issued, and breaks collection down class by class against what was invoiced. It exports to Excel so the day’s sheet can be printed, signed and filed.

Is exporting reports to Excel charged separately?

No. A complete export of your data is free and uncapped on every plan, including the free one.

Try it on a real school, today

Your trial opens on a full Pakistani school — students, families, challans, results — already loaded. You are looking at working screens in under a minute, not an empty setup wizard.