COVID-19 - Custom reports

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

We have provided a number of custom reports in the Accounting CS Library to help you navigate the requirements of the Families First Coronavirus Response (FFCR) Act, the Coronavirus Aid, Relief, and Economic Security (CARES) Act, and the American Rescue Plan Act of 2021 (ARPA). 

You can easily preview these reports directly from the Accounting CS Library. 

Notes

  • These reports and their associated variables were added over the course of multiple application updates. Verify that you're using the latest version to ensure that all reports can make use of the appropriate variables.
  • These reports were not designed to be filtered by location or department.
  • The calculations on these reports assumes that the ARPA type sick leave (ARPA self care, ARPA other car, and ARPA extended care) are subject to employer FICA-SS liability.

Payroll reports

  • 7200 Worksheet - COVID-19This report can help you complete Part 2 of the 7200 form for Advance Payment of Employer Credits Due to COVID-19.  For further information and for instructions on this form, see About Form 7200, Advance Payment of Employer Credits Due to COVID-19 on the IRS website.
  • Cash Requirements and Deposits - COVID-19. This report includes a section for COVID-19 federal tax deferral and credit amounts. Details
    • CARES Act Employer FICA-SS Tax Deferral. When the Defer payment of ERFICA-SS to the end of 2021 and 2022 checkbox is marked in COVID-19 Acts tab in the Setup > Clients screen, this amount includes the employer portion of the FICA-SS liability within the report date range.

      Note: This calculation is limited to payroll checks dated from March 27, 2020, to December 31, 2020.

    • Employee Retention Credit Available. This is the total amount of FIT Employee Retention Tax Adj that could be applied to the federal tax liability. This item is reported for the bank account with which the liability is associated. 
    • Employee Retention Credit Applied. This is the amount of FIT Employee Retention Tax Adj that could be applied to the federal tax liability without making the liability payment negative. This item is reported for the bank account with which the liability is associated. 
    • Sick Leave Credit Available. This is the total amount paid to employees for COVID-19 special type pay items (COVID-19-related self care, other care, and extended child care for both FFCRA and ARPA).
    • Employer FICA credit available. This is the amount of the employer’s share of FICA taxes based on the COVID-19 and ARPA special type pay items.
    • Credit applied. This is the sum of the COVID-19 and ARPA Sick Leave credit and the employer’s share of FICA taxes that can be applied to the federal tax liability without making the liability payment amount negative.
  • Depository Totals - COVID-19. This report includes a section for COVID-19 federal tax deferral and credit amounts. Details
    • CARES Act Employer FICA-SS Tax Deferral. When the Defer payment of ERFICA-SS to the end of 2021 and 2022 checkbox is marked in COVID-19 Acts tab in the Setup > Clients screen, this amount includes the employer portion of the FICA-SS liability within the report date range.

      Note: This calculation is limited to payroll checks dated from March 27, 2020, to December 31, 2020.

    • Employee Retention Credit Available. This is the total amount of FIT Employee Retention Tax Adj that could be applied to the federal tax liability.  
    • Employee Retention Credit Applied. This is the amount of FIT Employee Retention Tax Adj that could be applied to the federal tax liability without making the liability payment negative.  
    • Sick Leave Credit Available. This is the total amount paid to employees for COVID-19 special type pay items (COVID-19-related self care, other care, and extended child care for both FFCRA and ARPA).
    • Employer FICA credit available. This is the amount of the employer’s share of FICA taxes based on the COVID-19 and ARPA special type pay items.
    • Credit applied. This is the sum of the COVID-19 and ARPA Sick Leave credit and the employer’s share of FICA taxes that can be applied to the federal tax liability without making the liability payment amount negative.
    • Employee FICA-SS Tax Deferral. When the Defer withholding FICA-SS to the end of 2020 checkbox is marked in the Payroll Taxes tab on the Setup > Employees screen, this amount includes the employee portion of the FICA-SS liability within the report date range.

      Note: This calculation is limited to payroll checks dated from September 1, 2020, to December 31, 2020.

  • Employee Retention Credit Summary. This report shows the credit amounts potentially eligible for the Employee Retention Credit. Details
    The amounts in this report are accurate only for employers who had 100 or fewer employees in 2019, and will not be correct for employers who had 101 or more employees in 2019. That calculation is different, due to the criteria for eligibility. For more information, see COVID-19 - Employee Retention Credit.
  • Payroll Tax Summary - Check Detail. This report was updated to include the Deferred FICA-SS tax item, when the Defer withholding FICA-SS to the end of 2020 checkbox is marked for an employee in the Payroll Taxes tab on the Setup > Employees screen.
  • Preprocessing Summary - COVID-19. This report includes a section for COVID-19 federal tax deferral and credit amounts. Details
    • CARES Act Employer FICA-SS Tax Deferral. When the Defer payment of ERFICA-SS to the end of 2021 and 2022 checkbox is marked in COVID-19 Acts tab in the Setup > Clients screen, this amount includes the employer portion of the FICA-SS liability within the report date range.

      Note: This calculation is limited to payroll checks dated from March 27, 2020, to December 31, 2020.

    • Sick Leave Credit Available. This is the total amount paid to employees for COVID-19 special type pay items (COVID-19-related self care, other care, and extended child care for both FFCRA and ARPA).
    • Employer FICA credit available. This is the amount of the employer’s share of FICA taxes based on the COVID-19 and ARPA special type pay items.
    • Credit applied. This is the sum of the COVID-19 and ARPA Sick Leave credit and the employer’s share of FICA taxes that can be applied to the federal tax liability without making the liability payment amount negative.

EFTPS payment worksheets

  • EFTPS Payment Worksheet - COVID-19
  • EFTPS Phone Payment Worksheet - COVID-19

These reports appear similar to the standard reports, but the deferral and credit amounts are subtracted from the federal tax deposit values. With the 2020.2.6 update, we updated these two reports to also exclude the deferred employee portion of FICA-SS.

Paycheck Protection Program (PPP) worksheets

Was this article helpful?

Thank you for the feedback!