Generate an Excel workbook for school, college and university internal audit: admissions, fees, scholarships, grants, payroll, procurement, assets, hostels, transport, compliance and SIS/LMS controls.
| Area | Risk | Control | Test | Evidence | Cadence |
|---|---|---|---|---|---|
| Admissions student master | Admissions, withdrawals, concessions or student master changes are not approved, complete or reconciled to billing. | Admission approval workflow, maker-checker for student master, withdrawal approval and concession review. | Match admissions to application, approval, fee plan and student master; test withdrawals and concession changes. | Admission form, approval, student master dump, concession approval, withdrawal/TC record and enrolment reconciliation. | Admission cycle / Monthly |
| Fee billing collections | Tuition, transport, hostel, exam or other fees are under-billed, waived, collected outside system or not reconciled. | Approved fee structure, automated billing, receipt-bank reconciliation, waiver approval and receivable ageing review. | Recompute billing by class/course/category, match receipts to bank/payment gateway and review waivers/write-offs. | Fee circular, student ledger, receipt register, payment gateway report, bank statement, waiver approval and ageing. | Monthly / Term-wise |
| Scholarships concessions | Scholarships, concessions or quota benefits are given to ineligible students or not posted accurately. | Eligibility verification, scholarship sanction review, concession master approval and periodic exception review. | Sample eligibility, sanction and posting to student ledger; review old or manual concession entries. | Scholarship file, eligibility proof, sanction letter, concession approval, student ledger and exception report. | Term-wise |
| Grants donations funds | Government grants, CSR support, donations, restricted funds or corpus amounts are misstated or used outside purpose. | Grant agreement tracking, donation receipt control, fund-wise ledger and utilisation certificate review. | Match receipts to sanction/donor file, trace utilisation against terms and review restricted-fund balances. | Grant sanction, donation receipt, fund ledger, bank proof, donor restriction and utilisation certificate. | Monthly / Grant milestone |
| Payroll faculty outsourced staff | Faculty payroll, visiting faculty, contract staff, outsourced services or statutory deductions are unsupported. | HR master review, timetable/workload approval, payroll input maker-checker and statutory challan review. | Match payroll to appointment, attendance, workload and bank payment; test deductions, visiting faculty and outsourced bills. | HR master, appointment letter, workload/timetable, attendance, payroll register, bank proof, challans and deployment sheet. | Monthly |
| Procurement library laboratories | Books, lab consumables, equipment, uniforms, meals, repairs or services are procured without budget or receipt evidence. | Budget approval, quotation/PO control, GRN/service confirmation and stores/library issue records. | Match requisition, quotation, PO, receipt and invoice; test library accession, lab issues and split purchases. | Budget, requisition, quotations, PO, GRN/service note, invoice, library accession record and vendor file. | Monthly / Quarterly |
| Assets infrastructure capex | Buildings, classrooms, labs, IT assets, buses or equipment are unauthorised, untagged, not verified or wrongly capitalised. | Capex approval, capitalisation checklist, asset tagging, CWIP ageing and physical verification. | Match capex to approval, invoice and installation; review CWIP, tags, location and disposal approvals. | Capex approval, invoice, installation/completion certificate, CWIP ageing, FAR, tag list and verification sheet. | Quarterly / Annual |
| Hostel transport canteen | Auxiliary service receipts and costs are not reconciled to students, vendors, routes, rooms or usage records. | Service enrolment master, route/room allocation review, vendor billing reconciliation and collection control. | Reconcile hostel/transport enrolment to billing and collection; match vendor invoices to usage or attendance logs. | Service master, route/room allocation, usage log, vendor invoice, collection report and bank settlement. | Monthly |
| Affiliation statutory compliance | Affiliation, accreditation, public disclosures, safety requirements, tax filings or labour compliances lapse. | Compliance calendar, affiliation/accreditation tracker, public disclosure review and notice escalation. | Check approval validity, website disclosures, GST/TDS/PF/ESI/PT filings where applicable and ageing of notices. | Affiliation letter, accreditation record, compliance calendar, website disclosure support, returns, challans and notices. | Monthly / Annual |
| SIS LMS ERP access | Users can change student master, fee plans, waivers, marks, payroll or vendor data without review. | Role-based access, leaver access review, master-change approval and audit-log monitoring. | Review privileged users, leavers, shared IDs, master changes, audit logs and interface exceptions. | User list, role matrix, HR exit list, master-change log, audit log and interface exception report. | Monthly / Quarterly |
Use this with the education internal audit checklist, the RCM builder and the monitoring rules repository.
Education institution internal audit is strongest when student records, billing, bank settlements and regulator files are tested together. The workbook connects admissions, fees, concessions, scholarships, grants, payroll, procurement, assets, auxiliary services, compliance and SIS/LMS access into one fieldwork file.
The Excel export gives auditors separate sheets for engagement scope, RCM rows, admissions, fee collection testing, scholarships and grants, payroll/procurement/assets, compliance/access and monitoring exceptions. Tailor it to school, college, university, trust, society or company structure.
A CA firm is reviewing a school with tuition fees, transport fees, concessions, grant income, faculty payroll and SIS access controls.
