1 in 3
schools cannot reconcile their fee ledger within a week of term-end
68%
of fee discrepancies originate from manual payment posting errors
2–4 hrs
average time saved per term when FeeClick auto-matches bank receipts

Term-end reconciliation is the moment of truth for every bursar. It's when discrepancies between what was billed, what was collected, and what sits in the bank account become impossible to ignore. Done well, it closes the books cleanly and gives management an accurate financial picture heading into the next term. Done poorly — or not at all — it compounds into the next term's mess and undermines every fee-collection effort that follows.

This checklist breaks the process into four sequential phases. Work through them in order. Each phase builds on the accuracy of the previous one, so skipping ahead creates the exact discrepancies you're trying to eliminate.

📋 How to use this checklist

Click each item as you complete it. Your progress is tracked below. Items tagged FeeClick can be completed directly from your FeeClick dashboard. Items tagged Manual require physical records or action outside the system.

Checklist Progress 0 / 20 completed
Work through each phase in order for the most accurate results.
1
Phase 1 — Freeze & Verify the Fee Schedule
5 items
Lock the fee schedule for the closing term
Prevent any new fee line items, discounts, or waivers from being added retroactively. In FeeClick, set the term status to "Closed" to restrict further edits to the billing configuration.
FeeClick
Confirm total student enrolment count matches billing records
Cross-reference the active student count from SchoolClick with the number of students billed in FeeClick. Any discrepancy here — typically from late enrolments or mid-term withdrawals — must be resolved before totals can be trusted.
FeeClick
Verify all approved discounts and waivers are documented
Every discount — scholarship, sibling reduction, staff child concession — should have a corresponding approval on file. Pull the discount summary report and confirm each line has an authorised signatory. Undocumented discounts are a common audit finding.
Critical
Confirm expected revenue total from the term billing report
Generate FeeClick's Term Billing Summary. This is your baseline figure: the total that should have been collected if every student paid in full with no discounts beyond those approved. Note this number — everything in phases 2 and 3 reconciles against it.
FeeClick
Identify and write off uncollectable legacy balances (if applicable)
If any student accounts carry outstanding balances from prior terms that have been approved for write-off by management, process these before running reconciliation. Carrying irrecoverable balances forward distorts your collection rate metrics each term.
Manual
2
Phase 2 — Reconcile Payments Received
6 items
Post all pending cash and cheque payments before closing
Ensure every payment received before the last day of term has been entered into FeeClick. Payments collected at the front desk but not yet posted to student accounts are the single largest source of reconciliation differences.
Critical
Match bank transfer receipts against FeeClick payment entries
Download your school's bank statement for the term period and compare each inward transfer against a corresponding payment record in FeeClick. Flag any bank credits without a matching FeeClick entry — these are unposted payments. Flag any FeeClick entries without a bank credit — these may be duplicate entries or reversed transactions.
FeeClick
Review and reconcile POS / card payment settlement reports
If your school accepts card payments via POS terminals, the settlement amount from your payment processor may differ from the gross transaction total due to processor fees. Reconcile net settlements — not gross charges — against your bank statement credits.
Manual
Identify and resolve duplicate payment entries
Run FeeClick's duplicate payment check — found under Reports → Payment Integrity. Duplicates typically arise when a parent pays twice (once via transfer, once via the parent portal without knowing the first cleared) or when a cashier posts the same receipt twice. Issue refunds or contra-entries for confirmed duplicates.
FeeClick
Confirm total payments collected equals bank deposits for the period
The sum of all payment entries in FeeClick for the term should equal the net inward transfers on your bank statement. If they do not match after resolving the steps above, the gap must be investigated — it represents either undeposited cash or unrecorded receipts.
Critical
Record and file all physical payment receipts for the term
Physical receipt booklets must be fully accounted for: every issued receipt should correspond to a FeeClick entry, and every voided receipt should be physically retained with the reason for voiding noted. Missing receipt books are a serious audit and fraud-risk issue.
Manual

"Reconciliation is not about finding the answer — it's about proving you already had the right one."

