Financial Reports

Two report pages help you translate raw transactions into leadership-ready summaries: the Financial Reports dashboard and the Monthly Comparison trend.

Navigation: Finance ▸ Reports ▸ Financial Reports or Monthly Comparison.

Financial Reports Page

Date Range Filter

  • From / To date inputs default to the current month.
  • Submit reloads the page with query parameters; Clear removes filters.
  • All widgets on the page recompute based on the selected range.

Summary Cards

  • Total Fee Revenue – sums payments.amount within the date range.
  • Other Revenue – sums other_revenues.amount within the range.
  • Total Expenditure – sums expenditures.amount.
  • Net Position – (fee + other) − expenditure. Card color switches based on sign.

Revenue by Account Table

Column Description
Revenue Account Name of the account.
Amount Total fee + other revenue credited to the account during the range.
% Share of the total revenue (fee + other) represented by that account.

Expenditure by Type Table

  • Columns: Type Name, Amount, % of total expenditure.
  • Pulls directly from the Expenditure model grouped by expenditure_type_id.

Revenue vs Expenditure Chart

  • Rendered with Chart.js (line chart, fill enabled).
  • Shows Total Revenue vs Expenditure over the selected range.

Cashbook Balances Table

  • Lists each active cashbook with its type and current_balance.
  • Provides the total cash position at the bottom.
Actions: Use the built-in Print and Export to Excel buttons to share the report snapshot after applying filters.

Monthly Comparison Page

Shows the last 12 months (rolling) of fee revenue, other revenue, expenditure, and net position.

KPI Cards

  • Average Monthly Revenue
  • Average Monthly Expenditure
  • Average Net Position
  • Best Month (month/year plus net amount)

Monthly Breakdown Table

Column Description
Month Formatted as “Jan 2025”.
Fee Revenue / Other Revenue Sums for the month.
Total Revenue Fee + Other.
Expenditure Monthly spend.
Net Position Total Revenue − Expenditure.
% Change Net change compared to the previous month.

Trend Chart

  • Chart.js line chart with three datasets: Total Revenue, Expenditure, Net.
  • Helps visualize seasonality or spikes in spending.
Data sources: Both report pages read directly from payments, payment_fee_allocations, other_revenues, and expenditures filtered by your school. Ensure daily processes (payments, other revenue, expenditures) are recorded before running exports.