Puerto Rico Annual and Quarterly Reporting#

Set Up#

This document contains abbreviated set up requirements for Puerto Rico only. Please refer to the general document (US_Annual_Qtrly_Reporting_GEN) for other setup procedures that may also be required.

IDGV - State Registration#

  • DGV Definition Tab must be set up with ‘State Registration’ for State/Province: Puerto Rico
  • IDGV Variables Tab must be set up with ‘State Registration’ for State/Province: Puerto Rico
    • 'W2 STATE MEDIA FILING'- Must be ‘02’ for Puerto Rico

State File Procedures#

  • Puerto Rico Department of Revenue accepts filing of W-2s via magnetic media using the EFW2 file format.
  • Records required for the W2 reporting are: Codes RA, RE, W, RO, RT, RU, RV and RF. There are no optional records.
  • Puerto Rico requires to file the state wages by itself, therefore the user must set up IDGV as follows:
    • for State Registration of Puerto Rico, the IDGV Variable:
      • ‘W2 STATE MEDIA FILING’
      • 02 – State requires its own File, do not include other State information in the State File

Annual W2 Wage Reporting - EFW2 File Format#

RPYEU must be run with the following report parameters and filters selected to generate the Virginia State file information:

RPYEU Report Parameters

Annual Form CodeUse standard form code, such as 'HL$US-W2PR-20YY'
Period TypeMandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
Period End DateMandatory. Defines the end date of the reporting period. Enter in DD-MMM-YYYY format
Media FormatMandatory. Set to State File Format
Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
Directory Name Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
Media File NameMandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced

RPYEU Report Filters

Select State: Puerto Rico, USA

State Media Magnetic Media Reporting - EFW2 File Format#

Record Name: Code RA – Submitter Record (Same as the Federal Code RA)#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RA - Submitter Record#

ColumnDescriptionSource
1-2Record IdentifierConstant "RA"
3-11Submitter’s Employer ID Number (EIN)Required.
Derived from the ‘SUB-ER-EIN’ IDFDV Field Identifier (seq 1000).
Numeric only.
12-19User Identification (User ID)Required.
Enter the eight-character BSO User ID assigned to the employee who is attesting to the accuracy of this file.
20-23Software Vendor CodeEnter the numeric four-digit Software Vendor Identification Code assigned by the National Association of Computerized Tax Processors (NACTP).

If "99 (Off-the-Shelf Software)" is entered in the Software Code field (positions 36-37) enter the Software Vendor Code.
Otherwise, fill with blanks.
24-28BlankFill with blanks. Reserved for SSA use.
29Resub IndicatorEnter "1" if this file is being resubmitted. Otherwise, enter "0" (zero).
30-35Resub Wage File Identifier (WFID)If "1" was entered in Resub Indicator field (position 29), enter the WFID displayed on the notice SSA sent. Otherwise, fill with blanks.
36-37Software CodeEnter "99" to indicate 'Off-the-Shelf Software'
38-94Company NameEnter the Company Name.
Left justify and fill with blanks.
95-116Location AddressEnter the company's location address (Attention, Suite, Room Number, etc).
Left justify and fill with blanks
117-138Delivery AddressEnter the company's delivery address (Street or Post Office Box).
Example: 123 Main Street.
Left justify and fill with blanks
139-160CityEnter the company's city.
Left justify and fill with blanks
161-162State AbbreviationEnter the company's State or commonwealth/territory.
Use a postal abbreviation. For a foreign address, fill with blanks
163-167ZIP CodeEnter the company's ZIP code. For a foreign address, fill with blanks
168-171ZIP Code ExtensionEnter the company's four-digit extension of the ZIP code. If not applicable, fill with blanks
172-176BlankFill with blanks. Reserved for SSA use.
177-199Foreign State/ProvinceIf applicable, enter the company's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
200-214Foreign Postal CodeIf applicable, enter the company's foreign postal code.
Left justify and fill with blanks. Otherwise, fill with blanks.
215-216Country CodeIf one of the following applies, fill with blanks:
* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
217-273Submitter NameRequired.
Enter the name of the organization's submitter to receive error notification if this file cannot be processed.
Left Justify and fill with blanks.
Derived from the ‘SUB-SUBM-NAME’ IDFDV Field Identifier (seq 1150).
274-295Submitter Location AddressEnter the submitter's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-LOCN’ IDFDV Field Identifier (seq 1160).
296-317Submitter Delivery AddressRequired.
Enter the submitter's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-DELIV’ IDFDV Field Identifier (seq 1170).
318-339Submitter CityRequired.
Enter the submitter's city.
Left justify and fill with blanks.
Derived from the ‘SUB-SUBM-CITY’ IDFDV Field Identifier (seq 1180).
340-341Submitter State AbbreviationRequired.
Enter the submitter's State or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks.
Derived from the ‘SUB-SUBM-STATE’ IDFDV Field Identifier (seq 1190).
342-346Submitter ZIP CodeRequired.
Enter the submitter's ZIP Code.
For a foreign address, fill with blanks.
Derived from the ‘SUB-SUBM-ZIP’ IDFDV Field Identifier (seq 1200).
347-350Submitter ZIP Code extensionEnter the submitter's four-digit extension of the ZIP code. If not applicable, fill with blanks.
Derived from the ‘SUB-SUBM-ZIP-EXT’ IDFDV Field Identifier (seq 1210).
351-355BlankFill with blanks. Reserved for SSA use
IMPORTANT NOTE: If using a foreign address, the foreign State/Province (postions 356-378), Foreign Postal Code (positions 379-393) and the Contry Code (positions 394-395) are required to be completed.
356-378Foreign State/ProvinceIf applicable, enter the submitter's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
379-393Foreign Postal CodeIf applicable, enter the submitter's foreign Postal Code.
Left justify and fill with blanks. Otherwise, fill with blanks.
394-395Country CodeIf one of the following applies, fill with blanks
* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
396-422Contact NameRequired.
Enter the name of the person to be contacted by SSA concerning processing problems.
Left justify and fill with blanks.
Derived from the ‘SUB-CONT-NAME’ IDFDV Field Identifier (seq 1250).
423-437Contact Phone NumberRequired.
Enter the contact's phone number with numeric valies only (including area code). Do not use any special characters.
Left justify and fill with blanks.

