Expected Cash Flow Detail Report

You can use the Expected Cash Flow Detail report to generate the details to back up the Expected Cash Flow Summary report.

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

Prerequisites

Authorizations:

  • Common - Reports - View

  • Either Reports - Financial Aid - Expected Cash Flow Detail or Financial Aid - All Reports authorization (All Reports provides authorization to view all reports for Financial Aid.) 

If you selected the SSN option in Student ID to PrintClosed Indicates whether you want to include the Student ID, Social Security Number, Enrollment Number, or None. Note: The ID is printed for each student selected for the report. Most reports have all three student IDs available to print on the report. The SSN is required on some reports. You must be authorized to view social security numbers (SSNs) and to select SSNs in the list. Reports about leads (prospects) do not have an Enrollment ID. The ID selection is not used for reports that do not list individual students. 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 that 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. (Settings > System > Staff > select or add a staff member > Specialized Permissions)

To configure the timeout duration for Export to Excel, 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. The timeout duration for PDF export has been extended from 15 minutes. The timeout duration for the SSRS Report Timeout has been extended from 20 minutes. under Settings > System > General.

Access

Reports > Financial Aid > Expected Cash Flow Detail Report

Generate the Report

Specify the data selection criteria.

Award YearsClosed The financial aid award year associated with the record.

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.

Date ScheduledClosed The date when the item is scheduled. From and To

Disb StatusClosed The status of the disbursement.

Fund SourcesClosed The fund source associated with the award against which the refund is scheduled. If your institution uses 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

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

Payment TypesClosed The type of payment, such as ACH payment, Credit Card payment.

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

ShiftsClosed Select shifts associated with the students. Only students who are associated with the selected shifts will have statements generated.

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 your institution has configured Anthology Student to limit groups to campuses, you can only select groups for the campus to which you are assigned. The list 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 Indicates whether you want to include the Student ID, Social Security Number, Enrollment Number, or None. Note: The ID is printed for each student selected for the report. Most reports have all three student IDs available to print on the report. The SSN is required on some reports. You must be authorized to view social security numbers (SSNs) and to select SSNs in the list. Reports about leads (prospects) do not have an Enrollment ID. The ID selection is not used for reports that do not list individual students.

Student StatusesClosed The prospect or student status at your institution is configurable and may differ by school. When you change a student's status, you must confirm the update in a dialog box, and if there are pending tasks from the previous status, another dialog lets you choose which tasks to keep or close as canceled. A student's current status (like Active) depends on their history and activation units; simply entering a Version Start Date does not automatically activate them without proper status progression. Status values help filter student records in lists, processes, and reports. Alumni statuses include "complete" or "graduated."

TermsClosed Specifies the term associated with the record. Terms are configured by your institution. The term start date must be before the end date of the award year.

Version Start DateClosed The start date of the program version for the campus that the student is enrolling in. From and To

Take the appropriate action.

Task Action to Take
View the report Select View Report. Anthology Student displays the generated report.
Export the report

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

  2. Review, specify, or change the Export File Name.

  3. Select Export.

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.

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, Ellucian suggests using find and replace on the characters only if necessary to restore original values.
Save the selection criteria

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

  2. Specify the name to save the criteria.

  3. Save your changes. Anthology Student saves the selection criteria.
Delete the selection criteria

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

  2. Select Delete. Anthology Student deletes the selected saved criteria.

You can also save to a student group. Refer to Create or Update a Student Group Using a Report.

Details for the Report

In the report:

  • Expected Cash Flow Details are sorted by Campus, Fund Source, Student Name

  • In the fund source, students are listed in alphabetical order

  • Student count and the total amount for each fund source are displayed

  • Report total is displayed at the end of the report