Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Mass Load Instructions for Federal Deduction COVID Reporting

Using the UtilitesUtilities/Mass Load program, the 3 COVID reporting fields can be imported into the Federal Deduction with a spreadsheet. These amounts will appear on Box 14 of the employee's W2.

  1. Create a spreadsheet with the specific column headings listed below. 
    • number
    • code
    • COVID19SelfAmount.value
    • COVID19OthersAmount.value
    • COVID19EmergencyFamilyAmount.value
  2. Fill in the ID, code “001” for the Federal Payroll Item, and the amounts that you have tracked for each individual.
  3. If you have a large number of employees to load, another option would be to load the COVID Federal Deduction Fields.json file from the report repository into your reports manager to create your spreadsheet with the Employee ID and configuration code already populated.
  4. The 3 COVID fields have max amounts.
    • COVID Self - $5,110
    • COVID Other - $2,000
    • COVID Emergency - $10,000
  5. Save the spreadsheet as a .csv. Remember the format of the Federal Configuration Code column needs to be 3 characters in length for the system to recognize the leading zeros in the 001 deduction.
  6. Once your spreadsheet is complete you can upload the data through Utilities/Mass Load, using FederalTaxItem for the Importable Entities.