NOTE: It is imperative that the contact's telephone number be entered in the appropriate positions. Failure to include correct and complete submitter contact information may, in some cases, delay the timely processing of your file.

Derived from the ‘SUB-CONT-TEL’ IDFDV Field Identifier (seq 1260).
438-442Contact Phone ExtensionEnter the contact's telephone extension.
Left justify and fill with blanks.
Derived from the ‘SUB-CONT-TEL-EXT’ IDFDV Field Identifier (seq 1270).
443-445BlankFill with blanks. Reserved for SSA use.
446-485Contact E-mail/InternetEnter the contact's e-mail/internet address.
Derived from the ‘SUB-CONT-EMAIL’ IDFDV Field Identifier (seq 1280).
486-488BlankFill with blanks. Reserved for SSA use.
489-498Contact FaxIf applicable, enter the contact's fax number (including area code). Otherwise, fill with blanks.
Derived from the ‘SUB-CONT-FAX’ IDFDV Field Identifier (seq 1290).
499BlankFill with blanks. Reserved for SSA use.
500Preparer CodeEnter one of the following codes to indicate who prepared this file:
* A = Accounting Firm
* L = Self Prepared
* S = Service Bureau
* P = Parent Company
* O = Other

If more than one code applies, use the code that best describes who prepared this file.
501-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RE – Employer Record (Specific To Puerto Rico)#

ColumnDescriptionSource
1-2Record IdentifierConstant "RE"
3-6Tax yearRequired.
Enter the tax year for this report (YYYY).
Derived from the user defined FROM-TO period, converted to YYYY.
7Agent Indicator CodeIf applicable, enter one of the following codes:
* 1 = 2678 Agent
* 2 = Common Paymaster
* 3 = 3504 Agent
If more than one code applies, use the one that best describes your status as an agent.
Otherwise, fill with a blank.
8-16Employer/Agent EINRequired.
Derived from the applicable Federal reporting EIN, from IDGV or IDGR.
17-25Agent for EINIf "1" was entered in the Agent Indicator Code field (position 7), enter the client-employer's EIN for which you are an Agent. Otherwise, fill with blanks.
26Terminating Business IndicatorIf this is the last tax year that W-2s will be filed under this EIN, enter "1". Otherwise, enter 0 (zero).
27-30Establishment NumberFor multiple RE (Employer) Records with the same EIN, you can use this field to assign a unique identifier for each RE (Employer) Record. Otherwise, fill with blanks.
31-39Other EINFor this tax year, if you submitted tax payments to the IRS under Form 941, 943, 944, CT-1 or Schedule H or W2 data to SSA, and a different EIN was used from the EIN in positions 8-16, enter the other EIN. Otherwise, fill with blanks.
IMPORTANT NOTE: The Employer's Name field (positions 40-96) and the Employer's Address fields (positions 97-173) should normally match the employer name and address under which tax payments were submitted to the IRS under Form 941, 943, 944, 945, CT-1 or Schedule H.
40-96Employer NameRequired.
Enter the name associated with the EIN entered in positions 8 - 16.
Left justify and fill with blanks.
Derived from the 'W2-ER-NAME' IDFDV Field Identifier (seq 2010).
97-118Employer Location AddressEnter the employer's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the 'W2-ER-LOCN-ADDR' IDFDV Field Identifier (seq 2020).
119-140Employer Delivery AddressEnter the employer's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the 'W2-ER-DELIV-ADDR' IDFDV Field Identifier (seq 2030).
141-162Employer CityEnter the employer's city.
Left justify and fill with blanks.
Derived from the 'W2-ER-CITY' IDFDV Field Identifier (seq 2040).
163-164Employer State AbbreviationEnter the employer's State or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks.
Derived from the 'W2-ER-STATE' IDFDV Field Identifier (seq 2050).
165-169Employer ZIP CodeEnter the employer's ZIP Code.
For a foreign address, fill with blanks.
Derived from the 'W2-ER-ZIP' IDFDV Field Identifier (seq 2060).
170-173Employer ZIP Code ExtensionEnter the employer's four-digit extension of the ZIP code. If not applicable, fill with blanks.
Derived from the 'W2-ER-ZIP-EXT' IDFDV Field Identifier (seq 2070).
174-178 PRBlankFill with blanks. Reserved for SSA use.
179-201Foreign State/ProvinceIf applicable, enter the employer's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
202-216Foreign Postal CodeIf applicable, enter the company's foreign postal code. Left justify and fill with blanks. Otherwise, fill with blanks.
217-218Country CodeIf one of the following applies, fill with blanks:

* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
219Employment CodeRequired.
Enter the appropriate employment code:

* A = Agriculture (Form 943)
* H = Household (Schedule H)
* M = Military (Form 941)
* Q = Medicare Qualified Government Employment (Form 941)
* X = Railroad (CT-1)
* F = Regular (Form 944)
* R = Regular (all others) (Form 941).
NOTE: Railroad reporting is not applicable for Puerto Rico and territorial employers.
220Tax Jurisdiction CodeRequired.
Enter the code that identifies the type of income tax withheld from the employee's earnings:

* Blank (W-2)
* V = Virgin Islands (W-2VI)
* G = Guam (W-2GU)
* S = American Samoa (W-2AS)
* N = Northern Mariana Islands (W-2CM)
* P = Puerto Rico (W-2PR/499R-2)
221Third Party Sick Pay IndicatorEnter "1" for a sick pay indicator. Otherwise, enter "0" (zero).
222-512 PRBlankFill with blanks


Record Name: Code RW - Employee Wage Record (Specific To Puerto Rico)#

