Create a spreadsheet with the specific column headings listed below.
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.
- Fill in the ID, code “001” for the Federal Payroll Item, and the amounts that you have tracked for each individual.
- The 3 COVID fields have max amounts.
- COVID Self - $5,110
- COVID Other - $2,000
- COVID Emergency - $10,000
Save the spreadsheet as a .csv.
Tip 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.
- Once your spreadsheet is complete you can upload the data through Utilities/Mass Load, using FederalTaxItem PayrollItem for the Importable Entities.