W 2 Process
Back to current versionRestore this version

Table of Contents

US W2 PROCESS EP 2012#

The US W2 Process allows for reporting to the US government from the employees' YTD information according to the government specified requirement and for generating the magnetic media or electronic files to send to the government.

For annual reporting, this allows for reporting from the employees' YTD information according to selected criteria in order to produce the W2 Wage statement and for generating the W2 media file to send to the government.

For quarterly reporting, this allows for reporting from the employees' QTD information according to selected criteria and for generating the media file to send to the government.


2011-2012 Year End Changes#

Government Websites#

http://www.ssa.gov/employer/pub.htm http://www.irs.gov/pub/irs-prior/iw2w3--2011.pdf http://www.irs.gov/pub/irs-prior/fw2--2011.pdf

W2 Forms#

2-on-a-page FormLayout has no change. (However, Box 9 - Advance EIC Payment, has been deleted from the form.)
4 Corners FormLayout has no change. (However, Box 9 - Advance EIC Payment, has been deleted from the form.)
4-on-a-page FormLayout has no change. (However, Box 9 - Advance EIC Payment, has been deleted from the form.)
Note:While the W2 form layout itself has no changes, there are two new codes:
  • ‘DD’ in Box 12 (optional for 2011) used to report the Cost of Employer-Sponsored Health Coverage
  • ‘EE’ in Box 12 used to report the Designated Roth Contributions under a governmental section 457(b) plan
Important: For Oracle reports, RPW2/RP1099R must be run and the report sent to the PDF file instead of to the previewer. RPW2/RP1099R aligns the W2/1099R government forms in PDF format and allows the user to adjust the parameters of 'Adjust Top Margin' and ‘Between Form Space’ fields when generating the PDF file. Once the PDF file is generated, the Page set up does not need to be adjusted when printing.

For Windward report, RPW2 supports the 2-on-a-page form only.

EFW2 File#

The following record codes contain changes for tax year 2011 reporting.

IDFD Changes#

For 2011-2012 reporting, IDFD Form Code ‘HL$US-W2-2012’ is used.

IDFD – Store Option#

For 2011-2012 reporting, IDFD Form Code ‘HL$US-W2-2012’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for RPYEU to store the Employer Name / Addresses, Employee Name / Addresses in the Government Remittance tables. Important:RPYEU must be run with the new IDFD Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Names / Addresses and the Amounts in the Government Remittance Tables.

Any prior year’s Form Codes do not supply this option and therefore will not turn on the Store feature for RPYEU.

RPYEU – New Capabilities#

Since 2010 tax year reporting, RPYEU has the following new capabilities:
  1. RPYEU now stores the Employer Name / Addresses, Employee Name / Addresses and the Amounts in the following Government Remittance Tables for historical reference purposes: P2K_PR_GVT_RUNS (pgr), P2K_PR_GVT_HEADERS (pgh), P2K_PR_GVT_AMOUNTS (pga)

  2. After RPYEU is run, any release of 3.05.03 or above, will allow you to view the results on IPGR and IPGH.
    Each RPYEU generates a GVT Run number to be viewed on IPGR. UPGRUNDO can be run to undo the GVT Run.

  3. RPYEU parameter ‘Sort by Active/Inactive’ has been enhanced from a X_YES_NO toggle to use the lexicon value X_W2_SORT_ACTIVE.
    This allows sorting of terminated employees to be before or after the ‘Sort Level’ that is defined in the prompt. Read the RPYEU Sort Level section below.
  4. W2 Form (2-on-a-page) Box D - Control Number field size has lots of space, allowing more information to be printed.
    Box D is derived from the IDFDV Field Identifier - W2-CONTROL-PRT; value 3 to 6 are added as below.
W2-CONTROL-PRT
Specifies if the Control Number should be printed on the form or not
Null, 0Do not print Control Number on W2 Form
1Print Control Number as defined in W2-CONTROL-NUM Identifier
2Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
3Print W2-CONTROL-NUM Identifier and Person Code
4Print ‘Sort Level By’ prompt and Person Code
5Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code

RPW2 – capabilities (Oracle Report Only)#

Since 2010-tax year reporting, RPW2 has the following capabilities in the Oracle version report (but not the Windward version).


Government Reporting Procedures#

The following steps outline the procedure to produce the W2 Forms and the Government file:
  1. RPREGT
    • RPREGT
      • For annual reporting , run RPREGT to produce YTD Register
      • For quarterly reporting, run RPREGT to produce QTD Register
  2. IDFD/IDFDV/RDFD
    • IDFD
      • Specifies the W2 Form and File Definition for Annual and Quarterly reporting
      • Contains the default values to enter on IDFDV
      • The information on this screen is provided at release time using a script. The script only needs to be executed in order to load in the most current information for the year.
    • IDFDV
      • Mandatory set up of Annual W2 Form and File Definition with user information
      • Optional set up of Quarterly Form and File Definition with user information
    • RDFD
      • Used to report the Form and File Definition from IDFD and IDFDV
  3. RPYEU
    • RPYEU
      • Produces US Year End Summary Report for the reporting Year or the reporting Quarter
      • Must be used to balance to the YTD Register or QTD Register report (RPREGT)
      • Exception messages from this Summary Report must be checked and any exceptions corrected
      • Generates the Federal Government file in federal format
      • Generates State File in the federal file format for states that accept the federal file format
      • Generates State File for states with specific State File format requirement
      • RPYEU must be run one state at a time to generate state specific file
      • Each state may have its own requirement, it must be verified if that state specific format is supported by RPYEU prior to running RPYEU for a specific state file
      • Generates an XML file to feed into Oracle version RPW2 in order to print W2 Forms
      • Generates GVT Run and stores information in IPGR, IPGH for Windward RPW2
      • In utility trace mode, RPYEU generates a .txt file for SQL Select statement and csv trace file
      • Provides an option to generate data dump file in .csv format for Federal, State, Local, School data for debugging or balancing
  4. IPGR/IPGH
    • IPGR
      • Screen inquiry by GVT Run Number after RPYEU
    • IPGH
      • Screen inquiry by GVT Header for an employee after RPYEU
  5. UPGRUNDO
    • UPGRUNDO
      • Used to undo GVT Run number by employee
      • Used to undo erroneous GVT Run due to set up issues or to remove archived GVT info
  6. RPW2 (Oracle)/RPW2 (Windward)
    • RPW2 (Oracle)
      • Produces W2 forms (supporting either a 2-on-a-page or 4-on-a-page format)
      • Reads XML file generated from RPYEU to print W2 forms
      • Prints W2 on pre-printed W2 forms or prints different copies (Copy A, 1, B, C, 2, D ) of the W2 forms along with an option to print 'Employee Instructions' on the back
      • Generates grand total and exception messages with RPW2 Execution ID as Execution Run Logs
      • It is mandatory to use the Execution ID of the RPW2 and run RMEX to obtain a grand total report
    • RPW2 (Windward)
      • Produces W2 forms (supporting a 2-on-a-page format only)
      • Reads IPGR/IPGH information generated from RPYEU to print W2 Forms
      • Generates grand total and exception messages with RPW2 Execution ID as Execution Run Logs
  7. RMEX
    • RMEX
      • Produces a grand total report from the RPW2 run to balance to RPYEU
      • It is mandatory to enter the Execution ID of the RPW2 run to obtain a grand total report
      • The RMEX grand total report is used to balance to RPYEU only, and is not used for government reporting



Set Up#

IMUF – Define User Fields for IDGV#

On IMUF, define user fields for P2K_CM_GOVT_REGISTRATIONS

