Cash Receipts Summary Report

You can use the Cash Receipts Summary report to generate cash receipts by fund source with percentages for the 90/10 calculations.

If you frequently generate reports with the same selection criteria, you can save the selection criteria under a name. This makes it easier to generate reports in the future with the same selection criteria.

Prerequisites

You must have: 

  • Common - Reports - View authorization

  • Either Reports - Student Accounts - Cash Receipts Summary or Student Accounts - All Reports authorization (All Reports provides authorization to view all reports for Student Accounts.) 

If you selected the SSN option in Student ID to PrintClosed Specifies the ID that is printed. The values are Student Number, SSN, Enrollment Number, and None. and want Anthology Student to display the SSN details, your institution must have selected Allow reporting access to Social Security NumberClosed Select the check box if you want the staff member to view, print, and export social security numbers (SSNs) for all reports from the Reports tile and when they export lists that contain columns with the social security number. The social security number will be a selectable option from the Student ID to Print drop-down list on the Report Selection Information page, will appear on the selected report, and will be available for export. This feature applies to custom reports which use Anthology Student stored procedures. If the SSN is a specified field on the report and the staff member or staff group does not have permission, the phrase "SSN Blocked" is printed on the report instead of the social security number. The SSN is also not displayed for export. on the Staff page. (Select the Settings tile > expand System > select Staff > select the New button and specify the general information or select an existing staff member in the list > select the Specialized Permissions tile.).

To configure the timeout duration for the Export to Excel button, your institution must have configured Export to Excel Timeout in SecondsClosed Enter the Timeout Value in seconds (0-900) for all the SSRS Export to Excel. under Settings > System > General.

Access Method

Select the Reports tile > expand Student Accounts > select Cash Receipts Summary.

Procedure to Generate the Report

  1. Specify the data selection criteria.

    AmountClosed Select the condition for the amount in the report. The values are Equal To, Not Equal To, Greater than, Less than, Between, Like, and Include All. For example, if you select the condition Between and enter the range (1;5) in the respective value field, the report displays the amount records between 1 and 5 only.

    Amount ValueClosed The amount in dollars.

    Award YearsClosed The financial aid award year.

    Campus GroupsClosed The group you specified for the campus. Your institution configures the groups for campuses.

    CampusesClosed The campus or campuses to which a person or item is assigned. It is filtered to display the campuses to which you have access. In some cases, it is also used to filter a list to only those items for the campus. In some lists, you can select more than one campus or select All. In lists that display columns, if the column contains more than one campus, you cannot sort or filter on that column.

    Fund SourcesClosed The source of this fund. If your institution is using fund source security, you must have permission to work with the fund source.

    Graduation DateClosed The date when the student graduated or is scheduled to graduate from the program version. From and To

    LendersClosed The name of the lender. Lenders are configured by your institution.

    Load Saved CriteriaClosed Select the required saved criteria that you want to load in the selection criteria fields.

    Payment TypeClosed Specifies how the payment was made. By default, it includes all types of payment.

    Program VersionsClosed The program version associated with the student or item.

    Status CategoriesClosed The category for the status. It can include more than one student status. They are defined by the system and selected for the student statuses configured by your institution.

    Student GroupsClosed The name of the student group. If you are selecting a group and your institution has configured Anthology Student to limit groups to campuses, you can only select groups for the campus that you are assigned to. If you are selecting a group, it can also be filtered to display groups where you are the owner, public groups, and private groups to which you have been given access.

    Student ID to PrintClosed Specifies the ID that is printed. The values are Student Number, SSN, Enrollment Number, and None.

    Student StatusesClosed Specifies the status of the prospect or student at your institution. Statuses vary by institution. They are configured by your institution. If you change the status for a student, a dialog is displayed so that you can confirm the change. If there are also tasks associated with the previous status, Anthology Student displays a dialog that you can use to select the tasks to keep and the tasks to close with the result of canceled.

    Total Fund Src TypeClosed Select the option whether or not you want to display the total fund source type in the report.

    Transaction DateClosed The date when the transaction record was posted. From and To

  1. Take the appropriate action.

    Task Action to Take
    View the report

    1.   Select the View Report button. Anthology Student displays the generated report.

    Tip: You can export the report preview to Excel by selecting the Excel option from the toolbar in the Report Preview section. The resulting Excel file shows the data in a similar format as the preview.

    Preview toolbar

    Preview - Excel

    Export the report

    1.   Select the Export to Excel button. Anthology Student displays the Export Report Data dialog box.

    2.  Review, specify, or change the following value.

    Export File NameClosed The name of the exported file.

    3.  Select the Export button.

    Anthology Student exports the generated report as a CSV file which may be viewed in Excel. In some cases, the exported file will contain additional data not displayed in the report on your screen.

    Tip: When you select the Export to Excel button from the Report Selection section, the resulting file contains the raw data for the report. The data is not formatted like the data in the Excel file generated from the Report Preview toolbar.

    Export to Excel button

    Raw Excel

    Note: If you entered special characters like *, -, !, (, or ) in the report fields, Anthology Student automatically prepends an apostrophe to those field values upon export to Excel or CSV. The apostrophe is added to reduce vulnerability, as these characters are perceived by Excel as an actionable formula. Once the report is exported to Excel, Anthology suggests using find and replace on the characters only if necessary to restore original values.
    Save the selection criteria

    1.   Select the Save Criteria button. Anthology Student displays the Save Criteria dialog box.

    2.  Specify the name to save the criteria.

    3.  Select the Save button. Anthology Student saves the selection criteria for the report.
    Delete the selection criteria

    1.  Select the Delete Saved Criteria button. Anthology Student displays the Delete Criteria dialog box.

    2.  Select the Delete button. Anthology Student deletes the selected saved criteria for the report.

You can also save to a student group. For more information, see Create or Update a Student Group Using a Report.

Details for the Report

In the report:

  • Cash Receipts Summary is sorted by Campus and Fund Source

  • If you selected Yes in the Total Fund Src Type, the total for each fund source for the selected campus is displayed

  • The total of each selected campuses is displayed

  • The total of the campuses is displayed

  • If a Title IV Fund exists, it is indicated by an asterisk symbol, and the total of Title IV Fund is displayed