The Revenue Report Grid displays a spreadsheet-like format that shows you a line-item representation of each revenue item. This report displays total class revenue by either Fiscal Year or Time Period. The report is run through either or both selections and can be run for one or all sites, teachers, course groups, courses and classes.
All of the variables in the report can be grouped. Simply drag the header of the column you wish to group by to the header area that says Drag a column header here to group by that column and you will see the data grouped by that variable.
The variables in the columns can be collected with the symbol at the top of each column. Select the symbol that you want to use and type the variable that you want to see based on that symbol.
This report can be exported as a PDF or to Excel.
Definition of each column type:
Course Name - Name of the course.
Event Cd - The particular course code associated with the class.
Inv Amount - The total amount found on the invoice in reference to all the items found within that specific date range. If a new invoice item (revenue) was not created in the date range, it will not show here.
Adjustment - This is the sum of all adjustments found on those items. An adjustment up on the invoice item will show an increase and an adjustment down will show a decrease in this number. If the item has both positive and negative adjustments, it will shows a summation based on the date range of both.
Discount - The total amount of discounts associated to this invoice item.
Refund - The total refunds (not including credits) associated to all invoice items within that date range.
Credit Amt - This is any credit that was generated from that invoice item. This will be shown in the invoice transaction details as "Credit Given" on the invoice.
Net Revenue - Invoice amount minus Adjustments/Discounts/Refunds/Credit Amt
Payment Amount - The total of all different payments on that particular item not including account credits used. So if there were partial payments made in say, cash and check, it will display the total payments as the sum of all different types.
Total Paid - Payment Amount minus Refunds
Credit Payment - This is for any credits on the student's account that were used as payment made towards that item. This will be shown in the invoice transaction details as credit applied on the invoice.
Total Payment Applied - This is the Total Paid + Credit Payment - Credit Amt. If there are only Credit Payments, it will add to the total paid (Total Paid + Credit Payment). If there was any Credit Amt (e.g. Credit Issued), this would subtract from the Total Paid.
Total Due - This is the amount that is still owed in this class. Generally, this will be Net Revenue minus Total Payment Applied.
Reg (inc. dropped) - This is the total amount of registrants for this particular class, included dropped students. We include this since dropped students will still count as revenue, even if they have not paid for the class.
Reg (excl. dropped) - This is the total amount of registrants for this class, minus the dropped students.
Primary GL Code - This is the GL code associated to the primary fee for this class. We only show the primary fee's GL code.
GL_AccountName - This is the GL code's name associated to the primary fee for this class. We only show the primary fee's GL code's name.
Event ID - This is the special code generated from ASAP for this particular class, used as an identifier in our database to quickly look up the class, similar to a student ID.