Click Editorial — Finance & Bursary Series
3
Phase 3 — Outstanding Balances & Defaulters
5 items
Generate the end-of-term outstanding balance report
Run FeeClick's Outstanding Balances report filtered to the closing term. This is your definitive list of accounts with unpaid fees. Export it in both PDF (for management) and CSV (for follow-up workflows) formats and timestamp the export — this becomes the official record of what was owed at term close.
FeeClick
Segment defaulters by outstanding amount and duration
Not all outstanding balances need the same response. Segment accounts into: small balance (under ₦5,000 — likely administrative), medium balance (₦5,000–₦50,000 — requires direct follow-up), and large balance (above ₦50,000 — requires management involvement). FeeClick's filter and sort tools allow this segmentation in under five minutes.
FeeClick
Send end-of-term balance statements to all outstanding accounts
Use FeeClick's bulk statement dispatch to send each parent or guardian a personalised fee statement showing their outstanding balance, the fees paid this term, and any balance carried forward from previous terms. Transparency here is the most effective prompt for payment before the next term begins.
FeeClick
Flag accounts with arrears for re-enrolment hold
Mark accounts above a threshold outstanding balance to trigger a re-enrolment hold in SchoolClick. This ensures admissions staff are alerted at the start of the next term before a student is formally accepted back — the most practical leverage point for recovering significant arrears.
FeeClick
Obtain management sign-off on the final outstanding balance figure
Before the term is officially closed in the system, the total outstanding amount must be reviewed and signed off by the principal, head of finance, or governing board as appropriate to your institution's governance structure. This sign-off is the formal acceptance of the reconciliation result.
Manual
4
Phase 4 — Close, Report & Archive
4 items
Generate the final Term Revenue Summary report
This report should show: total fees billed, total discounts applied, total payments collected, total outstanding, and your effective collection rate as a percentage. This is the single-page financial snapshot that management and governors need. Export from FeeClick under Reports → Term Summary.
FeeClick
Compare collection rate against the previous two terms
A single term's collection rate tells you little. A trend tells you everything. Is your rate improving, declining, or stable? FeeClick's multi-term comparison view surfaces this automatically. A declining trend requires a policy review before next term — not after.
FeeClick
Archive all reconciliation documents for the term
File the following in a single labelled folder (digital or physical): Term Billing Summary, Payment Reconciliation workpaper, Bank Statement, Outstanding Balance Report, Discount Approval Register, management sign-off, and any correspondence relating to disputed payments. Retention minimum is seven years for most jurisdictions.
Manual
Formally close the term in FeeClick and open the next
With reconciliation complete and sign-off obtained, close the term in FeeClick. This triggers the automatic carry-forward of outstanding balances to the new term's ledger, generates opening balance notifications for affected accounts, and activates the new term's fee schedule. The next term starts clean.
FeeClick

The Five Most Common Reconciliation Errors — and How to Avoid Them

After working with dozens of school finance teams across Nigeria, Ghana, and Kenya, these are the mistakes that come up most often during reconciliation reviews:

Error Root Cause Prevention
Frequent
Payments received but not posted 		Cashier collects cash, issues receipt, but delays entering into system — sometimes indefinitely Require same-day posting as a standing policy. FeeClick's daily collection report makes unposted receipts visible by end of day.
Frequent
Duplicate student accounts 		Student registered twice (e.g., name variation), creating split payment history Run a duplicate student check in SchoolClick before opening the fee schedule each term. Merge duplicates before billing begins.
Common
Unapproved or undocumented discounts 		Discounts granted informally by the principal or class teacher without bursar notification Establish a written discount approval policy. All concessions — regardless of amount — must be entered in FeeClick with an authoriser name before they take effect.
Common
Payments allocated to wrong student 		Parent transfers without a reference, cashier allocates to wrong sibling or student with similar name Provide every parent with a unique FeeClick payment reference at the start of term. Require it on all bank transfers.
Occasional
Reversed payments not removed from ledger 		Bank reverses a transfer (bounced cheque, recalled transfer), but the original payment entry in FeeClick remains Subscribe to bank reversal alerts. Process reversal entries in FeeClick on the day they appear on the bank statement — not at term end.
⚠ A Word on Timing

Reconciliation is most effective when it is treated as a continuous process, not a term-end sprint. Bursars who do weekly mini-reconciliations — matching that week's bank credits to FeeClick entries every Friday — typically close their term in under two hours. Those who leave it all to the final week routinely spend two to three full days resolving compounded discrepancies.

Key FeeClick Tools Referenced in This Checklist

All of the FeeClick-tagged items in this checklist use features that are available on all FeeClick plans. Here is a quick reference to where each is found in the dashboard:

Term Billing Summary — Reports → Fee Reports → Term Summary. Filterable by class, student category, or fee type.

Payment Reconciliation Report — Reports → Payment Reports → Reconciliation View. Compare FeeClick totals to a manually entered bank figure and surface the gap instantly.

Outstanding Balances Report — Reports → Debtors → Outstanding by Term. Exportable to PDF and CSV. Can be scheduled for automatic delivery to a specified email address each Monday.

Duplicate Payment Check — Reports → Payment Integrity → Duplicate Detector. Flags any two payments on the same account within the same amount and a configurable time window.

Bulk Statement Dispatch — Communications → Fee Statements → Bulk Send. Generates personalised PDF statements for all outstanding accounts and sends via email or SMS in one action.

💡 Pro Tip

Schedule FeeClick's Outstanding Balances Report to auto-send to your inbox every Monday morning throughout the term. By the time reconciliation arrives, you'll have dealt with most discrepancies as they arose — not all at once.

See FeeClick's Reconciliation Tools Live

Book a 30-minute walkthrough of FeeClick's ledger, payment matching, and end-of-term reporting with our finance onboarding team.

Request a Demo
FeeClick Fee Management Reconciliation Bursars School Finance Checklist Term Close