ColumnDescriptionSource
1-2Record IdentifierConstant "RW"
3-11Social Security NumberRequired.
Enter the employee's SSN.
If an invalid SSN is encountered, this field is filled with zeros.
Derived from the ‘W2-EE-SSN’ (seq 2500) IDFDV Field Identifier.
12-26Employee First NameRequired.
Enter the employee's first name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-FIRST-NAME’ (seq 2510) IDFDV Field Identifier.
27-41Employee Middle Name or InitialIf applicable, enter the employee's middle name or initial.
Left Justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-MIDDLE’ (seq 2520) IDFDV Field Identifier.
42-61Employee Last NameRequired.
Enter the employee's last name.
Left justify and fill with blanks.
Derived from the ‘W2-EE-LAST-NAME’ (seq 2530) IDFDV Field Identifier.
62-65Employee SuffixIf applicable, enter the employee's alphabetic suffix.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-SUFFIX’ (seq 2540) IDFDV Field Identifier.
66-87Employee Location AddressEnter the employee's location address (Attention, Suite, Room Number, etc.)
Left justify and fill with blanks.
Derived from the ‘W2-EE-LOCN-ADDR’ (seq 2600) IDFDV Field Identifier.
88-109Employee Delivery AddressEnter the employee's delivery address (Street or Post Office Box).
Left justify and fill with blanks.
Derived from the ‘W2-EE-DELIV-ADDR’ (seq 2610) IDFDV Field Identifier.
110-131Employee CityEnter the employee's City.
Left justify and fill with blanks.
Derived from the ‘W2-EE-CITY’ (seq 2620) IDFDV Field Identifier.
132-133Employee State AbbreviationEnter the employee's State or commonwealth/territory.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-STATE’ (seq 2630) IDFDV Field Identifier.
134-138Employee ZIP CodeEnter the employee's ZIP code.
For a foreign address, fill with blanks.
Derived from the ‘W2-EE-ZIP’ (seq 2640) IDFDV Field Identifier.
139-142Employee ZIP Code ExtensionEnter the employee's four-digit ZIP code extension.
If not applicable, fill with blanks.
Derived from the ‘W2-EE-ZIP-EXT’ (seq 2650) IDFDV Field Identifier.
143-147BlankFill with blanks. Reserved for SSA use.
148-170Employee Foreign State/ProvinceIf applicable, enter the employee's foreign State/Province.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-F-STATE’ (seq 2660) IDFDV Field Identifier.
171-185Employee Foreign Postal CodeIf applicable, enter the employee's foreign postal code.
Left justify and fill with blanks. Otherwise, fill with blanks.
Derived from the ‘W2-EE-F-POSTAL’ (seq 2670) IDFDV Field Identifier.
186-187Employee Country CodeIf one of the following applies, fill with blanks:

* One of the 50 States of the U.S.A.
* District of Columbia
* Military Post Office (MPO)
* American Samoa
* Guam
* Northern Mariana Islands
* Puerto Rico
* Virgin Islands

Otherwise, enter the applicable Country Code.
Derived from the ‘W2-EE-COUNTRY’ (seq 2680) IDFDV Field Identifier.
188-209 PRZeroFill with zeroes
210-220 PRSocial Security WagesThe sum of this field and the Social Security Tips field should NOT EXCEED the annual maximum Social Security Wage base for the tax year ($132,900 for Tax Year 2019).
No negative amounts.
Right justified and zero fill
Derived from the ‘W2-SSN-WAGE’ (seq 3020) IDFDV Field Identifier.
221-231 PRSocial Security Tax WithheldIf the amount in this field is greater than zero, then the Social Security Wages field or the Social Security Tips field must be greater than zero.
This amount should NOT EXCEED $8,239.80 for Tax Year 2019.
No negative amounts. Right justified and zero fill.
Derived from the ‘W2-SSN-TAX’ (seq 3030) IDFDV Field Identifier.
232-242 PRMedicare Wages and TipsThe amount in this field must be equal or exceed the sum of the Social Security Wages and Social Security Tips.
No negative amounts. Right justified and zero fill.
243-253 PRMedicare Tax WithheldNo negative amounts. Right justified and zero fill
254-264 PRSocial Security TipsThe sum of this field and the Social Security Wages field should NOT EXCEED the annual maximum Social Security Wage base for the tax year ($132,900 for Tax Year 2019).
No negative amounts. Right justified and zero fill.
265-396 PRZeroFill with zeroes
397-407 PRBlankFill with blanks
408-462 PRZeroFill with zeroes
463-473 PRCost of Employer-Sponsored Health Coverage (Code DD)No negative amounts.
Right justify and zero fill.
474-484Permitted Benefits Under a Qualified Small Employer Health Reimbursement Arrangement (Code FF)No negative amounts.
Right justify and zero fill.
485BlankFill with blanks. Reserved for SSA use.
486Statutory Employee IndicatorEnter "1" for statutory employee. Otherwise, enter "0" (zero).
Derived from the ‘W2-STAT-EE’ (seq 6000) IDFDV Field Identifier.
487 PRBlankFill with blanks.
488Retirement Plan IndicatorEnter "1" for a retirement plan. Otherwise, enter "0" (zero).
Derived from the ‘W2-RETIRE-PLAN’ (seq 6020) IDFDV Field Identifier.
489Third-Party Sick Pay IndicatorEnter "1" for a sick pay indicator. Otherwise, enter "0" (zero). Derived from the ‘W2-3PARTY-SICK’ (seq 6060) IDFDV Field Identifier.
490-512 PRBlankFill with blanks.

