Table of Contents
PRODUCE US YEAR END SUMMARY#
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. The RPYEU process generates a summary of US payroll year end data.Please click on this link for additional information for the NJ WR-30 format.
Processing Information#
Report Parameters & Filters#
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 reuqired 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 |
