Disbursement Reconciliation Report Window

The Disbursement Reconciliation Report window reports on the financial aid disbursement monies present on student accounts in J1 and those authorized for disbursement in PowerFAIDS per POE. This allows you to review financial aid fund and student disbursement totals from both J1 and PowerFAIDS to determine if they are in-balance. If the fund or student totals are out-of-balance, you can open detailed transaction reports to review the totals.

Columns

Selecting the Trial Run radio button indicates a value of 'T' (Trial Run). The default is selected (On).

If you select the Trial Run radio button, the Trial Run Disbursement Reconciliation Report process is run but does not result in any database update to indicate that the transaction was reconciled (i.e., does not update the TRANS_HIST_EXT_PF.RECONCILED_DTE to the current system date).

Selecting the Update Transaction as Reconciled radio button indicates a value of 'A' (Actual Update). The default is cleared (Off).

If you select the Update Transaction as Reconciled radio button, the Final Run Disbursement Reconciliation Report process is run. Financial aid transactions update the TRANS_HIST_EXT_PF.RECONCILED_DTE to the current system date.

You must select a POE ID from the drop-down list (PF_POE_DEF table). The default is the POE_ID from POE_CONFIG.

Report Process

When you click the Process button, the Disbursement Reconciliation Report displays only the fund totals information with the option to Display Out-of-Balance Funds Only. All fund and student information is reported as of the current date.

If you expand the fund, each student receiving monies from that fund is displayed with their total monies.

If you expand the student, detailed transaction reports for that student are displayed for any disbursement activity that occurred in both J1 and PF.

If you expand the J1 report and the PF report, you can view the transaction detail. The J1 Transactions report displays the Source Code, Group Number, Status, Transaction Date, Transaction Amount, and User Name for each transaction. The PowerFAIDS Transactions report displays the Disbursement Roster, Source Type, Transaction Date, Amount, and User Name for each transaction.

The detail reports include information designed to assist you in your effort to determine why the student and the fund amounts are out-of-balance.

· The PF total fund amounts may include monies for students that do not appear in the expanded listing.

· The PF total student amounts and PF transaction detail report for each student requires a SSN match between systems.

· All disbursement transactions, including those still suspended or unposted, are calculated into the J1 totals.

How do I...

1. Select Trial Run and the POE ID you want to reconcile.

2. Select Update Transaction as Reconciled when the reconciliation is complete and to run a final report and update the J1 transaction to reflect the date of this reconciliation.

3. Click Process to create the report, or click Cancel to end the task.

The Print Report button opens the report based on your Display Out-of-Balance selection and enables you to expand levels. Only the visible data is printed.

Working with Disbursement Reconciliation Reports

Columns

Report Process

How do I...