Docs
mybridgeerp.com

Finance reports & reconciliation

Good reports turn a pile of payments into decisions: how much came in today, who still owes, which class is behind, and what the accountant needs at month-end. This page covers the core finance reports, the daily reconciliation routine, and exporting cleanly for your accounts team.

Where to find it — App drawer → Fees & Finance → Reports → Bursary Summary.
Finance reports & reconciliation
Finance reports & reconciliation in EduPrime.

Core reports

Find them under Fees & Finance → Reports.

ReportAnswers
CollectionsHow much was received, by date, method and account
OutstandingTotal still owed, by family, class and term
AgingHow old the arrears are (30/60/90)
By class / streamCollection and arrears broken down per class
Financial aidTotal scholarships and bursaries granted

Each report filters by term, class, stream and date range, and exports to spreadsheet. Use By class / stream at finance-committee meetings – it shows instantly where collection is strong and where to focus follow-up.

Tip — Schedule the Collections and Outstanding reports to email the head and bursar every Monday. A weekly rhythm catches a slipping class while there is still term left to recover it.

Daily reconciliation routine

Reconcile every day so problems surface within 24 hours, not at term-end.

  1. Open the Collections report filtered to today.
  2. Compare mobile money totals against each aggregator’s settlement statement – they should match.
  3. Compare cash recorded against the physical cash counted at the bursary.
  4. Compare bank/card against the bank feed.
  5. Clear the Unmatched payments tray – assign any mis-referenced payments to the right student.
  6. Investigate and note any difference before close of day.
Important — The most common daily discrepancy is a payment sitting unmatched because the parent used the wrong reference. Always empty the Unmatched tray before reconciling cash – otherwise you will hunt for a “missing” amount that is actually sitting unallocated.

Exporting for the accounts team

Your accountant works in the school’s general ledger or external accounting package. EduPrime exports the figures they need without re-keying.

  1. Run the report for the period (month or term).
  2. Export to spreadsheet, grouped by income account so it maps to the chart of accounts.
  3. Provide the collections summary, the outstanding summary and the aid summary together – they tie out to each other.
Tip — Because fee items carry their GL account, the export already groups revenue by ledger code. Hand your accountant the grouped export rather than a raw transaction dump – it slots straight into their books and saves an afternoon of sorting.

Month-end checklist

  • Unmatched tray empty.
  • Mobile-money settlements reconciled to Collections.
  • Cash and bank reconciled.
  • Aging reviewed and reminders/plans actioned.
  • Reports exported and shared with accounts.

Run this checklist every month and term-end becomes a formality rather than a crisis.

Was this page helpful?