Record Name: Code RO - Employee Wage Record (Specific To Puerto Rico)#

ColumnDescriptionSource
1-2Record IdentifierConstant ‘RO’
3-11BlankFill with blanks. Reserved for SSA use.
12-22 PRZeroFill with zeroes
23-33Uncollected Employee Tax on Tips (Codes A and B)Combine the uncollected Social Security tax and the uncollected Medicare tax.
No negative amounts.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’ (seq 4010)
34-99 PRZeroFill with zeroes
100-274 PRBlankFill with blanks
275-285 PRWages Subject to Puerto Rico TaxNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
286-296 PRCommissions Subject to Puerto Rico TaxNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
297-307 PRAllowances Subject to Puerto Rico TaxNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
308-318 PRTips Subject to Puerto Rico TaxSNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
319-329 PRTotal Wages, Commissions, Tips, and Allowances Subject to Puerto Rico TaxNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
330-340 PRPuerto Rico Tax WithheldNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
341-351 PRGovernment Retirement FundNo negative amounts.
Right justify and zero fill.
For Puerto Rico employees only.
352-362 PRBlankFill with blanks
363-384 PRZeroFill with zeroes
385-512BlankFill with blanks

Record Name: Code RS - State Record (Specific To Puerto Rico)#

PositionDescriptionSource
1-2Record IdentifierConstant "RS"
3-4 PRState CodeFill with zeroes
5-9 PRTaxing Entity CodeFill with zeroes
10-18Social Security NumberEnter the employee's social security number as shown on the original/replacement SSN card issued by SSA.
Derived from IDFDV Field Identifier: ‘W2-EE-SSN’
If an invalid SSN is encountered, this field is entered with zeroes
19-33Employee First NameEnter the employee's first name as shown on the social security card.
Left justified and fill with blanks
Derived from IDFDV Field Identifier: ‘W2-EE-FIRST-NAME’
34-48Employee Middle Name or InitialIf applicable, enter the employee's middle name or initial as shown on the social security card.
Left justified and fill with blanks. Otherwise, fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-MIDDLE’
49-68Employee Last NameEnter the employee's last name as shown on the social security card.
Left justified and fill with blanks
Derived from IDFDV Field Identifier: ‘W2-EE-LAST-NAME’
69-72Employee SuffixIf applicable, enter the employee's alphabetic suffix. For example: SR, JR.
Left justified and fill with blanks. Otherwise, fill with blanks
Derived from IDFDV Field Identifier: ‘W2-EE-SUFFIX’
73-94Employee Location AddressEnter the employee's location address (Attention, Suite, Room Number, etc.). Left justified and fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-LOCN-ADDR’
95-116Employee Delivery AddressEnter the employee's delivery address.
Left justified and fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-DELIV-ADDR’
117-138Employee CityEnter the employee's city.
Left justified and fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-CITY’
139-140Employee State AbbreviationEnter the employee's state or commonwealth/territory. Use a postal abbreviation.
For a foreign address, fill with blanks
Derived from IDFDV Field Identifier: ‘W2-EE-STATE’
141-145Employee ZIP CodeEnter the employee's zip code. For a foreign address, fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-ZIP’
146-149Employee ZIP Code ExtensionEnter the employee's 4 digit extension of the zip code. If not applicable, fill with blanks.
Derived from IDFDV Field Identifier: ‘W2-EE-ZIP-EXT’
150 PRPayment for Services Rendered by a Qualified Physician IndicatorIf remuneration includes payments to the employee for Services rendered by a qualified physician under Act 14-2017 enter “1”, otherwise fill with a blank.
151 PRPayment for Domestic Services IndicatorIf remuneration includes payments to the employee for Domestic services enter “1’”, otherwise fill with a blank.
152 PRPayment for Other Services IndicatorIf remuneration includes payments to the employee for Other services enter “1”, otherwise fill with a blank.
153-192 PRPayment for Other Services Concept DescriptionIf “1” is entered for Payment for Other Services Indicator field, use this field to indicate the payment concept.
193 PRPayment for Services Rendered in Agricultural Labor IndicatorIf remuneration includes payments to the employee for Services rendered in agricultural labor enter “1”, otherwise fill with a blank
194 PRPayment for Services Rendered by a Minister of a Church or by a Member of a Religious Order IndicatorIf remuneration includes payments for Services rendered by a minister of a church or by a member of a religious order enter “1”, otherwise fill with a blank.
195-205Charitable ContributionsDerived from IDFDV Field Identifier: ‘W2-PR-DONATION’
206-216Contributions to Save and Double Your Money ProgramEnter the amount shown in box 6 of Form 499R-2/W-2PR.
No negative amount. Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-SAVE-PROGRAM’
217-231 PRZeroFill with zeroes
232-242 PRExempt Salaries BEnter the amount shown in box 18 of Form 499R-2/W-2PR.
No negative amount. Right justified and zero fill.
243-244 PRExempt Salaries B CodeEnter one single Code A, B, C, D, G, H or I.
For two codes enter AB, BG, AG, AH, BH or GH.
If you need to report code E or F, you must do so in box 16.
A Code is required if an amount is reported in box 18 (shown in box 18 of Form 499R-2/W2PR).
For combined Codes, use box 16 or 17.
Do not repeat the same Code in any field.
If not applicable, fill with blanks
245-273 PRBlankFill with blanks
274-307 PRZeroFill with zeroes
308 PRBlankFill with blanks
309-330ZeroFill with zeroes
331-347BlankFill with blanks
348-355Cease of Operations DateIf you have terminated your business during this tax year, enter the month, day and 4 digit year. Example: 013120YY.
Right justified and zero fill
Derived from IDFDV Field Identifier: ‘W2-ER-CEASE-DATE’
356-364 PRControl NumberEnter a unique control number of 9 digits for Form 499R-2/W-2PR. Do not use sequence between 900000000 to 999999999.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-ER-CONTROL-NUM’
365-375 PRBlankFill with blanks
376-386Contributions to Qualified Plans (CODA PLANS)Enter the amount shown in box 15 of Form 499R-2/W-2PR.
This amount should NOT EXCEED $25,000 for Tax Year 2019.
No negative amount.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-CODA-PLANS’
387-397Reimbursed Expenses and Fringe BenefitsEnter the amount shown in box 12 of Form 499R-2/W-2PR.
No negative amount.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-REIMB-EXPENSES’
398-403BlankFill with blanks
404-414Uncollected Social Security Tax on TipsEnter the amount shown in box 25 of Form 499R-2/W-2PR.
No negative amount.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-UNC-SS-TAX’
415-425Uncollected Medicare Tax on TipsEnter the amount shown in box 26 of Form 499R-2/W-2PR.
No negative amount.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-UNC-MC-TAX’
426-430Specialist’s Register NumberIf you are a Returns, Declarations or Refund Claims Specialist, enter the Register Number assigned by the Tax Practitioner and Education Division of the Department of the Treasury.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SP-REG-NUM’
431-441Exempt SalariesEnter the amount shown in box 16 of Form 499R-2/W-2PR.
No negative amount.
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-EXM-SALARY’
442 PRExempt Salaries CodeEnter one single Code A, B, C, D, E F, G, H or I where it is required if an amount is reported in box 16 (shown in box 16 of Form 499R-2/W-2PR).
For combined Codes, use box 17 or 18.
Do not repeat the same Code in any field.
If not applicable, fill with a blank.
Derived from IDFDV Field Identifier: ‘W2-PR-EXM-CODE’
443-449 PRBlankFill with blanks
450-487 PRSupplemental Data 2To be defined by user
488-498 PRExempt Salaries AEnter the amount shown in box 17 of Form 499R-2/W-2PR.
No negative amount.
Right justified and zero fill.
499 PRExempt Salaries Code AEnter one single Code A, B, C, D, G, H or I. If you need to report code E or F, you must do so in box 16.
A Code is required if an amount is reported in box 17 (shown in box 17 of Form 499R-2/W-2PR).
For combined Codes, use box 16 or 18.
Do not repeat the same Code in any field.
If not applicable, fill with a blank.
500 PRBlankFill with blanks
501-508 PRDate of BirthEnter the Date of Birth shown in box 1 of Form 499R-2/W-2PR. Format is YYYYMMDD.
If Code E is used in box 16 or 17, this field is required.
No negative amount.
Right justified and zero fill.
509-512 PRBlankFill with blanks
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 (Specific To Puerto Rico)#

