Table of Contents
- 2018-2019 Year End Changes
- 1099R PROCESSING
- 1099R 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
- Reissued / Corrected 1099R Form
- Void 1099R Form
- RPYEU
- RPYEU Registration Set Up Audit
- RPYEU Exception Messages
- RPYEU Summary Report Level
- RPYEU Trace Level
- RPYEU Sort Levels
- RPYEU Sort by Zip – Mailing 1099R at discount rate
- RPYEU Combined Employment Type
- 1099R Form Control Number Print
- RPREGT - Pay Totals Register
- RPYEU – US Year End Summary Report
- RPYEU Report Selection Criteria
- RPYEU Selection Criteria - Quarterly Reporting
- 1099R Form Box Descriptions
- RP1099RW Form Print Program
- IDFDV Form Variables
There is required set up of 1099Rs before the forms, reports and media files can be produced. Users must confirm the setup of groups, states, counties, school districts and tax jurisdictions as they apply to your organization.
The government registration of the required government reporting levels and any applicable user fields must also be confirmed.
After the 1099Rs set up is complete, the Summary Report is run for comparison to the Year-To-Date Register. When everything is balanced, the 1099Rs can be printed and the summary report can be re-run to produce the required media file.
2018-2019 Year End Changes#
New for 2018 No recharacterizations of conversions made in 2018 or later.A conversion of a traditional IRA to a Roth IRA, and a rollover from any other eligible retirement plan to a Roth IRA, made after December 31, 2017, cannot be recharacterized as having been made to a traditional IRA.
Disaster distributions.
Special rules apply to retirement plan distributions made to employees affected by certain natural disasters that occurred in 2016 and 2017. See Pub. 976, Disaster Relief, for more information.
Form 1099-R: Reportable policy sale box.
We have added a new box to show the date of a payment of reportable death benefits and added instructions to the recipient copy. See Reportable death benefits and Date of Payment Box, later in this document.
New distribution codes.
We have added two new distribution codes, C and M, for box 7.
Form 5498: New rollover code.
We have added code "PO" for reporting qualified plan loan offset rollovers.
Date of Payment Box.
New box to enter the date payment was made for reportable death benefits.
Government Websites
https://www.irs.gov/pub/irs-pdf/i1099R.pdf
https://www.irs.gov/pub/irs-pdf/f1099R.pdf
1099R PROCESSING#
The RP1099RW form print program prints all information retrieved from the RPYEU xml file, according to the selection criteria.If an employee has multiple States and Local tax information to be reported, each 1099RW form is printed with 2 States and 2 Locals information until all State and Local information are printed. The Local information printed may not necessarily coincide with the State Information on the same page.
The RP1099RW program generates Summary Totals by each Employer Identification Number and Employment Type. At the end of the RP1099RW run, a Grand Total Summary is generated for all Employers.
Users must run RMEX with the RP1099RW Mex ID to obtain the Summary and Grand totals to balance to the RPYEU Summary report.
The RP1099RW Summary and Grand Totals are accumulated for numeric, alphanumeric or Toggle boxes that are not totaled.
Users should verify the RP1099RW numeric box totals balance to the RPYEU numeric box totals.
The RP1099RW process generates the Summary Totals and Grand Totals for all States and Locals regardless:
- If the tax is from the WORK or HOME tax jurisdiction
- Which States and Locals the taxes are in
The RP1099RW process does not accumulate the State and Local tax totals by each State and each Local. Users should run the RPYEU Summary report to obtain the totals for each State and Local.
If the RP1099RW process cannot select any information from the xml file to print, users must run RMEX with the RP1099RW Mex ID to review any error or exception messages to locate the problem.
1099R Type of Employment#
- On IDGR, the ‘1099R Employment Type’ field must be defined on the Registrations tab to qualify employees who have YTD information and belong to a Group, for each 1099R Type of Employment.
- A - Agriculture
- F – Form 944 filer
- H - Household
- M - Military
- Q – Medicare Qualified Government Employment
- R – Regular (All others)
- X - Railroad
- Users must run RPYEU for each 1099R Type of Employment. Example: Run RPYEU for 'Regular' employment, then run RPYEU for 'Agriculture' employment.
- The ‘1099R Employment Type’ for a group MUST NOT BE CHANGED even if there are multiple effective date records for a group.
- If the ‘1099R Employment Type’ is changed for a group for different effective date, then the 1099R reporting will be incorrect because it cannot qualify the YTD information under the proper ‘1099R Employment Type’.
- Employees can work for multiple ‘Types of Employment’ during a year. Example: An employee is a ‘Regular Employment’ employee during the year and also works for ‘Agriculture Employment’ during the summer. In this case, the Agriculture Employment requires to report earnings on Form 943 and the Agriculture earnings should be separate from the Regular employment reporting on the 1099R. Users should set up a different group for Agriculture and the employees should be paid and reported under the Agriculture group.
- When RPYEU is run, the employee will be automatically reported under the proper ‘1099R Type of Employment’ from IDGR.
- For Medicare Qualified Government Employees, users do not need to define a specific Group with ‘1099R Type of Employment’ as ‘Q’ in order for the employees to be reported with ‘Q’ type employment. Employees are classified as MQGE by the FICA and Medicare tax method on IPRLU.
- If the IPRLU FICA method is defined as ‘Do not Calculate’ and the Medicare method is defined, the employee is qualified as an MQGE employee and will be reported under ‘1099R Type of Employment’ ‘Q’ regardless of which group the employee belongs to.
- When RPYEU is run, if the '1099R Type of Employment' selected is 'R', the employee will still be reported under Q depending on the FICA and MEDICARE tax method (defined on IPRLU).
Government Media File Name#
- When RPYEU is run, users can select to generate a magnetic media file
- Users must define a valid directory name and a magnetic media file name, such as 1099R_2017.txt)
- Users can also attach the RPYEU Execution ID to the file name by defining the word ‘Mex’ in the file name, such as 1099R_2017_mex.txt. This will generate a magnetic media file 1099R_2017_67109.txt for Execution ID 67109
XML File#
- When RPYEU is run, users MUST define a valid File Directory name in order for the XML file to be generated.
- The XML file contains all employee information to be read by RP1099R (the Oracle 1099R Form Print program).
- RPYEU attaches the ‘.xml’ extension to the defined Media File name for the XML file.
- Media File Name: 1099R_2017_mex.txt
XML File Name: 1099R_2017_mex.xml
- Media File Name: 1099R_2017_mex
XML File Name: 1099R_2017_mex.xml
- After RPYEU is run, users can use Notepad or a PFE editor to review the XML file content.
- Users should Double click on the .xml file to open the XML file using an xml editor.
- Users can archive this XML file for historical reporting purposes or to reprint the 1099Rs.
RPYEU Trace and Data Dump File#
- Users should always run RPYEU with the Trace Level set to 'Exceptions only’ for all employees
- If there is problem in RPYEU and a user needs to determine which employee has the problem, the user should run RPYEU with the Trace Level set to ‘Program Trace'. This will print a list of processed employees in order to determine which employee has the problem.
- When the Trace Level is set to ‘Program Trace’, the SQL SELECT Statements for Federal, State and Local levels are also written as Trace messages. Users can review the select statement by running RMEX for the RPYEU Execution ID.
- When Trace Level = ‘Program Trace’, after each employee is processed, the estimated performance time for this employee is displayed.
- After determining which employee has the problem, users should run RPYEU for one employee with the Trace Level set to ‘Utility Trace’ to determine the problem in detail.
- When RPYEU is run with any Trace level, all trace messages are also written to a ‘_trace.csv’ file so users can open the file in Excel for investigation. The dynamic SQL SELECT statement is written to ‘_select.txt’ file
- When the ‘Create Data Dump’ toggle is set to YES, RPYEU will generate data dump files with a .csv extension for any available Federal, State, Local and School information. Users can open these data dump files in Excel for debugging and balancing purposes. Example: When Mex ID 750234 is run with trace and data dump and following files are generated:
- rpyeu_1099R_750234.txt - Magnetic media file to be sent to the government
- rpyeu_1099R_750234.xml - xml file to be read by RP1099R (Oracle Version Only) to print the 1099R forms
- rpyeu_1099R_750234_select.txt - SQL SELECT statement, can be used in SQL+
- rpyeu_1099R_750234_trace.csv - Trace file for debugging
- rpyeu_1099R_750234_fed.csv - Federal data dump file for debugging or balancing
- rpyeu_1099R_750234_state.csv - State data dump file for debugging or balancing
- rpyeu_1099R_750234_local.csv - Local data dump file for debugging or balancing
- rpyeu_1099R_750234_school.csv - School data dump file for debugging or balancing
- If RPYEU is not run in Trace mode, then only the first two files are generated:
- rpyeu_1099R_150277.txt - Magnetic media file to be sent to the government
- rpyeu_1099R_150277.xml - xml file to be read by RP1099R (Oracle Version Only) to print the 1099R forms
Government Media File – Code RW, RS when Select by State#
- When RPYEU is run with no specific State selected, the Federal magnetic media file and Code RW records will be generated.
- When RPYEU is run with one State selected, only the specific State records is processed, therefore Code RW records will not be generated.
Exclude Employees#
- Users can exclude certain employees from 1099R reporting by setting up '1099R-EXCLUDE-EE’ Identifier on IDFDV
- If the value of the '1099R-EXCLUDE-EE’ identifier is defined as ‘Y’, the employee is bypassed.
Example: If a user does not want to report employees whose Assignment Title is ‘Election Worker’ or ‘Self Employed’, set up the ‘1099R-EXCLUDE-EE’ Identifier with the following:- Field variable = EASD.ASSIGNMENT_TITLE
- Derivation Expression = decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N')
Note: Use UPPER(~) to convert an alphanumeric field to compare all upper case letters.
- If a user has a complex situation to exclude an employee, a STAT CODE can be used to indicate that the employee should be excluded.
Example: An employee is excluded when they work in certain groups, or with certain hours. Users can keep track of this setting the 'STAT CODE' value to 1.00.
- Field Source = Statistics
- Field variable = the STAT CODE that is used to exclude employee
- Derivation Expression = decode(~,1,'Y','N')
Election Workers#
Election workers earnings should be reported on the 1099R if:- The earnings are less than $600 and the Social Security and Medicare taxes are withheld
Election workers earnings should NOT be reported on the 1099R if:
- The earnings are less than $600 and the Social Security and Medicare taxes are NOT withheld
Users can manage this reporting as follows:
- Use a separate pay component to record the Election worker earnings. If FICA and Medicare are not calculated for these earnings, users can exclude the election worker earnings by not defining the pay component in the element for each 1099R Box.
- If the employee is paid with election earnings and FICA and Medicare tax are withheld, users should determine if the employee should be excluded or not. If an employee is excluded, users can set up a 'STAT CODE' for the ‘1099R-EXCLUDE-EE’ Identifier on IDFDV, to exclude the employee from reporting on the 1099R form.
- Users can exclude All Election workers by setting the EASD.ASSIGNMENT_TITLE to‘ELECTION WORKER’, then setting the ‘1099R-EXCLUDE-EE’ Identifier to EASD.ASSIGNMENT_TITLE.
Reissued / Corrected 1099R Form#
If an employee loses their 1099R Form, organizations can reissue the 1099R Form by running RP1099R and selecting the specific employee.For RP1099R (Oracle version), prior to reissuing the 1099R Forms, users must have the XML file ready for the RP1099R program. The XML file can be from one of the following:
- Re-run RPYEU to generate the XML file for the specific employee, OR
- Use the archived XML file from the previous RPYEU run and select the employee from the XML file.
For RP1099RW4C/RP1099RW4TB (Windward versions), users must select the GVT Run number that the employee belongs to when RPYEU is run.
- Re-run RPYEU to generate a new GVT Run number for the specific employee, OR
- Use the existing GVT Run number that the employee's 1099R was originall issued for.
When any 1099R Print Program is run, users should enter the word ‘REISSUED’ or ‘CORRECTED’ in the ‘Reissued/Corrected field’, so the 1099R form will be printed with the defined word.
Void 1099R Form#
- If an error is discovered on the 1099R forms and the Forms have not be distributed to the employees, users should fix the error(s) and re-run RPYEU and the 1099R Print Program(s).
- If an error is discovered on the 1099R forms nd the Forms have be distributed to the employees, users must manually correct the 1099R Forms by completing Form 1099R-C for corrections. High Line does not support the 1099R-C form.
RPYEU#
RPYEU Registration Set Up Audit#
When RPYEU is run, users have the option to audit and fix the government registrations set up on IDGV. Users can define the following the Regist/Set Up Audit field to:| Option | Description |
|---|---|
| 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 option is used when a user just wants to verify all of the government registration set up prior to running RPYEU. This option allows exception messages to be printed. |
| 02 | Print and run. After the Government Registration is audited, print all registrations and continue to run RPYEU. This should be the default so users can verify all of the government registration set up and run RPYEU. This option allows exception messages to be printed. |
| 03 | Excp and run. After the Government Registration is audited, do not print registrations and continue to run RPYEU. This option allows exception messages to be printed. |
RPYEU Exception Messages#
Negative (credit) amounts are never allowed for 1099R reporting. If negative amounts are encountered, an exception message is printed. Users must resolve the negative amount and the re-run the report until no exceptions are found.The following set up exception messages are highlighted if one of the ‘Regist/Set Up Audit field' are defined that allows exception messages to be printed (Options 01, 02 and 03 only):
| IMUF | User Field 1099R STATE MEDIA FILING is not set up for P2K_CM_GOVT_REGISTRATIONS |
| IMUF | User Field 1099R TAX TYPE CODE is not set up for P2K_CM_GOVT_REGISTRATIONS |
| IMUF | User Field 1099R TAXING ENTITY is not set up for P2K_CM_GOVT_REGISTRATIONS |
| IDGV | Federal Registration is not set up for Entity: Entity name |
| IDGR | 1099R EMP TYPE is not set up for Entity: entity code, Unit: unit code, Group: group code or Effective date |
| IDGV | State Registration is not set up for State: State name |
| IDGV Variables | State: State name 1099R STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03 |
| IDGV | Local Registration is not set up for County Tax Jurisdiction: County name |
| IDGV Variables | County: county name 1099R STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03 |
| IDGV | Local Registration is not set up for City Tax Jurisdiction: City name |
| IDGV Variables | City: city name 1099R STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03 |
| IDGV | School Registration is not set up for School: School name |
| Warning | IDFDV Identifier Name is not set up |
| Warning | IDFDV Identifier Name contains CONSTANT |
The following exception messages are always printed for an employee: The following exception messages are always printed for an employee:
| Code | Message |
|---|---|
| Empl nnn | Invalid SSN: ssn, SSN must be 11 positions, position 4 and 7 must be a hyphen (-). Users must verify and correct The SSN number, otherwise 1099R form and Magnetic media filing will be incorrect for the employee |
| Empl nnn | Term date YYYYMMDD is prior to reporting year YYYY. This is a warning that indicates the employee has been terminated in a prior year, but 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. Users must correct either the Box 3 or Box 7 set up. 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 1099R 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 changed to 0.00. Uses must review this error and correct the negative amount, otherwise the system will report zero for this field. |
| Empl nnn | Identifier Amt 999999.9999 exceeds 2 decimals, amount changed to 999999.99. This can cause a rounding error. Users should be review the error to find out why the amount exceeds 2 decimals and correct the data. |
| 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. Users should review the printing of 1099R for this field and the government file to report this amount. |
| 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 on the file Users MUST correct this error because the report will show ####### in the field and the government will reject the file. Users should not correct the ####### to zero in the file. This will result in incorrect reporting for the 1099R, between the 1099R form print and the 1099R file. The 1099R form may be large enough to print the field size while the magnetic media reporting could not report this large amount. Users must find out if incorrect data is the cause of the problem, or contact High Line for support. |
RPYEU Summary Report Level#
There are five levels of reporting for RPYEU Summary Report:- Federal
- State
- County
- City
- School District
The Federal level print is reported and sorted by employees 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.
Users can suppress the printing of ‘Set Up Exceptions’ for IDFDV, IDGV, etc., however, the employee level of exception are always printed, to show error or warning messages for an employee.
RPYEU Trace Level#
Users should always run RPYEU with the Tracel Level set to 'Exceptions Only' for all employees.If there is problem in RPYEU, users should run RPYEU with the Trace Level set to Program Trace. This will print a list of processed employees to determine which employee has the problem.
When the Trace Level is set to Program Trace, the Select Statements for Federal, State and Local levels are also written as Trace messages. Users can review the Select statements by running RMEX for the RPYEU Execution ID.
After determining which employee has the problem, users should run RPYEU for the specific employee with the Trace Level set to Utility Trace to review and determine the problem in detail.
RPYEU Sort Levels#
There are three options to sort employees in RPYEU for distribution of the 1099R Forms:1. Sort Level By
The lexicon X_1099R_SORT_LEVEL is used for this prompt.
- Department is the prime assignment details’ department that is effective as of the defined ‘As of date’.
- Users can define a special ‘1099R Destination’ at the department level or the employee level for 1099R distribution purposes.
- Users can also define to ‘Provide Sort Level Totals’ by defining a ‘Sort Level By’ level
Options are:
- 00-Not Applicable
- 01-Department
- 02-Dept 1099R Destination
- 03-Dept SUI ER Number
- 04-Pay Dest (EASD)
- 05-Location (EASD)
- 06-1099R Destination (EID)
2. Sort by Active/Inactive
This prompt is useful for sorting Terminated employees from Active employees for distribution purposes.
The lexicon X_1099R_SORT_ACTIVE is used for this prompt.
The options are:
- 00-Do not sort active/inactive. Terminated employees will not be sorted before active employees
- 01-Before Sort Level. Terminiated employees will be sorted before the defined 'Sort Level By' field (above). Example: All Inactive employees are group together, by Department (Sort Level), followed by Active employees.
- 02-After Sort Level. Terminiated employees will be sorted after the defined 'Sort Level By' field (above). Example: All inactive employees are grouped together, within each department (Sort Level), followed by Active Employees in the same department.
Example for 01-Before Sort Level
Department A has 2 terminated employees (A1, A2) and 3 active employees (A3, A4, A5)
Department B has 2 terminated employees (B1, B3) and 3 active employees (B3, B4, B5)
RPYEU will sort in this order:
| Department A | Status: Inactive | Employee A1 |
| Employee A2 | ||
| Department B | Status: Inactive | Employee B1 |
| Employee B2 | ||
| Department A | Status: Active | Employee A3 |
| Employee A4 | ||
| Employee A5 | ||
| Department B | Status: Active | Employee B3 |
| Employee B4 | ||
| Employee B5 |
Example for 02-After Sort Level
Department A has 2 terminated employees (A1, A2) and 3 active employees (A3, A4, A5)
Department B has 2 terminated employees (B1, B3) and 3 active employees (B3, B4, B5)
RPYEU will sort in this order:
| Department A | Status: Inactive | Employee A1 |
| Employee A2 | ||
| Status: Active | Employee A3 | |
| Employee A4 | ||
| Employee A5 | ||
| Department B | Status: Inactive | Employee B1 |
| Employee B2 | ||
| Status: Active | Employee B3 | |
| Employee B4 | ||
| Employee B5 |
3. Sort Employees By
The lexicon X_1099R_SORT_PERSON is used for this prompt.
This prompt will sort within the ‘Sort Level By’ and ‘Sort by Active / Inactive’ fields. The options are:
- 01-Person Code
- 02-Last Name/First Name
- 03-Destin/Last/First
- 04-Dept/Last/First
- 05-Mailing Zip/Last/First
- 06-Primary Zip/Last/First
RPYEU Sort by Zip – Mailing 1099R at discount rate#
For organizations who are mailing a large volume of the 1099R forms to their employees, arrangements can be made with the US Post Office to mail the 1099R forms at a discounted postal rate if the 1099R forms are sorted by ZIP code.To mail 1099R forms at a discounted rate, when RPYEU is run, users should select to Sort Employees By:
- Mailing ZIP/Last/First name (recommended)
- Primary ZIP/Last/First name
If the IEPI Mailing Address does not exist, the IEPI Primary Address will be used.
The RPYEU report prints the employees by ZIP code sequence and prints the ZIP codes on the Employee’s line.
The RP1099R (Oracle Version only) print program reads from the xml file and prints records in the sequence as sorted by RPYEU. If the RP1099RW4C/RP1099RW4TB (Windward Version only) print program is used, the print program reads the IPGH ID Sequence that has been sorted by the RPYEU process.
NOTE: When using the option to sort by ZIP code, the employees are sorted in ZIP order and not by Last/First name or Person code sequence. This can make it difficult to locate a specific employee.
For auditing and balancing purposes, it is recommended that RPYEU should be run with the Sort Employee By parameter set to either Person Code or Dept/Last/First. This will generate the government file, to balance to the RPREGT, and submit to the government.
Prior to printing the 1099R forms through the 1099R Print Form programs, users should re-run the RPYEU with the Sort Employee By parameter set to either Mailing ZIP/Last/First or Primary ZIP/Last/First to generate the xml file to sort by ZIP code. Users should also verify that this RPYEU run report balances to the RPYEU report from the prior run, to ensure the totals match. Users can then run 1099R Print Form programs to print the 1099R forms.
After the 1099R Print Form program is run, users should save the RPYEU xml file for backup or auditing purposes. If a user needs to reference the order of 1099R printing, users can re-run RPYEU with the Sort Employee By parameter set to either Person Code or Dept/Last/First to generate the government file sequence to be kept on the IPGR / IPGH form for balancing to the government file.
RPYEU Combined Employment Type#
The EF1099R media file Code RE Employer record requires to report one of the following types of employment:- A - Agriculture
- F – Form 944 filer
- H - Household
- M - Military
- Q – Medicare Qualified Government Employment
- R – Regular (All others)
- X - Railroad
The Employment Code is retrieved from the ‘1099R Employment Type’ parameter on IDGR or from the employee’s FICA and Medicare method defined on IPRLU.
- All employees with the same Employment Code are grouped together under one Code RE record.
- If IPRLU FICA method is set to ‘Do not calculate’ and the MEDICARE method is NOT set to ‘Do not calculate’, the employee is classified as '1099R Employment Type Q’ for 1099R reporting.
- The EF1099R Federal Filing requires Code RE records to be reported by 'Type of Employment', however, some States filing do not require to separate employees by the Type of Employment, therefore, the 'Combine Employment Types' field on RPYEU is used.
- Typically, this field is set to NO for most RPYEU file reporting, however, if a State filing does not require to file by Types of Employment, users can set this field to YES to combine all Types of Employment under one Code RE record.
- If your organization has only ‘Regular’ types of employment, users should set this field to NO all the time.
1099R Form Control Number Print#
On the 1099R Form, 2-on-1-page, Box D, users can print the Control Number on the form for reference or distribution purpose, such as a Person Code. Users must set up the following Identifiers on the IDFDV form:Seq 2800 1099R-CONTROL-PRT
Print Control Number on Form
Form Code: Use current year's form code
Identifier: 1099R-CONTROL-PRINT
Level: Federal
O/R: CONTROL NUM PRT
Source: Constant
Field Variable Options:
- Null, 0 – Do not print Control Number on 1099R Form
- 1 - Print Control Number as defined in 1099R-CONTROL-NUM Identifier
- 2 - Print Control Number as defined from RPYEU ‘Sort Level By’ field
- 3 - Print 1099R-CONTROL-NUM Identifier and Person Code
- 4 - Print ‘Sort Level By’ field and Person Code
- 5 - Print ‘Sort Level By’ field and 1099R-CONTROL-NUM Identifier
- 6 - Print ‘Sort Level By’ field, the 1099R-CONTROL-NUM Identifier and Person Code
Seq 2810 1099R-CONTROL-NUM
Control Number on Form
Form Code: Use current year's form code
Identifier: 1099R-CONTROL-NUM
Level: Federal
O/R: CONTROL NUMBER
Source: Data Base Column
Field Vaiable Option: Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc.
If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
- within the reporting year the employee has been paid by more than one entry of this database column (employee is paid under 2 Payroll Codes), and
- the Government Registrations are the same
Example:
Employee is paid by PAYROLL_CODE: US CENTRAL BW
Employee is also paid by PAYROLL_CODE: US WEST BW
Then ‘US WEST BW’ code will be printed.
RPREGT - Pay Totals Register#
Run the To Date Register (RPREGT) to create the summary register of YTD totals for employees.Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter.
Create an element on the IPPE form with only the pay components that will be reported on the 1099RW form. This will greatly reduce the size of the Year-to-Date Register.
If an employee worked in two different jurisdictions, there will be one register for each jurisdiction. Consequently, the employee will receive a separate 1099RW form for each jurisdiction.
For auditing purposes, (comparing RPREGT TO RPYEU) users should define the Provide Totals By field as Fed Regist Number when RPREGT is run.
RPYEU – US Year End Summary Report#
The US Year End Summary Report (RPYEU) is used to verify that the totals are balanced with the Year to Date information before printing the W2 forms. Produce the US Year End Summary Report.- This report is used to balance to the Year-To-Date Register and the Quarter-To-Date (RPREGT) report
- Check the exception messages from this Summary Report and correct any exceptions
- Generate the W2 File in the federal format (EFW2 Format is supported for year 2018 reporting)
- Generate the State Information in the federal file format for the States that accept the federal file format
- Produce the W2 State File for States with the specific State file format requirements
- Users must run the RPYEU process, one State at a time, to generate the State specific file
- Since each State has its own requirements, users must check with High Line to verify if the State is supported, prior to running the RPYEU for a specific State file
- Generate an XML file to populate the RPW2 program to print the W2 Forms for all processed employees
RPYEU Report Selection Criteria#
Report Parameters
| Parameter | Description |
|---|---|
| Annual Form Code | Mandatory. Form Code that is defined on the IDFDV form. NOTE: Always use the current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. |
| Quarterly Form Code | Blank for Annual Reporting. Defines the quarterly form code for the report. Optional |
| Govt Interface Format | Blank for Annual Reporting. Defines the government interface format for the report. Optional |
| Period Type | Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter for quarterly reporting. |
| Period End Date | Mandatory. Defines the end date of the reporting period. |
| As of Date | Mandatory. Defines the start date of the reporting period. |
| Combine Employment Type | Defines if the employees on the report should be sorted by their Employment Type Set this field to YES to combine Regular and Other Types of Employment, such as Agriculture. Optional. This parameter is used mostly for State filing so an employee is reported only once for a State, even if they have been paid by multiple Federal Registrations. Therefore, when this field is set to YES, RPYEU will not store the Federal Level amounts on the IPGH form because the Federal Registration Numbers are combined and will not be linked to a specific Federal Registration Number. A warning message is issued when this field is set to YES: *** WARNING: Combine Fed Regist = Yes, IPGR Federal Amounts and Employee Remittance Header are not added by Federal Registration Number. |
| Combine Fed Regist | Defines if all of the selected 'Federal Regist' for State/Local Reporting should be combined. Set this field to YES to combine all 'Federal Regist' for State/Local reporting. Optional |
| Media Format | Defines the Federal file format for SSA reporting. Optional |
| Directory Name | Mandatory. Defines the name of the government Magnetic Media file. |
| Media File Name | Mandatory. Defines the media file name of the data being uploaded. |
| Create Data Dump | Defines if a data dump file with the extension of .csv should be generated. Optional |
| Trace Level | Defines the tracing level (report messages) for the report. Optional. Users should always run RPYEU with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing. |
| Regist/Set Up Audit | Option to print exceptions that may exist from set up. Optional. Options are: 00-Do not print, run 01-Print, do not run 02-Print and run 03-Excp and run |
| User Comments | Enter a comment to print on the header of the report. Optional |
Report Filters
| Filter | Description |
|---|---|
| Entity | To define and report on a specific Entity. Optional |
| Federal Regist Set | To define and report on a specific Federal Registration Set, on IDGV. Optional |
| Federal Regist Number | Defines the Employer Identification Number, on IDGV. Optional |
| People List | This field limits the process to the people in the defined list. Optional |
| Person | Enter the Person Code of the employee you are tesating with. Optional |
| Select State | Defines a State to report on. Optional. Do not enter a State when generating the Federal File or W2 forms. If a State is selected, the process will report on the defined State only. |
| State Regist Set | To define and report on a specific State Registration set, on IDGV. Optional. This field is not required for Annual reporting. |
| State Regist Number | Used only for Quarterly State filing. Is a State is not entered, then the Federal Regist Number on IDGV is used. Optional |
| Local Regist Set | To define and report on a specific Local Registration set. Optional |
| Local Reigst Number | To define and report on a specific Local Registration set. Optional |
| Select County | To define and report on a specific County. Optional |
| Select City | To define and report on a specific City. Optional |
| Select School | To define and report on a specific School District. Optional |
RPYEU Selection Criteria - Quarterly Reporting#
Report Parameters| Parameter | Description |
|---|---|
| Annual Form Code | Mandatory. Form Code that is defined on the IDFDV form. NOTE: Always use the current year form code. DO NOT use a prior year form code as the Identifiers may be obsolete. |
| Quarterly Form Code | Optional. If not defined, it defaults to the Annual Form Code with the EF1099R format. If the State is using a format such as ICESA, TIB-4 and other special formats for quarterly reporting, enter HL$US-QTR-2014. HL$US-QTR-2014 will not be updated after 2014 because this format code is only used for prior year ICESA and TIB-4 formats. Most States are now converted to EF1099R. |
| Govt Interface Format | Optional. Some States require a specific government XML file format that is defined on the IDIF form. Example: The Florida State format is HL$US-QTR-FL2019. Please refer to the State document that indiciates if this parameter should be used. |
| Period Type | Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting. |
| Period End Date | Mandatory. Defines the end date of the quarterly reporting period. |
| As of Date | Mandatory. Defines the start date of the quarterly reporting period. |
| Combine Employment Type | Defines if the employees on the report should be sorted by their Employment Type. Set this toggle to YES to combine Regular and Other Types of Employment. |
| Combine Fed Regist | Defines if all of the selected 'Federal Regist' for State/Local Reporting should be combined. Set this field to YES to combine all 'Federal Regist' for State/Local reporting. DO NOT SET THIS TOGGLE TO YES WHEN GENERATING THE FEDERAL FILE. When this field is set to YES, RPYEU will not store the Federal Level amounts on the IPGH form because the Federal Registration Numbers are combined and will not be linked to a specific Federal Registration Number. A warning message is issued when this field is set to YES: *** WARNING: Combine Fed Regist = Yes, IPGR Federal Amounts and Employee Remittance Header are not added by Federal Registration Number. |
| Media Format | Enter the State file format or SUI file format for State Reporting. For the SUI file format, use the SUI Registration Number from IDGV. |
Defines the Federal file format for SSA reporting. Optional
| Directory Name | Mandatory. Defines the name of the government Magnetic Media file. |
| Media File Name | Mandatory. Defines the media file name of the data being uploaded. |
| Create Data Dump | Defines if a data dump file with the extension of .csv should be generated. Optional |
| Trace Level | Defines the tracing level (report messages) for the report. Optional. Users should always run RPYEU with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing. |
| Regist/Set Up Audit | Option to print exceptions that may exist from set up. Optional. Options are: 00-Do not print, run 01-Print, do not run 02-Print and run 03-Excp and run |
| User Comments | Enter a comment to print on the header of the report. Optional |
Report Filters
| Filter | Description |
|---|---|
| Entity | To define and report on a specific Entity. Optional |
| Federal Regist Set | To define and report on a specific Federal Registration Set, on IDGV. Optional |
| Federal Regist Number | Defines the Employer Identification Number, on IDGV. Optional |
| People List | This field limits the process to the people in the defined list. Optional |
| Person | Enter the Person Code of the employee you are tesating with. Optional |
| Select State | Defines a State to report on. Optional. Do not enter a State when generating the Federal File or W2 forms. If a State is selected, the process will report on the defined State only. |
| State Regist Set | To define and report on a specific State Registration set, on IDGV. Optional. This field is not required for Annual reporting. |
| State Regist Number | Used only for Quarterly State filing. Is a State is not entered, then the Federal Regist Number on IDGV is used. Optional |
| Local Regist Set | To define and report on a specific Local Registration set. Optional |
| Local Reigst Number | To define and report on a specific Local Registration set. Optional |
| Select County | To define and report on a specific County. Optional |
| Select City | To define and report on a specific City. Optional |
| Select School | To define and report on a specific School District. Optional |
1099R Form Box Descriptions#
Users should read the following form descriptions and refer to the IRS 2018 instructions for Forms 1099R and 5498 prior to setting up the IDFDV form.https://www.irs.gov/pub/irs-pdf/i1099RW.pdf
2018 1099R format for reporting in 2019
| Box | Title | Description |
|---|---|---|
| 1 | Gross Distribution | Enter the total amount of the distribution before income tax or other deductions were withheld |
| 2a | Taxable Amount | Enter the taxable amount |
| 2b | Total Distribution | Enter an “X” in this box only if the payment shown in box 1 is a total distribution |
| 2b | Taxable Amount Not Determined | Enter an “X” in this box if you are unable to reasonably obtain the data needed to compute the taxable amount. |
| 3 | Capital Gain (Included in Box 2a) | Report any amount that is taxable as a capital gain |
| 4 | Federal Income Tax Withheld | Enter any federal income tax withheld |
| 5 | Employee Contributions/ Designated Roth Contributions or Insurance Premiums | Enter the employee's contributions |
| 6 | Net Unrealized Appreciation (NUA) in Employer's Securities | Use this box if a distribution from a qualified plan (except a qualified distribution from a designated Roth account) includes securities of the employer corporation |
| 7 | Distribution Code(s) | Enter an “X” in the IRA/SEP/SIMPLE checkbox if the distribution is from a traditional IRA, SEP IRA, or SIMPLE IRA. Do not check the box for a distribution from a Roth IRA or for an IRA recharacterization |
| 8 | Other | Enter the current actuarial value of an annuity contract that is part of a lump-sum distribution. |
| 9 | Your Percentage of Total Distribution | If this is a total distribution and it is made to more than one person, enter the percentage received by the person whose name appears on Form 1099-R. |
| 9b | Total Employee Contributions | You are not required to enter the total employee contributions or designated Roth contributions in box 9b |
| 10 | Amount Allocable to IRR Within 5 Years | Enter the amount of the distribution allocable to an IRR made within the 5-year period, beginning with the first day of the year in which the rollover was made. |
| 11 | 1st Year of Designated Roth Contributions | Enter the first year of the 5-tax-year period |
| 12-17 | State and Local Information | These boxes and Copies 1 and 2 are provided for your convenience only and do not need to be completed for the IRS. Use the state and local information boxes to report distributions and taxes for up to two states or localities. |
| FATCA Filing Requirement | Check the box if you are an FFI reporting a cash value insurance contract or annuity contract that is a U.S. account in a manner similar to that required under section 6047(d). | |
| Account Number | The account number is required if you have multiple accounts for a recipient for whom you are filing more than one Form 1099-R. | |
| Date of Payment | Enter the date payment was made for reportable death benefits. |
RP1099RW Form Print Program #
The US 1099R Forms (RP1099RW) report will print a list of 1099R forms.The RP1099RW program currently supports the 2 on-a-page format.
| Report Parameters | |
|---|---|
| EE/ER Copy | Optional. Defines if the Employee ot Employer copy of 1099 will be printed. Options are: *01 - Employer Copy *02 - Employee Copy |
| Corrected Toggle | Optional. When this toggle is set to ON, an “X” will be printed in the Corrected box (top of form). |
| Reissued/Corrected | Optional. Defines if the 1099RW is being reissued for an employee. If an employee has lost their 1099RW form and have requested a replacement copy, users should run the RP1099RW process and define the Person Code for the specific employee. *Enter the word REISSUED in this field for re-issued 1099RW forms. *Enter the word CORRECTED in this field for corrected 1099RW forms. Users can enter a date in this field to indicate the Date of the Corrected copy (if an employee has more than one corrected copy). The exact wording in this field will be printed on the top of the 1099RW form. |
| Exception Level | Optional. Defines the level of detail on the exception report. Users should always run with the Exception Level set to Exception Only for all employees, unless it is being used for debugging. |
| Trial Print Only | Defines if the Print Stage field on the IPGH form will be updated when the 1099s are printed. When set to YES, the field will not updated. When set to NO, the Print Stage will be changed to Forms Printed |
| User Comment | Optional, Text This field holds the user-supplied comment which will appear in the header of all pages of the report. |
| Report Filters | |
|---|---|
| GVT Run | Mandatory. This field defines the GVT Run number to be used to read, extract the data from and produce the 1099R forms. |
| State | Optional. If used, only one State can be entered. This field should not be defined when users are printing the Employee Copy. Employees MUST have all of the States printed on their 1099 forms. When printing the Employer copy, users can define to print by State to file the 1099RW paper copy to the State. |
| Person | Optional. Users can enter one or more person codes to report on. |
IDFDV Form Variables#
IDFD Form: HL$US-1099R-YYYY – system provided
IDFD Form Type: US 1099R Definition
Form Code HL$US-1099R-2019 Identifiers
NOTE: Fields marked with an asterisk (*) are mandatory.
- 1099R Form Code Definitions
| Field Identifier | Description | Suggested Field Source | Suggested Variable |
|---|---|---|---|
| * SUB-ER-EIN | Submitter’s Employer EIN | Constant | 9 character EIN |
| SUB-PIN-NUMBER | Personal Identification Number | Constant | 8 characters assigned to you as PIN #. Enter 1 if the file is submitted, otherwise enter 0 (zero) |
| SUB-RESUB-IND | Resubmitt Indicator | Constant | Enter 1 if file is resubmitted, otherwise 0 |
| SUB-RESUB-WFID | Resubmitt SSA WFID from notice | Constant | If resubmitted, enter SSA WFID from notice |
| SUB-VENDOR | Software Vendor Code | Constant | Enter your company data |
| SUB-SOFTWARE | Submitter Software Code | Constant | Enter your company data |
| SUB-COMP-NAME | Company Name receive EFR99 | Constant | Enter Company name who receives EFR99 |
| SUB-COMP-LOCN | Company Location Address | Constant | Enter company’s location address such as Attention, Suite, Room # etc |
| SUB-COMP-DELIV | Company Delivery Address | Constant | Enter company’s delivery address such as Street or Post Office Box |
| SUB-COMP-CITY | Company’s City | Constant | Enter company’s city |
| SUB-COMP-STATE | Company’s State Abbrev | Constant | Enter company’s State Abbreviation |
| SUB-COMP-ZIP | Company’s ZIP Code | Constant | Enter company’s ZIP code |
| SUB-COMP-ZIP-EXT | Company’s ZIP Code Extension | Constant | Enter company’s ZIP code extension |
| SUB-COMP-F-STATE | Company’s foreign State/province | Constant | Enter company’s foreign State/Province |
| SUB-COMP-F-POST | Company’s foreign postal code | Constant | Enter company’s foreign postal code |
| SUB-COMP-COUNTRY | Company’s country if applicable | Constant | Enter company’s Country if applicable |
| * SUB-SUBM-NAME | Submitter Organization Name | Constant | Organization Name to receive unprocessed data |
| * SUB-SUBM-LOCN | Submitter Location Address | Constant | Enter submitter location address such as Attention, Suite, Room # etc |
| * SUB-SUBM-DELIV | Submitter Delivery Address | Constant | Enter submitter delivery address such as Street or Post Office Box |
| * SUB-SUBM-CITY | Submitter City | Constant | Enter submitter city |
| * SUB-SUBM-STATE | Submitter State Abbrev | Constant | Enter submitter State Abbreviation |
| * SUB-SUBM-ZIP | Submitter ZIP Code | Constant | Enter submitter ZIP code |
| SUB-SUBM-ZIP-EXT | Submitter ZIP Code Extension | Constant | Enter submitter ZIP code extension |
| SUB-SUBM-F-STATE | Submitter foreign State/province | Constant | Enter submitter foreign State/Province |
| SUB-SUBM-F-POST | Submitter foreign postal code | Constant | Enter submitter foreign postal code |
| SUB-SUBM-COUNTRY | Submitter country if applicable | Constant | Enter submitter Country, if applicable |
| * SUB-CONT-NAME | Contact name for SSA | Constant | Enter your company data |
| * SUB-CONT-TEL | Contact telephone # for SSA | Constant | Enter your company data |
| SUB-CONT-TEL-EXT | Contact telephone extension | Constant | Enter your company data |
| * SUB-CONT-EMAIL | Contact e-mail address for SSA | Constant | Enter your company data |
| SUB-CONT-FAX | Contact FAX phone # for SSA | Constant | Enter your company data |
| SUB-CONT-METH | Preferred Contact method | Constant | MUST be BLANK |
| SUB-PREPARER | Preparer Code | Constant | Enter your company data |
| SUB-3RD-PARTY-SICK | Third-Party Sick Pay Indicator | Constant | Enter your company data |
| SUB-3RD-PARTY-TAX | Income Tax Withheld by 3rd Party | Constant | Enter your company data |
| ER-AGENT-IND | Agent Indicator Code | Constant | If applicable, enter appropriate code |
| ER-FOR-EIN | Agent for which EIN | Constant | If you are an agent, enter the EIN for which you are an agent for |
| ER-TERM=BUS | Terminating business indicator | Constant | Enter appropriate code from SSA |
| ER-ESTAB | Establishment Number | Constant | Further identify with EIN |
| ER-OTHER-EIN | Other EIN | Constant | Other EIN used |
| * R99-ER-EIN | Employer Identification Number | Data Base Column | DGV.GOVT_REGIST_NUMBER |
| * R99-ER-NAME | Employer Name | Data Base Column | DED.ENTITY_NAME |
| R99-ER-LOCN-ADDR | Employer Location Address | Constant | Employer’s location address such as 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. |
| R99-ER-DELIV-ADDR | Employer Delivery Address | Constant | Employer’s delivery address such as Street or Post Office Box DLN.ADDRESS_LINE_1 or DLN.MAIL_ADDRESS_LINE_1 Enter blank, system derived |
| R99-ER-CITY | Employer City | Constant | Employer’s city DLN.LOCALITY or DLN.MAIL_LOCALITY Enter blank, system derived |
| R99-ER-STATE | Employer State Abbrev | Constant | Employer’s State abbreviation DSP.STATE_PROVINCE_CODE Enter blank, system derived |
| R99-ER-ZIP | Employer ZIP Code | Constant | Employer’s ZIP Code DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL Enter blank, system derived |
| R99-ER-ZIP-EXT | Employer ZIP Extension | Constant | Employer’s ZIP Code DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL Enter blank, system derived |
| R99-ER-F-STATE | Employer foreign State/province | Constant | Employer foreign state/province or Constant Enter the word NAME or blank |
| R99-ER-F-POSTAL | Employer foreign postal code | Constant | Enter Employer foreign postal code or Constant |
| R99-ER-COUNTRY | Employer country if applicable | Constant | Enter Employer country Enter blank, system derived |
| R99-ER-F-COUNTRY | Employer foreign country | Constant | Enter the word NAME, ISO or blank |
| R99-ER-TAX-JURIS | Tax Jurisdiction Code | Constant | Enter appropriate code or null |
| R99-ER-ACCT-NO | Account Number | Constant, Data Base Column or IDGV variable | For IDGV variable, users can look up the IDGV Field Variable and enter the Account NUmber on IDGV |
| R99-EE-SSN | Employee Social Security Number | Data Base Column | EID.GOVERNMENT_CODE |
| R99-EE-FIRST-NAME | Employee First Name | Data Base Column | EID.FIRST_NAME |
| R99-EE-MIDDLE | Employee Middle Name | Data Base Column | EID.MIDDLE_NAME |
| R99-EE-LAST-NAME | Employee Last Name | Data Base Column | EID.LAST_NAME |
| R99-EE-SUFFIX | Employee Suffix Name | Data Base Column | EID.RANK with derivation expression Decode(~,’01’,’JR’,’02’,’SR’,NULL) |
| R99-EE-LOCN-ADDR | Employee Location Address | Constant | Employee’s location address such as 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. |
| R99-EE-DELIV-ADDR | Employee Delivery Address | Constant | Employee’s delivery address such as Street or Post Office Box EPS.ADDRESS_LINE_2 or EPS.MAIL_ADDRESS_LINE_2 Enter blank, system derived |
| R99-EE-CITY | Employee City | Constant | Employee’s city EPS.LOCALITY or EPS.MAIL_LOCALITY Enter blank, system derived |
| R99-EE-STATE | Employee State Abbrev | Constant | Employee’s State abbreviation DSP.STATE_PROVINCE_CODE Enter blank, system derived |
| R99-EE-ZIP | Employee ZIP Code | Constant | Employee’s ZIP Code EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL Enter blank, system derived |
| R99-EE-ZIP-EXT | Employee ZIP Extension | Constant | Enter employee’s ZIP Code EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL Use derivation expression substr(~,6) for ZIP extension |
| R99-EE-F-STATE | Employee foreign State/province | Constant | Employee foreign state/province or Constant Enter the word NAME or blank |
| R99-EE-F-POSTAL | Employee foreign postal code | Constant | Employee foreign postal code Enter blank, system derived |
| R99-EE-COUNTRY | Employee country if applicable | Constant | Enter Employee country Enter blank, system derived |
| R99-EE-F-COUNTRY | Employer foreign country | Constant | Enter the word NAME or the word ISO or blank |
| R99-CONTROL-PRT | Print Control Number on Form | Constant | Null, 0 – Do not print Control Number on R99 Form 1 - Print Control Number as defined in R99-CONTROL-NUM Identifier 2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt 3 - Print R99-CONTROL-NUM Identifier and Person Code 4 - Print ‘Sort Level By’ prompt and Person Code 5 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier 6 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier and Person Code |
| R99-CONTROL-NUM | Control Number on Form | Data Base Column | Enter your company data |
| R99-DATE-OF-PAYMENT | Date of Death Benefit Paid | Data Base Column | EID.DATE_OF_PAYMENT. See note below for setup |
| R99-EXCLUDE-EE | Exclude Employee | Data Base Column | Enter your company data |
| R99-GROSS-DISTR | Gross Distribution | Element | F1099R-BOX-01 |
| R99-TAXABLE-AMT | Taxable Amount | Element | F1099R-BOX-02A |
| R99-TXBL-NOT-DET | Taxable Amount Not Determined | Element | F1099R-BOX-02B-1 |
| R99-TXBL-TOT-DIS | Taxable Amount Total Distribution | Element | F1099R-BOX-02B-2 |
| R99-CAPITAL-GAIN | Capital Gain | Element | F1099R-BOX-03 |
| R99-FIT | Federal Income Tax Withheld | Element | F1099R-BOX-04 |
| R99-EE-ROTH | Employee Roth Contributions | Element | F1099R-BOX-05 |
| R99-NUA-ER-SEC | Net Unrealized Appreciation ER Securities | Element | F1099R-BOX-06 |
| R99-DISTR-CODE | Distribution Code(s) | Constant | Enter your company data |
| R99-IRA-SEP-SIMP | IRA or SEP or SIMPLE | Element | F1099R-BOX-07 |
| R99-OTHER-DOL | Other Dollars | Element | F1099R-BOX-08 |
| R99-OTHER-PERC | Other Percent | Element | F1099R-BOX-08-1 |
| R99-PERC-DISTR | Percentage of Total Distribution | Element | F1099R-BOX-09A |
| R99-EE-CONTR | Total Employee Contributions | Element | F1099R-BOX-09B |
| R99-1ST-YR-ROTH | First Year Roth Contributions | Element | F1099R-BOX-ROTH |
The values from R99-CODE-1 to R99-CODE-T are for Box 7 Distribution Codes and are for documentation purposes only. There is no need to set these identifiers up.
| Field Identifier | Description | Suggested Field Source | Suggested Variable |
|---|---|---|---|
| R99-CODE-1 | Early Distr, no known exceptions | Pay Component | Enter your company data |
| R99-CODE-2 | Early Distr, exception applies | Pay Component | Enter your company data |
| R99-CODE-3 | Disability | Pay Component | Enter your company data |
| R99-CODE-4 | Death | Pay Component | Enter your company data |
| R99-CODE-5 | Prohibited transaction | Pay Component | Enter your company data |
| R99-CODE-6 | Section 1035 exchange | Pay Component | Enter your company data |
| R99-CODE-7 | Normal distribution | Pay Component | Enter your company data |
| R99-CODE-8 | Excess contribution earnings deferrals 2018 | Pay Component | Enter your company data |
| R99-CODE-9 | Cost current life insurance | Pay Component | Enter your company data |
| R99-CODE-A | Eligible 10 year tax option | Pay Component | Enter your company data |
| R99-CODE-B | Roth account distribution | Pay Component | Enter your company data |
| R99-CODE-D | Excess contribution earnings deferrals 2018 | Pay Component | Enter your company data |
| R99-CODE-E | Excess 425 or 403(b) | Pay Component | Enter your company data |
| R99-CODE-F | Charitable gift annuity | Pay Component | Enter your company data |
| R99-CODE-G | Rollever contribution | Pay Component | Enter your company data |
| R99-CODE-J | Early distribution Roth IRA | Pay Component | Enter your company data |
| R99-CODE-L | Loans distribution 72(p) | Pay Component | Enter your company data |
| R99-CODE-N | IRA contributions 2018 | Pay Component | Enter your company data |
| R99-CODE-P | Excess contribution earnings 2018 | Pay Component | Enter your company data |
| R99-CODE-Q | Qualified distributions Roth IRA | Pay Component | Enter your company data |
| R99-CODE-R | IRA contributions 2018 | Pay Component | Enter your company data |
| R99-CODE-S | Early distribution SIMPLE IRA 2 yrs, no exception | Pay Component | Enter your company data |
| R99-CODE-T | Roth IRA distributions, exception applies | Pay Component | Enter your company data |
The values from R99-OTHER-01 to R99-OTHER-20 are for future use. There is no need to set these identifiers up.
| Field Identifier | Description | Suggested Field Source | Suggested Variable |
|---|---|---|---|
| R99-OTHER-01 | Your company description | Pay Component | Enter your company data |
| R99-OTHER-nn | Your company description | Pay Component | Enter your company data |
| R99-OTHER-20 | Your company description | Pay Component | Enter your company data |
Set up the following State/Local Identifiers, if necessary.
| R99-STATE-CODE | State Code | Data Base Column | DSP.STATE_PROVINCE_CODE | |
| R99-STATE-REGIST | State Registration I.D. No | Data Base Column | DGV.GOVT_REGIST_NUMBER | |
| R99-STATE-DIST-HOME | State Distributions (Home State) | Element | R99-STATE-DIST-H | |
| R99-STATE-DIST-WORK | State Distributions (Work State) | Element | R99-STATE-DIST-W | |
| R99-STATE-TAX-HOME | State Income Tax (Home State) | Element | R99-STATE-TAX-H | |
| R99-STATE-TAX-WORK | State Income Tax (Work State) | Element | R99-STATE-TAX-W | |
| R99-CNTY-NAME | County Name | Data Base Column | DCN.COUNTY_NAME | |
| R99-CN-DIST-HOME | County Distributions (Home County) | Element | R99-CNTY-DIST-H | State |
| R99-CN-DIST-WORK | County Distributions (Work cOUNTY) | Element | R99-CNTY-DIST-W | State |
| R99-CN-TAX-HOME | County Tax (Home County) | Element | R99-CNTY-TAX-H | |
| R99-CN-TAX-WORK | County Tax (Work County) | Element | R99-CNTY-TAX-W | |
| R99-CITY-NAME | City Name | Data Base Column | DTX.JURISDICTION_NAME | |
| R99-CI-DIST-HOME | City Distributions (Home City) | Element | R99-CITY-DIST-H | |
| R99-CI-DIST-WORK | City Distributions (Work City) | Element | R99-CITY-DIST-W | |
| R99-CI-TAX-HOME | City Tax (Home City) | Element | R99-CITY-TAX-H | |
| R99-CI-TAX-WORK | City Tax (Work City) | Element | R99-CITY-TAX-W |
