Skip to main content

Expense Management Guide

Roles: School Admin, Accountant, Staff (view own expenses)

Expense Management allows schools to track and categorize all operational expenses including utilities, supplies, maintenance, staff salaries, and other costs. This feature helps administrators and accountants maintain accurate financial records and generate expense reports.

Feature Access

This feature must be enabled for your school. If you don't see the Expense menu, contact your system administrator or support to activate Expense Management module.

Overview​

The Expense Management system consists of two main components:

  1. Expense Categories - Organize expenses into logical groups (e.g., Utilities, Supplies, Maintenance)
  2. Expense Records - Individual expense entries with details like amount, date, reference number, and description

Key Features:

  • Create and manage expense categories
  • Record expenses with detailed information
  • Track expenses by session year
  • Filter and search expense records
  • Generate expense reports and analytics
  • View expense trends over time
  • Export expense data

💰 Managing Expense Categories​

Before recording expenses, you should create expense categories to organize your expenses logically.

Creating Expense Categories​

Step 1: Access Expense Categories

  1. Log in as School Admin or Accountant
  2. Go to Finance → Expense Categories (or similar menu path)

Step 2: Add New Category

  1. In the "Create Expense Category" section, fill in:
    • Name (required) - Category name (e.g., "Utilities", "Office Supplies", "Maintenance")
    • Description (optional) - Additional details about this category
  2. Click Submit

Example Categories:

  • Utilities - Electricity, water, internet bills
  • Office Supplies - Stationery, printer ink, paper
  • Maintenance - Building repairs, equipment servicing
  • Transportation - Vehicle fuel, maintenance (handled separately for school transport)
  • Salaries - Staff payroll (auto-generated by payroll system)
  • Miscellaneous - Other operational expenses
Best Practice

Create specific categories rather than lumping everything into "Miscellaneous". This makes reporting and analysis much more meaningful.

Editing Expense Categories​

  1. In the expense category list, find the category you want to edit
  2. Click the Edit button (pencil icon)
  3. Update the name or description
  4. Click Submit
caution

Category names must be unique. You cannot have two categories with the same name.

Deleting Expense Categories​

  1. In the expense category list, find the category to delete
  2. Click the Delete button (trash icon)
  3. Confirm the deletion

Soft Delete:

  • Deleted categories are moved to "Trashed" (not permanently deleted)
  • You can view trashed categories by clicking Trashed in the list view
  • Restore a category by clicking Restore in the trashed view
  • Permanently delete only if the category has no associated expenses
warning

You cannot permanently delete a category that has expense records. You must first reassign or delete those expenses.

📝 Recording Expenses​

Creating an Expense Record​

Step 1: Access Expense Management

  1. Log in as School Admin or Accountant
  2. Go to Finance → Expenses

Step 2: Fill in Expense Details

  1. In the "Create Expense" form, provide:

    • Category (required) - Select from your expense categories
    • Title (required) - Brief description (e.g., "Electricity Bill - January 2026")
    • Reference No (optional) - Invoice number, bill reference, or tracking number
    • Amount (required) - Expense amount (numbers only, no currency symbol)
    • Date (required) - Date of expense (must be within the selected session year)
    • Description (optional) - Additional notes or details
    • Session Year (required) - The academic session this expense belongs to

  2. Click Submit

Field Validation:

  • Amount must be a positive number (0 or greater)
  • Reference No must be unique within the session year (if provided)
  • Date must fall within the selected session year's start and end dates
Reference Numbers

Use reference numbers for tracking invoices and receipts. This makes it easier to match expenses with physical documents during audits.

Editing an Expense Record​

  1. In the expense list, find the expense to edit
  2. Click the Edit button (pencil icon)
  3. Update the fields as needed
  4. Click Submit
Salary Expenses

Expenses marked as "Salary" (auto-generated from payroll) cannot be edited or deleted manually. These are managed through the Payroll system.

Deleting an Expense Record​

  1. In the expense list, find the expense to delete
  2. Click the Delete button (trash icon)
  3. Confirm the deletion

What Gets Deleted:

  • The expense record is permanently removed
  • Session year tracking is updated
  • This action cannot be undone
Permission Required

You need expense-delete permission to delete expense records.

🔍 Viewing & Filtering Expenses​

Expense List View​

The expense list displays all recorded expenses with:

  • No. - Serial number
  • Reference No - Invoice/bill reference
  • Title - Expense description
  • Category - Expense category name
  • Description - Additional details
  • Date - Expense date
  • Amount - Expense amount (with currency symbol)
  • Actions - Edit/Delete buttons

Filtering Expenses​

Use the filters at the top of the expense list to narrow down results:

Filter Options:

  1. Session Year - View expenses for a specific academic year
  2. Category - Filter by expense category (or select "Salary" to see payroll expenses)
  3. Month - View expenses for a specific month

Search:

  • Use the search box to find expenses by title, reference number, amount, description, or category name

Example Usage:

  • To see all utility bills for 2025-2026: Select session year "2025-2026" and category "Utilities"
  • To view January expenses: Select month "January"
  • To find a specific invoice: Search by reference number

