Adding Employer-Sponsored Health Coverage Values to W2s

Overview

You wish to add Employer-Sponsored Health Coverage medical values to the W2 forms

  

Solution

1. Create the User Defined Data: 

  1. Click the Options Menu on your Cort Payroll main window and then click on User Defined Data Definitions:
  2. Enter the new Form name (or select an existing one if you want to update it) The example here uses the name W20, but you can name it anything you wish. 
  3. Then Add the Screen Title. To do this:
    • Click on New Item:
      mceclip1.png
      Populate the fields with the following values:
      • Item Name - Item Name, (The example here uses W20)
      • Type (a/n/d) - N
      • Characters - 9
      • Decimals - 2
        Click OK:
    • Double click the New Item field as highlighted in the right-side pane and add the position data as: 
      • Left - 100
      • Top - 685
        Click OK: 
    • Double click on the New Item title that appears in the right side pane (w20 in this example) and populate the fields with the following values: 
      • Left - 135
      • Top - 400
        Click OK:


    • Click OK on the User Defined Data Definitions window to save the Form:


2. Add the new definition to the Input file format:

  1. On your CORT Payroll main window, navigate to Options -> Entry Control Specifications -> External Input File Formats.
    • Select the Format code or create a new one, where the new 'User Defined Data' will be added
    • Double click on userdata from the Items list to display all the user-defined items:
    • Select the required user-defined item for the external input file, created on Step 1.- Create the User Defined Data, in this case W20:

 

3. Prepare the file to be imported to CORT: 

  • Open a new Excel file and keep only the two columns that are needed: The Employee Code and the W20, which is the dollar amount of Employer-Sponsored Health Coverage provided to each employee. 
  • Make sure that the two columns have no headers, i.e. data entries start from row 1.
  • Format the entries in the second column as numbers: (to be displayed as 1234.56 instead of 1,234.56)
  • Save the file as a UTF-8 CSV file, naming it as 'YYYY med ins.csv'. Open the saved file using a text editor such as Notepad. It should display entries in a format similar to the following: 


4. Import the Prepared File:

  1. Import the file prepared by going to Entry > Read external Input File on the CORT menu:

  2. Then,
    • Select the same File Format that you selected under the "Format Code" header in Step 2.
    • Click on Read File to search our file, selecting the CSV file created in the previous step:
    • Add a comment for the change and click OK
    • Once completed close the Data Import Function window
      ​​

 

5. Run the W2 Utility on Reports: 

  1. Navigate to CORT > Reports > W2's:

    ​​
  2. Process the new records on the Actions > Prepare Totals Menu:


    You will get the following alert after the totals are computed:

    ​​
  3. Navigate to the Boxes tab on the W-2 Utility. Double click on the box where you wish the Employer-Sponsored Health Coverage to be added. In this example, the box selected is the 12a box: 
    ​​

  4. Add the new W20 values to this box. 
    1. Select code 'DD' - Cost of employer-sponsored health coverage on the W-2 Box Value Definition​.
    2. Delete any existing user-defined codes
    3. Select Type 'User Defined Item'

    4. Select W20 from the Code/Item List

    5. Click on Add:
      mceclip2.png

    Click on OK to save

Testing

To check the results, you can print the result of one employee from Print  > Print One > Employee on the W-2 Utility menu:
mceclip0.png
Check the printed values to confirm whether they are correct. Please contact support if you need any further help. 

Comments

0 comments

Please sign in to leave a comment.