Reports listed in the category are typically those related to Revenue and Expense transactions.
Balance Due
Displays list of Balance Due amounts grouped by Client and displayed in a column format.
Deposited Transactions
Displays list of transactions that contain a Deposit Date and displayed in a column format.
Deposited Transactions Pivot
Displays list of transactions grouped by Deposit Date and aggregate totals by Payment Type displayed in a pivot column format.pivot
Gateway Log
Displays list of transactions processed through the Payment Gateway and displayed in a column format.
OnAccount Aging
Displays a list of Clients with OnAccount transactions grouped by Client with aggregate totals and aging details displayed in a column format.
OnAccount List
Displays a list of OnAccount transactions displayed in a column format.
Revenue by Client
Displays list of revenue transactions grouped by Client and displayed in a column format.
Revenue by Course Code
Displays list of revenue transactions grouped by Course Code and displayed in a column format.
Revenue by Fee Group
Displays list of revenue transactions grouped by active Fee Group and displayed in a column format. Active Fee Group in this scenario is considered the Fee Group on the Course Section Start Date.
Staff Payroll Estimates
Displays list of expected payroll expenses calculated based on Course Section related fields and displayed in a column format.
Staff Payroll Expenses
Displays list of payroll expenses calculated based on expense records and displayed in a column format.
Transactions By
Displays list of transactions displayed in a column format. Filter defaults to Revenue transactions. Change [Transaction Category] = "Expense" to get expense records only.
The report is provided in several groupings:
- Account: Grouped by Account using a derived Account field. If the account exists in the transaction record exists, the Transaction Account value is used. Otherwise, the Revenue Account from the Course Section is used.
- Client
- Company: Only transactions paid by Companies are displayed.
- Course Code
- Date: Transaction Date
- Payment Type
Transactions 1098-T Eligible
Displays list of transactions tagged as 1098-T eligible.
Transactions Log
Displays list of transaction deleted records from the Transaction Log and displayed in a column format.
Undeposited Transactions
Displays list of transactions that do not contain a Deposit Date and displayed in a column format.
Vendor Billing
Displays list of Course Sections related to third-party vendors (Ed2Go, Ed4Career, ProTrain) with cost amounts and displayed in a column format. Saved filters may change from time to time to match current billing periods.
Rick Stern
Comments