Reconciliation is more than matching totals
A school may collect fees through cash, bank transfer, UPI, cheque, payment gateway, or a mix of channels. The challenge is not only recording payments; it is proving that receipts, bank entries, student ledgers, and pending reports agree.
When reconciliation happens late, small mismatches become hard to investigate. A daily or weekly rhythm reduces pressure and improves trust in fee reports.
Capture payment references clearly
Each payment should include student name or admission number, amount, date, mode, receipt number, fee head, and reference number where applicable. UPI and bank transfer references are especially important when parents pay outside the school counter.
If a payment cannot be matched immediately, keep it in a pending verification list instead of forcing it into the wrong student account.
Separate receipt correction from deletion
Mistakes happen. The workflow should allow corrections with clear reason and authorization, but casual deletion of receipts creates audit risk.
Maintain a correction trail for cancelled receipts, adjusted amounts, wrong student mapping, duplicate payment entries, and concession changes.
Reconcile by mode and date
Review cash collection, bank deposits, UPI references, cheque clearance, and online gateway settlement separately before combining totals. This makes mismatches easier to locate.
The final reconciliation report should explain collected amount, reversed amount, pending verification, concessions, and outstanding dues in a way leadership can understand.