WorksheetsFormatting ER Files
Total questions: 15
Worksheet time: 4hrs 45mins
Regardless of the plan, all ER files have the same formatting requirements.
True
False
The Census File has _______ columns for employers to complete per employee.
24
20
19
125
Birthdate can be in any of the following formats (check all that apply):
01/01/1970
Jan 1st 1970
1/1/1970
01011970
SSN/ITIN must be ______ digits and _________ contain spaces.
9; can
11;cannot
9;cannot
11;can
If any mailing address fields are populated, then the following fields MUST be completed (check all that apply):
Mailing Zip Code
Mailing State
Mailing Line 1
Mailing City
Mailing Line 2
The date of birth field is not required on the Census File.
False
True
The following fields are optional on the Census File (check all that apply):
Primary Phone Number
Email Address
External Payroll ID
Mailing Address
In an uploaded Excel File, the primary phone numbers are 10 digits long and can be in the following formats (check all that apply):
(555) 555 5555
5555555555
555-555-5555
(555)-555-5555
In the Contribution File, the dollar amount has to have the dollar sign ($) before it.
True
False
The external payroll ID field has a max of________ alphanumeric characters and _______ contain spaces.
25; cannot
17; can
25; can
17; cannot
The following could be errors when an ER uploads a Contribution File (check all that apply):
The employee account status is "open"
Roth deferral amount is a numeric amount that is less than 1
External Payroll ID is invalid
The employee is over 59 1/2
The physical address can be a P.O. Box.
True
False
The email address can contain letters, number and the following special characters (check all that apply):
Period .
Dash -
At sign @
Underscore _
The dollar amount on the Contribution File should be formatted as (check all that apply):
$nn.nn
nn.nn
$nn
nn
What would happen if the zip code on 1 row in a 25 row file is invalid for the state provided?
The system would process all valid rows and reject the invalid row(s) that for review
The system would reject the whole file for review with a detailed warning pop-up.
The system would update the incorrect zip code according to the USPS website
The file will process and the employer will receive an error in their message center an hour later informing them of an error
