Skip to content
← TemplatesSchools & churches

Free School Fees Management System (Excel) for Kenyan schools

Chasing fee balances by hand is where schools lose money and patience. This free workbook fixes it: set the fee for each class once, add your students, and log every payment — the sheet bills each student automatically, keeps a running balance, and shows you exactly who has cleared and who still owes.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Auto-bill each student from their class fee (INDEX/MATCH)
  • Payments rolled up by admission number
  • Red 'Balance' / green 'Cleared' status per student
  • Dashboard: billed, collected, outstanding, collection rate, per-class balances
  • Change a class fee once — the whole class re-bills

The tabs

  • Start Here (guide)
  • Fee Structure
  • Students
  • Payments
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

It has four working tabs. Fee Structure holds your school name, the term and the fee for each class (PP1 to Grade 12) — change a class's fee and every student in it is re-billed instantly. Students is your register: add each child's admission number, name and class, and their fee, payments and balance appear on their own. Payments is a simple log with an admission-number dropdown. The Dashboard totals fees billed, collected and outstanding, your collection rate, and the outstanding balance for every class.

Balances turn red when a student owes and green when cleared, so a bursar can see the whole school at a glance. Everything is a formula; only the yellow cells accept typing, so the maths can't be broken. It opens in Excel or Google Sheets — share the sheet with the head teacher and treasurer.

When you need to hand parents a fee statement or receipt, our free document tools produce clean, printable versions in minutes.

Do it online instead

Explore our free tools for schools & businesses

Open the free tool →

Frequently asked questions

How does the fee get billed to each student?

You set the fee per class on the Fee Structure tab. When you enter a student's class on the Students tab, the sheet looks up that class's fee and bills it automatically. Change the class fee and every student in the class is re-billed.

Can it handle CBC classes and several terms?

Yes. The class list runs PP1 to Grade 12 and is editable. Each term you update the fee per class; the students and payments stay, so balances carry correctly.

Is it suitable for a small tuition centre?

Yes — it works for any school, college or tuition centre that bills fees by class or level. Add as many students and payments as you need.