The Revenue Report with grouping displays a spreadsheet-like format that shows you a line-item representation of each revenue item. This report displays total class revenue by date range. The report is run through a specific date range 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. For best practices on using this report to see your total revenue and also how to use the filters, see this article: Revenue Report with Grouping - How To's
Definition of each column type:
Name - Name of the fee.
Code - The particular course code associated with the item.
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.
Out of Range Revenue - This indicates if any revenue was received BEFORE the date range that was selected.
Cash, Check, CC, Other - The type of payment assigned towards that specific item. Other includes all other offline/custom forms of payment that is not credit.
Regis - The number of registrants that are within that specific class/item. The reason for why it shows total registrants instead of just enrolled is due to the revenue received for partial/unpaid invoices that still show the student as pending. This revenue generated from their invoices is also included in this report.