There is required set up for 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 1099R 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.
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
The seed data (SEED_RP1099RWWW_20181220.sql) provided will create new user fields as follows:
After loading the seed data, confirm these 2 fields are created.
On IDFDV, for the new “R99-DATE-OF-PAYMENT’ Identifier, the field variable column must be set to “EID.DATE_OF_PAYMENT”.
On the Maintain Identity Information (IEID) form, in the ‘Date of Death Benefit Paid’ User Field, the date must be entered for the defined employees.
Users can copy the IDFDV Variable definition from last year to the current year. Please refer to the Copy Last Year’s definition to Current Year section, below.
This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code.
IMPORTANT: Users must run the RPYEU process with the new IDFD HL$US-1099R-2019 Form Code, or users can run a copy of this Form Code that has the Store Option set up to store the Addresses and the Amounts in the Government Remittance Tables.
Any prior year’s Form Codes do not supply this Option and therefore will not turn on the Store feature for the RPYEU process.
1) On the IDFDV form, select last year’s Form Code: HL$US-1099R-2018
2) Press the Copy Form Definition button
3) The Copying dialog box is displayed. Enter the current year New Form Code: HL$US-1099R-2019
4) Set the Copy Definition with Variables toggle to ON. This will copy the variables set up from HL$US-1099R-2018 to HL$US-1099R-2019 for the same Field Identifier name.
Users should only work with the Source and Field Variable columns. The Derivation Expression field can be used by advanced users or under the guidance of a High Line consultant.
On this form, users define where, in their particular set up, each required field of data is to be retrieved from.
Field | Desciption |
---|---|
Seq # | Defines the sequential order of the variable. |
Identifier | The fields within this form are defined here. |
Description | Enter a short description of the variable. |
Level | Defines the field level, such as employee, employer, federal, etc. |
O/R Prompt | The override name of the field that will be displayed on the form is defined here. |
Source | Defines the type of source of the field, such as database column, element, pay component, etc. |
Field Variable | The variable for the field is defined here. |
Copy Form Definition | Press this button to copy the form definition. |
Field Usage | Defines the field usage, such as file only, form only, internal, etc. |
Text | Users can add additional notes in this field |
Derivation Expression | Users can add programming code for additional computation of the data within the record. |
IDFDV HL$US-1099R-2019 Form Code Identifiers
IDFD Form: HL$US-1099R-YYYY – system provided
IDFD Form Type: US 1099R Definition
NOTE: Fields marked with an asterisk (*) are MANDATORY
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-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 # |
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. |
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-ALLOC-TO-IRR | Amount allocable to IRR within 5 years | Pay Component | F1099R-BOX-10 |
R99-1ST-YR-ROTH | First Year Roth Contributions | Element | F1099R-BOX-ROTH |
R99-FATCA | FATCA Requirement | Element | F1099R-BOX-10-FATCA |
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 415 or 403(b) | Pay Component | Enter your company data |
R99-CODE-F | Charitable gift annuity | Pay Component | Enter your company data |
R99-CODE-G | Rollover 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 |
R99-CODE-U | ESOP under section 404(k) | Pay Component | Enter your company data |
R99-CODE-W | Payments for LT Care Insurance | Pay Component | Enter your company data |
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 |
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 |
R99-CN-DIST-WORK | County Distributions (Work cOUNTY) | Element | R99-CNTY-DIST-W |
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 |
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:
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.
Election workers earnings should NOT be reported on the 1099R if:
Users can manage this reporting as follows:
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:
For RP1099RW4C/RP1099RW4TB (Windward versions), users must select the GVT Run number that the employee belongs to when RPYEU is run.
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.
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. |
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:
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. |
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.
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.
Options are:
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:
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 |
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 |
To mail 1099R forms at a discounted rate, when RPYEU is run, users should select to Sort Employees By:
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.
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.
Seq 2800 1099R-CONTROL-PRT
Print Control Number on Form
Field | Description |
---|---|
Form Code | Use current year's form code |
Identifier | 1099R-CONTROL-PRINT |
Level | Federal |
O/R | CONTROL NUM PRT |
Source | Constant |
Field Variable | Options are: *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
Field | Description |
---|---|
Form Code | Use current year's form code |
Identifier | 1099R-CONTROL-NUM |
Level | Federal |
O/R | CONTROL NUMBER |
Source | Data Base Column |
Field Variable | Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc. |
NOTE: If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
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.
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 |
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 Type | To define and report on a specific Federal Registration type, defined 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 Type | To define and report on a specific State Registration type, defined on IDGV. Optional |
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 Regist Type | To define and report on a specific Local Registration type, defined on IDGV. Optional |
Local Regist 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 |
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. |
Report Parameters | Description |
---|---|
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 | Description |
---|---|
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. |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation