eRAMP Automated Reconciliation Setup File Confirmation

Automated Reconciliation Setup (File Confirmation)

Applies to: eRAMPSQL and eRAMP Standard Access

eRAMP's automated reconciliation process is the easiest way to synchronizes loan transactions submitted to MERS using the batch (SFTP) upload for the following transaction types: 
  • 102 Registration, 103 Update, 108 Reversal
  • 207 Transfer of Beneficial and Servicing Right, 202 Transfer of Beneficial Rights, 203/206 Transfer of Servicing Rights
  • 251 Beneficial Rights Transfer (Option 2), 252 Servicing Rights Transfer, 253 Interim Funder Release
  • 303 Paid Off, 304 Servicing Rights Transfer to Non-MERS Servicer, 353 Paid Off Reversal, 354 Reversal of Servicing Rights Transfer to Non-MERS Servicer
Loans submitted using MERS XML Online Registration system will be registered and confirmed at the same time. The File Confirmation process is only required to reconcile loans submitted through the batch (SFTP) upload.

eRAMP provides a manual reconciliation process and an automated reconciliation process. The automated reconciliation program uses the Consolidated Report Data File (OD) report from MERS.  Reconciliation should be performed daily for the previous business day (including Saturday).

The reconciliation process should be run for every business day including Saturday

To setup the Automated Reconciliation feature Consolidated Report Data File (OD) report must have been activated.  To start the OD report follow these steps:

Open your web browser and go to the live production system: www.mersonline.org or, for the training/test environment  www.mersonlinetraining.org
 
Then from the Main menu, select the Administration link



From there select the Member information link



Then the Reports link




Select the Optional Report tab and scroll all the way down to the bottom of the page.


Make sure to check the box to select the Consolidated Report Data File (OD) report and then hit the 'update' button at the bottom of the page.




Switch to Mandatory Reports tab:



Check all the Data boxes for every report listed in the Mandatory Reports section.


This need only be setup once for the training/test and live production environments.

The Consolidated Report Data File (OD) report will be available the next business day.


MERS system will not create the Consolidated Report Data File if the Combined Report/Data File select report has been selected. Uncheck the Select Report checkbox.


 
Users must have access to administer their MERS profile in order to see the above links.

    • Related Articles

    • Setup Automated Reconciliation

      To simplify the reconciliation process eRAMP has an automated reconciliation program. Automated Reconciliation downloads the Consolidated Transaction Report Data File (OD) report from MERS. This report contains details for all loans processed using ...

    • Using Automated reconciliation process for confirmation

      Before using the automated reconciliation process the OD/Consolidation Transaction report must be activated. See article How to setup automated reconciliation process for setup instructions. A critical step to keep data current with MERS is to run ...

    • Clicking the Retrieve Report button in Confirmation displays error “No File Found”

      When I click the Retrieve Report button in Confirmation I receive an error “No File Found”. This error message is displayed when the Consolidated Report Data File (OD report) has not been setup as defined on page 9 in our User's Guide or the report ...

    • Understanding eRAMP Template File Setup

      Template files are saved as .fil files in a folder users/public/ERAMP_DATA on each user's workstation. If eRAMP is installed on multiple workstations each workstation could have its own unique template setup for any of the eRAMP templates; ...

    • eRAMP Working File Descriptions

      eRAMP uses various text files to control the way functions work and record information about eRAMP processes. System generated files with the extension .FIL are used to control the flow of data importing into eRAMP. Files with the extension .INI ...