W 2_GOVERNMENT_REPORTING_PROCEDURES
Back to current versionRestore this version

The following steps outline the procedure to produce the W2 Forms and the Government file:

RPREGT

IDFD/IDFDV/RDFD

IDFD

  1. RPYEU
    • RPYEU
      • Produces US Year End Summary Report for the reporting Year or the reporting Quarter
      • Users must use this report to balance to the YTD Register or QTD Register report (RPREGT)
      • Users must check exception messages from this Summary Report and correct any exceptions
      • Generates the Federal Government file in federal format
      • Generates the State File in the federal file format for States that accept the federal file format
      • Generates the State File for States with specific State File format requirements
      • Users must run RPYEU one State at a time to generate State specific file
      • Each State may have its own requirements. Users must verify if that State specific format is supported by RPYEU prior to running RPYEU for a specific State file
      • Generates an XML file for RPW2 (Oracle version) to print the W2 Forms
      • Generates the GVT Run and stores information in IPGR, IPGH for RPW2W (Windward version) to print the W2 forms
      • In utility trace mode, RPYEU generates a .txt file for the SQL Select statement and the .csv trace file
      • Provides an option to generate data dump file in a .csv format for Federal, State, Local, School data for balancing and debugging purposes
  2. IPGR/IPGH
    • IPGR
      • View data by GVT Run Number after RPYEU is run
    • IPGH
      • View data by GVT Header after RPYEU is run for an employee
  3. UPGRUNDO
    • UPGRUNDO
      • Allows users to undo a GVT Run number by employee
      • To undo an erroneous GVT Run due to set up issues or to remove archived GVT info
  4. RPW2 (Oracle)/RPW2W (Windward)
    • RPW2 (Oracle)
      • Produces W2 forms (supporting either a 2-on-a-page or 4-on-a-page format)
      • Reads the .XML file generated from RPYEU to print the W2 forms
      • Prints W2 on pre-printed W2 forms or prints different copies (Copy A, 1, B, C, 2, D ) of the W2 forms along with an option to print 'Employee Instructions' on the back
      • Generates grand totals and exception messages with the RPW2 Execution ID as Execution Run Logs
      • Users MUST use the Execution ID of the RPW2 and run RMEX to get a grand total report
    • RPW2W (Windward)
      • Produces W2 forms (supports 2-on-a-page and 4-on-a-page formats )
      • Reads IPGR/IPGH information generated from RPYEU to print the W2 Forms
      • Generates grand totals and exception messages with the RPW2W Execution ID as Execution Run Logs
  5. RMEX
    • RMEX
      • Produces a Grand Total report from the RPW2 run to balance to the RPYEU report
      • Users MUST enter the Execution ID of the RPW2W run to obtain a grand total report
      • This report is used to balance to RPYEU only. It is not used for government reporting