PositionDescriptionSource
1-2Record IdentifierConstant "RT"
3-9Number of RW RecordsTotal number of code "RW" records reported since last code "RE" record
Right justified and zero fill.
10-39 PRZeroFill with zeroes
40-54Social Security WagesEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-WAGE’
55-69Social Security Tax WithheldEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-TAX’
70-84Medicare Wages and TipsEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
The amount in this field must be equal or exceed the sum in the fields for Social Security Wages and Social Security Tips.
Derived from IDFDV Field Identifier: ‘W2-MEDI-WAGE’
85-99Medicare Tax WithheldEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-MEDI-TAX’
100-114Social Security TipsEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-SSN-TIP’
115-294ZeroFill with zeroes
295-309Cost of Employer-Sponsored Health CoverageEnter the total for all Employee Records (Code RW) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-DD’
310-399 PRZeroFill with zeroes
400-414 PRPermitted Benefits Under a Qualified Small Employer Health Reimbursement ArrangementEnter the total for all Employee Records (RW) reported since the last Employer Record (RE).
Right justify and zero fill.
415-512 PRBlankFill with blanks. Reserved for SSA use.

Record Name: Code RU - Total Record (Specific To Puerto Rico)#

ColumnDescriptionSource
1-2Record IdentifierConstant "RU"
3-9Number of RO RecordsTotal number of "RO" records reported since last "RE" record.
Right justify and zero fill.
10-24 PRZeroFill with zeroes
25-39Uncollected Employee Tax on Tips (Code A and B)Total of all "RO" records since last "RE" record.
Right justify and zero fill.
Derived from IDFDV Field Identifier: ‘W2-CODE-A’ and ‘W2-CODE-B’
40-129 PRZeroFill with zeroes
130-354 PRBlankFill with blanks.
355-369Wages Subject to Puerto Rico TaxTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
370-384Commissions Subject to Puerto Rico TaxTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
385-399Allowances Subject to Puerto Rico TaxTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
400-414Tips Subject to Puerto Rico TaxTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
415-429Total Wages, Commissions, Tips and Allowances Subject to Puerto Rico TaxTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
430-444Puerto Rico Tax WithheldTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
445-459 Retirement Fund Annual ContributionsTotal of all "RO" records since last "RE" record.
Right justify and zero fill.
For Puerto Rico employees only.
460-489 PRZeroFill with zeroes
490-512BlankFill with blanks. Reserved for SSA use.

