School fee reconciliation
School fee reconciliation software for finance teams
Cointab helps finance teams reconcile student fee records, fee demand reports, online payments, offline collections, concessions, refunds, reversals, bank statements, and accounting entries.
View live demo reportTrusted by teams reconciling education fee collections
Cointab is used by finance and operations teams handling recurring reconciliation across school fees, online payments, offline collections, banks, accounting systems, and internal records.
School fee collections are difficult to reconcile manually
Schools and education groups collect fees across multiple modes, campuses, grades, students, fee heads, installments, and payment partners. Finance teams need to confirm that every fee collected is recorded correctly in the school system, bank, and accounts.
Student fee records and payment records may not match
A student may pay through a payment gateway, bank transfer, cash, cheque, UPI, card, or offline counter, but the school ERP or fee system may not show the same receipt, amount, or status.
Fee heads and installments add complexity
Tuition fees, transport fees, admission fees, exam fees, activity fees, hostel fees, late fees, and installment plans may appear differently across reports.
Online and offline collections follow different flows
Payment gateway collections, bank transfers, cash deposits, cheque payments, DDs, and counter collections may each have separate reports, references, and settlement timelines.
Concessions and waivers need validation
Scholarships, sibling discounts, staff concessions, special waivers, reversals, and manual adjustments can change the expected fee amount.
Refunds and reversals create open items
Cancelled admissions, duplicate payments, failed payments, cheque bounces, reversed transactions, excess payments, and refunds need clear tracking across student records and bank data.
Multi-campus reporting increases reconciliation work
Education groups often need to reconcile student-wise, campus-wise, class-wise, section-wise, fee-head-wise, and payment-mode-wise collections.
Bank settlement timing creates gaps
Online collections may be paid by parents on one date, settled by the payment gateway later, and credited to the bank in a different period.
Excel becomes fragile as volume grows
Finance teams often compare fee demand reports, collection receipts, payment gateway files, bank statements, offline collection sheets, concession reports, refund files, and accounting ledgers using repeated VLOOKUPs and filters.
Open items need clear action
Teams need to know whether a difference is due to missing receipt, payment gateway delay, failed transaction, concession mismatch, duplicate payment, refund, bank timing difference, or accounting entry issue.
What is school fee reconciliation?
School fee reconciliation is the process of matching student fee demand, fee collection, payment gateway, offline collection, bank, concession, refund, and accounting records.
For example, your school ERP may show the fee due for a student. The payment gateway may show an online payment transaction. The bank statement may show the final settlement credited. The accounting system may show the fee income, receivable, bank, concession, or refund entry.
Cointab helps bring these records together so your finance team can answer:
- Which student fees were collected successfully?
- Which payments are present in the gateway but missing from school records?
- Which receipts are created internally but missing from bank or gateway data?
- Which students have short, excess, duplicate, or failed payments?
- Which fee heads, installments, or campuses have differences?
- Which concessions, waivers, or scholarships were applied correctly?
- Which refunds, reversals, or cheque bounces need review?
- Which payment gateway settlements match bank credits?
- Which student ledger balances differ from accounting records?
- Which records need follow-up with parents, payment partners, school admin teams, or accounts teams?
Bring together student fees, collections, concessions, refunds, and bank credits
Cointab can reconcile school fee workflows using multiple reports from school ERPs, fee management systems, payment gateways, banks, accounting systems, and internal teams.
| Data source | Example records |
|---|---|
| Student fee demand report | Student ID, admission number, campus, class, fee head, due amount, due date |
| Fee collection / receipt report | Receipt number, student ID, paid amount, payment mode, receipt date, fee head |
| Student ledger | Opening balance, fee demand, paid amount, concession, refund, closing balance |
| Payment gateway report | Transaction ID, payment status, paid amount, gateway fee, settlement ID |
| Offline collection report | Cash, cheque, DD, counter collection, manual receipt, deposit reference |
| Bank statement | Final bank credit, UTR/reference, value date, amount, narration |
| Concession / waiver report | Scholarship, sibling discount, staff concession, manual waiver, approved concession |
| Refund / reversal report | Refund ID, duplicate payment refund, cancelled admission refund, reversal status |
| Cheque bounce report | Cheque number, bounce date, bounce reason, reversal amount, student reference |
| Accounting / GL report | Fee income ledger, receivable ledger, bank ledger, concession ledger, refund ledger |
| Campus / branch report | Campus code, school branch, class, section, academic year, collection center |
| Supporting data | Student mapping, campus mapping, fee head mapping, payment mode mapping, concession rules |
Users can start with student fee collection and bank reports, then add payment gateway, student ledger, concession, refund, offline collection, accounting, campus, or supporting reports as the workflow becomes more complete.
Find fee collection, receipt, concession, and bank differences faster
Cointab helps finance teams separate clean school fee matches from exceptions that need review.
Payment received but receipt missing
The payment gateway or bank shows a student payment, but no matching receipt is found in the school ERP or fee system.
Receipt created but payment missing
The school system shows a fee receipt, but no matching payment is found in gateway, offline collection, or bank data.
Student paid but amount differs
The student reference matches, but the paid amount does not match the expected fee, receipt amount, or bank credit.
Short payment
The amount collected is lower than the fee due, installment amount, or expected collection amount.
Excess payment
The student has paid more than the expected fee amount, but the excess is not adjusted, carried forward, or refunded correctly.
Duplicate payment
The same student, receipt, transaction, or bank reference appears more than once.
Failed transaction marked as paid
A payment is marked as successful internally, but the payment gateway shows failed, pending, cancelled, or reversed status.
Gateway settlement delay
A student payment is successful, but the amount is settled to the bank in a later period.
Fee head mismatch
The payment is recorded against the wrong fee head, such as tuition, transport, admission, hostel, activity, or exam fee.
Concession or waiver mismatch
Scholarship, sibling discount, staff concession, manual waiver, or approved concession does not match the expected amount.
Refund or reversal mismatch
A duplicate payment refund, cancelled admission refund, payment reversal, or failed transaction reversal does not match across systems.
Cheque bounce mismatch
A cheque payment is recorded as collected, but the bank shows a bounce or reversal.
Student ledger balance mismatch
Opening balance, fee demand, paid amount, concession, refund, outstanding balance, or closing balance differs between systems.
Campus or class mismatch
The student, campus, class, section, academic year, or fee period is mapped incorrectly.
Bank credit mismatch
Payment gateway settlement or offline deposit amount does not match the final bank credit.
How Cointab automates school fee reconciliation
Cointab gives finance teams a reusable workflow for preparing school fee data, matching records, reviewing exceptions, and exporting reports.
Select or create the workflow
Start with a school fee reconciliation template or build a custom workflow for your school ERP, fee management system, payment gateway, bank, accounting system, campus structure, or internal reports.
Upload or automate data
Upload CSV, XLS, or XLSX files manually, or automate recurring data input through email, SFTP, or APIs.
Map required fields
Select date, amount, and identifier columns such as student ID, admission number, receipt number, transaction ID, payment reference, UTR, fee head, campus code, academic year, settlement ID, or journal number.
Add supporting data
Use supporting files for student mapping, campus mapping, class mapping, fee head mapping, payment mode mapping, concession rules, installment logic, bank account mapping, or accounting logic.
Create derived columns
Use AI to create calculated fields such as expected fee amount, net collected amount, concession-adjusted amount, refund-adjusted amount, clean student ID, normalized receipt number, fee-head-adjusted amount, or settlement-adjusted amount.
Run reconciliation
Cointab applies structured matching logic across fee demand reports, collection reports, payment gateway files, offline collection data, refund files, concession records, student ledgers, accounting reports, and bank statements.
Review exceptions
See fully matched, partially matched, unmatched, and skipped records, then drill into student-level, receipt-level, fee-head-level, campus-level, settlement-level, or bank-level details.
Download or automate output
Download Excel reports or push matched, unmatched, exception, or summary data back to ERP, accounting, BI, analytics, finance, school administration, or internal systems.
Match structured school fee data with rules and difficult exceptions with AI
Cointab applies structured matching first, then uses AI to help with difficult open transactions where student references, receipt numbers, payment IDs, fee heads, or bank narrations are missing, messy, or spread across multiple reports.
Structured matching
Cointab can match school fee records using:
Matching scenarios
One-to-one
One student fee receipt matches one payment gateway transaction, offline collection entry, bank credit, or accounting entry.
One-to-many
One student fee demand maps to multiple installments, partial payments, concessions, refunds, or receipts.
Many-to-one
Multiple student payments are grouped into one payment gateway settlement, offline bank deposit, accounting entry, or bank credit.
Many-to-many
Multiple student fees and multiple collection, concession, refund, settlement, bank, or accounting records are grouped and compared.
Partial matching
Student ID, receipt number, payment reference, or settlement ID matches, but the amount differs because of short payment, concession, refund, late fee, gateway fee, reversal, or timing difference.
Contra / reversal matching
Refunds, reversals, failed payments, cheque bounces, cancelled receipts, duplicate payment adjustments, and concession reversals are netted against original fee collection records.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- Student IDs are incomplete or formatted differently
- Admission numbers differ across systems
- Receipt numbers appear in different columns
- Bank narrations contain embedded student, receipt, or payment references
- Student names are similar but not identical
- Campus or class names differ across reports
- Payment gateway references do not directly match ERP receipts
- Offline collection references are incomplete
- Refunds or reversals do not directly map to original receipts
- Multiple possible matches exist across fee, gateway, bank, and accounting reports
- Descriptions are unstructured or incomplete
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists reconciliation, but Cointab keeps the output transparent, reviewable, and audit-friendly.
Clear school fee reconciliation reports your team can use
Cointab gives finance teams a complete report showing what matched, what partially matched, what remains unmatched, and what was skipped.
Report categories
Fully matched
Student fee receipts, payment gateway transactions, offline collections, concessions, refunds, settlements, accounting entries, or bank credits where identifiers and amounts match.
Partially matched
Records where identifiers match but fee amount, receipt amount, concession amount, refund amount, settlement amount, ledger balance, or bank amount differs.
Unmatched in internal records
Student fee receipts, expected collections, expected concessions, expected refunds, or accounting entries present internally but not found in external reports.
Unmatched in external records
Payment gateway transactions, bank entries, offline deposits, settlement records, refunds, or payment partner records present externally but not found internally.
Skipped
Rows excluded because of missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Transaction-level tables
- Student-level detail view
- Receipt-level detail view
- Fee-head-level review
- Campus-wise review
- Class-wise review
- Payment-mode-wise review
- Settlement-level detail view
- Matched transaction detail view
- Filters for review
- Difference amounts
- Excel export
- Manual match
- Undo manual match
- Audit-ready output
- Open-item reason and action analysis
Automate recurring school fee reconciliation
Once your school fee reconciliation workflow is configured, Cointab can automate data input, reconciliation runs, and output delivery.
Bring data into Cointab
Receive or pull data through:
- Student fee demand report pushed from school ERP
- Fee collection report exported from fee management system
- Payment gateway report received by email or API
- Bank statement pulled through API or uploaded automatically
- Offline collection report uploaded by campus or finance team
- Concession and waiver report received on schedule
- Refund and reversal report added automatically
- Accounting ledger pushed from ERP or accounting software
- Student, campus, fee head, and payment mode mapping files maintained as supporting data
Run reconciliation automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Fully matched fee receipts
- Fully matched payment transactions
- Partially matched student payments
- Unmatched internal receipts
- Unmatched payment gateway records
- Unmatched bank credits
- Short payment records
- Excess payment records
- Duplicate payment records
- Failed transaction differences
- Concession mismatch records
- Refund and reversal differences
- Cheque bounce differences
- Student ledger balance differences
- Fee-head-wise differences
- Campus-wise differences
- Bank credit mismatches
- Exception reasons
- Suggested actions
- Excel reports
- Structured API output
Start faster with school fee reconciliation templates
Use a ready-made school fee reconciliation template where available, or create a custom workflow for your school ERP, fee collection system, payment gateway, bank, concession, refund, and accounting reports.
Fee Collection vs Payment Gateway
Best for matching student fee receipts with online payment gateway transactions and settlement records.
View templateFee Collection vs Bank
Best for comparing student fee collections, offline deposits, gateway settlements, and final bank credits.
View templateStudent Ledger Reconciliation
Best for reviewing student opening balance, fee demand, paid amount, concessions, refunds, outstanding amount, and closing balance.
View templateOffline Collection Reconciliation
Best for reconciling cash, cheque, DD, counter collections, campus deposits, and bank entries.
View templateConcession and Waiver Reconciliation
Best for comparing scholarships, sibling discounts, staff concessions, waivers, approvals, and accounting entries.
View templateRefund and Reversal Reconciliation
Best for matching duplicate payment refunds, cancelled admission refunds, failed payments, reversals, and bank entries.
View templateSchool ERP vs Accounting Ledger
Best for comparing fee collections, receivables, concessions, refunds, and accounting ledger entries.
View templatePayment Gateway Reconciliation
Best for schools that want to reconcile online payments, payment status, refunds, fees, settlements, and bank credits.
Explore solutionBank Reconciliation
Best for matching school fee collections, settlements, refunds, deposits, and internal accounting records with bank statements.
Explore solutionIf a specific school fee template is not available yet, users can still create a custom reconciliation using their own fee demand, collection, receipt, payment gateway, offline collection, concession, refund, accounting, and bank reports.
See a school fee reconciliation report before signing up
Open a sample School Fee Reconciliation report and see how Cointab presents matched, partially matched, unmatched, and skipped transactions.
School Fee Reconciliation Demo
See how student fee records are matched with payment gateway transactions, offline collections, concession reports, refund files, accounting records, and bank statements. Review how missing receipts, failed payments, short collections, duplicate payments, concession differences, refund mismatches, and bank credit differences are highlighted.
View demo reportBuilt for schools, education groups, campuses, and finance teams
Cointab is useful for teams that regularly reconcile student fee demand, collections, payment gateways, offline payments, concessions, refunds, bank credits, and accounting records.
Schools
For schools reconciling student-wise fee collections, receipts, concessions, refunds, bank credits, and accounting entries.
Education groups
For groups managing multiple schools, campuses, branches, classes, sections, and fee collection modes.
Colleges and institutes
For institutions reconciling tuition fees, admission fees, exam fees, hostel fees, transport fees, and other student collections.
Multi-campus finance teams
For finance teams that need campus-wise, class-wise, fee-head-wise, and payment-mode-wise reconciliation.
School administration teams
For teams reviewing parent payments, missing receipts, failed transactions, duplicate payments, and student ledger differences.
Finance teams
For teams preparing school fee reconciliation reports for month-end close, books, audit, bank review, and collection follow-up.
Accounting firms
For firms handling recurring fee reconciliation for schools, education groups, coaching institutes, or training centers.
Audit and compliance teams
For teams that need transaction-level support for collections, concessions, refunds, student balances, ledger entries, and bank credits.
Trusted by teams handling school fee and education reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across education, payments, banks, accounting systems, partners, and internal records.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
School fee reconciliation FAQs
Start reconciling school fee collections faster
Use a ready-made school fee reconciliation template, build a custom workflow, or schedule a guided setup with the Cointab team.
View live demo reportNo credit card required · Manual uploads and automated data flows supported