Skip to content
School and Education templates2 free downloads

School and Education templates

Manage fees, payroll, and school finances clearly and accurately

Templates included

Key features

  • Per-student, per-term fee tracking
  • Partial payment recording with running balance
  • Class-level and school-level collection summaries
  • Outstanding balance alerts
  • Payment date and method recording

Real use case

A private primary school in Ibadan with 340 students uses this to prepare a weekly collection report for the proprietor. It reduced uncollected fees by 28% in the first term of use by making the outstanding balances visible to the admin team daily.

Download Student Fee Tracker

How to use these templates

  1. 1

    Download the file

    Click the download button. The .xlsx file saves instantly — no account needed.

  2. 2

    Open in Excel

    Open with Microsoft Excel 2016+ or Google Sheets. All formulas are pre-built and compatible.

  3. 3

    Customise and use

    Replace sample data with your business figures. Adjust headings and start immediately.

How Nigerian Schools Can Eliminate Fee Collection Chaos With Proper Financial Records

Fee management is one of the most operationally stressful aspects of running a school in Nigeria. With hundreds of students paying across three terms, at different dates, in different amounts, and sometimes in instalments, the margin for error is enormous. Most Nigerian schools track fee payments in notebooks, WhatsApp messages, or basic spreadsheets that were never designed for this purpose — and the result is constant disputes, missed collections, and year-end shortfalls.

The fundamental problem is the absence of a systematic per-student, per-term fee record. When a parent claims they paid Term 2 fees in cash and no formal receipt was issued with a corresponding ledger entry, it is impossible to verify. A proper student fee tracker creates a permanent record of every payment, including the date, amount, method, and the person who received it.

Payroll management is equally important for school sustainability. Staff costs typically represent 60 to 80 percent of a Nigerian school's total expenses, yet many school owners have no accurate, month-by-month record of what they actually spent on payroll. The PAYE obligation is another area where schools regularly face penalties — a payroll sheet that automatically computes PAYE helps school administrators meet this obligation every month.

Ready to move beyond spreadsheets?

DigitGlance Invoice automates invoicing, payment tracking, VAT reporting, and supplier management.

See DigitGlance

Need a custom school and education Excel solution?

We build custom VBA automation, management dashboards, and tailored Excel systems.

Contact us