Reports

Balance Sheet

Purpose: The Balance Sheet provides a snapshot of the financial condition of the institution at a specific point in time, summarizing assets, liabilities, and equity.

Key Components:

• Assets: Resources owned by the institution (e.g., cash, receivables).
• Liabilities: Obligations or debts (e.g., loans, payables).
• Equity: The residual interest in the assets after deducting liabilities (e.g., retained earnings).

Process:

1. Fetch Transactions: Retrieve all transactions for a specified period.
2. Categorize Transactions: Classify transactions into assets, liabilities, and equity.
3. Aggregate Values: Sum the amounts for each category to calculate total assets, liabilities, and equity.
4. Return Data: Provide detailed and summary information for each category.

Diagram:

Users/Clients
    |
    +---> API Endpoints
             |
             +---> Fetch Balance Sheet Data (GET /finance/reports/balance-sheet)
                        |
                        +---> Fetch Transactions from DB
                        |          |
                        |          +---> Transactions Table
                        |
                        +---> Fetch Categories from DB
                        |          |
                        |          +---> Categories Table
                        |
                        +---> Fetch Accounts from DB
                        |          |
                        |          +---> Accounts Table
                        |
                        +---> Process Transactions
                        |          |
                        |          +---> Classify as Assets, Liabilities, or Equity
                        |
                        +---> Calculate Totals
                        |          |
                        |          +---> Total Assets
                        |          +---> Total Liabilities
                        |          +---> Total Equity
                        |
                        +---> Return Balance Sheet Data

Income Statement

Purpose: The Income Statement summarizes the revenue, expenses, and net income for a specific period, providing insights into the financial performance of the institution.

Key Components:

• Revenue: Income generated from various sources (e.g., tuition, fees, grants).
• Expenses: Costs incurred during the period (e.g., salaries, supplies, facilities).
• Net Income: The difference between total revenue and total expenses.

Process:

1. Fetch Transactions: Retrieve all transactions for the specified period.
2. Categorize Transactions: Classify transactions into revenue and expenses.
3. Aggregate Values: Sum the amounts for each category to calculate total revenue, total expenses, and net income.
4. Return Data: Provide detailed and summary information for each category.

Diagram:

Users/Clients
    |
    +---> API Endpoints
             |
             +---> Fetch Income Statement Data (GET /finance/reports/income-statement)
                        |
                        +---> Fetch Transactions from DB
                        |          |
                        |          +---> Transactions Table
                        |
                        +---> Fetch Categories from DB
                        |          |
                        |          +---> Categories Table
                        |
                        +---> Fetch Accounts from DB
                        |          |
                        |          +---> Accounts Table
                        |
                        +---> Process Transactions
                        |          |
                        |          +---> Classify as Revenue or Expense
                        |
                        +---> Calculate Totals
                        |          |
                        |          +---> Total Revenue
                        |          +---> Total Expenses
                        |          +---> Net Income
                        |
                        +---> Return Income Statement Data

Receivables

Purpose: The Receivables feature tracks the amounts owed by students and summarizes outstanding balances, aiding in managing and collecting due payments.

Key Components:

• Student Details: Information about students with outstanding balances.
• Total Outstanding: The sum of all amounts due from students.
• Total Paid: The total amount paid by students.

Process:

1. Fetch Student Data: Retrieve active student information and their payment records.
2. Calculate Balances: Compute the total fees per semester, total paid, and remaining balances for each student.
3. Aggregate Values: Summarize the total outstanding and total paid amounts.
4. Return Data: Provide detailed and summary information about student balances.

Diagram:

Users/Clients
    |
    +---> API Endpoints
             |
             +---> Fetch Receivables Data (GET /finance/reports/receivables)
                        |
                        +---> Fetch Student Data from DB
                        |          |
                        |          +---> Students Table
                        |
                        +---> Fetch Payments from DB
                        |          |
                        |          +---> Payments Table
                        |
                        +---> Process Student Data
                        |          |
                        |          +---> Calculate Total Fees, Total Paid, and Remaining Balances
                        |
                        +---> Calculate Totals
                        |          |
                        |          +---> Total Outstanding
                        |          +---> Total Paid
                        |
                        +---> Return Receivables Data