PAY Report: Unemployment Compensation Tax

Overview

Unemployment Compensation Tax Report options are accessed from Payroll Reports. Use the Unemployment Compensation (UC) Tax report to gather unemployment compensation detail for each state and the federal government. This report displays Gross and Taxable Earnings for each employee (although there are a few state UC formats that do not want the 'Taxable' earnings shown on the report).

Formats that include timekeeping hours information will only look at paid Timekeeping records. Subcontractor Checks are excluded from this report. This report should be run at the end of each quarter. You may print this report or prepare an electronic file.

Important:  For security reasons, TEAM cannot upload files to states on your behalf. You must upload the file to the state’s website using your user name and password. Contact the state directly if you need assistance, or if you encounter an error during the upload process (after you inform TEAM about the error). To help avoid upload errors, be sure to review your account numbers and make sure they don’t contain any hyphens or negative amounts before filing.


To prevent possible errors from coming back when filing the electronic files, the program will remove all ASCII characters from the employee’s name when creating each electronic file. These include the following characters:

~ ! @ # $ % ^ & * ( ) _ = ` { } [ ] \ , . ; ' : " < > ? - + / |

Note:  

Illinois

Beginning with the 2020 tax year, a Schedule P (Illinois Withholding Schedule) must be filed with every Form IL-UC (Illinois Withholding Income Tax Return). This file is created when you create the current IL UC electronic file. A prompt to save the file displays following completion of the existing file and summary. The default location for the file is the location selected for the original file and the default name is ILUIMonthlyWage-SchedulePxxxxxx (xxxxxx is the quarter ending date-for example 063020). You can edit both the location and file name.

Maryland

The electronic file for MD UC (Maryland Unemployment Compensation) is created created as a .csv file, but to retain the correct formatting it should be opened using Notepad (or similar app) instead of Excel. If opened using Excel, we cannot guarantee the data will remain in the correct format.

Texas

If you are filing Texas unemployment compensation, download the QuickFile program from the state and use this to upload your ICESA file to the state of Texas. Before filing, review the records to ensure there are no negative amounts or invalid UC Account Numbers.

Virgin Islands

The Virgin Islands does not accept an electronic file, instead they require the information in an Excel spreadsheet. To create this required spreadsheet, use the Report output type.

Key Functionality

Security

The PAY: Report Unemployment Compensation Tax screen has its own Security Group, PAY Report Unemployment Compensation Tax, which is part of the PAY Reports All Employees. For more information see Learning about Security Groups.