Sorting & Pagination​

  • Sort - Click column headers to sort by that field
  • Page Size - Choose how many records to display (5, 10, 20, 50, 100, 200)
  • Navigation - Use pagination controls to browse through pages

📊 Expense Analytics & Reports​

At the bottom of the expense list, you'll see:

  • Total Amount - Sum of all expenses matching your current filters

This updates automatically as you apply filters.

Viewing Expense Graph:

  1. Go to Dashboard (expense analytics may be shown here)
  2. Select a Session Year from the dropdown
  3. View the expense trend graph showing:
    • Monthly expense amounts
    • Total expenses per month
    • Comparison across months

What the Graph Shows:

  • X-axis: Months within the selected session year
  • Y-axis: Total expense amount
  • Only months with recorded expenses are displayed
Financial Planning

Use the expense trend graph to identify peak spending months and plan your budget accordingly. For example, if expenses spike in certain months due to maintenance or events, budget extra for those periods.

Exporting Expense Data​

Step 1: Apply Filters

  • Set the session year, category, and month filters as needed

Step 2: Export

  1. Click the Export button in the toolbar (usually shows export icon)
  2. Choose export format (e.g., Excel, CSV, PDF)
  3. The file will download with all visible expense records

Export Filename:

  • Format: expense-list-DD-MM-YY.xlsx (or similar, based on export date)
  • Contains all columns except the "Actions" column

🔐 Permissions & Access Control​

Required Permissions​

Expense Category Management:

  • expense-category-create - Create new expense categories
  • expense-category-list - View expense category list
  • expense-category-edit - Edit expense categories
  • expense-category-delete - Delete expense categories

Expense Management:

  • expense-create - Record new expenses
  • expense-list - View expense list
  • expense-edit - Edit expense records
  • expense-delete - Delete expense records

Role-Based Access​

School Admin:

  • Full access to all expense features
  • Can manage categories and record expenses
  • Can view all expense reports

Accountant:

  • Full access to expense management
  • Primary role for day-to-day expense recording
  • Can generate financial reports

Other Staff:

  • Generally no access to expense management
  • May have view-only access if specifically granted
Setting Permissions

Go to Settings → Roles & Permissions to configure which roles can access expense features.

Best Practices​

Expense Recording​

Be Consistent:

  • Record expenses promptly (ideally within a week of incurring them)
  • Always include reference numbers for bills and invoices
  • Use clear, descriptive titles (avoid vague terms like "Payment" or "Bill")

Example Good Titles:

  • ✅ "Electricity Bill - Main Building - January 2026"
  • ✅ "Office Stationery Purchase - Invoice #12345"
  • ✅ "Building Roof Repair - Contractor ABC"
  • ❌ "Bill" (too vague)
  • ❌ "Payment" (no details)

Categorize Properly:

  • Use the most specific category available
  • Create new categories if existing ones don't fit
  • Don't default to "Miscellaneous" unless truly necessary

Session Year Management​

Always Select Correct Session Year:

  • Expenses are tracked per academic session
  • Ensure the expense date falls within the session year dates
  • The system will restrict date selection to the chosen session year

Why This Matters:

  • Accurate year-over-year comparisons
  • Proper financial reporting per academic cycle
  • Budget tracking aligned with school operations

Record Keeping​

Maintain Supporting Documents:

  • Keep physical or digital copies of all invoices and receipts
  • Store them in a way that matches your reference numbers
  • This is essential for audits and financial reviews

Regular Reviews:

  • Review expense records monthly
  • Check for duplicate entries
  • Verify all expenses are categorized correctly
  • Generate monthly expense reports for leadership review

Financial Controls​

Dual Verification:

  • Have accountant record expenses
  • Have admin review and approve monthly
  • This reduces errors and fraud risk

Budget Monitoring:

  • Compare actual expenses against budget
  • Identify overspending early
  • Adjust spending or budget as needed

Salary Expenses (Automatic)​

How Salary Expenses Work​

When staff payroll is processed:

  1. The system automatically creates expense records for salaries
  2. These appear in the expense list with category "Salary"
  3. They include staff details and payroll month/year

Characteristics:

  • Category: Shows as "Salary" (not a manually created category)
  • Staff Link: Associated with a specific staff member
  • Month/Year: Linked to payroll period
  • Cannot Be Edited: Managed through Payroll module, not Expense module
  • Cannot Be Deleted: Remove through Payroll corrections, not Expense module
info

To manage salary expenses, use the Payroll module under Staff Management. The Expense module only displays them for reporting purposes.

Filtering Salary Expenses​

  1. In the expense list filters, select Category: Salary
  2. Optionally filter by session year and month
  3. View all payroll expenses

This is useful for:

  • Total salary expenditure reports
  • Comparing salary vs operational expenses
  • Budget planning

Troubleshooting​

"Reference number already exists"​

Problem: You get an error when creating or editing an expense with a reference number.

