GEGI Customer Care

TABLE OF CONTENTS

• 90/10 Revenue Percentage Report
• Summary
• Comparison to Customer Balance Summary

90/10 Revenue Percentage Report

GEGI features the ability to get data for calculating the revenue percentage. This report is located in the Financial → Financial Reports → 90/10 Revenue Percentage menu:

The report includes all students with payments or refunds in the selected Period.

The column set complies with the official documentation of the U. S. Department of Education report.

Before using the report, each payment type (Admin → Charges & Payments → Payments) needs to be configured:

• The 90/10 Column field defines the column where this type of payment will be shown.

Note: The Title IV Funds Returned for a Student Under 34 C.F.R. § 668.22 column shows the award refunds with the Refunded Under 34 C.F.R § 668.22 option set to Yes: 

• Use as Check Refunds for 90/10 Report: If selected, refunds of this payment type can be applied to any payment during 90/10 balance calculations. These refunds will be applied last.
• Can be Applied as Refund to Other Types of Payments: If selected, refunds of this payment type can be applied to selected types of payments during 90/10 balance calculations.
• Show as Separate Line in the 90/10 Report Summary: If selected, payments of this type will be displayed as separate lines in the 90/10 Revenue Percentage summary.

Payments are distributed to the columns according to the program Title IV eligibility settings (Admin → Programs → Edit → Eligible for Title IV):

• If a program is eligible for Title IV, payments are distributed according to the "90/10 Column" settings. 
• If a program is not eligible for Title IV, all payments related to this program are distributed to the Revenue From Other Sources column.

The last row of the report shows the total revenue percentage for all students:

Summary

Under the Actions button, the report can be exported to CSV, or a Summary view of the report can be exported to Excel:

Export Summary to Excel opens the summary configuration page, where users can define which payment types with their amounts should be displayed as separate lines. Amounts of other payments types will be summed up in Other Federal Funds and Other Funds in the respective sections of the report. 

Comparison to Customer Balance Summary

It is possible to see the discrepancies between the amounts in the Customer Balance Summary and the values of the Adjustments and the Balances Carried Over from Prior Year in 90/10 Revenue Percentage fields.

The cells with the mismatched amounts are highlighted and provided with an informational tooltip.

The Show Only with Balance Discrepancies filter allows selecting only the records with the mismatched amounts: 

The amounts for each student are matched in the following way: