Title: | NRDS to Magic Verification and Comparison Report |
Submitted by: | Rapattoni Magic Software Support |
Issue: | How can I compare my membership database with the data at NRDS? |
As many of you know, NAR will run membership counts, by local association, directly from the NRDS system on April 1. These counts will be used to assess the amount each association owes NAR.
With this in mind, now would be a great time to run the NRDS Verification Utility to compare your membership data to the data at NRDS. After running the report, be sure to update any members or offices on NRDS that show as inactive in your database but active at NRDS. This will help you avoid getting charged for members or offices that actually never paid dues.
Step 1: Request a Batch Refresh from NRDS. NRDS will email the file to the key office contact that NRDS has on file.
Note: NRDS will email the refresh data as an attachment to your Local AOR staff email address that is on file with them.
Step 2: Save the file. When you receive the file from NRDS, save it to the directory shown in the Directory Path field of the NRDS Verification Utility (this is usually the R:\RAP\NAR\NRDSIN\ARCHIVE folder, but your association’s setup may be different).
Step 3: Go to the NRDS Verification Utility in Data Exchange.
This report shows you inconsistencies between your data and the data at NRDS.
This report compares the data in four ways, as follows:
NRDS vs. Association (Members)
The data on the left side is from the NRDS file and it’s compared to what you have in your database. This is showing you what NRDS has on file, and in what ways it does not match what you have in your database.
NRDS vs. Association (Offices)
The data on the left side is from the NRDS file and it’s compared to what you have in your database. This is showing you what NRDS has on file, and in what ways it does not match what you have in your database.
Association vs. NRDS (Members)
The data on the left side is from your database and it’s compared to what is on file at NRDS. In some instances, this report may be larger due to the fact that you may have numerous member types that you do not report to NRDS. This is normal.
Association vs. NRDS (Offices)
The data on the left side is from your database and it’s compared to what is on file at NRDS. In some instances, this report may be larger due to the fact that you may have numerous office types that you do not report to NRDS. This is normal.
If you need assistance running this report or interpreting any items on the report, please feel free to contact our AMS Support department at (866) 730-7115.