Record Name: Code RV – State Total Record (Specific To Puerto Rico)#

PositionDescriptionSource
1-2Record IdentifierConstant "RV"
3-12Employer Phone NumberEnter the employer phone number, such as "7879999999". Otherwise, fill with zeros
Derived from IDFDV Field Identifier: ‘W2-ER-CTAC-PHONE’
13-32 PRBlankFill with blanks
33-47Reimbursed Expenses and Fringe BenefitsEnter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-REIMB-EXPENSES’
48-62Contributions to Qualified Plans (CODA PLANS)Enter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-CODA-PLANS’
63-77Exempt SalariesThe sum of the Exempt Salaries field (Box 16), (RE State Record, positions 431- 441), Exempt Salaries A field (Box 17), (RS State Record, positions 488-498) and Exempt Salaries B field (Box 18), (RS State Record, positions 232-242).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-EXM-SALARY’
78-92Uncollected Social Security TaxEnter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-UNC-SS-TAX’
93-107Uncollected Medicare Tax on TipsEnter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-UNC-MC-TAX’
108-122Charitable ContributionsEnter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-DONATION’
123-137Contributions to Save and Double Your Money ProgramEnter the total for all State Records (Code RS) reported since the last Employer Record (Code RE).
Right justified and zero fill.
Derived from IDFDV Field Identifier: ‘W2-PR-SAVE-PROGRAM’
138-512 PRBlankFill with blanks.

Record Name: Code RF - Final Record (Same as Federal Record)#

State Media Magnetic Media Reporting - SSA EFW2 File Format for Annual and Quarterly Reporting#

Record Name: Code RF - Final Record#

ColumnDescriptionSource
1-2Record IndentifierConstant "RF"
3-7BlankFill with blanks. Reserved for SSA use
8-16Number of RW RecordsTotal number of RW (Employee) Records reported on the entire file.
Right justify and zero fill
17-512BlankFill with blanks. Reserved for SSA use

Notes#

Click to create a new notes page