Solution:

  • Reference numbers must be unique within each session year (for non-salary expenses)
  • Check if you've already recorded this expense
  • If it's a different expense with the same reference, add a suffix (e.g., "INV-123-A", "INV-123-B")
  • Or leave the reference number blank if not critical

"Cannot delete expense category"​

Problem: You cannot permanently delete a category from the trash.

Solution:

  • The category has associated expense records
  • First, reassign those expenses to another category or delete them
  • Then try deleting the category again
  • Or simply leave it in the trash (soft-deleted categories won't appear in active lists)

"Feature not available" Error​

Problem: You get a "feature not available" error when accessing Expense Management.

Solution:

  1. Verify Expense Management module is enabled for your school
  2. Check your user role has the required permissions
  3. Contact your system administrator or support if the issue persists

Date Picker Shows No Available Dates​

Problem: When selecting a date, all dates appear disabled.

Solution:

  • The date picker is restricted to the selected session year's date range
  • Change the session year to one that includes your expense date
  • If the session year is correct, verify its start and end dates are configured properly

Expense Total Doesn't Match Expectations​

Problem: The total at the bottom doesn't match your calculations.

Solution:

  • The total reflects only the expenses matching your current filters
  • Check if session year, category, or month filters are applied
  • Clear filters to see the true total
  • Remember: Pagination doesn't affect the total (it sums all matching records, not just the current page)

Workflow Examples​

Monthly Expense Recording Workflow​

For Accountants:

Week 1 of Month:

  1. Collect all bills and invoices from previous month
  2. Verify amounts and reference numbers
  3. Log into system → Finance → Expenses

Recording Process:

  1. Select appropriate session year
  2. For each bill/invoice:
    • Choose category
    • Enter title (e.g., "Electricity - February 2026")
    • Enter reference number (invoice #)
    • Enter amount
    • Select date (invoice date or payment date, per school policy)
    • Add description if needed
    • Click Submit
  3. Repeat for all expenses

Week 2 of Month:

  1. Generate expense report for previous month
  2. Filter by last month
  3. Review total expenses by category
  4. Compare against budget
  5. Export data for admin review
  6. File export with supporting documents

End of Month:

  1. Update dashboard to view expense trends
  2. Prepare financial summary for leadership
  3. Note any unusual spending patterns
  4. Plan for upcoming expenses

Annual Budget Planning Workflow​

For Admins (Before New Session Year):

Step 1: Review Previous Year

  1. Go to Expense Management
  2. Filter by previous session year
  3. Export full year expense data
  4. Analyze spending by category
  5. Note seasonal variations (month-by-month)

Step 2: Create Budget

  1. Calculate average monthly expenses per category
  2. Identify trends (increasing/decreasing)
  3. Factor in planned changes (e.g., new staff, renovations)
  4. Add contingency (typically 10-15%)
  5. Document budget by category

Step 3: Monitor Throughout Year

  1. Monthly: Compare actual vs budget
  2. Quarterly: Review and adjust forecasts
  3. Flag overspending early
  4. Reallocate budget if needed

Frequently Asked Questions​

Q: Can I record expenses for past session years? A: Yes, select the past session year from the dropdown. The date picker will adjust to that year's date range.

Q: How do I categorize expenses that fit multiple categories? A: Choose the primary category. If needed, mention the secondary aspect in the description. For complex expenses, consider splitting them into separate records.

Q: What if I enter the wrong amount? A: Click the Edit button on the expense record, correct the amount, and save. Audit logs will track the change.

Q: Can parents or students see expense records? A: No, expense data is restricted to admin and accounting staff by default. It's not visible to parents, students, or teachers unless explicitly granted.

Q: How far back does expense data go? A: All expense records are retained indefinitely unless manually deleted. You can view expenses from any past session year.

Q: Can I bulk upload expenses from Excel? A: This feature may be available depending on your system version. Check Data Import/Export documentation or contact support.

Q: What's the difference between "Date" and when I record the expense? A: "Date" is when the expense occurred (e.g., invoice date). The system automatically tracks when you created the record. Use the invoice/bill date for consistency.

Q: Do I need to create categories for salaries? A: No, salary expenses are auto-generated from the Payroll module and appear with the category "Salary". You don't need to create this category manually.

Summary Checklist​

For Initial Setup:

  • ✅ Ensure Expense Management module is enabled
  • ✅ Set up expense categories that match your accounting structure
  • ✅ Grant permissions to accountant and admin roles
  • ✅ Train accounting staff on expense recording procedures

For Monthly Operations:

  • ✅ Collect all bills and invoices
  • ✅ Record expenses within one week of payment
  • ✅ Include reference numbers for all bills
  • ✅ Review and verify expense totals
  • ✅ Generate monthly expense report
  • ✅ Compare against budget

For Year-End:

  • ✅ Export full year expense data
  • ✅ Reconcile with financial statements
  • ✅ Analyze spending patterns
  • ✅ Use data for next year's budget planning
  • ✅ Archive reports and supporting documents

Expense management is a critical part of school financial operations. Accurate, timely expense recording enables better budgeting, financial planning, and transparency. Keep your records up-to-date and review them regularly! 💰📊

Last updated on