Reporting for the CARES Act (H.R. 748) Paycheck Protection Program
Description

Cause

The Paycheck Protection Plan from the C.A.R.E.S. Act authorizes up to $349 billion in forgiveable loans to small businesses to pay their employees during the COVID-19 crisis. All loan terms will be the same for everyone.
For additional information, including what qualifies the loan to be forgiven, please see the SBA's Paycheck Protection Program page.

NOTE: Sage is closely monitoring government reporting (e.g. 941). This article may change as more information becomes available. Reporting for PPP loans will not be required until Q2. It is recommended to work with your accountant or CPA to determine which program(s) under the C.A.R.E.S. Act will be best for your business.

Resolution
[BCB:5:Third-party support:ECB]

The loan application process requires specific Payroll reports.


For your 2019 IRS Quarterly 940, 941, or 944 Payroll Tax reports, use your Aatrix saved reports to provide these documents. They can be saved as a PDF or printed. If you are required to provide 2019 W2's use your Aatrix Saved Reports to reprint or save the file to a PDF. For details refer to KB article ID 37617, DocLink: How to reprint saved payroll and accounts payable tax forms

For Gross wages for each employee, including officer(s) if paid W2 Wages:

  • Go to Federal State Tax Reporting and reprint W-2s for last year.
  • Check History Report > Selection Criteria = By Check Date Range > Uncheck the Print Check Details checkbox > select Print Taxes checkbox. Gross Earnings will print on the report.
  • Quartery Tax Report will print QTD and YTD Gross Wages

For PTO, Vacation Pay and Family Medical Leave Pay for Each Employee use the following reports

  • Check History Report > Selection Criteria = By Check Date Range > Uncheck the Print Check Details checkbox > select Print Earnings checkbox. Earnings summarized by employee/earnings code will print on the report.
  • Earnings Report, (can only do by quarter, which will include YTD) > Select the earnings for PTO, Vacation, and Family Medical Leave. Selection criteria = Equal To

For State and Local Taxes assessed on each Employee's earnings use the Subject to by Date Range

  • Go to Federal State Tax Reporting and reprint W-2s for last year.
  • Check History Report > Selection Criteria = By Check Date Range > Uncheck the Print Check Details checkbox > Select Print Taxes checkbox. Taxes summarized by employee will print on the report.
  • Quartery Tax Report will print YTD taxes.

For Fringe amounts for a specific date range:

  • Check History Report > Selection Criteria = By Check Date Range > Uncheck the Print Check Details checkbox > Select Print Earnings and Deductions checkbox. Earnings and deductions summarized by employee/earnings code and employee/deduction code will print on the report.
  • If fringes are employer contribution deductions, then the Deduction Report (can only do by quarter, which will include the YTD) > select the deduction codes > separated by commas, for those deductions > Selection criteria = Equal To.
  • If fringes are earnings then print Earnings Report (can only do by quarter, which will include YTD) > select the earnings code for Fringe earnings > Selection criteria - Equal to.

For Vendor 1099 payment information:

  • Go to Accounts Payable > Reports. Select the Payment History Report. When printing the Payment History Report, enter the applicable Range of Dates and select the Print 1099 Vendors Only checkbox.

NOTE: For additional assistance customizing reports and/or creating documents please contact your Consultant or Buiness Partner.

DocLink: How do I set up to pay employees Emergency Paid Sick Leave and Emergency Family Medical Leave associated with the HR_6201 - Families First Coronavirus Response Act (FFCRA) in Sage 100?
DocLink: Reporting for the CARES Act (H.R. 748) - Employee Retention Credit
DocLink: How to setup and track costs for a Paycheck Protection Program (PPP) loan in Sage 100

[BCB:155:Chat 100 US:ECB]

Steps to duplicate
Related Solutions