Accounting for School Administrators

1. Why Schools Need Accounting

A school is a business. It collects fees, pays salaries, buys food, maintains buildings, and must account for every shilling to:

• Parents — "Where does my school fees go?"
• The Board of Governors — "Are we spending wisely?"
• The Ministry of Education — "Is the USE (Universal Secondary Education) grant being used properly?"
• URA (Uganda Revenue Authority) — "Are you remitting PAYE and NSSF correctly?"
• Auditors — "Can you prove every transaction?"

Without proper accounting, a school cannot answer these questions. The SchoolAdmin system automates this process so that you don't need to be a trained accountant — but understanding the concepts will make you far more effective.

2. The Accounting Equation

This is the single most important concept in all of accounting. Everything else flows from it:

What does this mean in a school context?

The equation must ALWAYS balance. If the school has UGX 500M in assets and owes UGX 200M, the equity is UGX 300M. Always. This is not a suggestion — it's a mathematical law that the system enforces.

Why Two More Categories?

To track how money flows in and out, we add:

3. Chart of Accounts — Your Financial Dictionary

The Chart of Accounts (CoA) is a numbered list of every category where money can be recorded. Think of it as the school's financial filing system — every transaction must be filed into one of these categories.

SchoolAdmin seeds 74 default accounts for Ugandan schools, organized into 5 types:

ASSETS (Codes 1000–1499) — What the school owns

LIABILITIES (Codes 2000–2299) — What the school owes

EQUITY (Codes 3000–3099) — The school's net worth

REVENUE (Codes 4000–4199) — Money earned

EXPENSES (Codes 5000–5900) — Money spent

Header Accounts vs. Postable Accounts

In the Chart of Accounts tree view, some accounts are marked Is Header = Yes. These are category groupings — you cannot record transactions against them. Only leaf accounts (non-headers) can receive journal entry lines.

For example:

• 1100 Current Assets — Header (grouping only)
  • 1110 Cash on Hand — Postable (transactions go here)
  • 1120 Bank Account – Main — Postable (transactions go here)

Normal Balance — Debit or Credit?

4. Double-Entry Bookkeeping — Every Transaction Has Two Sides

This is the core principle: every financial event affects at least two accounts, and the debits must equal the credits.

The Logic (Simplified)

When money moves, it always comes from somewhere and goes to somewhere:

Why Double-Entry Matters

1. Error detection — If debits ≠ credits, something is wrong. The system won't let you post an imbalanced journal entry.
2. Complete trail — You can trace where every shilling came from and where it went.
3. Automatic reports — The Balance Sheet and Income Statement are just summaries of all journal entries.

5. The Fees Module — Where Money Comes In

The Fees module manages the school's primary revenue stream — collecting money from parents and guardians.

5.1 Fee Categories — What You Charge For

Fee categories define the types of fees a school charges:

5.2 Fee Structures — How Much You Charge

Fee structures set the actual amounts for each category, per class and term. Think of it as a price list:

5.3 Student Bills — The Invoice

When you generate bills, the system creates one StudentBill per student per term, containing StudentBillItems (line items) for each applicable fee category.

5.4 Fee Payments — Recording Money Received

Every payment is recorded with details of how the money was received:

5.5 SchoolPay Integration — Automated Payments

SchoolPay is Uganda's leading school fee payment platform. Parents pay via MTN MoMo or Airtel Money, and SchoolPay automatically notifies your system.

5.6 Fees Dashboard — The Overview

6. The Finance Module — Where Money Goes Out & Gets Tracked

The Finance module handles everything beyond fee collection: expenses, accounting records, budgets, and financial reporting. It's the school's complete accounting system.

7. Journal Entries — The Heart of the System

A journal entry is the official record of a financial transaction in the accounting system. Every financial event — whether a parent pays fees, the school buys food, or petty cash is used — creates a journal entry.

7.1 What a Journal Entry Looks Like

Example: School pays teacher salaries for February 2025

The school's salary expense (5110) goes UP by 82.5M (debit increases expenses). The school's bank account (1120) goes DOWN by 82.5M (credit decreases assets). The totals are equal — the entry is balanced.

7.2 Journal Entry Statuses

7.3 Reference Types — Where Did This Entry Come From?

7.4 When to Create Manual Journal Entries

You only need to create manual journal entries for non-routine events:

7.5 Creating a Journal Entry in SchoolAdmin

1. Navigate to Finance → Overview → Journal Entries
2. Click “Add Journal Entry”
3. Fill in the Date, Description, and Reference Type (usually MANUAL)
4. Add line items (minimum 2): Select an account, enter either a Debit or Credit amount (never both on the same line), add a description
5. The form shows a running balance — the difference must be zero (shown in green) before you can save
6. Click “Save as Draft” to review later, or “Save & Post” to finalize immediately

7.6 Reversing a Posted Entry

Made a mistake on a posted entry? You can't edit it (that would break the audit trail), but you can reverse it:

1. Open the journal entry
2. Click “Reverse”
3. The system creates a new entry with the debits and credits swapped
4. Both the original and the reversal are kept in the records — full transparency

8. Expense Management — Tracking Where Money Goes

8.1 Expense Categories

Expense categories group your spending into logical buckets. Each category has a linked chart account so the system knows which GL (General Ledger) account to debit when an expense is recorded.

8.2 Recording an Expense

1. Category — Select from dropdown (e.g., “Food & Provisions”)
2. Date — When the expense occurred
3. Amount — How much was spent (in UGX)
4. Description — What was purchased (e.g., “Posho 50 bags, beans 30 bags”)
5. Vendor — Who you bought from
6. Receipt Number — Supplier invoice or receipt reference
7. Payment Method — How you paid (CASH, BANK_TRANSFER, CHEQUE, MOBILE_MONEY)

