You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Loading instructions for Federal Deduction COVID reporting
Classic
Using the USPLOAD/DEDSCN 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 spreadsheet with the specific column headings listed below:
    • EMPLOYEE_ID
    • DED_CODE
    • COVID_SELF
    • COVID_OTH
    • COVID_EMER


  • 2. Fill in the ID, code for Federal "001", and the amounts that you have tracked for each individual.


  • 3. The 3 COVID fields have max amounts.
    • COVID Self - $5,110
    • COVID Other - $2,000
    • COVID Emergency - $10,000


  • 4. Save the spreadsheet as a .csv. Remember the format of the DED_CODE column needs to be 3 characters in length for the system to recognize the leading zeros in the 001 deduction.


  • 4. Transfer the .csv file to Reflections using FileZilla or the File Transfer in Reflections
  • 5. To upload the data go to USPLOAD, then the DEDSCN option.

  • 6. View the COVID amounts in your employee's 001 Federal Tax Deduction Record.
  • No labels