Please read the following notes before proceeding to download at the bottom of the page

Version 2.8.1 Build 60

Roth 403B contributions can be entered or imported and uploaded to the NAD Retirement Office

As part of its pre-upload error check, ARP Upload now attempts a connection to the US SSA Website. If the connection is achieved, the latest release of valid SSN group and area numbers are downloaded. These lists are then used to validate each SSN in the file. If the connection fails, a message is displayed alerting you to the failure, but the rest of the error check will proceed.

If your system consistently fails to achieve this connection, it's possible that your network administrator has implemented a URL filtering utility which prohibits connections to certain sites. This ban can be excepted from the setups of most URL filtering tools. Have your local IT person attempt to "white list" the following URL: http://www.ssa.gov/employer/ssnvs/highgroup.txt

Addition of the Roth 403B feature necessitated a change in the structure of the ARP Data Table. Those who import payroll data from their Payroll software using the ARP Mapping Utility must open that utility (Transfer | Import Data, then click <Map Fields>. Any values in the column headed "DbfFldNum" greater than 25 must be incremented by 1. If you import the sum of all Employee Pre-Tax contributions as one amount, then Employee Pre-Tax Contributions which were once mapped to DBF Field Number 22, Elect101, must be remapped to Field Number 41, Tot101.

If you need assistance, please contact your ARP Support Representative.

Version 2.8.2 Build 61

A new button appears on both the ARP Data Manager and ARP Upload next to the Help Button. Clicking it and confirming the information message opens your web browser to the LogMeIn123 web page for assistance from your ARP Support person.

General Note for ARP Upload

The upload address in now arp.nadadventist.org. We no longer use an IP Address because these tend to not be static whenever firewalls and/or proxy servers are involved.

There have been some locations (so far only educational sites) who've been unable to connect to arp.nadadventist.org for the upload. Apparently part of the address is trapped by a porn site filter commonly used in educational environments.

This address can also be "white listed" for your URL filtering as described above under Version 2.8.1.

The ARP Upload Dialog contains a Checkbox, "FTP Passive Connection". It is checked by default because connection to the NAD FTP Server can be achieved most easily in passive mode. If your connection attempt fails, you might try unchecking it, then repeat the connection attempt.

ARP Data Manager Version 2.9.0

Calculations of Employer Basic and Matching Contributions have been modified to incorporate the changes voted at NAD Year-End 2007. Employee contributions considered in calculating the Employer Match include Elective Deferral, After Tax, and Roth 403B.

Calculation of Employer Match

With the implementation of the changes voted at NAD Year-End 2007, the Employer Match Calculation has become far more complex. The Employer Matching Contribution is calculated as follows:

M = A x W

A = the lesser of -- ((E + T + R) / W) x P
or
V x P x B

Where M = Employer Matching Contribution ($)
A = Applied Match Percent (%)
W = ARP Gross Wages ($)
E = Total Employee Elective Deferral ($)
T = After Tax Contribution ($)
R = Total Roth403B Contribution ($)
P = Employer Match Percent of Voluntary Deduction (%)
V = Voluntary Percent of Employer Basic (%)
B = Employer Basic Contribution Percent (%)

Inasmuch as both formulae for deriving the Applied Match Percent use two or more decimal numbers, rounding is done only at the final calculation for M, Employer Matching Contribution ($). Therefore, performing test calculations using any other rounding methodologies may produce results which vary from those of the ARP Data Manager by a few pennies.

The error check algorithm is the same now for ARP Data Manager and ARP Upload. The rules have been tightened considerably for Status Codes and what, if any, contributions are allowed for each code. This change was necessitated because of recently discovered methodologies at AIG with the benefit of fewer errors finding their way to NAD ARP resulting in fewer delays in getting payroll files processed.

The <Factors> Button now brings up a dialog containing the calculation factors by year. The factors have been entered for each year through July 1, 2011.

The Pay Data Page now contains a field for Payroll End Date. The value is automatically set based on your last used Pay Frequency and PayRoll Date, if available. If not available, the current system date is used. You should check and set this date first whenever you open the ARP Data Manager. The Factors used in calculating basic and matching contributions are now date driven, and if your Payroll End Date happens to be in the wrong year, your contributions will not be calculated correctly. A Payroll Date more than 31 days in the future will trigger a warning from the Error Check Algorithm. A Payroll End Date in a previous year more than 45 days in the past will return a fatal error.

The Pay Data Page also contains a checkbox, "Override Calculations" in the Contributions Group just under the Employer Matching Amount. When this box is checked, you can manually enter values for Employer Basic and Matching amounts, and the calculate algorithm will not recalculate those values.

ARP Data Manager Version 2.9.1 and ARP Upload Version 3.0.1

Error Check: Employer Basic Contributions are now allowed for disabled employees with status code of "D"; however, no employee contributions and no employer match are allowed.

General Note for All Checkboxes

Please look carefully when determining whether a checkbox is checked. A checked checkbox contains a dark black check mark. An unchecked checkbox contains nothing; i.e., it is blank. A gray check mark in a checkbox is a null value; i.e., neither checked nor unchecked, and the program treats it in the same manner as unchecked.

Payroll Run Reference (Run Ref)

The Payroll Run Reference, a 3-character alphanumeric string which can be entered in the ARP Batch Identification Dialog should now be maintained in the Databases Dialog. Assign one unique Run Ref to each of your payroll databases. The Run Ref can still be entered in the Batch Identification Dialog, but it's better to assign it when you can see any others that you have created.

Installing on Windows Vista

The only configuration in which ARP Data Manager and ARP Upload have been installed and run successfully under Windows Vista is for the person whose workstation it is to be part of the Administrators Group of Vista. Any attempt for a person of the Administrators Group to install for a user who is not part of the Administrators Group has failed.

Follow the prompts of the Windows Installer. You will be prompted several times whether to cancel or allow running a program from a publisher unknown to Windows. Simply click <Allow>.

At a point during the Install, it will appear to have frozen. Check your Task Bar for an icon, "Merge Error". If one is visible, click it. Click OK to the message, "Unable to merge new configuration...", then click <Finish> to close the Installer. The Merge Error message appears to have no adverse impact on running either the ARP Data Manager or any of its modules.

Two shortcuts are now on your desktop, "ARP Data Manager" and "ARP Upload". Right-click the ARP Data Manager shortcut. Select "Properties" from the pop-up menu. Click <Advanced> on the Shortcut page. Check the <Run as Administrator> checkbox. Click <OK> to close the Advanced Dialog. Click <Apply> and <Continue> to authorize the change as Administrator (twicd), then <OK> to close the Properties Dialog. ARP Data Manager should now launch and run normally

---

DOWNLOAD and Install ARP Data Manager Version 3.0.0 (Includes Upload Ver 3.1.0)

DOWNLOAD and Install ARP Upload Version 3.1.0

Tel. No. (301) 680-5186  •  All software © Copyright 2006 NAD Information Technology Services