ARP Data Manager
Calculation of Employer Match
M = A x W
Where
A = Applied Match Percent (%)
W = ARP Gross Wages ($)
For all employees entitled to Employer Matching Contribution, the calculation is:
A = the lesser of
(E + T + R) / W)
or
3% of ARP Gross Wages.
Where
E = Employee Total Elective Deferral ($)
T = Employee Total After Tax Contribution ($)
R = Employee Total Roth 403B Contribution ($)
Rounding for the Applied Match Percent is done only at the final calculation for M, Employer Matching Contribution ($). Calculations using any other rounding methodology may produce results which vary from those of the ARP Data Manager by a few pennies.
Local Hire Guidelines (LHGL):
After providing your LHGL Resolution Document and Rollout Data to the NAD ARP Office, you must configure the ARP Data Manager for these criteria.From the Data Manager, click <Settings> | <Identity, Folders, and Payroll>. In the Local Hire Group Box enter your rollout date and click <OK> at the bottom of the dialog.
Back at the Main Menu, click <Databases>. In the Databases Dialog, Click <Edit>. In the Local Hire Group Box, select the Employer Option Code you have decided to apply from the drop down list under "2011". Following your selection, one of two things will happen:
If you selected "B", all of the employees in the database will be coded "1",
or
If you selected "V", then all the employees will be coded "2".
If you selected "G" or "P", you will be presented with a dialog which will enable you to enter the codes permited for your selected code for each employee.
Error Checks:
The Hire Date must always be after the Birth Date. Otherwise a FATAL ERROR will be generated.The only organizations who may properly provide a Compliance Group code of "M" are the GC Mission Service and Guam Micronesia Mission. A fatal error will be generated for any others attempting to use the Compliance Group code of "M".
Foreign Addresses and Use of Country Field:
Foreign addresses can be entered in a similar manner as US addresses with a few exceptions as noted below. The error check algorithm no longer requires that the Zip / Postal Code be all integers nor does it generate a fatal error if left blank. Canadian Postal Codes can now be entered, and in those cases where a foreign country has no postal codes, the zip code can be left blank.When the employee's address is in a foreign country OTHER THAN CANADA click <Other> in the Country Radio Group. Select the country name from the dropdown list of foreign countries that is now visible.
For Canadian addresses, click <Canada> in the Country Radio Group. Select the Canadian Province from the State dropdown list. Enter the Canadian Postal Code in the Zipcode Field.
VERY IMPORTANT! The country field MUST be left blank when the employee's address is in the United States.
All Checkboxes
The purpose of a Checkbox is to indicate a True or False condition. Checked indicates True; unchecked indicates False. Please look carefully when determining whether a checkbox is checked. A checked checkbox (True) contains a dark black check mark. An unchecked checkbox (False) 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 (False).Payroll Run Reference (RunRef)
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 in the Databases Dialog where you can also see any others that you have created. Each of your unique payroll types should be assigned a likewise unique RunRef. Once a RunRef is assigned to a payroll type, do not change it.DOWNLOAD and INSTALL
If you are setting up ARP on a new or different computer, select Full Install Set. If you simply need to update an existing installation, select Update.ARP Data Manager Version 3.2.8
This release was necessitated by the discovery that the Census File Prep Feature could display multiple rows for each employee in the database when for whatever reason the payroll center had created an additional database containing the same employees as an existing one.For this release, the update to the ARP Data Manager is contained in a compressed file "ARP328.zip". In response to the dialog, click <Save>. Save the Zip file to the folder from which you run ARP Data Manager. Ascertain that location by right-clicking on the icon for ARP Data Manager on your desktop, click <Properties>. In the Properties Dialog, the path to your ARP Data Manager is in the Target Folder Field. Once you've saved the zip file, open your Windows Explorer, navigate to the folder in which you saved the zip file. Right-click the file name, ARP328.zip, and select "Extract All...". Follow the dialogs to extracting to the folder from which you run ARP Data Manager. Confirm by clicking <Yes> to overwrite the existing executable. After clicking <Finish>, your update should be installed and ready to run. If a shortcut to ARP Upload is on your desktop, you should delete it, as it is obsolete since February 4, 2011.
For a full install on a new workstation, click the link below to email your ARP Support person who will assist you with its setup.