Review the Quarterly Tax Report for federal, state, or local taxes

Quarterly Tax report Summarized

• Sage 100 version 2018 and higher allows you to generate the Quarterly Tax Report for closed years and quarters. This is based on the years to retain option in Payroll Options. Select the applicable Calendar Year and Calendar Quarter options when printing this report.
• For prior period data, the Total Employees, Active Employees, Terminated Employees, Inactive Employees count at the end of the report, will be the current statuses of Employees. The system purges terminated employees at year-end. There’s no data stored with the historical data to report the Employee numbers for prior periods.

In Sage 100 Payroll 2.20.2, the Quarterly Tax Report was enhanced to support changes made by the Families First Coronavirus Response Act (FFCRA). If you paid your employees any Sick or Family Leave wages to your employees using any of the following the Emergency Pay tax rules:

• 800121 (Emergency Paid Sick Leave-Self)
• 800123 (Emergency Paid Family and Medical Leave)
• 800125 (Emergency Paid Sick Leave - Others)

The IRS added lines for these taxes on the 941 Form for 2020. To be consistent with the way amounts appear on the 941 form, the following will occur:

• • Any emergency sick or family leave wages paid under the Families First Coronavirus Response Act (FFCRA) subject to Medicare tax are combined with your regular Medicare wages on the Quarterly Tax Report.
  • The combined Medicare wages are the taxable Medicare wages reported on Form 941 Form, Line 5c, Column 1 (Taxable Medicare wages and tips).

The Social Security taxes that are associated with any of these emergency pay tax rules aren’t combined. These taxes print separately at the end of the Federal Taxes section on the Quarterly Tax Report.

• The employees sick leave wages reported on the 941 Form, line 5a(i) (Qualified sick leave wages) print under the following federal tax groups. Take the combined total of these wages to reconcile to the amount on the 941 Form.
  • FSOCEPSLSWH Federal Social Security Tax EPSLS Withholding
  • FSOCEPSLOWH Federal Social Security Tax EPSLO Withholding

• The employee family leave wages reported on the 941 Form, line 5a(ii), Qualified family leave wages, are printed under the following federal tax group:
  • FSOCEPFMLWH Federal Social Security Tax EPFML Withholding

The Quarterly Tax Report described:

The Quarterly Tax Report produces a summary of each employee's wage and tax information for the current quarter and year for each tax jurisdiction. When the Quarterly Tax Report prints for the fourth quarter, all employees with any earnings for the year are included on the report. This report assists in reconciling your W2/W3 forms, quarterly 941 form, and applicable State quarterly tax forms.

Report options provide for all employees or a range of employees. Federal tax information prints first, followed by state and, if applicable, local information. For departmental Payroll, subtotals are provided by the department. If there is at least one employee with an Earned Income Credit (EIC) or taxable tips reported, EIC information and tip earnings print following the federal taxes information. For each employee, a recap of taxable tips reported, tips deemed to be wages, EIC, and allocated tips is provided.

The State Totals amounts are printed on the final page of the state report; the State Totals columns reflect the sum of all states for which there are wages recorded.

Note: For employees reporting tip wages, Social Security (FICA) tips and Social Security (FICA) tip tax amounts are printed separately under the Taxes Withheld column in the report.

To run the Quarterly Tax report:

1. Open Payroll, Reports, Quarterly Tax Report.
2. If applicable, clear the appropriate check boxes for 'Print Federal Data', 'Print State Data', or 'Print Local Data'.
   •  EXAMPLE: To print the Federal Quarterly Tax Report only, clear the 'Print State Data' and 'Print Local Data' check boxes. 
3. Click the Print or Preview button.