Are there reports I can use to track my COVID-19 Pays and Employer Social Security Amounts?

These reports have not been QA'd and are provided as a reporting tool.

Important Note: The revised form 941 and instructions that outline the changes to Form 941 associated with reporting of the COVID-19 related Sick and FLMLA pays and Social Security wages have been finalized by the IRS as of 06-27-2020.

Information for reporting COVID-19 Emergency Pays on W-2 forms can be found in 2020 W2 Reporting Requirements for COVID-19 Pays

• The COVIDPaysTaxReport.rpt can be used to show the wages for your COVIDSICK and COVIDFMLA pays.
  Attachment: COVIDPaysTaxReport.rpt
  
  • This report is not specific to those exact ID's and provides prompt fields for you to enter your exact Pay ID.
  • This report combines the FWH, MED, MEDADDL and SOC tax paid by your employee, as well as the MED_E, Subject to MED_E, SOC_E, Subject to SOC_E and Health Fringe paid by the Employer.
  • There is a prompt field where you can enter your Employer Health Fringe ID.
  • This report runs by Check Date, and can be run from your New or Current PR transaction files.
  • The report includes the Subject to for MED_E and SOC_E for COVIDSICK and COVIDFMLA. You'll need this information when filling out the 941 report, Part 1 Section 5.
  • For steps to add this report to your menu, see How do I save, add, and print a report design?

• The COVIDPaysTaxReportRevisedDecember2020.rpt can be used to show the wages for your COVIDSICK,COVIDFMLA and COVFMLA10 pays.
  Attachment: COVIDPaysTaxReportRevisedDecember2020.rpt
  
  • This report is not specific to those exact ID's and provides prompt fields for you to enter your exact Pay ID.
  • There is a prompt field where you can enter your Employer Health Fringe ID.
  • This report runs by Check Date, and can be run from your New or Current PR transaction files.
  • The report includes the SOC_E amounts associated with the COVIDSICK, COVIDFMLA and COVFMLA10. You'll need this information when filling out the 941 report, Part 1 Section 5. You may need this information when filing form W-2 as well.
  • For steps to add this report to your menu, see How do I save, add, and print a report design?
• The COVIDPaysTaxReportbyCheckDate.rpt and COVIDPaysTaxReportbyCheckDateRevisedDecember2020.rpt can be used to show the wages for your COVIDSICK,COVIDFMLA and COVFMLA10 pays sorted in check date order and include monthly check date and monthly totals. These report can be used to calculate the amounts needed to fill out form 941 Schedule B.
  Attachment: COVIDPaysTaxReportbyCheckDate.rpt
  Attachment: COVIDPaysTaxReportbyCheckDateRevisedDecember2020.rpt
  
  • The pays associated with the FFRCA are not subject to Employer Social Security. Sage 300 CRE Payroll is not able to exclude the amounts of the COVID-19 related pays from the calculation of wages that are subject to Employer Social Security because the wages are still Subject to Employer Medicare where the option to set the Pay as Exempt from the employer taxes for FICA would apply to both Medicare and SOC_E.
  • For steps to add this report to your menu, see How do I save, add, and print a report design?
• The PRCOVID19SOCETaxCalculationReport.rpt and PRCOVID19SOCETaxCalculationReportRevisedDecember2020 can be used as a means to report the amounts of COVID-19 Pays that accumulated SOC_E taxable and subject to wages.
  Attachment: PRCOVID19SOCETaxCalculationReport.rpt
  Attachment: PRCOVID19SOCETaxCalculationReportRevisedDecember2020.rpt
  
  • This report is inclusive of all pays on each check, and is provided as an additional tool to assist with adjustments to payroll tax deposits as well as quarter and year end federal reports.
  • For steps to add this report to your menu, see How do I save, add, and print a report design?