Disbursement Batches Not Reconciled

You can use the Disbursement Batches Not Reconciled report to generate information about posted batches where the amount posted is not reconciled. For example, when posted amounts plus returned amounts are unequal to the total amount for the batch.

You can also determine:

  • A deposit associated with a disbursement batch is required before the batch can auto-post

  • A disbursement batch has a deposit associated with it

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 - Financial Aid - Disbursement Batches Not Reconciled or Financial Aid - All Reports authorization (All Reports provides authorization to view all reports for Financial Aid.) 

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 Financial Aid > select Disbursement Batches Not Reconciled.

Procedure to Generate the Report

  1. Specify the data selection criteria.

    Batch IDClosed Select the condition for the batch ID 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 batch ID records between 1 and 5 only.

    Batch ID ValueClosed Enter the batch ID value.

    Campus GroupsClosed Specifies the campus group for which the report is generated.

    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 PostedClosed Select the condition for the date posted 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 date posted records between 1 and 5 only.

    Date Posted Value (mm/dd/yyyy)Closed Enter the date posted value in mm/dd/yyyy format.

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

    ReconcileClosed Select the option for which you want to reconcile records in the report.

  1. Take the appropriate action.

    Task Action to Take
    View the report

    1.  Select the View Report button. Anthology Student displays the generated report.
    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.

    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.

Details for the Report

In the report:

  • Disbursement Batches Not Reconciled are sorted by Campus, Batch ID

  • When you select a Batch ID, a separate detail report is provided of all transactions in the selected batch