Refund Check Register Report

You can use the Refund Check Register report to reconcile Refunds and Stipends when closing the accounting period.

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

Prerequisites

You must have:

Common - Reports - View authorization

Either Reports - Student Accounts - Refund Check Register 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 Print 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 Number 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. (Select the Settings tile > expand System > select Staff > select the New button and specify the general information or select an existing staff member > 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 Seconds Enter the Timeout Value in seconds (0-900) for SSRS Export to Excel. under Settings > System > General.

Access Method

Select the Reports tile > expand Student Accounts > select Refund Check Register.

Procedure to Generate the Report

Specify the data selection criteria.

Campuses Select campuses for which you would like to view refunds and stipends.

Campus Groups Select group(s) of campuses for which you would like to view the refunds and stipends.

Date Sent Select the date range when the refund was sent. From and To

Fund Sources Select the fund source associated with the refunds and stipends.

Lender Select the name of the lender. Lenders are configured by your institution.

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

Programs The name of the program. Programs are configured by your institution. Select program(s) from the list to access transactions for students who are associated with the selected programs only.

Refund Types Select the type of refund. The options are Stipends and Refunds or Stipends or Refunds.

Status Categories 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 Groups 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 Print Specifies the ID that is printed. The values are Student Number, SSN, Enrollment Number, and None.

Trans Date The date when the transaction record was posted. From and To

Take the appropriate action.

Task

Action to Take

View the report

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

Export the report

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

Review, specify, or change the following value.

Export File Name The name of the exported file.

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.

If you have entered specific characters like *, -, !, (, or ) into the fields of the report, 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 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 Student Group

Select the Save Student Group button. Anthology Student displays save student group dialog box.
Specify the student group name.
Select the Save button. Anthology Student saves student group.

Save the selection criteria

Select the Save Criteria button. Anthology Student displays save criteria dialog box.
Specify the name to save the criteria.
Select the Save button. Anthology Student saves the selected criteria for the report.

Delete the selection criteria

Select the Delete Saved Criteria button. Anthology Student displays the delete confirmation dialog box.
Select the Delete button. Anthology Student deletes the selected saved criteria for the report.

Details for the Report

In the report:

The Refund Check Register report is sorted by Student Name and Check Number
The total includes the sum of all transactions posted and the sum of all voided transactions (negative amounts)
Posted and Voided transactions are displayed on the last page