9. Petty Cash — Small Cash for Daily Needs

Petty cash is a small amount of physical cash kept at the school for minor, urgent expenses — things too small to justify a cheque or bank transfer.

How Petty Cash Works

1. Top-up (DEPOSIT): The bursar withdraws cash from the bank and adds it to the petty cash tin.
2. Disbursement (WITHDRAWAL): When someone needs small cash, they get it from petty cash.
3. Balance tracking: The system tracks the running balance after each transaction.

10. Bank Accounts & Reconciliation

10.1 Bank Accounts

Most schools maintain multiple bank accounts for different purposes:

10.2 Bank Reconciliation — Why It Matters

Bank reconciliation is the process of comparing your books (journal entries) with the bank's records (bank statements) to make sure they agree.

Why might they differ?

11. Budgets — Planning Your Money Before Spending It

Why Budget?

• Board approval — The Board of Governors must approve spending before the year starts
• Spending control — Prevents departments from overspending
• Government compliance — USE grant schools must show how funds will be used
• Variance analysis — Compare actual spending to planned spending to spot problems early

Budget Structure

A budget consists of a Header (name, type, academic year, status) and Budget Lines (each line references a chart of accounts entry with a budgeted amount).

Budget vs. Actual — Variance Analysis

For each budget line, the system compares: Variance = Budgeted Amount − Actual Spent

• Positive variance (green) — Spent less than planned. Good.
• Negative variance (red) — Spent more than planned. Needs investigation.
• Zero variance — Spent exactly as planned. Unlikely but perfect.

12. Financial Reports — The Payoff

All the data entry, journal entries, and careful categorization lead to two essential financial reports that tell the school's financial story.

12.1 Income & Expenditure Statement (I&E)

The I&E (also called “Profit & Loss” in business) answers: “Did the school earn more than it spent during this period?”

12.2 Balance Sheet

The Balance Sheet answers: “What does the school own, owe, and what is its net worth — right now?”

12.3 Finance Dashboard

The dashboard is the at-a-glance view that combines everything: KPI cards (Total Revenue, Total Expenses, Net Income, Cash Position), an Expense-by-Category pie chart, recent journal entries, and alerts for pending items.

13. How It All Connects — The Full Picture

Here's how the Fees and Finance modules work together:

The Money Flow

1. Parent pays via MoMo → SchoolPay receives payment → Sends webhook to SchoolAdmin
2. Fees Module records the payment, updates student bill
3. DB Trigger automatically creates a journal entry (DR Cash/Bank/MoMo, CR Revenue)
4. Journal entries aggregate into Financial Reports (I&E, Balance Sheet, Dashboard)
5. School records expenses → Finance Module saves the expense
6. DB Trigger automatically creates a journal entry (DR Expense, CR Bank)
7. Same reports show the complete picture of revenue vs. expenses

The Auto-Journal Triggers — The Magic Glue

Three database triggers automatically create journal entries:

14. Real-World Scenarios

Scenario 1: “A parent just paid UGX 1,000,000 via MTN MoMo”

What happens in the system:

1. SchoolPay receives the payment and sends a webhook
2. The system creates an external_payment_transaction (status: PENDING)
3. Auto-matching finds the student by admission number
4. A fee_payment is created (method: MOBILE_MONEY, provider: SCHOOLPAY)
5. The student's bill is updated (balance reduced by 1M)
6. The auto-journal trigger creates: DR 1140 Mobile Money Account 1,000,000 / CR 4010 Tuition Fees 1,000,000
7. The Fees Dashboard updates: Today's Collection + 1M
8. The I&E Report shows increased revenue
9. The Balance Sheet shows increased assets (cash) and increased equity (revenue)

Scenario 2: “We need to buy 50 bags of posho and 30 bags of beans”

What you do:

1. Go to Finance → Expenditure → Record Expenses
2. Category: Food & Provisions, Amount: UGX 28,000,000, Vendor: Mukwano Industries Ltd
3. Save the expense

What happens automatically: DR 5310 Food & Provisions 28,000,000 / CR 1120 Bank Account 28,000,000. The I&E report now shows UGX 28M more in Food expenses.

Scenario 3: “The generator ran out of fuel during a power outage”

1. Go to Finance → Accounts → Petty Cash
2. Click “Disburse” — Amount: UGX 85,000, Description: “Fuel for generator”
3. Auto-creates: DR 5800 Miscellaneous 85,000 / CR 1150 Petty Cash 85,000

Scenario 4: “The government sent our USE capitation grant”

1. Go to Finance → Overview → Journal Entries
2. Click “Add Journal Entry”
3. Line 1: DR 1120 Bank Account 49,000,000
4. Line 2: CR 4080 Government Grants 49,000,000
5. Click “Save & Post”

Scenario 5: “The Board wants to know if we're within budget”

1. Go to Finance → Budgeting → Budget vs Actual
2. Select the approved budget
3. The system shows each budget line with budgeted amount, actual amount, and variance
4. Look for red items — those are categories where spending exceeded the budget

Scenario 6: “Month-end bank reconciliation”

1. Get the bank statement from Stanbic (online or paper)
2. Go to Finance → Reports → Bank Reconciliation
3. Select “Main Operating Account”
4. Enter the closing balance from the bank statement
5. Check off each statement entry that matches a journal entry in your books
6. Investigate unmatched entries (bank charges, interest, errors)
7. Goal: statement balance − book balance = 0

15. Quick Reference & Glossary

What To Do When…

Glossary of Accounting Terms