Data Integrity Checks
Closing the Year
W2s and W2-Cs
This document details the necessary steps to be followed in order to complete the End of Year Processing (EOY) in TempWorks Software. It involves the completion of Data Integrity Checks, creating and printing the W2's and 1099's, and creating state and federal mag media files.
Year end processing can be run at System level or at EINC (Entity) level for reporting once your year has been closed. The year must be closed by Tempworks if you are a hosted client. Please call our support line to schedule your Year End process by the end of November.
To access the year end processing in Enterprise, navigate to pay/bill, then select year end from the list of options on the left.
If the year is not yet displayed, you will need to add the year you need to process. To do this, click on the sign located in the upper right. The form below will be displayed. Add the year and select either System level or the EINC from the dropdown.
Note: You can only have one Year created per Entity.
You will then be brought in to the Year End worksheet. This step by step process will walk you through closing the year. Below we will cover each step, as well as best practices. Please review each step in detail before beginning the process. If you have questions throughout, don't hesitate to contact TempWorks, but please note there are also tool tips built in. Placing your mouse over buttons or reports will provide you with additional details regarding that item.
Step 1: Run Integrity Check
Click on Run Check to run the data integrity check.
The Integrity check is checking for potential errors and missing data.
Once you've completed the integrity check, the Data Integrity Check Report will be displayed. Use this report to view the any errors or potential discrepancies.
Data Integrity Check report reviews the following;
a. Checks for employee name, address etc errors
b. Checks for wage discrepancies
c. Gives warnings for things that need to be verified such as employees with over 9 exemptions.
Note: Viewing this report does not re-run the check. The report is displaying the results of the most recent check.
Correct errors, if applicable, or contact TempWorks for assistance. If any information has been changed and/or you've corrected errors, rerun the integrity check and integrity check report to ensure accuracy.
If no errors were received, the Integrity Check Addressed step should be automatically marked complete and the Check Finished box will be grayed out. If there are errors or discrepancies that you wish to approve, manually click on the Check Finished box to mark this step complete.
Run the Estimated 1099 Count Report.
- This report provides an estimate of how many 1099's will be created in the system at year end. This report is helpful in knowing how many 1099's to order.
Run the Estimated W2 Count Report.
- This report provides an estimate of how many W2's will be created in the system at year end. It is helpful to run this report to know how many W2's to order.
Step 2: Initialize New Year
Initializing the New Year is essentially the point of no return. It is best practice to ensure you have closely reviewed the Data Integrity Check report and the Tax Deposit or Payroll Journal Report to ensure all items are accurate. Initializing the year takes all current year information, saves it off, and sets the system up for the New Year. Any corrections or voids that need to take place after this step has been completed will need to be done with the assistance of TempWorks.
Once you've confirmed that information is accurate and you are ready to initialize the New Year, click on Run Init to Initialize New Year.
Note: This must be done by a Tempworks support rep if you are hosted.
Step 3: Generating W2 and 1099 Data
To generate W2 data, click on Generate to the right of W2.
To generate 1099 data, click on Generate located on the right of Generate 1099 Data.
Note: Generating, regenerating, and refreshing W2 and 1099 data must be done at System level.
Note: You can refresh the employer and employee data (if you've made any changes) by using the more options dropdown. If this is necessary, once you've completed the refresh, you need to regenerate the data. To complete this, click on more options, select Refresh Employer Data, and then click on Regenerate.
Once you've generated the data, is it best practice to review the following reports to ensure accuracy.
Federal W2 Summary. This report breaks out the wages and tax withheld amounts shown on the W2's for Federal taxes. This can be expanded to see the detail per employee.
State W2 Summary. This report breaks out the wages and tax withheld amounts shown on the W2's for State taxes. It summarizes by state and can be expanded to see the detail per employee.
Local W2 Summary. This breaks out the wages and tax withheld amounts shown on the W2's for Local taxes. It summarizes by state and can be expanded to see the detail per local and employee.
Step 4: Downloading W2's, 1099's, W3's, 1096's, and Employer W2's
Once you have generated the W2 and 1099 data, when ready, download this information by clicking on Download in Step 4.
Once you click on Download, you will be prompted with the following screen;
Select your desired sorting option.
You can sort by Employee, Branch, or State.
Additionally, you can filter based on EINC, State, Branch, and Employee Status.
When downloading, check the Include Employees who opted for an electronic W2 box if you wish to also download paper W2's for these employees.
If you wish to download two states or local jurises per W2, check the box accordingly.
Note: It is considered best practice to download only one state and only one local juris per W2.
Once you've selected your desired sorting and filter options, click Download located on the lower right.
Your W2s will be downloaded onto a CSV file and can be saved to a desired location - Tempworks will either print and mail your W2s for you (please contact your Account Manager if you are interested in this option) or this downloaded file can be provided to your third party printing provider.
If using WebCenter and employees will be accessing their W2 information via the Employee Portal you must determine when they can access this. To enable the employees to pull this information, use the more options dropdown and select Enable WebCenter W2 Download. This makes the information accessible on the Employee Portals and employees can then download their W2's electronically.
Note: Only W2's are available via the employee portal. 1099's are not accessible via the employee portal.
If you find that there are errors in the data and you need to make corrections, retract the WebCenter W2's by using the same dropdown to Disable WebCenter W2's. This will remove the ability to each employee to pull their W2 from WebCenter. Once the corrections are made, you can then Enable WebCenter W2's again.
To print your W3's, 1096's, and Employer W2 Form, click on Print located to the right of each option.
It is good practice to verify the W3 against your Federal W2 Summary. The W3 should match the Federal W2 Summary report.
Step 5: Pass Mag Media Data Check
TempWorks will not generate Mag Media files unless the Mag Media Data Check has been run. Click on Run Check to complete this process.
Once you've completed the check, the Mag Media Data Integrity Check report will be displayed. Use this report to view any possible errors. Errors may occur if there is missing Employer information that needs to be included in the Mag Media file. If errors occur, it is recommended to contact TempWorks as depending on the error, it may be necessary to refresh or regenerate data in steps 2-4.
The Mag Media Data Integrity Check Report is similar to the Data Integrity Check report; however, instead of looking at the core check data it looks at the W2 data which is used to generate the mag media files from.
Note: No errors are permitted to move past this step. All errors must either be fixed, or pryear table must be manually updated.
Step 6: Download Federal, State, and Local Mag Media files
Once the Mag Media checks have been completed, you can download the Federal, State, and Local Mag Media files.
Click on Download next to each option to generate and download the data. Once you've generated the data, pull the
Mag Media Totals Report report. This report will show the mag media data (which is basically the W2 data) by state, local and federal.
If at any time changes are made and you need to regenerate the Mag Media files, you can do so by selecting Regenerate Mag Media from the more options dropdown.
Step 7: Close Year
Once all information has been downloaded and printed, click on Close Year in step 7. As with the other steps, a checkmark and time and date stamp will be displayed once it is complete.
Note to Self Hosted Clients: If at any time you are unable to complete a step, and therefore unable to move on to the next step, you'll need to update the pryear table directly. Once the table has been updated, within Enterprise, the user will need to navigate off of the year end screen, and come back in, for it to refresh.