The following user fields are used on the IDGV Variables tab. (RPYEU will generate these UDF's if any of the UDF do not exist.)

For Annual and Quarterly Reporting

UDFUsage
W2 STATE MEDIA FILINGUsed by all states
W2 TAX TYPE CODEUsed by all states
W2 TAXING ENTITYUsed by all states
W2 WAGE PLAN CODEUsed by the state of California
W2 BRANCH CODEUsed by the state of California
W2 ER NAMEUsed by Federal reporting, this overrides 'Entity Name' on IDEN
W2 LOCN CODEUsed by Federal reporting, this overrides 'Location Code' on IDEN

For Quarterly reporting, these UDF's are used when ‘HL$US-QTR-2004’ Form Code is being used:

IMUF – Define User Fields for IDDP#

On IMUF, define the user fields for P2K_CM_DEPARTMENT_DETAILS.

The following user fields are used on IDDP. (RPYEU will generate these UDF's if they do not exist.)

UDFUsage
SUI ER NUMBER
W2 DESTINATION

IMUF – Define User Fields for IEID#

On IMUF, define the user fields for P2K_HR_IDENTITIES.

The following user fields are used on IEID for Minnesota. (They be may set up on IMUF manually or RPYEU will generate these UDF's if they do not exist.)

UDFUsage
W2 DESTINATION
MMREF PROBATIONARYUsed by the state of Missouri
MMREF OFFICER CODEUsed by the state of Missouri

IMUF – Define User Fields for IDCO#

On IMUF, define the user fields for P2K_CM_COUNTRIES. (RPYEU will generate these UDF's if it does not exist.)
UDFUsage
ISO COUNTRY CODE

IDCO – Define ISO Country Code for Foreign Countries#

If the employer or employees have addresses that are not within in USA, the EFW2 file need to report the 2 character International Organization for Standardization (ISO) country code.

'Country Code' on IDCO is a user-specified country code; usually the three character United Nations code for a specific country, but can be the two character ISO code.

For Example:

CountryUnited Nation CodeISO Country Code
MexicoMEXMX
MozambiqueMOZMZ

The ISO country code needs to be entered on the IDCO User Defined field. If it is not entered, then the IDCO country code is used as the ISO country code.

Please read the Employer and Employee Address sections below.

IDDP – Department Screen#

IEID – Employee Identity Screen User Field#

IEID is used to enter the ‘W2 Destination’, ‘MMREF Officer Code’ for the employee

IDGR – Define Group for Govt Registration#

Important: Federal/State/Local Registration MUST not be changed for a Group for different effective date records. The UPCLOZ program will not cut new YTD records if the Group changes the effective date. Therefore, if the Group requires a change of Registration numbers, either a new Group should be created or all effective records should be changed to the same Registration numbers.

For each group at the Federal level, the Federal Registration number is retrieved according to the ‘Fed Regist Set’ and ‘Fed Regist Type’ from IDGV and then displayed on IDGR.

For each group at the State/Prov/Local level, a ‘State/Prov Set’ and ‘State/Prov Type’ can be pointed to. Since each group can be paid in many different states, the State/Prov Registration number cannot be displayed on IDGR. For each employee belongs to this group, the State Registration Number is retrieved from IDGV by ‘State/Prov Set’ and ‘State/Prov Type’ and the Pay Header State/Prov of this employee.

At the local level, the Local Registration Number is retrieved from IDGV by ‘Local Regist Set’ and ‘Local Regist Type’ and the GEO Local of this employee

Each group must define one of the following ‘W2 Employment Type’ for W2 reporting purpose:

Note:For the ‘Q - MQGE' type employment, it is not required to group all employees under one group. The MQGE employees can belong to a group with ‘R’ type employment, IPRLU can specify the proper MEDICARE and FICA method to classify MQGE employees (see below for detail)

IDSP – Define States#

IDCN – Define Counties#

IDTX – Define Tax Jurisdictions#

IDSD – Define School Districts#

IDGV – One or Multiple Government Registrations#

For each Entity on IDGV, the Government Registration Set that is used to collect Federal, State and Local Registrations must first be defined. Under the Registration Set, ‘Federal Registration’ must be set up for Country ‘USA with valid ‘Employer Identification Number’. Then State, Local Registrations may be set up for each State or Local under the same Registration Set.

User with one Federal Registration

Note:If Registration Type ‘US Fed Regist 1’ is used, then the FICA registration should be defined using Registration Type = ‘US FICA Regist 1’, for MEDICARE registration, the Registration Type should = ‘US MEDI Regist 1’ etc. The last digit of the Registration Type must be matched.

User with Multiple Federal Registrations For a user with multiple Federal Registrations, there are two options:

  1. One "Main Registration Set" can be used, then Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’ can be set up. This allows up to nine Federal Registrations.
  2. Multiple "Registration Sets" can be used, then set up Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’. This allows for an unlimited number of Federal Registrations.
“Govt Registration Set” may be used to group similar Registrations together.

For Example:

Govt Registration SetUsage
MAIN REGISTUse as default to group all registrations initially
REGIST 2User may define another set for all level of registrations
FED REGISTUser may define Federal level registrations for this set
STATE REGISTUser may define State level registrations for this set
LOCAL REGISTUser may define Local level registrations for this set
FULLTIME REGISTUser may define Registrations for Full time employees
PARTTIME REGISTUser may define Registrations for Part time employees
SEASONAL REGUser may define Registrations for Seasonal employees
STATE OHIOUser may define Registrations for Ohio for this set only

Important Note for IDGV set up: The IDGV “Govt Registration Set” and Registration Types are used on the IDGR Registration tab for each of the Federal, State and Local level set up.
On IDGV set up, the last digit of Registration Type must match for the same Federal, State and Local level of registrations.

Example #1
If Registration Type = ‘US Fed Regist 1’ is used, then

If Registration Type = ‘US State Regist 1’ is used, then
Example #2
If Registration Type = ‘US Fed Regist 2’ is used, then If Registration Type = ‘US State Regist 2’ is used, then

On the IDGR Registration tab, when the user specifies to use State/Prov Type = ‘US State Regist 1’, this implies all State level registrations with the last digit matching ‘Regist 1’ should be used, thus ‘US SUI Regist 1’ will be used.

IDGV – Override Employer Name and Address by EIN#

On the IDGV Variables tab, there is the option to define an override for the Employer’s Name and Address.
This option allows the users who have multiple government registrations for one entity to report a different Employer Name or Address by each Federal Registration Number (EIN).
W2 ER NAMEEnter the Employer Name to be reported, this overrides the IDEN Entity Name
W2 LOCN CODEEnter the Location code to be reported, this overrides the IDEN Location code

Note: The exact Location code must be entered in this field, otherwise it will not be used.

IDGV – Levels of Government Registrations#

The following levels of Government Registration must be set up for the Federal, State, County, City and School tax reporting.

Federal Level

State Level

Local Level

School Level

IDGV – Define State SUI Registrations for Quarterly Filing#

When running RPYEU with Calendar Type = ‘Q’ for a quarter, each state must set up with ‘US SUI Regist’. The last digit of ‘US SUI Regist’ Registration type must match the last digit of ‘US State Regist’ Registration type, i.e. ‘US State Regist 1’ should also define ‘US SUI Regist 1’, ‘US State Regist 2’ should also define ‘US SUI Regist 2’, etc,
According to each state’s quarterly filing format, some state may require to submit Taxes Due, Previous Underpayment etc. For each quarter, define the IDGV Variables tab for these quarterly amount for the proper ‘US SUI Regist’ prior to running RPYEU.

Please note each QTR field’s decimal point and enter in the above format.

IDFD – Define Form Code#

IDFD – Starter Scripts#

IDFD – Store Option#

Since 2010-tax year reporting, IDFD Form Code ‘HL$US-W2-2011’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for RPYEU to store the Employer Name / Addresses, Employee Name / Addresses and the Amounts of the Seq# in the Government Remittance Tables. Important: RPYEU must be run with the new IDFD Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Addresses and the Amounts in the Government Remittance Tables. Any prior year’s Form Codes do not supply this option and therefore will not turn on the store feature for RPYEU.

IDFDV – Copy Last Year’s Definition to Current Year#

IDFDV – Form Definition Variables#

IDFD FORM
HL$US-W2-2012 - system supplied
IDFD FORM TYPE
US W2 EFW2 Definition - indicates the W2 definition for EFW2 filing format
Form Code ‘HL$US-W2-2012’ Identifiers
Field IdentifierDescriptionSuggested Field SourceSuggested Variable
SUB-ER-EINSubmitter’s Employer EINConstant9 characters EIN
SUB-USER-IDSubmitter User IdentificationConstant8 characters User ID assigned to the employee who is attesting to the accuracy of the file
SUB-RESUB-INDResubmitt IndicatorConstantEnter 1 if file is resubmitted, otherwise 0
SUB-RESUB-WFIDResubmitt SSA WFID from noticeConstantIf resubmitt, enter SSA WFID from notice
SUB-VENDORSoftware Vendor CodeConstantEnter your company data
SUB-SOFTWARESubmitter Software CodeConstantEnter your company data
SUB-COMP-NAMECompany Name receive EFW2ConstantEnter Company name who receive EFW2
SUB-COMP-LOCNCompany Location AddressConstantEnter company’s location address

i.e. Attention, Suite, Room # etc
SUB-COMP-DELIVCompany Delivery AddressConstantEnter company’s delivery address

i.e. Street or Post Office Box
SUB-COMP-CITYCompany’s CityConstantEnter company’s city
SUB-COMP-STATECompany’s State AbbrevConstantEnter company’s State Abbreviation
SUB-COMP-ZIPCompany’s ZIP CodeConstantEnter company’s ZIP code
SUB-COMP-ZIP-EXTCompany’s ZIP Code ExtensionConstantEnter company’s ZIP code extn
SUB-COMP-F-STATECompany’s foreign State/provinceConstantEnter company’s foreign state/province
SUB-COMP-F-POSTCompany’s foreign postal codeConstantEnter company’s foreign postal code
SUB-COMP-COUNTRYCompany’s country if applicableConstantEnter company’s country if applicable
SUB-SUBM-NAMESubmitter Organization NameConstantOrganization Name to receive unprocessed data
SUB-SUBM-LOCNSubmitter Location AddressConstantEnter submitter location address

i.e. Attention, Suite, Room # etc
SUB-SUBM-DELIVSubmitter Delivery AddressConstantEnter submitter delivery address

i.e. Street or Post Office Box
SUB-SUBM-CITYSubmitter CityConstantEnter submitter city
SUB-SUBM-STATESubmitter State AbbrevConstantEnter submitter State Abbreviation
SUB-SUBM-ZIPSubmitter ZIP CodeConstantEnter submitter ZIP code
SUB-SUBM-ZIP-EXTSubmitter ZIP Code ExtensionConstantEnter submitter ZIP code extension
SUB-SUBM-F-STATESubmitter foreign State/provinceConstantEnter submitter foreign state/province
SUB-SUBM-F-POSTSubmitter foreign postal codeConstantEnter submitter foreign postal code
SUB-SUBM-COUNTRYSubmitter country if applicableConstantEnter submitter country if applicable
SUB-CONT-NAMEContact name for SSAConstantEnter your company data
SUB-CONT-TELContact telephone # for SSAConstantEnter your company data
SUB-CONT-TEL-EXTContact telephone extensionConstantEnter your company data
SUB-CONT-EMAILContact e-mail address for SSAConstantEnter your company data
SUB-CONT-FAXContact FAX phone # for SSAConstantEnter your company data
SUB-CONT-METHPreferred Contact methodConstantEnter your company data
SUB-PREPARERPreparer CodeConstantEnter your company data
SUB-3RD-PARTY-SICKThird-Party Sick Pay IndicatorConstantEnter your company data
SUB-3RD-PARTY-TAXIncome Tax Withheld by 3rd PartyConstantEnter your company data
W2-ER-AGENT-INDAgent Indicator CodeConstantIf applicable, enter appropriate code
W2-ER-FOR-EINAgent for which EINConstantIf you are an agent, enter the EIN for which you are an agent for
W2-ER-TERM-BUSTerminating business indicatorConstantEnter appropriate code from SSA
W2-ER-ESTABEstablishment NumberConstantFurther identify within EIN
W2-ER-OTHER-EINOther EINConstantOther EIN used
W2-ER-EINEmployer Identification NumberData Base ColumnDGV.GOVT_REGIST_NUMBER
W2-ER-NAMEEmployer NameData Base ColumnDED.ENTITY_NAME
W2-ER-LOCN-ADDREmployer Location AddressConstantEmployer’s location address

i.e. Attention, Suite, Room # etc.
DLN.ADDRESS_LINE_2 or DLN.MAIL_ADDRESS_LINE_2

Enter the word MAIL or blank
To use Primary address, leave this blank
To use Mailing address, enter the word MAIL
System will derive the complete primary or mailing address and store in the Address Identifiers.
W2-ER-DELIV-ADDREmployer Delivery AddressConstantEmployer’s delivery address

i.e. Street or Post Office Box
DLN.ADDRESS_LINE_1 or DLN.MAIL_ADDRESS_LINE_1

Enter blank, system derived
W2-ER-CITYEmployer CityConstantEmployer’s city
DLN.LOCALITY or DLN.MAIL_LOCALITY

Enter blank, system derived
W2-ER-STATEEmployer State AbbrevConstantEmployer’s State abbreviation
DSP.STATE_PROVINCE_CODE

Enter blank, system derived
W2-ER-ZIPEmployer ZIP CodeConstantEmployer’s ZIP Code
DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL

Enter blank, system derived
W2-ER-ZIP-EXTEmployer ZIP ExtensionConstantEmployer’s ZIP Code
DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL

Enter blank, system derived
W2-ER-F-STATEEmployer foreign State/provinceConstantEmployer foreign state/province or Constant

Enter the word NAME or blank
W2-ER-F-POSTALEmployer foreign postal codeConstantEnter Employer foreign postal code or Constant
W2-ER-COUNTRYEmployer country if applicableConstantEnter Employer country

Enter blank, system derived
W2-ER-F-COUNTRYEmployer foreign countryConstantEnter the word NAME or the word ISO or blank
W2-ER-TAX-JURISTax Jurisdiction CodeConstant Enter appropriate code or null
W2-KIND-OF-EMPLOYERKind of EmployerConstant
W2-EE-SSNEmployee Social Security NumberData Base ColumnEID.GOVERNMENT_CODE
W2-EE-FIRST-NAMEEmployee First NameData Base ColumnEID.FIRST_NAME
W2-EE-MIDDLEEmployee Middle NameData Base ColumnEID.MIDDLE_NAME
W2-EE-LAST-NAMEEmployee Last NameData Base ColumnEID.LAST_NAME
W2-EE-SUFFIXEmployee Suffix NameData Base ColumnEID.RANK with derivation expression

Decode(~,’01’,’JR’,’02’,’SR’,NULL)
W2-EE-LOCN-ADDREmployee Location AddressConstantEmployee’s location address

i.e. Attention, Suite, Room # etc

EPS.ADDRESS_LINE_2
EPS.MAIL_ADDRESS_LINE_2

Enter the word MAIL or blank
To use Primary address, leave this blank.
To use Mailing address, enter the word MAIL.
System will derive the complete primary or mailing address and store in the Address Identifiers.
W2-EE-DELIV-ADDREmployee Delivery AddressConstantEmployee’s delivery address

i.e. Street or Post Office Box

EPS.ADDRESS_LINE_2 or EPS.MAIL_ADDRESS_LINE_2

Enter blank, system derived
W2-EE-CITYEmployee CityConstantEmployee’s city

EPS.LOCALITY or EPS.MAIL_LOCALITY

Enter blank, system derived
W2-EE-STATEEmployee State AbbrevConstantEmployee’s State abbreviation

DSP.STATE_PROVINCE_CODE

Enter blank, system derived
W2-EE-ZIPEmployee ZIP CodeConstantEmployee’s ZIP Code

EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL

Enter blank, system derived
W2-EE-ZIP-EXTEmployee ZIP ExtensionConstantEnter employee’s ZIP Code

EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL

Use derivation expression substr(~,6) for ZIP extension
W2-EE-F-STATEEmployee foreign State/provinceConstantEmployee foreign state/province or Constant

Enter the word NAME or blank
W2-EE-F-POSTALEmployee foreign postal codeConstantEmployee foreign postal code

Enter blank, system derived
W2-EE-COUNTRYEmployee country if applicableConstantEnter Employee country

Enter blank, system derived
W2-EE-F-COUNTRYEmployer foreign countryConstantEnter the word NAME or the word ISO or blank
W2-CONTROL-PRTPrint Control Number on FormConstantNull, 0, 1, 2, 3, 4, 5, 6

Null, 0 – Do not print Control Number on W2 Form
1 - Print Control Number as defined in W2-CONTROL-NUM Identifier
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
3 - Print W2-CONTROL-NUM Identifier and Person Code
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
W2-CONTROL-NUMControl Number on FormData Base ColumnEnter your company data
W2-EXCLUDE-EEExclude EmployeeData Base ColumnEnter your company data
W2-FIT-WAGEWages, Tips, Other CompensationElementW2-BOX-01
W2-FIT-TAXFederal Income Tax WithheldElementW2-BOX-02
W2-SSN-WAGESocial Security WagesElementW2-BOX-03

Derivation expression LEAST(~,94200.00) may be used for year 2006 max

System verify Box 3 + Box 7 does not exceed annual max, otherwise issue msg
W2-SSN-TAXSocial Security Tax WithheldElementW2-BOX-04

Derivation expression LEAST(~,5840.40)may be used for year 2006 max
W2-MEDI-WAGEMedicare Wages and TipsElementW2-BOX-05
W2-MEDI-TAXMedicare Tax WithheldElementW2-BOX-06
W2-SSN-TIPSocial Security TipsElementW2-BOX-07
W2-ALLOC-TIPAllocated TipsElementW2-BOX-08
W2-EICAdvanced EIC CreditElementW2-BOX-09
W2-DEP-CAREDependent Care BenefitElementW2-BOX-10
W2-NQUALNon Qualified PlansElementW2-BOX-11
W2-NQUAL-457Non Qualified Plans Sect 457ElementW2-BOX-11-457
W2-NQUAL-N457Non Qualified Plans Not Sect 457ElementW2-BOX-11-N457
W2-CODE-AUncollect SSA/RRTA tax on tipsPay ComponentEnter your company data
W2-CODE-BUncollect Medicare tax on tipsPay ComponentEnter your company data
W2-CODE-CGroup Term Life Ins > 50000Pay ComponentEnter your company data
W2-CODE-DDeferred 401(k) cashPay ComponentEnter your company data
W2-CODE-EDeferred 401(b) Salary reductionPay ComponentEnter your company data
W2-CODE-FDeferred 408(k)(6) Salary reductPay ComponentEnter your company data
W2-CODE-GDeferred 457(b) compensationPay ComponentEnter your company data
W2-CODE-HDeferred 501(c)18(D) tax exemptPay ComponentEnter your company data
W2-CODE-JNon taxable sick payPay ComponentEnter your company data
W2-CODE-K20% excise parachute paymentPay ComponentEnter your company data
W2-CODE-LEmployee business expense reimbursePay ComponentEnter your company data
W2-CODE-MUncollect SSA/RRTA group insPay ComponentEnter your company data
W2-CODE-NUncollect medicare group insPay ComponentEnter your company data
W2-CODE-PMoving expensePay ComponentEnter your company data
W2-CODE-QNontaxable combat payPay ComponentEnter your company data
W2-CODE-REmployer Contrib to MSAPay ComponentEnter your company data
W2-CODE-SSalary reduction to 408(p)Pay ComponentEnter your company data
W2-CODE-TAdoption benefitsPay ComponentEnter your company data
W2-CODE-VIncome of nonstat stock optPay ComponentEnter your company data
W2-CODE-WER contrib Health Saving AccountPay ComponentEnter your company data
W2-CODE-YDeferrals 409A Nonqual planPay ComponentEnter your company data
W2-CODE-ZIncome 409A Nonqual planPay ComponentEnter your company data
W2-CODE-AARoth contrib 401(k)Pay ComponentEnter your company data
W2-CODE-BBRoth contrib 403(b)Pay ComponentEnter your company data
W2-CODE-CCHIRE exempt wagesPay ComponentEnter your company data
W2-CODE-DDER sponsored Health CoveragePay ComponentEnter your company data
W2-CODE-EERoth Contribution 457(b)Pay ComponentEnter your company data

The values from W2-OTHER-01 to W2-OTHER-20 are printed on W2 Form Box 14.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
W2-OTHER-01Your company descriptionPay ComponentEnter your company data
W2-OTHER-nnYour company descriptionPay ComponentEnter your company data
W2-OTHER-20Your company descriptionPay ComponentEnter your company data

Please enter Box 14 Description in the Prompt field in format of 14-xxxxxxx.

The values from W2-USER-01 to W2-USER-20 are used by CLIENTS only, the values are not printed on the W2 form or file. These identifiers are used by users to obtain amounts to show on RPYEU Summary report. e.g. 125 plan, 401 plan, benefit amounts, or employer portion of certain employee contribution etc.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
W2-USER-01Your company descriptionPay ComponentEnter your company data
W2-USER-nnYour company descriptionPay ComponentEnter your company data
W2-USER-20Your company descriptionPay ComponentEnter your company data

The values from W2-HL-01 to W2-HL-10 are used only internally. These identifiers are used internally to obtain amounts to show on RPYEU Summary report or for other purposes. These are internally reserved areas to allow users to define additional new variables that are not available or defined at time when the programming is done. If needed, Support will give instruction for users to set these up.

Field IdentifierDescriptionSuggested Field SourceSuggested Variable
W2-HL-01Internally defined descriptionPay ComponentEnter your company data
W2-HL-nnInternally defined descriptionPay ComponentEnter your company data
W2-HL-10Internally defined descriptionPay ComponentEnter your company data
W2-STAT-EEStatutory employeeStatisticsEnter your company data
W2-RETIRE-PLANRetirement plan employeeStatisticsEnter your company data
W2-3PARTY-SICKThird-party sick payStatisticsEnter your company data
W2-SCHL-WAGESchool Taxable WagesElementW2-SCHL-WAGE
W2-SCHL-TAXSchool TaxElement W2-SCHL-TAX
W2-STATE-CODEState CodeData Base ColumnDSP.STATE_PROVINCE_CODE
W2-STATE-REGISTState Registration I.D. NoData Base ColumnDGV.GOVT_REGIST_NUMBER
W2-STATE-WAGE-HOMEState Wages and Tips (Home State)ElementW2-STATE-WAGE-H
W2-STATE-WAGE-WORKState Wages and Tips (Work State)ElementW2-STATE-WAGE-W
W2-STATE-TAX-HOMEState Income Tax (Home State)ElementW2-STATE-TAX-H
W2-STATE-TAX-WORKState Income Tax (Work State)ElementW2-STATE-TAX-W
W2-SUI-WAGE-EEState SUI Wages (Employee)ElementW2-SUI-WAGE-EE
W2-SUI-WAGE-ERState SUI Wages (Employer)ElementW2-SUI-WAGE-ER
W2-SUI-TAX-EEState SUI Tax (Employee contrib)ElementW2-SUI-TAX-EE
W2-SUI-TAX-ERState SUI Tax (Employer contrib)ElementW2-SUI-TAX-ER
W2-SDI-WAGE-EEState SDI Wages (Employee)ElementW2-SDI-WAGE-EE
W2-SDI-WAGE-ERState SDI Wages (Employer)ElementW2-SDI-WAGE-ER
W2-SDI-TAX-EEState SDI Tax (Employee contrib)ElementW2-SDI-TAX-EE
W2-SDI-TAX-ERState SDI Tax (Employer contrib)ElementW2-SDI-TAX-ER
W2-SUI-HRS-WRKSUI Hours WorkedElementW2-SUI-HRS-WORK
W2-SUI-WK-WRKSUI Weeks Worked (From User)ElementW2-SUI-WK-WORK
W2-SUI-WEEKS-WRKSUI Weeks Worked (Derived)Not specifiedSystem Derived, no need to set up
W2-SUI-TAXABLE-WAGESSUI Taxable WagesNot specifiedSystem Derived, no need to set up
W2-SUI-EXCESS-WAGESSUI Excess WagesNot specifiedSystem Derived, no need to set up
W2-SUI-MTH1-WORKSUI Worked on 12th day of mth 1Not specifiedSystem Derived, no need to set up
W2-SUI-MTH2-WORKSUI Worked on 12th day of mth 2Not specifiedSystem Derived, no need to set up
W2-SUI-MTH3-WORKSUI Worked on 12th day of mth 3Not specifiedSystem Derived, no need to set up
W2-TIP-WAGE-WORKWork State Tips Wages ElementTips Wages for each State
W2-ST-TIP-WORKWork State TipsPay ComponentTips for each State
W2-WC-WORKWorkers Compensation ContributionElementW2-WC-WORK
W2-CNTY-NAMECounty NameData Base ColumnDCN.COUNTY_NAME
W2-CN-WAGE-HOMECounty Wages (Home County)ElementW2-CNTY-WAGE-H
W2-CN-WAGE-WORKCounty Wages (Work County)ElementW2-CNTY-WAGE-W
W2-CN-TAX-HOMECounty Tax (Home County)ElementW2-CNTY-TAX-H
W2-CN-TAX-WORKCounty Tax (Work County)ElementW2-CNTY-TAX-W
W2-CITY-NAMECity Name Data Base ColumnDTX.JURISDICTION_NAME
W2-CI-WAGE-HOMECity Wages (Home City)ElementW2-CITY-WAGE-H
W2-CI-WAGE-WORKCity Wages (Work City)ElementW2-CITY-WAGE-W
W2-CI-TAX-HOMECity Tax (Home City)ElementW2-CITY-TAX-H
W2-CI-TAX-WORKCity Tax (Work City)ElementW2-CITY-TAX-W

For California SDI reporting, there are two options to print SDI on W2 forms:

  1. For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’.
  2. For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the Box 14 may be set up to print ‘CASDI’ and the SDI amount.

IDFDV – Employer Primary Address and Mailing Address#

SeqField IdentifierDescriptionField Variable
2020W2-ER-LOCN-ADDREmployer Location AddressMAIL
2030W2-ER-DELIV-ADDREmployer Delivery Addressblank
2040W2-ER-CITYEmployer Cityblank
2050W2-ER-STATEEmployer State Abbrevblank
2060W2-ER-ZIPEmployer Zip Codeblank
2070W2-ER-ZIP-EXTEmployer Zip Code Extensionblank
2100W2-ER-COUNTRYEmployer countryblank

Foreign Country Primary and Mailing Address set up:

SeqField IdentifierDescriptionField Variable
2080W2-ER-F-STATEEmployer foreign State AbbrevBlank or enter the word NAME

If ‘NAME’ is entered, the State name is used, otherwise the State code is used

This foreign state description is printed on W2 and reported on EFW2 file
2090W2-ER-F-POSTALEmployer foreign postal CodeBlank
2105W2-ER-F-COUNTRYEmployer foreign countryBlank or enter the word NAME, or ISO

If ‘NAME’ is entered, the Country name is used
If ‘ISO’ is entered, the ISO Country code from IDCO UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used

IDFDV – Employee Primary Address and Mailing Address#

SeqField IdentifierDescriptionField Variable
2600W2-EE-LOCN-ADDREmployer Location AddressMAIL
2610W2-EE-DELIV-ADDREmployer Delivery AddressBlank
2620W2-EE-CITYEmployer CityBlank
2630W2-EE-STATEEmployer State AbbrevBlank
2640W2-EE-ZIPEmployer Zip CodeBlank
2650W2-EE-ZIP-EXTEmployer Zip Code ExtensionBlank
2680W2-EE-COUNTRYEmployer countryBlank

Foreign Country Primary and Mailing Address set up:

SeqField IdentifierDescriptionField Variable
2660W2-EE-F-STATEEmployee foreign State AbbrevBlank or enter the word NAME
\If ‘NAME’ is entered, the State name is used, otherwise the State code is used

This foreign State description is printed on W2 and reported on EFW2 file
2670W2-EE-F-POSTALEmployee foreign postal codeBlank
2685W2-EE-F-COUNTRYEmployee foreign countryBlank or enter the word NAME, or ISO

If ‘NAME’ is entered, the Country name is used
If ‘ISO’ is entered, the ISO Country code from IDCO UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used



Processing#

Taxation Level Processing#

If an employee has worked in and/or lived in multiple tax jurisdictions during one taxation year, the reporting of W2 for this employee is as follows:

Federal Level

State Level

Local Level

School Level

W2 Type of Employment#

Government Media File Name#

XML File#

RPYEU Trace and Data Dump File#

Government Media File – Code RW, RS when Select by State#

Exclude Employees#

Election Workers#

The election workers earnings should be reported on W2 if the payment is $600 or more. If the payment is less than $600 and if social security and medicare taxes are withheld, then the earnings should be reported.

In this situation, that means if the election worker’s earnings is less than $600 and there is no social security and medicare tax withheld, then the payment should not be reported on W2. The Election Worker situation should be handled as follows:

  1. Use a separate pay component to record the election worker payment. If FICA and Medicare are not calculated for these payments, then the election worker payment can be excluded by not putting the pay component in the element for each W2 Box.
  2. If the employee is paid with election worker payment and FICA and Medicare tax are withheld, then determine if the employee should be excluded or not. If employee is excluded, a STAT CODE may be set up for IDFDV Identifier ‘W2-EXCLUDE-EE’ to exclude the employee from reporting on W2 form.
  3. All Election Workers may be excluded by using the EASD.ASSIGNMENT_TITLE = ‘ELECTION WORKER’, then the Identifier ‘W2-EXCLUDE-EE’ should be used to exclude EASD.ASSIGNMENT_TITLE = ‘’ELECTION WORKER’.

Reissued / Corrected W2 Form#

If an employee has lost the W2 Form, the W2 Form can be reissued by running RPW2 with the employee selected.

For Oracle version RPW2, prior to reissue of the W2 Forms by RPW2, the XML file must be ready for the RPW2 program. The XML file can be from one of the followings:

  1. RPYEU may be re-run to generate the XML file for the reissued employees, OR
  2. The archive XML file may be used from the previous RPYEU run and the employees from XML file selected

For Windward version RPW2, the GVT Run number that the employee belongs to when RPYEU is run must be selected:

  1. RPYEU may be re-run to generate a new GVT Run number for the employee, OR
  2. The existing GVT Run number that the employee’s W2 was originally issued may be located

When RPW2 is run, the word ‘REISSUED’ or ‘CORRECTED’ should be entered for the prompt ‘Reissued/Corrected:’, then the W2 form will be printed with word specified.

Void W2 Form#

RPYEU Registration Set Up Audit#

When RPYEU is run, there is an option to audit and fix the government registrations set up on IDGV.

The following prompt can be answered: Regist/Set Up Audit: Print and Run

This prompt is validated from lexicon ‘X_PRINT_AND_RUN

‘00 – Do not print, run’
After the Government Registration is audited, do not print all registrations, continue to run RPYEU. This option suppresses all exception messages to be printed.
‘01 – Print, do not run’
After the Government Registration is audited, print all registrations, do not run RPYEU. This is used when all government registration set up needs to be verified prior to the RPYEU run. This option allows exception messages to be printed.
‘02 – Print and Run’
After the Government Registration is audited, print all registrations, continue to run RPYEU. This should be the default so all government registration set up can be verified and RPYEU run. This option allows exception messages to be printed.
‘03 – Excp and Run’
After the Government Registration is audited, do not print registrations, continue to run RPYEU. This option allows exception messages to be printed.

RPYEU Exception Messages#

Negative (credit) amounts are never allowed for W2 reporting and therefore if negative amounts are encountered, an exception message is printed, the negative amount must be resolved and the report re-run.

The following set up exception messages are highlighted if the ‘Set Up Exceptions’ are selected to be printed:

IMUFUser Field: W2 STATE MEDIA FILING is not set up for P2K_CM_GOVT_REGISTRATIONS
IMUFUser Field: W2 TAX TYPE CODE is not set up for P2K_CM_GOVT_REGISTRATIONS
IMUFUser Field: W2 TAXING ENTITY is not set up for P2K_CM_GOVT_REGISTRATIONS
IDGVFederal Registration is not set up for Entity: entity name
IDGRW2 EMP TYPE is not set up for Entity: entity code Unit: unit code Group: group code Effective date
IDGVState Registration is not set up for State: State name
IDGV VariablesState: State name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGVLocal Registration is not set up for County Tax Jurisdiction: County name
IDGV VariablesCounty: county name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGVLocal Registration is not set up for City Tax Jurisdiction: City name
IDGV VariablesCity: city name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGVSchool Registration is not set up for School: School name
Warning:
IDFDV Identifier Name is not set up
IDFDV Identifier Name contains CONSTANT

The following exception messages are always printed for an employee:

Empl nnn
Invalid SSN: ssn, SSN must be 11 positions, position 4 and 7 must be a hyphen (-)

The SSN number must be verified and corrected, otherwise W2 form and Magnetic media filing will be incorrect for the employee
Empl nnn
Term date CCYYMMDD is prior to reporting year CCYY

This is a warning to indicate the employee has been terminated in prior years and has YTD information for this calendar year
Empl nnn
Box 3 999999.99 + Box 7 999999.99 = 999999.99 exceeds Annual Max Wage Base 999999.99

Either Box 3 or Box 7 set up must be corrected, the system does not adjust this number because it does not know if Box 3 or 7 is correct. If this situation is not corrected, the W2 will be rejected because the government does not allow these wage base to exceed the annual maximum.
Empl nnn
Employee has no Federal Information for Employment Type R, employee is bypassed
Empl nnn
Identifier Amt 999999.99-, negative amount not allowed, amount change to 0.00

This situation must be reviewed and the negative amount corrected, otherwise the system reports zero for this field.
Empl nnn
Identifier Amt 999999.9999 exceeds 2 decimals, amount change to 999999.99

This situation may cause a rounding error and should be reviewed in order to find out why the amount exceeds 2 decimals and corrected if necessary.
Empl nnn
Identifier Amt 999999999.99 exceeds 11 digits, check printed Form and Govt File size

The system highlights the amount that exceeds 11 digits, the printing of W2 for this field and the government file size to report this amount should be reviewed.
Empl nnn
Error: RS record posn 999 length = nn only, Field size exceeded for Amt 99999999.99

This Error message is issued when the Length of the Field Size available on the magnetic media file is not large enough to hold the amount. The field size is always checked for each numeric field prior to writing the amount into the file

This situation must be corrected because Oracle will report ‘#######’ in the field and the government will reject this file. The ‘#######’ is not corrected to report zero in the file because this will result in incorrect reporting for the W2 between the W2 form print and the W2 file.

The printing of the W2 will probably be large enough to print the field size while the magnetic media reporting could not report this large amount.

An investigation must be made to see if incorrect data is the cause of the problem, or Support must be contacted.

RPYEU Summary Report Level#

There are five levels of reporting for RPYEU Summary Report: Each level of print can be suppressed by selecting the options from the RPYEU run. However, the Federal level grand total report is always printed to capture all statistics of the RPYEU run.

The Federal level print is reported and sorted by employee and has all levels of details for an employee The State, County, City and School District levels are reported and sorted by State, County, City and School District.

The printing of ‘Set Up Exceptions’ may be suppressed for IDFDV, IDGV, etc. However, the employee level of exception are always printed, as error or warning situations are encountered for each employee.

RPYEU Sort Level#

There are three prompts to allow sorting of employees in RPYEU for distribution of W2 Form purposes:

1. Sort Level By
The lexicon X_W2_SORT_LEVEL is used for this prompt.
The department is the prime assignment details’ department that is effective as of the user specified ‘As of date’
A special ‘W2 Destination’ may be defined at the department level or employee level for W2 distribution purpose.
‘Provide Sort Level Totals’ may also be specified if a ‘Sort Level By’ level has been specified

2. Sort by Active/Inactive
This prompt is useful for sorting Terminated employees from Active employees in order that the W2 forms for terminated employees can be mailed.
The lexicon X_W2_SORT_ACTIVE is used for this prompt.
If 00 is selected, the terminated employees will not be sorted before active employees
If 01 is selected, all terminated employees will be sorted before the sort Level from the previous prompt.
For example:
If Department A has 2 terminated employees (A1, A2), 3 active employees (A3, A4, A5)
If Department B has 2 terminated employees (B1, B3), 3 active employees (B3, B4, B5) RPYEU will show in this order
Department AStatus: InactiveEmployee A1
Employee A2
Department BStatus: InactiveEmployee B1
Employee B2
Department AStatus: ActiveEmployee A3
Employee A4
Employee A5
Department BStatus: ActiveEmployee B3
Employee B4
Employee B5
All Inactive employees are grouped together by Department (Sort Level) and then followed by all Active employees.

If 02 is selected, all terminated employees will be sorted After the Sort Level from the previous prompt.
RPYEU will show in this order:
Department AStatus: InactiveEmployee A1
Employee A2
Status: ActiveEmployee A3
Employee A4
Employee A5
Department BStatus: InactiveEmployee B1
Employee B2
Status: ActiveEmployee B3
Employee B4
Employee B5
Inactive employees are grouped together within each department (Sort Level) and then followed Active employees of the same department.

3. Sort Employees By
The lexicon X_W2_SORT_PERSON is used for this prompt.
This prompt is sorted within the ‘Sort Level By’ and ‘Sort by Active / Inactive’ prompt

RPYEU Combined Employment Type#

The EFW2 media file code RE Employer record requires to report one of the following types of employment:

The Employment Code is retrieved from IDGR ‘W2 Employment Type’ or employee’s IPRLU FICA and Medicare method.

W2 Form Control Number Print#

On W2 Form 2-on-1-page Box d, the Control Number may be printed on the form for reference or distribution purpose, 9e.g. Person Code). The following identifiers may be set up on IDFDV:

Seq 2800 W2-CONTROL-PRT Print Control Number on Form Constant

Seq 2810 W2-CONTROL-NUM Control Number on Form Data Base Column




RPREGT – Pay Totals Register#

RPREGT – Selection Criteria#

For auditing purpose between RPREGT and RPYEU, the following should be selected when RPREGT is run:
Provide Totals By
Fed Regist Number



RPYEU – US Year End Summary Report#

RPYEU – Selection Criteria – Annual Reporting#

Report Criteria Tab
Report ParametersDescription
Annual Form CodeMandatory
HL$US-W2-2012
NOTE: always use the most current year form code ‘HL$US-W2-2011’
Enter the most current year’s Form Code because RPYEU is programmed with identifiers from the most current year information. Prior year’s Form Code should not be used because prior year’s identifiers may be obsolete.
For 2011-2012 reporting, Form Code from current year ‘HL$US-W2-2012’ contains the STORE OPTION field to store the Employer Addresses, Employee Addresses and Amounts in the Government Remittance Tables to be viewed on IPGR/IPGH
Quarterly Form CodeBlank for Annual reporting
Govt Interface FormatBlank for Annual reporting
Period TypeEnter ‘Year’ for Annual reporting
Period End DateEnter the Year Ending Date
As of DateThis date is used to retrieve employee information such as name, address, etc.
Combine Employment TypeCheck this toggle to combine ‘Regular’, ‘Agriculture’ employment, etc.
Combine Fed RegistCheck this toggle to combine all selected ‘Federal Regist’ for State/Local reporting.
Do not check this toggle when generating the Federal File
When this toggle is checked, RPYEU will not store the Federal Level amounts on IPGH because the Federal Registration Number are combined and will not be linked to a specific Federal Registration Number.
Media FormatEnter ‘Federal File Format’ for SSA reporting
Directory NameEnter a valid directory name
Media File NameEnter a file name for govt magnetic media file
Create Data DumpOptional toggle
If checked, RPYEU will generate data dump files with .csv extension for Federal, State, Local, School information. The data dump file can be opened with Excel spreadsheet for debugging and balancing purposes.
Trace LevelShould always run with Exception only unless for tracing
Regist/Set Up AuditCan select to audit Govt Registration set up and continue processing, etc.
Print and Run lexicon available.
User CommentEnter any comment to be printed on RPYEU report

Report FiltersDescription
EntityOptional
Enter one or more Entities
Federal Regist SetOptional
Enter only if you want to select by different ‘Federal Regist Set’. Otherwise, do not select Federal Regist Set if run for all employees.
Federal Regist NumberOptional
Enter one or more Federal Registration Number
People ListOptional
Specify if a 'People List' is to be used
PersonOptional
Enter one or more Person Codes
Select StateOptional
Do not enter any state when generating the Federal File for W2.
If a state is entered, RPYEU automatically switches to report by state.
State Regist SetOptional
Enter one or more State Registration Sets
State Regist NumberOptional
Enter one or more State Registration Numbers
Enter State Regist Set and State Regist Number only when running for one state.
Local Regist SetOptional
Enter one or more Local Registration Sets
Local Regist NumberOptional
Enter one or more Local Registration Numbers
Enter Local Regist Set and Local Regist Number only when running for one Local
Select CountyOptional
Enter one or more Counties
If a County is entered, RPYEU may switch to report by this County
Select CityOptional
Enter one or more Cities
If a City is entered, RPYEU may switch to report by this City
Select SchoolOptional
Enter one or more Schools
If School list are entered, RPYEU reports for these schools only

Report Run Options Tab
For Annual reporting, RPYEU generates .xml file for RPW2 to print W2 Forms and generates Federal media file for SSA government.

Report OptionsDescription
Sort by LevelEnter ‘Sort by Level’ if necessary
Sort by Active/InactiveThis prompt is used to separate Active and Inactive employees for distribution purpose
Sort People byEnter ‘Sort People by’ if necessary
Provide Sort Level TotalsOptional, if the toggle is ON, the total is generated for ‘Sort by Level’
Federal Level PrintEnter‘Federal Level Print’ to show the amount detail for Federal level
State Level PrintEnter ‘State Level Print’ to show the amount detail for State level
SUI Level PrintEnter ‘SUI Level Print’ to show the amount detail for SUI level
Local Level PrintEnter ‘Local Level Print’ to show the amount detail for County and City level
School Level PrintEnter ‘School Level Print’ to show the amount detail for School level

RPYEU – Selection Criteria – Quarterly Reporting#

Report ParametersDescription
Annual Form CodeMandatory
HL$US-W2-2012, use most current year Form Code
Quarterly Form CodeOptional
If not specified, it defaults to the Annual Form Code with EFW2 format.
If the State is using the format such as the ICESA, TIB-4 and special format for quarterly reporting, enter ‘HL$US-QTR-2012.
‘HL$US-QTR-2012’ may not be updated after 2012 because this format code is only used for prior year format ICESA and TIB-4, most states are converted to EFW2
Govt Interface FormatOptional
Some states require specific government XML file format that is defined on IDIF, e.g. Florida State format HL$US-QTR-FL2008
Please refer to the State document that indicates if this parameter should be used
Period TypeEnter ‘Quarter’ for Quarterly reporting
Period End DateEnter the Quarter Ending Date
As of DateThis date is used to retrieve employee information such as Name and address etc
Combine Employment TypeCheck this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
Combine Fed RegistCheck this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
Media FormatEnter ‘State File Format’ or ‘SUI File Format’ for State reporting
For ‘SUI File Format’, the IDGV ‘SUI Registration’ number is used.

Report FiltersDescription
Federal Regist SetOptional
Enter only if you want to select by different ‘Federal Regist Set’
Federal Regist NumberOptional
Enter only if you want to select by different Federal Registration Number
Select StateMandatory for Quarterly State Filing, if State is not entered, then it’s a Federal run
State Regist SetOptional
Enter only if you want to select by different ‘State Regist Set’
State Regist NumberOptional
Enter one or more State Registration Numbers
Enter State Regist Set and State Regist Number only when running for one state

Please enter other prompts accordingly.

RPYEU – Quarterly Form Code Set Up#

RPYEU – Sample Run#




IPGR – Government Reporting Screen#

IPGR – GVT Run tab#

IPGR – Header Tab#




IPGH – Employee Government Reporting Screen#

IPGH#

IPGH – Amount tab#




UPGRUNDO – Undo GVT Run#

UPGRUNDO – Selection Criteria#

GVT Run Number
Mandatory, at least one GVT Run Number must be entered
A list of GVT Run Numbers generated by RPYEU for undo can be selected.
Person Code
Optional, Enter one or more Person Codes
The selected Person codes within the GVT Run Numbers are processed.
Trace Level
"Exception Only" should always be run, unless for tracing.
Trial
Optional toggle allows for review of the report for verification prior to undo.
In non-trial mode, UPGRUNO removes GVT Headers and GVT Run for the qualified GVT Run.

UPGRUNO allows the GVT Run number to be undone by employees. This procedure should be used to undo erroneous GVT Run due to set up issues or to remove any archived GVT information that are not needed.


RPW2 – W2 Form Print#

RPW2 – W2 Form Print Selection Criteria#

For Oracle version RPW2, run RPW2 must be run and the report sent to PDF file instead of to the Previewer. RPW2 aligned the W2 government forms in PDF format, allowing the user to adjust the parameters for ‘Top Margin’ and the ‘Between Form Space’ when generating the PDF file. Once the PDF file is generated, the page set up does not need to be adjusted when printing.

Report Parameters - (For both Oracle and Windward RPW2)

Report ParametersDescription
EE/ER CopySpecifies if the Employee Copy or Employer Copy of W2 are to be printed

From the X_W2_COPY lexicon.

01 – Employer Copy
On one page, print multiple Employees W2 info
For ‘2 on 1 Page’, print two employees on one page
For ‘4 on 1 Page’, print four employees on one page

02 – Employee Copy - on one page, print one Employee W2 info
For ‘2 on 1 Page’, print one employee twice
For ‘4 on 1 Page’, print one employee four times
Show FormSpecifies which W2 Form Copy image is to be shown on the background
This option is for ‘2 On 1 Page’ only, there is no form image for ‘4 On 1 Page’ from the government
From the X_W2_FORM_COPY lexicon

00 – Not Specified - do not show W2 Form image
This option is used to print W2 Forms on the pre-printed W2 Forms

01 – Copy A, SSA copy - This Copy A option is for viewing purpose only
Copy A should not be sent to SSA with this option. Copy A should be printed on the pre-printed Copy A that are machine-readable

02 – Copy 1, State,Local copy

03 – Copy B, EE Federal copy

04 – Copy C, EE Record copy

05 – Copy 2, EE State,Local copy

06 – Copy D, ER copy

20 – Copy B + C (1 Pg)- Show Copy B and Copy C on one page

21 – Copy C + 2 (1 Pg)- Show Copy C and Copy 2 on one page

22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one page follow by Copy 2 and Copy 2 on the next page


For Windward RPW2
Only ‘2-on-1-Page’ format is supported, the '4-on-1-Page' format is not available
Only option ‘01 – Copy A, SSA copy’ is supported, the other options are not available
Employment TypeOptional
A specific employment type may be chosen to print, e.g. Agriculture employees
StateOptional
If used, only one state can be entered
This prompt should not be entered when the EMPLOYEE copy is being printed
The employee MUST have all the states printed on their W2 forms.
When the EMPLOYER copy is being printed, there is an option to print by state so the paper W2 copy can be filed to the state. If the filing W2 is in magnetic media format, then the W2 forms should not be printed by state.
Reissued/CorrectedOptional
If an employee has lost their W2 Forms and have requested a replacement copy, RPW2 should be run with the ‘Person Code’ specified and the word ‘REISSUED’ or ‘CORRECTED’ entered for this prompt. RPW2 will then print the W2 Form with the exact wording ‘REISSUED’ or ‘CORRECTED’ as entered on the W2 form.
Exception Levelshould always be run with 'Exception Only' unless for tracing
Test Form Set UpOptional
All users should test their printer with this ‘Form Set Up’ toggle to find out the correct Page Set Up for ‘Top Margin Adjustment’ and ‘Between Form Space’ adjustment prior to printing the actual W2 Forms.

Since each printer’s page set pp margin varies differently, each time the W2 forms are printed on a different printer, the Printer set up test should be run.
User CommentEnter any comment to be printed on RPW2 report parameter page

Report Parameters (* Oracle Report Only)

Report ParametersDescription
Directory NameMandatory
For Oracle version RPW2, enter a valid directory name
Should be the same Directory Name from the RPYEU run
XML File NameMandatory for Oracle version RPW2
Enter the xml file that is generated from RPYEU with file extension .xm
Print W2 FormsSpecifies the W2 Format to be printed:
From X_W2_PRINT lexicon

01 – 2 On 1 Page - ‘2 On 1 page’ W2 format is used

02 – 4 Corner Form - ‘4 Corners Form’ W2 format is used

03 – 4 Corner, Addr. Back - ‘4 Corners Form’ W2 format is used with Address printed on the back of form
The printer must be set to to Duplex mode when printing

04 – 4 On 1 Page (Top-bottom) - ‘4 On 1 Page’ W2 Top to Bottom format is used

EE instruction on back - when the ‘Show Form (2 on 1 pg)’ parameter is selected to print on the employee’s copy, (i.e. Copy B, C, 2), the associated employee instructions can also be printed on the back of these W2 Forms.

Note that for each employee copy (i.e. Copy B, C, 2), the EE Instructions are different.

In order to print a complete set of all Employee’s W2 Copies and Instructions, select:
22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one Page followed by Copy 2 and Copy 2 on the next page
Adjust Top MarginOptional

Specifies the Top Margin Adjustment for the printing of the form

Default to NULL or ‘00 – 0 line’ adjustment to begin testing

After the PDF file is generated, print one page on blank paper, align the paper with the pre-printed form and check if the alignment fits into the box.

If adjustment is needed, then re-run RPW2 by entering the Top Margin adjustment

From X_TOP_MARGIN_ADJ lexicon
00 – 0 line
11 – Up 1/5 line
12 – Up 2/5 line
13 – Up 3/5 line
21 – Down 1/5 line
22 – Down 2/5 line
23 – Down 3/5 line
Between Form SpaceOptional

Specifies the space increment between 2 forms on the same page

Default to NULL or ‘0 – 0 line space’ to begin testing

After the PDF file is generated, print one page on blank paper, align the paper with the pre-printed form and check if the alignment fits between 2 forms

If adjustment is needed, then re-run RPW2 by entering the ‘Between Form Space’

From X_BTWN_FORM_SPACE lexicon
0 – 0 line space
1 – 1/5 line space
2 – 2/5 line space
3 – 3/5 line space
4 – 4/5 line space
5 – 1 line space
Show FrameWhen testing the margin set up or to debug a Print Format problem, this toggle may be used to show the line border of the internal frames.

Report Filters (For Oracle and Windward RPW2)

GVT Run (WW only)If running Oracle version of RPW2, this GVT Run parameter is not used

For Windward version of RPW2, one GVT Run number MUST be entered.
Person CodeOptional
Enter one or more Person Codes
NOTE for Oracle RPW2: If the combination of ‘Top Margin Adjustment’ and ‘Between Form Space’ pushes the form to go over to the next page, the alignment should be checked with the actual pre-printed form and RPW2 re-run with different ‘Top Margin’ and ‘Between Form Space’.

When running RPW2 for pre-printed forms, please do not toggle the ‘Show W2 Form’, ‘Show Frame’ parameters.

RPW2 Example:

Show Form (2 on 1 Pg)Copy B + C (1 Pg)
Show Frame (Test Only)Yes

For 'Top Margin' adjustment, on the top form, the darker red line above the top form is between several green lines, in the center. It can be adjusted up or down from the ‘Adjust Top Margin’ parameter.

For ‘Between Form Space’, the blue line in the middle is the bottom of the Top form. The space increment can be increased for the Bottom form from the ‘Between Form Space’ parameter.

RPW2 – Printer Set Up#

Important: When printing from the pdf file, the Page Scaling option must be set to ‘None’ to avoid re-sizing of the form on a page.

RPW2 – Form Print Processing#

- RPW2 Summary and Grand Totals are accumulated for Federal Level Box 1 to 11 only, Box 12 and 14 are not totaled

- the user should verify RPW2 Box 1 to 11 totals to balance to RPYEU Box 1 to 11

- for Box 12 ‘Code Information’ and Box 14 ‘Other Information’, since the printing on W2 Forms are free format, RPW2 will not total these boxes, RPYEU Summary Report contains the totals for these boxes for user reference

- RPW2 accumulates the Summary Totals and Grand Totals for all States and Locals regardless if the tax is from WORK or HOME tax jurisdiction and regardless of which States and Locals the taxes are in

- RPW2 does not accumulate the State and Local tax totals by each State and each Local, the user should use the RPYEU Summary report to obtain the totals by each State and Local

- if RPW2 cannot select any information from the xml file to print, the user must run RMEX with the RPW2 mex id to review the errors or exception messages to locate the problem, usually the problem is because of an invalid Directory or File name

- from this link http://www.irs.gov/pub/irs-pdf/fw2.pdf, there are different copies of the W2 form that needs to be distributed to the employees and send to the government: Copy A, 1, B, C, 2, D

- RPW2 provides options from Selection criteria parameter ‘Show Form (2 on 1 pg)’ to print different copies of the W2 forms and the Employee Instructions on the back

- user can select to print the W2 forms on the pre-printed W2 forms or to show Copy A, 1, B, C, 2, D of the W2 forms

- W2 Form Copy A, 1, B, C, 2, D and Instructions are taken directly from the government link above, however, it is the user’s responsibility to ensure these Employee Copies are accepted by the government as substitute of the pre-printed forms prior to distributing to the employees


W-2 Wage Form Descriptions#

W-2 Wage Form Descriptions (2011 Format – reporting in 2011)#

Users should read the following W-2 WAGE FORM DESCRIPTIONS and refer to "2010 Instructions for Forms W-2 Wages and Tax Statement" prior to setting up IDFDV screen.

Box a - Employee's social security number - derived from IDFDV screen - Field Identifier: W2-EE-SSN - suggested Field Variable: ‘EID.GOVERNMENT_CODE’

Box b - Employer's Identification Number assigned by IRS - derived from IDFDV screen, handles multiple government registrations - Field Identifier: ‘W2-ER-EIN - suggested Field Variable: ‘DGV.GOVT_REGIST_NUMBER’ Box c - Employer's name, address and ZIP code - derived from IDFDV screen - Field Identifier: W2-ER-NAME’ - suggested Field Variable: ‘DED.ENTITY_NAME’ - Field Identifier: W2-ER-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’ - Field Identifier: W2-ER-DELIV-ADDR - suggested Field Variable: blank - Field Identifier: W2-ER-CITY - suggested Field Variable: blank - Field Identifier: W2-ER-STATE - suggested Field Variable: blank - Field Identifier: W2-ER-ZIP - suggested Field Variable: blank - Field Identifier: W2-ER-ZIP-EXT - suggested Field Variable: blank

- the City State ZIP print format will be conformed with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension

For foreign country address: - Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’ - if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this country Identifier field value is changed to blank - otherwise Field Identifier: ‘W2-ER-COUNTRY’ will be retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code

- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the Country NAME or ISO Country code or leave blank to use the default - if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed - if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF - if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed

Box d - Control Number - derived from IDFDV screen Field Identifier: W2-CONTROL-PRT Specifies if the Control Number should be printed on the Form or not Null, 0 – Do not print Control Number on W2 Form 1 - Print Control Number as defined in W2-CONTROL-NUM Identifier 2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt 3 - Print W2-CONTROL-NUM Identifier and Person Code 4 - Print ‘Sort Level By’ prompt and Person Code 5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier 6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code

W2-CONTROL-NUM Control Number on Form, may contain a Data Base Column Enter your company data e.g. ‘EID.PERSON_CODE’

- if ‘W2-CONTROL-PRT’ value is specified, then the value of ‘W2-CONTROL-NUM’ is printed on W2 Form Control Number field

Box e - Employee's name (first,middle,last) - derived from IDFDV screen - Field Identifier: W2-EE-FIRST-NAME - suggested Field Variable: ‘EID.FIRST_NAME’ - Field Identifier: W2-EE-MIDDLE - suggested Field Variable: ‘EID.MIDDLE_NAME’ - Field Identifier: W2-EE-LAST-NAME - suggested Field Variable: ‘EID.LAST_NAME’ - Field Identifier: W2-EE-SUFFIX - suggested Field Variable: ‘EID.RANK’ derivation expression: Decode(~,'01','JR','02','SR',NULL)

Box f - Employee's address and ZIP code - derived from IDFDV screen - Field Identifier: W2-EE-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’ - Field Identifier: W2-EE-DELIV-ADDR - suggested Field Variable: blank - Field Identifier: W2-EE-CITY - suggested Field Variable: blank - Field Identifier: W2-EE-STATE - suggested Field Variable: blank - Field Identifier: W2-EE-ZIP - suggested Field Variable: blank - Field Identifier: W2-EE-ZIP-EXT - suggested Field Variable: blank

- the City State ZIP print format will be conformed with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension

For foreign country address: - Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’ - if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this country field value is blank - otherwise Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code

- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the country NAME or ISO code or leave blank to use the default - if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed - if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF - if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed

Box 1 - Wages, tips, other compensation - derived from IDFDV screen - Field Identifier: W2-FIT-WAGE - suggested Field Variable (Element): ‘W2-BOX-01’ - this is the taxable earnings applicable for federal income tax withheld - if users specify an element that derives the wages (i.e. Regular Earnings, O/T earnings etc), the element should contain all taxable earnings less exemptions such as 401K, 125 plans etc. - if users specify an element that from Federal Earning Pay Components after Vertex calculation, this element should contain Federal Earnings Pay Component and Federal Supplemental Earnings Pay Component Box 2 - Federal income tax withheld - derived from IDFDV screen - Field Identifier: W2-FIT-TAX - suggested Field Variable (Element): ‘W2-BOX-02’

Box 3 - Total social security wages - derived from IDFDV screen - Field Identifier: W2-SSN-WAGE - suggested Field Variable (Element): ‘W2-BOX-03’

- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up on IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.

Box 4 - Employment social security tax withheld - derived from IDFDV screen - Field Identifier: W2-SSN-TAX - suggested Field Variable (Element): ‘W2-BOX-04’

Box 5 - Medicare wages and tips - derived from IDFDV screen - Field Identifier: W2-MEDI-WAGE - suggested Field Variable (Element): ‘W2-BOX-05’

Box 6 - Medicare tax withheld - derived from IDFDV screen - Field Identifier: W2-MEDI-TAX - suggested Field Variable (Element): ‘W2-BOX-06’

Box 7 - Social security tips - derived from IDFDV screen - Field Identifier: W2-SSN-TIP - suggested Field Variable (Element): ‘W2-BOX-07’

- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up n IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.

Box 8 - Allocated tips - derived from IDFDV screen - Field Identifier: W2-ALLOC-TIP - suggested Field Variable (Element): ‘W2-BOX-08’

Box 9 - Deleted

Box 10 - Dependent care benefits - derived from IDFDV screen - Field Identifier: W2-DEP-CARE - suggested Field Variable (Element): ‘W2-BOX-10’

Box 11 - Nonqualified plans - derived from IDFDV screen - Field Identifier: W2-NQUAL - suggested Field Variable (Element): ‘W2-BOX-11’ - the value for ‘W2-NQUAL’ should include amounts for Identifier ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’ - the magnetic media file will report amount from ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’ while the W2 form will print amount from ‘W2-NQUAL’

Box 12 - Codes - derived from IDFDV screen - Field Identifier: ‘W2-CODE-A’ - Field Identifier: ‘W2-CODE-B’ - Field Identifier: ‘W2-CODE-C’ - Field Identifier: ‘W2-CODE-D’ - Field Identifier: ‘W2-CODE-E’ - Field Identifier: ‘W2-CODE-F’ - Field Identifier: ‘W2-CODE-G’ - Field Identifier: ‘W2-CODE-H’ - Field Identifier: ‘W2-CODE-J’ - Field Identifier: ‘W2-CODE-K’ - Field Identifier: ‘W2-CODE-L’ - Field Identifier: ‘W2-CODE-M’ - Field Identifier: ‘W2-CODE-N’ - Field Identifier: ‘W2-CODE-P’ - Field Identifier: ‘W2-CODE-Q’ - Field Identifier: ‘W2-CODE-R’ - Field Identifier: ‘W2-CODE-S’ - Field Identifier: ‘W2-CODE-T’ - Field Identifier: ‘W2-CODE-V’ - Field Identifier: ‘W2-CODE-W’ - Field Identifier: ‘W2-CODE-Y’ - Field Identifier: ‘W2-CODE-Z’ - Field Identifier: ‘W2-CODE-AA’ - Field Identifier: ‘W2-CODE-BB’ - Field Identifier: ‘W2-CODE-CC’ - Field Identifier: ‘W2-CODE-DD’ - Field Identifier: ‘W2-CODE-EE’

- up to 4 lines can be printed per W2 form - if more than 4 lines are required for one employee, subsequent W2 form is used - each Box 12 entry is associated with a W2 code which will be printed on Box 12 along with the associated amount - for explanation of each code's usage, please refer to Instructions for Form W-2 Box 12 - when the value of the IDFDV Field Variable is not zero, the W2 code and the value of content is printed

Box 13 - Check boxes that apply: - Statutory employee - IDFDV Field Identifier: ‘W2-STAT-EE’ - if the amount is non zero, then this box is checked

- Retirement plan - IDFDV Field Identifier: ‘W2-RETIRE-PLAN’ - if the amount is non zero, then this box is checked

- Third-party sick pay - IDFDV Field Identifier: ‘W2-3PARTY-SICK’ - if the amount is non zero, then this box is checked

Box 14 - Other

- derived from IDFDV screen - Field Identifier: ‘W2-OTHER-01’, ‘W2-OTHER-02’, …. up to ‘W2-OTHER-20’

- Field Identifier: ‘W2-SCHL-WAGE’, for school district taxable wages - Field Identifier: ‘W2-SCHL-TAX’, for school district tax

- for W2 form ‘2 on 1 page’ format, up to 4 lines (2 Box 14 items) can be printed - for W2 form ‘4 Corner Form’ format, up to 2 lines (2 Box 14 items) can be printed - if more than 2 Box 14 items are required for one employee, subsequent W2 form is used - each Box 14 entry is associated with a W2 description which will be printed on Box 14 along with the associated amount - example of W2 descriptions are : "UNDUE","MV EXP","HLT INS", "EDUC" etc - for explanation of each description usage, please refer to Instructions for Form W-2 Box 14 - when the value of the content field is not zero, the W2 Description and the value of content is printed

- if school district tax has been withheld for an employee, the school district tax information will be printed in Box 14 prior to printing other Box 14 information - Each school district will be printed on one separate W2 Form Box 14 as follows: e.g. SCHL 02307 WAGE 1484.00 SCHL 02307 TAX 14.84

- the IDFDV ‘W2-SCHL-TAX’ entry should specify an element that contains all the school district tax pay components e.g. PC 6923 CITY Home School Tax, PC 6903 CITY Work School Tax, PC 6823 CNTY Home School Tax, PC 6803 CNTY Work School Tax

- the IDFDV ‘W2-SCHL-WAGE’ entry should specify an element that contains all the school district wages pay components e.g. PC 6907 CITY Work School Earns, PC 6827 CNTY Home School Earns PC 6807 CNTY Work School Earns, PC 6927 CITY Home School Earns

Box 15 - Name of state - IDFDV Field Identifier: ‘W2-STATE-CODE’ - IDFDV Field Variable: ‘DSP.STATE_PROVINCE_CODE’ - RPW2 program will print the proper STATE_PROVINCE_CODE according to YTD State information

- Employer's state I.D. Number - IDFDV Field Identifier: ‘W2-STATE-REGIST’ - IDFDV Field Variable: ‘DGV.GOVT_REGIST_NUMBER’ - RPW2 program will print the GOVT_REGIST_NUMBER of the proper STATE_PROVINCE_CODE according to YTD State information - the IDGV screen must have an entry exist with ‘State Registration’ for the State to be reported

Box 16 - State wages, tips etc - IDFDV Field Identifier: ‘W2-ST-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-16-H’ - IDFDV Field Identifier: ‘W2-ST-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-16-W’

- this is the taxable earnings that are applicable for state income tax withheld - if users specify an element that derives the State wages (i.e. Regular Earnings, O/T earnings etc), the element should contain all taxable earnings less exemptions such as 401K, 125 plans etc. - if users specify an element from State Earning Pay Components after Vertex calculation, this element should contain the State Earnings Pay Component and State Supplemental Earnings Pay Component (if these pay components are defined)

- Vertex State tax calculation differentiates state wages by work state wage and residence state wage - W2 only requires to report state wages by the State regardless if it is from work or residence state - the system will retrieve the proper work state wages according to the YTD WORK GEO code and the proper residence state wages according to the YTD RES GEO code and report these as state wages only

- IDFDV Field Identifier ‘W2-ST-WAGE-WORK’ is used to set up the WORK State wage information - this should include all State Wages pay components that are applicable to Work State Tax calculation - e.g. PC 6301 Work State Earnings, PC 6302 Work State Supplemental Earnings

- IDFDV Field Identifier ‘W2-ST-WAGE-HOME’ is used to set up the Residence State wage information - this should include all State Wages pay components that are applicable to Residence State Tax calculation - e.g. PC 6401 Home State Earnings, PC 6402 Home State Supplemental Earnings

- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-WAGE-HOME’ entry does not need to be set up, thus this ‘W2-ST-WAGE-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State

Box 17 - State income tax - IDFDV Field Identifier: ‘W2-ST-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-17-H’ - IDFDV Field Identifier: ‘W2-ST-TAX-WORK’ - suggested Field Variable (Element): ‘W2-BOX-17-W’

- if users specify an element from State Tax Pay Components after Vertex calculation, this element should contain the State Tax Pay Component, State Supplemental Tax Pay Component and State Additional Tax Pay Component (if these pay components are defined)

- Vertex State tax calculation differentiates state taxes withheld by work state tax and residence state tax - W2 only requires to report state tax by State regardless if it is from work or residence state - the system will retrieve the proper work state tax according to the YTD WORK GEO code and the proper residence state tax according to the YTD RES GEO code and report these as state tax only

- IDFDV Field Identifier ‘W2-ST-TAX-WORK’ is used to set up the WORK State tax information - this should include all State tax pay components that are applicable to Work State Tax calculation - e.g. PC 6311 Work State Tax, PC 6312 Work State Supplemental Tax, 6313 Work State Additional Tax

- IDFDV Field Identifier ‘W2-ST-TAX-HOME’ is used to set up the Residence State tax information - this should include all State Tax pay components that are applicable to Residence State Tax calculation - e.g. PC 6411 Home State Tax, PC 6412 Home State Supplemental Tax, 6413 Home State Additional Tax

- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-TAX-HOME’ entry does not need to be set up, thus this ‘W2-ST-TAX-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State

Box 18 - Local wages, tips etc - IDFDV Field Identifier: ‘W2-CN-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-H’ - IDFDV Field Identifier: ‘W2-CN-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-W’ - IDFDV Field Identifier: ‘W2-CI-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-H’ - IDFDV Field Identifier: ‘W2-CI-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-W’

- this is the taxable earnings applicable for County or City tax withheld - if users specify an element that derives the County or City wages (i.e. Regular Earnings, O/T earnings etc), the element should contain all taxable earnings less exemptions such as 401K, 125 plans etc.

- Vertex County or City tax calculation differentiates wages by work local wage and residence local wage - W2 only requires to report local wages by Local name regardless if it is from work or residence local - the system will retrieve the proper work local wages according to the YTD WORK GEO code and the proper residence local wages according to the YTD RES GEO code and report these as local wages only

- IDFDV Field Identifier ‘W2-CI-WAGE-WORK’ is used to set up the WORK City wage information - this should include all City Wages pay components that are applicable to Work City Tax calculation - e.g. PC 6905 Work City Earnings, PC 6906 Work City Supplemental Earnings

- IDFDV Field Identifier ‘W2-CN-WAGE-WORK’ is used to set up the WORK County wage information - this should include all County Wages pay components that are applicable to Work County Tax calculation - e.g. PC 6805 Work County Earnings, PC 6806 Work County Supplemental Earnings

- IDFDV Field Identifier ‘W2-CI-WAGE-HOME’ is used to set up the Residence City wage information - this should include all City Wages pay components that are applicable to Residence City Tax calculation - e.g. PC 6925 Residence City Earnings, PC 6926 Residence City Supplemental Earnings

- IDFDV Field Identifier ‘W2-CN-WAGE-HOME’ is used to set up the Residence County wage information - this should include all County Wages pay components that are applicable to Residence County Tax calculation - e.g. PC 6825 Residence County Earnings, PC 6826 Residence County Supplemental Earnings

Box 19 - Local income tax - IDFDV Field Identifier: ‘W2-CN-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-H’ - IDFDV Field Identifier: ‘W2-CN-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-W’ - IDFDV Field Identifier: ‘W2-CI-TAX -HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-H’ - IDFDV Field Identifier: ‘W2-CI-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-W’

- Vertex County or City tax calculation differentiates City/County tax by work local tax and residence local tax - W2 only requires to report local income tax by Local name regardless if it is from work or residence local - the system will retrieve the proper work local tax according to the YTD WORK GEO code and the proper residence local tax according to the YTD RES GEO code and report these as local income tax only

- IDFDV Field Identifier ‘W2-CI-TAX -WORK’ is used to set up the WORK City tax information - this should include all City tax pay components that are applicable to Work City Tax calculation - e.g. PC 6901 Work City Tax, PC 6902 Work City Supplemental Tax

- IDFDV Field Identifier ‘W2-CN-TAX -WORK’ is used to set up the WORK County tax information - this should include all County tax pay components that are applicable to Work County Tax calculation - e.g. PC 6801 Work County Tax, PC 6802 Work County Supplemental Tax

- IDFDV Field Identifier ‘W2-CI-TAX -HOME’ is used to set up the Residence City tax information - this should include all City tax pay components that are applicable to Residence City Tax calculation - e.g. PC 6921 Residence City Tax, PC 6922 Residence City Supplemental Tax

- IDFDV Field Identifier ‘W2-CN-TAX -HOME’ is used to set up the Residence County tax information - this should include all County tax pay components that are applicable to Residence County Tax calculation - e.g. PC 6821 Residence County Tax, PC 6822 Residence County Supplemental Tax

For California SDI reporting, there are 2 options to print SDI on W2 Forms:

(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’

(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount

Box 20 - Locality Name - IDFDV Field Identifier: ‘W2-CNTY-NAME’ - IDFDV Field Variable: ‘DCN.COUNTY_NAME’ - IDFDV Field Identifier: ‘W2-CITY-NAME’ - IDFDV Field Variable: ‘DTX.JURISDICTION_NAME’

- RPW2 program will print the proper DTX.JURISDICTION_NAME according to YTD GEO information - if County tax is reported, the County name is retrieved from the IDCN County screen with GEO code = ‘xx-xxx-0000’ - e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, then use County Code ‘15-097-0000’ to retrieve the County name of ‘Marion’ for reporting - if City tax is reported, the City name is retrieved from the IDTX Tax Jurisdiction screen with GEO code - an entry must also exist on IDGV screen with ‘Local Registration’ for a County or City in order for the County or City tax to be reported


Government Media Reporting#

Submitting W-2 Copy A to SSA (EFW2 Format)#

The EFW2 Format is used for 2011 Annual and Quarterly Reporting.

Record Name: Code RA – Submitter Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RA"

3-11 - Submitter’s Employer ID number (EIN) - Numeric only - Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’

12-19 - User Identification (User ID) - Derived from IDFDV screen, Field Identifier: ‘SUB-USER-ID’

20-23 - Software Vendor Code - Derived from IDFDV Seq# 1035 Field Identifier: ‘SUB-VENDOR’ - this optional Vendor Code will not be provided, if the users do not have a Vendor Code, leave this blank

24-28 - blank

29 - Resub Indicator - Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-IND’

30-35 - Resub WFID - Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-WFID’

36-37 - Software Code - Derived from IDFDV screen, Field Identifier: ‘SUB-SOFTWARE’

38-94 - Company Name - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-NAME’

95-116 - Location Address - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-LOCN’

117-138 - Delivery Address - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-DELIV’

139-160 - Company City - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-CITY’

161-162 - Company State Abbreviation - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-STATE’

163-167 - Company ZIP code - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP’

168-171 - Company ZIP code extension - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP-EXT’

172-176 - blank

177-199 - Company Foreign State/Province - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-STATE’

200-214 - Company Foreign Postal Code - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-POST’

215-216 - Company Country Code - Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-COUNTRY’

217-273 - Submitter Name - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-NAME’

274-295 - Submitter Location Address - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-LOCN’

296-317 - Submitter Delivery Address - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-DELIV’

318-339 - Submitter City - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-CITY’

340-341 - Submitter State Abbreviation - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-STATE’

342-346 - Submitter ZIP code - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP’

347-350 - Submitter ZIP code extension - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP-EXT’

351-355 - blank

356-378 - Submitter Foreign State/Province - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-STATE’

379-393 - Submitter Foreign Postal Code - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-POST’

394-395 - Submitter Country Code - Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-COUNTRY’

396-422 - Contact Name - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-NAME’

423-437 - Contact Phone Number - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL’

438-442 - Contact Phone Extension - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL-EXT’

443-445 - blank

446-485 - Contact E-mail - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’

486-488 - blank

489-498 - Contact FAX - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’

499-499 - Preferred Method of Problem Notification Code - Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-METH’

500-500 - Preparer Code - Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’

501-512 - blank

Record Name: Code RE – Employer Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RE"

3-6 - Tax year CCYY - From user specified FROM-TO period converted to CCYY

7 - Agent Indicator Code - Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’

8-16 -Employer/Agent EIN - System derived the applicable Federal reporting EIN, from IDGV or IDGR - If on RPYEU selection screen the ‘Combined Fed Regist#’ toggle is ‘checked’, then this Employer/Agent EIN is retrieved from IDFDV screen, Field Identifier: ‘W2-ER-EIN’, otherwise the EIN is derived for every Code RE record

17-25 - Agent for EIN - Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’

26 - Terminating Business Indicator - Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’

27-30 - Establishment Number - Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’

31-39 - Other EIN - Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’

40-96 - Employer Name - Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’

97-118 - Employer Location Address - Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’

119-140 - Employer Delivery Address - Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’

141-162 - Employer City - Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’

163-164 - Employer State Abbreviation - Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’

165-169 - Employer ZIP Code - Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’

170-173 - Employer ZIP Code Extension - Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’ 174-174 - Kind of Employer - Derived from IDFDV screen, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)

175-178 - Blanks

179-201 - Employer Foreign State/Province - Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’

202-216 - Employer Foreign Postal Code - Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’

217-218 - Employer Country Code - Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’ - if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this field is blank - otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-ER-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code

- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank - if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed - if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed - if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed

219 - Employment Code - from IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method - If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting - otherwise the W2 Type of employment is derived from IDGR screen Registration tab ‘W2 Emp Type’

- a set of code RE, RW/RO/RS, RT/RU records will be generated for different Type of employment

220 - Tax Jurisdiction Code - Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’

221 - Third-Party Sick Pay Indicator - Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’

222-512 - blank

Record Name: Code RW – Employee Wage Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RW"

3-11 - Social Security Number - Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’ - if an invalid SSN is encountered, this field is entered with zeroes.

12-26 - Employee First Name - Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’

27-41 - Employee Middle Name or Initial - Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’

42-61 - Employee Last Name - Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’

62-65 - Employee Suffix - Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’

66-87 - Employee Location Address - Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’

88-109 - Employee Delivery Address - Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’

110-131 - Employee City - Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’

132-133 - Employee State Abbreviation - Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’

134-138 - Employee ZIP Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’

139-142 - Employee ZIP Code Extension - Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’

143-147 - blank

148-170 - Employee Foreign State/Province - Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’

171-185 - Employee Foreign Postal Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’

186-187 - Employee Country Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’ - if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this field is blank - otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code

- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank - if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed - if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed - if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed

188-198 - Wages, Tips and other compensation - Derived from IDFDV screen, Field Identifier: ‘W2-FIT-WAGE’

199-209 - Federal Income Tax Withheld - Derived from IDFDV screen, Field Identifier: ‘W2-FIT-TAX’

210-220 - Social Security Wages - Derived from IDFDV screen, Field Identifier: ‘W2-SSN-WAGE’

221-231 - Social Security Tax Withheld - Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TAX’

232-242 - Medicare Wages & Tips - Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-WAGE’

243-253 - Medicare Tax Withheld - Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-TAX’

254-264 - Social Security Tips - Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TIP’

265-275 - Advanced Earned Income Credit - Derived from IDFDV screen, Field Identifier: ‘W2-EIC’

276-286 - Dependent Care Benefits - Derived from IDFDV screen, Field Identifier: ‘W2-DEP-CARE’

287-297 - Deferred Compensation contribution to Section 401(k) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-D’

298-308 - Deferred Compensation contribution to Section 403(b) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-E’

309-319 - Deferred Compensation contribution to Section 408(k)(6) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-F’

320-330 - Deferred Compensation contribution to Section 457(b) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-G’

331-341 - Deferred Compensation contribution to Section 501(c)(18)(D) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-H’

342-352 - Military Employees Basic Quarters, Subsistence and Combat Pay - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’ - This field is valid for tax years 1995-2001 only, not used

353-363 - Non-qualified Plan section 457 - Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-457’

364-374 - Employer Contributions to a Health Savings Account - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-W’

375-385 - Non-qualified Plan Not section 457 - Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-N457’

386-396 - Nontaxable Combat Pay - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’

397-407 - blank

408-418 - Employer cost of premiums for Group Term Life insurance over $50000 - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-C’

419-429 - Income from Nonstatutory Stock Options - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-V’ 430-462 - blank 463-473 - Cost of Employer-Sponsored Health Coverage - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-DD’ (seq 4250) 474-485 - blank

486 - Statutory Employee Indicator - Derived from IDFDV screen, Field Identifier: ‘W2-STAT-EE’ - if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered

487 - blank

488 - Retirement Plan Indicator - Derived from IDFDV screen, Field Identifier: ‘W2-RETIRE-PLAN’ - if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered

489 - Third-Party Sick Pay Indicator - Derived from IDFDV screen, Field Identifier: ‘W2-3PARTY-SICK’ - if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered

490-512 - blank

Record Name: Code RO – Employee Wage Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RO"

3-11 - blank

12-22 - Allocated Tips - Derived from IDFDV screen, Field Identifier: ‘W2-ALLOC-TIP’

23-33 - Uncollected Employee Tax on Tips - combined the uncollected social security tax and the uncollected medicare tax - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’

34-44 - Medical Savings Account - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’

45-55 - Simple Retirement Account - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’

56-66 - Qualified Adoption Expenses - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’

67-77 - Uncollected SSA tax on Group Ins > 50000 - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’

78-88 - Uncollected Medicare tax on Group Ins > 50000 - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’ 89-110 - blank 111-121 - Designated Roth Contribution under section 457(b) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’ (seq 4260) 122-264 - blank

Location 265 to 362
For Puerto Rico employees only
ColumnDescriptionSource
265 - blank

266-274 - Spouse’s SSN - blank

275-285 - Wages Subject to Puerto Rico Tax - stored as zeroes

286-296 - Commissions Subject to Puerto Rico Tax - stored as zeroes

297-307 - Allowances Subject to Puerto Rico Tax - stored as zeroes

308-318 - Tips Subject to Puerto Rico Tax - stored as zeroes

319-329 - Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax - stored as zeroes

330-340 - Puerto Rico Tax Withheld - stored as zeroes

341-351 - Retirement Fund Subject to Puerto Rico Tax - stored as zeroes

352-362 - blank

Location 363 to 384
For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees
ColumnDescriptionSource
363-373 - Total wages, tips and other compensation subject to Virgin Islands, … income tax - stored as zeroes

374-384 - Virgin Islands, … etc Income Tax Withheld - stored as zeroes

385-512 - blank

Record Name: Code RS – Supplemental Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RS"

3-4 - State code, appropriate FIPS postal numeric code - system Derived from the State being reported - e.g. California is code "06"

5-9 - Taxing Entity Code - if County, City or School district tax is reported, this field is derived from IDGV 'W2 TAXING ENTITY' field for the County, City or School district tax being reported

10-18 - Social Security Number - Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’ - if an invalid SSN is encountered, this field is entered with zeroes.

19-33 - Employee First Name - Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’

34-48 - Employee Middle Name or Initial - Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’

49-68 - Employee Last Name - Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’

69-72 - Employee Suffix - Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’

73-94 - Employee Location Address - Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’

95-116 - Employee Delivery Address - Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’

117-138 - Employee City - Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’

139-140 - Employee State Abbreviation - Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’

141-145 - Employee ZIP Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’

146-149 - Employee ZIP Code Extension - Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’

150-154 - blank

155-177 - Employee Foreign State/Province - Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’

178-192 - Employee Foreign Postal Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’

193-194 - Employee Country Code - Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’

Location 195 to 267
Apply to Quarterly Unemployment Reporting

If the user specified ‘Period Type’ = ‘Quarter’, then Location 195 to 267 will be filled. Please read document US_Annual_Qtrly_Reporting_XX.doc for the specific State where XX is the State Code. If the State document does not exist, please read US_Annual_Qtrly_Reporting_GEN.doc for quarterly reporting.

ColumnDescriptionSource
195-196 - Optional code - blank

197-202 - Reporting Period MMCCYY - From user specified Period End Date converted to MMCCYY for the quarter - e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’

203-213 - State Quarterly Unemployment Insurance Total Wages - Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’

- note that the IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in UPCALC and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages, therefore RPYEU is using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages

214-224 - State Quarterly Unemployment Insurance Taxable Wages - this amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government - please read document US_Annual_Qtrly_Reporting_XX.doc for detail for quarterly reporting

225-226 - Number of Weeks Worked - From system derived number of Weeks Worked for the Reporting State - the system reads all Pay Headers with pay category = ‘Regular Pay’ that are not reversed with Pay Issue Date falls within the user specified Quarter begin and end date - if the Pay Header’s Work State or Home State is the same as the reporting State, then the Pay Header Tax Weeks is accumulated

227-234 - Date First Employed MMDDCCYY - From system derived latest Employment Hired Date

235-242 - Date of Separation MMDDCCYY - From system derived latest Employment Termination Date that is greater than the Employment Hired Date

243-247 - blank

248-267 - State Employer Account Number - Derived from IDFDV screen, Field Identifier: ‘W2-STATE-REGIST’ for the reporting State - When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV screen for the SUI Registration of the State

268-273 - blank

Location 274 to 337
Apply to Income Tax Reporting

If the user specified ‘Period Type’ = ‘Quarter’ or ‘Year’, then Location 274 to 337 will be filled.

ColumnDescriptionSource
274-275 - State code, appropriate FIPS postal numeric code - system Derived from the State being reported - e.g. California is code "06"

276-286 - State Taxable Wages - Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’

287-297 - State Income Tax Withheld - Derived from IDFDV screen, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’

298-307 - Other State Data, to be defined by each State

State: California 298-302 - State data SUI Tax - Derived from IDFDV screen, Field Identifier: ‘W2-SUI-TAX-ER’

303-307 - State data SDI Tax - Derived from IDFDV screen, Field Identifier: ‘W2-SDI-TAX-EE’

308 - Tax Type Code

- this field is used to report County, City or School district tax - if the County, City or School district requires to report taxes along with the State Tax information, then the following values are used for this field: C – City Income Tax D – County Income Tax E – School District Income Tax F – Other Income Tax

- the user must set up IDGV screen for the Local or School Registration by County/City or School district for the following fields on the Variables Tab: - 'W2 STATE MEDIA FILING' - 'W2 TAX TYPE CODE' - 'W2 TAXING ENTITY'

- 'W2 STATE MEDIA FILING' indicates whether the County/City or School should report taxes with the State or not - 'W2 TAX TYPE CODE' must contain the valid Tax Type Code as defined above - 'W2 TAXING ENTITY' contains the Taxing Entity code supplied by the County/City or School government booklet

- if County, City or School district tax is reported, this field is derived from IDGV 'W2 TAX TYPE CODE' field

309-319 - Local Taxable Wages - if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-WAGE’ - if County Tax is reported, this field is derived from Identifier ‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’ - if City Tax is reported, this field is derived from : ‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’

320-330 - Local Income Tax Withheld - if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-TAX’ - if County Tax is reported, this field is derived from Identifier ‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’ - if City Tax is reported, this field is derived from : ‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’

331-337 - State Control Number (optional) - blank

338-412 - Supplemental Data 1 - blank

413-487 - Supplemental Data 2 - blank

488-512 - blank

Multiple Code RS Records:Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a state. In this case, the state wages and tax will be zero for the subsequent code RS records.

Record Name: Code RT – Total Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RT"

3-9 - Number of RW Records - Total number of code "RW" records reported since last code "RE" record

10-24 - Wages, Tips and Other Compensation - Derived from IDFDV screen, Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record

25-39 - Federal Income Tax Withheld - Derived from IDFDV screen, Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record

40-54 - Social Security Wages - Derived from IDFDV screen, Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record

55-69 - Social Security Tax Withheld - Derived from IDFDV screen, Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record

70-84 - Medicare Wages and Tips - Derived from IDFDV screen, Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record

85-99 - Medicare Tax Withheld - Derived from IDFDV screen, Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record

100-114 - Social Security Tips - Derived from IDFDV screen, Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record

115-129 - Advanced Earned Income Credit - Derived from IDFDV screen, Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record

130-144 - Dependent Care Benefits - Derived from IDFDV screen, Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record

145-159 - Deferred Compensation Contributions to Section 401(k) - Derived from IDFDV screen, Field Identifier ‘W2-CODE-D’, total of all code "RW" records since last "RE" record

160-174 - Deferred Compensation Contributions to Section 403(b) - Derived from IDFDV screen, Field Identifier ‘W2-CODE-E’, total of all code "RW" records since last "RE" record

175-189 - Deferred Compensation Contributions to Section 408(k)(6) - Derived from IDFDV screen, Field Identifier ‘W2-CODE-F’, total of all code "RW" records since last "RE" record

190-204 - Deferred Compensation Contributions to Section 457(b) - Derived from IDFDV screen, Field Identifier ‘W2-CODE-G’, total of all code "RW" records since last "RE" record

205-219 - Deferred Compensation Contributions to Section 501(c)(18)(D) - Derived from IDFDV screen, Field Identifier ‘W2-CODE-H’, total of all code "RW" records since last "RE" record

220-234 - Military Employees Basic Quarters, Subsistence and Combat pay - Derived from IDFDV screen, Field Identifier ‘W2-CODE-Q’, total of all code "RW" records since last "RE" record - This field is valid for tax years 1995-2001 only, not used

235-249 - Non-Qualified Plan Section 457 - Derived from IDFDV Identifier ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record

250-264 - Employer Contributions to a Health Savings Account - Derived from IDFDV screen, Field Identifier ‘W2-CODE-W’, total of all code "RW" records since last "RE" record

265-279 - Non-Qualified Plan Not Section 457 - Derived from IDFDV Identifier ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record

280-294 - blank 295-309 - Cost of Employer-Sponsored Health Coverage - Derived from IDFDV screen, Field Identifier ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record

310-324 - Employer Cost of Premiums for Group Term Life Insurance over $50000 - Derived from IDFDV screen, Field Identifier ‘W2-CODE-C’, total of all code "RW" records since last "RE" record

325-339 - Income Tax Withheld by Third-Party Payer - Derived from IDFDV Identifier ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record

340-354 - Income from Nonstatutory Stock options - Derived from IDFDV screen, Field Identifier ‘W2-CODE-V’, total of all code "RW" records since last "RE" record

355-369 - Deferrals Under a Section 409A Non-qualified Deferred Compensation Plan - Derived from IDFDV screen, Field Identifier ‘W2-CODE-Y’, total of all code "RW" records since last "RE" record

370-384 - Designated Roth Contributions to 401(k) plan - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-AA’, total of all code "RW" records since last "RE" record

385-399 - Designated Roth Contributions to 403(b) salary reduction agreement - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-BB’, total of all code "RW" records since last "RE" record

400-512 - blank

Record Name: Code RU – Total Record#

ColumnDescriptionSource

1-2 - Record Identifier - Constant "RU"

3-9 - Number of RO Records - Total number of code "RO" records reported since last code "RE" reocrd

10-24 - Allocated Tips - Derived from IDFDV screen, Identifier: ‘W2-ALLOC-TIP’, total of all code "RO" records since last "RE" record

25-39 - Uncollected Employee Tax on Tips - Derived from IDFDV ‘W2-CODE-A’ and ‘W2-CODE-B’, total of all code "RO" records since last "RE" record

40-54 - Medical Savings Account - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’, total of all code "RO" records since last "RE" record

55-69 - Simple Retirement - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’, total of all code "RO" records since last "RE" record

70-84 - Qualified Adoption Expenses - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’, total of all code "RO" records since last "RE" record

85-99 - Uncollected SSA tax on Group Ins > 50000 - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’, total of all code "RO" records since last "RE" record

100-114 - Uncollected Medicare tax on Group Ins > 50000 - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’, total of all code "RO" records since last "RE" record 115-144 - Blank 145-159 - Designated Roth Contribution under section 457(b) - Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’, total of all code "RO" records since last "RE" record 160-354 - Blank

355-369 - Wages Subject to Puerto Rico Tax - stored as zeroes

370-384 - Commissions Subject to Puerto Rico Tax - stored as zeroes

385-399 - Allowances Subject to Puerto Rico Tax - stored as zeroes

400-414 - Tips Subject to Puerto Rico Tax - stored as zeroes

415-429 - Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax - stored as zeroes

430-444 - Puerto Rico Tax Withheld - stored as zeroes

445-459 - Retirement Fund Subject to Puerto Rico Tax - stored as zeroes

460-474 - Total wages, tips and other compensation subject to Virgin Islands, … income tax - stored as zeroes

475-489 - Virgin Islands, … etc Income Tax Withheld - stored as zeroes

490-512 - blank

Record Name: Code RV – State Total Record#

ColumnDescriptionSource

1-2 - Record Identifier - Constant "RV"

3-512 - Supplemental Data (optional) - To be defined by each State e.g. State of Maryland uses Code RV record to report MW508 information

Record Name: Code RF – Final Record#

ColumnDescriptionSource
1-2 - Record Identifier - Constant "RF"

3-7 - blank

8-16 - Number of RW Records - Total number of code "RW" records on file

17-512 - blank


SSA ACCU Wage Software#

Validate EFW2 File Format#

The Social Security Administration has provided a software program AccuWage for users to download from SSA website to validate the EFW2 file prior to submitting to SSA.

The web link is http://www.ssa.gov/employer/accuwage/index.html#download

Please download the AccuWage software for the current year with this link. Then user should always run AccuWage software with the EFW2 file generated by RPYEU to verify and correct all potential errors prior to sending the EFW2 file to SSA.

AccuWage Error Example:


Notes#

Click to create a new notes page