{% extends "../base.html" %} {% load crispy_forms_tags %} {% load humanize %} {% block page_title %}Financial Summary Report{% endblock %} {% block content %}

Financial Summary Report

Executive Summary

Financial Overview for {{ academic_year_name }} - {{ term_name }}

{% if collection_rate >= 90 %} Excellent School fees collection is performing very well at {{ collection_rate }}%. {% elif collection_rate >= 75 %} Good School fees collection is satisfactory at {{ collection_rate }}%. {% else %} Needs Attention School fees collection requires improvement at {{ collection_rate }}%. {% endif %}

{% if net_balance >= 0 %} Surplus The school has a positive financial position with UGX {{ net_balance|floatformat:0|intcomma }} surplus. {% else %} Deficit The school has a deficit of UGX {{ net_balance|floatformat:0|intcomma|slice:"1:" }}. {% endif %}

Total Revenue: UGX {{ total_income|floatformat:0|intcomma }} | Total Expenses: UGX {{ total_expenditure|floatformat:0|intcomma }} | Outstanding Fees: UGX {{ total_outstanding|floatformat:0|intcomma }}

{% if overall_quality != 'good' %}
Data Quality: {% if overall_quality == 'poor' %} Poor - Critical issues detected {% else %} Fair - Some issues detected {% endif %}
{% endif %}
{% if over_expenditure_alerts %}
{% endif %} {% if class_data %}

Key Performance Indicators

Quick overview of the school's financial health

School Fees Collection

{{ collection_rate|floatformat:1 }}%

Of billed fees collected
{% if collection_rate >= 90 %} Excellent performance {% elif collection_rate >= 75 %} Good performance {% else %} Needs improvement {% endif %}
Budget Usage

{{ budget_utilization }}%

Of allocated budget spent
{% if budget_utilization <= 90 %} Within budget {% elif budget_utilization <= 105 %} Slightly over budget {% else %} Significantly over budget {% endif %}
Unpaid School Fees

{{ total_outstanding|floatformat:0|intcomma }}

UGX still owed by parents
{% if total_outstanding == 0 %} All fees collected {% else %} Outstanding balance {% endif %}
Collected Fees

{{ total_school_fees_collected|floatformat:0|intcomma }}

UGX collected
Total collected

School Fees Collection by Class

Detailed breakdown of tuition fees and other charges for each class

{% for class_info in class_data %} 200 %}style="background-color: #fff3cd;"{% endif %}> {% endfor %}
Class Tuition Fee per Student Other Fees per Student Number of Students Total Tuition Billed Total Other Fees Total Amount Collected Outstanding Balance Collection Performance
{{ class_info.class_name }} {% if class_info.collection_rate > 200 %} {% endif %} UGX {{ class_info.school_fees_per_student|intcomma }} UGX {{ class_info.other_fees_per_student|intcomma }} {{ class_info.num_students }} UGX {{ class_info.total_school_fees|intcomma }} UGX {{ class_info.total_other_fees|intcomma }} UGX {{ class_info.total_collected|intcomma }} UGX {{ class_info.outstanding|intcomma }} {{ class_info.collection_rate|floatformat:1 }}% {% if class_info.collection_rate > 200 %}
⚠️ Verify data {% endif %}
OVERALL TOTAL UGX {{ total_school_fees_billed|intcomma }} UGX {{ total_other_income|intcomma }} UGX {{ total_school_fees_collected|intcomma }} UGX {{ total_outstanding|intcomma }} {{ collection_rate|floatformat:1 }}%
{% if budget_item_data %}

Expenditure & Budget Analysis

Detailed breakdown of budget allocations, actual expenditures, and financial performance

Total Budget Allocated

UGX {{ total_allocated }}

Total Spent

UGX {{ total_expenditure|floatformat:0|intcomma }}

Remaining Budget

UGX {{ remaining_budget|floatformat:0|intcomma }}

{{ budget_utilization }}% Used
{% for item in budget_item_data %} {% if item.expenditures %} {% for expenditure in item.expenditures %} {% endfor %} {% endif %} {% endfor %}
Department Expense Category Budget Allocated Amount Spent Remaining Utilization Status
{{ item.budget_item.department }} {{ item.budget_item.expense }} UGX {{ item.allocated|floatformat:0|intcomma }} UGX {{ item.spent|floatformat:0|intcomma }} UGX {{ item.remaining|floatformat:0|intcomma }} {% if item.allocated > 0 %} {{ item.utilization }}% {% else %} N/A {% endif %} {% if item.allocated > 0 %} {% if item.spent > item.allocated %} Over Budget {% elif item.utilization <= 90 %} On Track {% else %} Near Limit {% endif %} {% else %} No Budget {% endif %}
{{ expenditure.description|default:"Expenditure" }} UGX {{ expenditure.amount|floatformat:0|intcomma }} {{ expenditure.date|date:"M d, Y" }}
TOTAL UGX {{ total_allocated|floatformat:0|intcomma }} UGX {{ total_expenditure|floatformat:0|intcomma }} UGX {{ remaining_budget|floatformat:0|intcomma }} {{ budget_utilization|floatformat:1 }}% {% if budget_utilization <= 90 %} Excellent {% elif budget_utilization <= 105 %} Good {% else %} Needs Attention {% endif %}
{% for dept_name, dept_data in department_breakdown.items %}
{{ dept_name }} Department
{% for item in budget_item_data %} {% if item.budget_item.department.name == dept_name %} {% endif %} {% endfor %}
Budget Item Expense Category Allocated Spent Remaining Utilization
{{ item.budget_item.expense }} {{ item.budget_item.expense }} UGX {{ item.allocated|floatformat:0|intcomma }} UGX {{ item.spent|floatformat:0|intcomma }} UGX {{ item.remaining|floatformat:0|intcomma }} {% if item.allocated > 0 %} {{ item.utilization }}% {% else %} N/A {% endif %}
Department Total UGX {{ dept_data.allocated|floatformat:0|intcomma }} UGX {{ dept_data.spent|floatformat:0|intcomma }} UGX {{ dept_data.remaining|floatformat:0|intcomma }} {{ dept_data.utilization|floatformat:1 }}%
{% endfor %}

Revenue

School Fees Collected: UGX {{ total_school_fees_collected|floatformat:0|intcomma }}
Other Income: UGX {{ total_other_income|floatformat:0|intcomma }}
Total Revenue: UGX {{ total_income|floatformat:0|intcomma }}

Expenditures

Total Expenditures: UGX {{ total_expenditure|floatformat:0|intcomma }}
Net Position: UGX {{ net_balance|floatformat:0|intcomma }}
Key Performance Indicators
  • Collection Rate: {{ collection_rate|floatformat:1 }}% of billed fees collected
  • Budget Utilization: {{ budget_utilization|floatformat:1 }}% of allocated budget spent
  • Financial Health: {% if net_balance >= 0 %} Positive balance of UGX {{ net_balance|floatformat:0|intcomma }} {% else %} Deficit of UGX {{ net_balance|floatformat:0|intcomma|slice:"1:" }} {% endif %}
{% else %}
No Budget Data Available

No budget has been created for the selected academic year and term ({{ academic_year_name }} - {{ term_name }}).

To view expenditure analysis, please:

  • Create a budget for this term in the Budget Management section
  • Or select a different academic year/term that has budget data
{% endif %}
{% else %}

No data available for the selected filters

{% endif %}
{% endblock %}