Start a new Reconciliation

To start a new reconciliation click on the New Reconciliation link at the top right of the main page

Select the desired Award Year, Cutoff date and Fund Type. The Campus Ivy CORE system can complete reconciliations between CORE and COD, CORE and a school's SIS and COD and a school's SIS.

Once you click 'Save & Continue' you will be taken to the screen to load the appropriate COD file.

Option 1: Manual Upload
You can choose the file by browsing your network drives and folders by clicking on Choose File box shown above. Once the appropriate file is chosen then click upload.
Option 2: Choose Existing File
The system can be configured to load your COD files from a secure location. All available files will be listed under this option and can be loaded be selecting the desired file and then clicking upload.
Once the COD file is loaded you will then be taken to the SIS upload or CORE Upload screen.
SIS Upload

SIS uploads can be done by clicking on 'Choose File' and searching your networks drives and folders for the appropriate file. Once the file is located you would then click upload. All uploaded SIS files will be listed under the Uploaded Files section, select the desired file from the list and click next.
The SIS file format has a specific set of data fields for both Pell and Direct Loan files.


CORE Upload

CORE import will run once you click on the import button. The system will gather all disbursements matching the fund type, award year and date range used when setting up the reconciliation. Once the data is imported then click next.

Reconciliation will automatically run and give you a results page.

The results page will give you a summary of the data in each file source that is being compared. It will show total transactions as well as total dollar amounts. The differences shown are in absolute values.
There are 3 categories of discrepancies identified in the reconciliation process:

1. Found with Differences
2. Not in SIS/CORE
3. Not in COD

Each category is broken down automatically by School, Fund Type and School & Fund Type, to view these breakdowns just click on the links provided.

Found with Differences – The system has found the funds in both files bit there is a difference between the two.
Not in SIS/CORE – The system has found the funds in the COD file but it cannot be matched in the SIS/CORE Data.
Not in COD – The system has found the funds in the SIS/CORE data but it cannot be matched in the COD file.
To view the detail of each category click on 'View Detail' link below the summary of that category.
Reconciliation statuses can be used to track the process, the system will update the reconciliation status to In Progress after it has completed the initial comparison. The User can then update that status as needed, available statuses are In Progress, Send For Processing, Received For Processing and Complete. Once the reconciliation has been placed in a Complete status the 'Variance's Reviewed' flag will be generated.

Variance's Reviewed
The Variance's Reviewed flag should be used to track when all variances in a reconciliation has been corrected. Schools can use this flag to ensure that the entire reconciliation cycle has been completed.