Final Fee Report
Final Fee Report
Consolidated Financial Analytics
The **Final Fee Report** serves as the executive summary for the institute's finances. It aggregates data by **College and Course**, providing a bird's-eye view of total revenue. Instead of listing individual students, it shows totals: *Total Students, Total Base Amount, Total Concessions, Total Collections, and Total Pending Balance* for each program. This is essential for budgeting and financial planning.
1 Generate Summary
| # | Faculty (College) | Course | Students | Total Base Fee | Concession | Net Payable | Collected | Balance |
|---|---|---|---|---|---|---|---|---|
| 1 | Akal College of Economics | B.Com. (Hons) | 30 | 3,674,250 | 506,475 | 3,167,775 | 2,973,813 | 193,962 |
| 6 | Akal College of Economics | MBA | 19 | 3,160,400 | 419,566 | 2,740,834 | 2,698,639 | 42,195 |
| 10 | Dr. Khem Singh Gill College | B.Sc. (Hons) Agriculture | 91 | 12,118,150 | 1,644,068 | 10,474,082 | 10,238,617 | 235,465 |
Revenue Analysis
This report allows management to identify which courses generate the most revenue and which ones have high outstanding dues (Balance), facilitating targeted fee recovery efforts.
Discount Impact
By comparing **Total Base Amount** vs **Total Concession**, you can analyze the percentage of revenue being waived off as scholarships for each department.