Subscribe to the SSDT Newsletter by clicking here.  Your email will be added to a distribution list.                                                             

Report Bundles

They are here! The Monthly Report Bundle and Payroll Report Bundles have been officially added to USAS-R and USPS-R to replicate the functionality of the Classic MonthlyCD and PayrollCD.

These report bundles are triggered to automatically generate reports when certain events are processed in Redesign. The reports that are generated are sent to a File Archive page where employees can download, view, and print the reports at their convenience. The File Archive pages are organized based on the time period or type of reports included and each shows a description, filename, and timestamp.

In USPS-R, there are fifteen individual Payroll Report Bundles scheduled to run for a variety of events. There are bundles that run for each part of the Payroll process, including when the payroll is posted and when the ACH submission is created. These reports will be tied to a description specific to each payroll so that reports for a specific pay run can be easily queried in the File Archive. There are also events for monthly and quarterly processing, including when the benefit accruals are updated or the ODJFS submission is created. For a full list of Payroll Bundles, events, and to see which reports are included CLICK HERE.

In USAS-R, there is currently one bundle containing all of the Monthly Reports. This contains a group of twenty six standard reports that are generated whenever a Posting Period is closed.  The File Archive for USAS-R is split into tabs for Monthly and Fiscal Year End Archives. When a Posting Period is closed, this Report Bundle will automatically generate the standard reports and send them to a folder in the Monthly Archive specific to the Month and Year of the period that was closed. For a full list of reports included in the Monthly Report Bundle CLICK HERE.

The Fiscal Year End Bundle is currently in the process of being created and is anticipated to be available for the end of Fiscal Year 2020.

In addition to the standard Monthly Report Bundle and Payroll Report Bundles, districts can add custom report bundles to schedule their own reports to run at the same time as the standard reports. This is as simple as creating a new report bundle, and scheduling it to run based on the same event as the standard Report Bundle. These supplemental reports can be sent to the same File Archive folder or emailed. In USPS-R, the easiest way to determine how to schedule an additional bundle is to click the view icon  for the standard bundle that you would like to "match" so that you can copy the Event Trigger and Send to Address for the File Archive into your custom report bundle. A similar method can be used in USAS-R.

For a full walk through of how to add additional Monthly Reports in USAS-R CLICK HERE.

W2 Reporting

In USPS-R you have the capability to create a W2 Report for verification of data as well as the creation of an XML file that will be used by your ITC for the printing of W2’s.  The system also allows for the creation of the W2Tape file which is used for submission of your calendar year end 2019 data to the SSA. You can also create W2 tape files for CCA , RITA and special City reporting. New this year any district that files 10 or more W2 forms with the State of Pennsylvania are now required to file those forms electronically. The USPS-R system now offers the option to create a Pennsylvania submission tape file and transmittal csv file that can be uploaded through eTIDES.

W2 Report-

To create a W2 Report go to Reports/W2 Report and Submission. Click on the Report button.  If you wish to include specific payroll items for Box 14 reporting on the W2 you may enter the code(s) in the  box, click on the Payroll Item and then click “Add.”

*Note- Leased Vehicle information is always included as the first option in Box 14  (if applicable)  and then other selected payroll items will follow.  Only the first 3 payroll items selected for each employee will be listed in the order they were selected on the setup screen.

• W2 Report can be processed as many times as necessary.

W2 XML file-

To create a W2 XML file for W2 printing, under Reports/W2 Report and Submission click on the XML button. If processing immediately after W2 Report the selected Payroll Items for Box 14 will be displayed in the order they were selected for the report. If not immediately after W2 Report then choose the specific Payroll Items you wish to appear in Box 14 on the W2. Click on the   button.

• You will want to Save the W2 FORM DATA XML file to your desktop or a folder of your choosing.
• You will then securely send the XML file to your ITC for printing.

W2 TAPE.SEQ, W2CCA.SEQ  and W2RITA.SEQ  tape files-

To create the W2 Submission file, W2 CCA Submission file, or W2 RITA Submission file, under Reports/W2 Report and Submission click on the Submission button.  Verify all populated district data is accurate. You must enter in a Contact Name, Contact Phone Number and Contact Email Address. Click on the appropriate   or   or   button.

 *Note- Each tape file you wish to create must be run separately.

• Save the respective SEQ file to your desktop or a folder of your choosing.
• You will securely send the W2TAPE.SEQ, W2 CCA.SEQ (if applicable) and W2RITA.SEQ (if applicable) file to your ITC for submission.

W2 Specific City Tape Files-

*Note- you and your ITC must be in agreement on which cities they submit files to.

To create city tape files, under Reports/W2 Report and Submission click on the W2 City Options tab.  Verify all populated district data is accurate. Enter in the Tax Entity Code of the city you are processing the tape file for. Click on the button.

• Save the file to your desktop or folder of your choosing.
• You will securely send the W2CITY_XXXX.SEQ file to your ITC for submission.
• Repeat this process for each specific city that you wish to create a submission file for

W2 Pennsylvania Submission file and Pennsylvania CSV Transmittal File-

To create the Pennsylvania W2 Submission file, under Reports/W2 Report and Submission click on the W2 State Options tab. Verify all populated district data is accurate. You must enter in a Contact Name, Contact Phone Number and Contact Email Address. Click on the   button.

• Save the file W2PA.SEQ file to your desktop or folder of your choosing.

To create the Pennsylvania CSV Transmittal file click the button.

• Save the W2PA_TRANS.CSV file to your desktop or a folder of your choosing.

*Note- When generating the Pennsylvania CSV Transmittal file during the first year of converting to USPSR, quarter amounts will need to be manually added to the generated file. A template file will be generated with placeholders to enter these values. Counts for 1099’s will also have to be manually entered in the file.

• You will need to log into the eTIDES website and upload the W2PA.SEQ file and the W2PA_TRANS.CSV file for submission.

1099 Reporting 

Michelle article...