941 Quarterly Federal Tax Return - Reports

Use the 941 Quarterly Federal Tax Return - Reports page to generate 941 reports and supporting tax detail reports based on data loaded during the 941 quarterly federal tax return load process.

Generate reports for:

• 941 Federal Tax Return

• FICA Tax

• Medicare Tax

• Federal Tax

1. On the 941 Quarterly Federal Tax Return page, select Reports.

2. Select the Report Type:

   • 941 Federal Tax Return Report: Generates a report that corresponds with the format issued by the IRS.

   • FICA Tax Report: Generates the FICA wages, employee tax, and employer-paid amounts for checks issued during the date ranges entered in the Report Criteria section.

   • Medicare Tax Report: Generates the Medicare wages, employee tax, and employer-paid amounts for checks issued during the date ranges entered in the Report Criteria section.

   • Federal Tax Report: Generates the Federal wages and employee tax for checks issued during the date ranges entered in the Report Criteria section.

3. If you selected FICA, Medicare, or Federal Tax Report, you must select an option in the Employee Detail and Report Sort sections:

   • Employee Detail section:

     • The Employee option includes the following in the report:

       • Employee Number

       • Employee Name

       • Taxable wages: Total wages from all checks for the employee within the entered range

       • Taxes paid: Total taxes from all checks for the employee within the entered range

     • The Employee/Detailed Check option includes the following in the report:

       • Employee Number

       • Employee Name

       • Check Number

       • Taxable wages: For the individual check number

       • Taxes paid: For the individual check number

       • Date issued

       • Date voided (if applicable) 

   • Report Sort section:

     • Department/Name sorts by department first, then employee name within a department

     • Name sorts by employee name

4. Select the Reporting Year for the 941 Quarterly Federal Tax Return report.

5. Select a Reporting Quarter:

   • 1 - 1st quarter

   • 2 - 2nd quarter

   • 3 - 3rd quarter

   • 4 - 4th quarter

6. Select the Employer Federal Tax ID for the 941 Quarterly Federal Tax Return report. This is not required for the FICA, Medicare, or Federal Tax reports.

7. In the Check Issue Date Range and Check Void Date Range fields:

   • If you select Report Type 941 Federal Tax Return Report, the system defaults the start and end dates of the quarter, and the fields are read-only.

   • If you select one of the other report types, you must enter a date range in either the Check Issue Date Range or Check Void Date Range. The defaults are based on the year and quarter entered, but can be updated as needed.

8. Select Accept.

9. If you selected 941 Federal Tax Return Report in the Report Type section, select a Destination for the report file:

   • Select File to create the report in .rpt format. The default file name is irs941.rpt. You can change the default file name.

   • Select Screen to download the report in .pdf format. The default file name is irs941_<#####>.pdf.

     • Select OK.

       • Download the .rpt file from the View Files page.

       • Save the .pdf file.
         For more information about the Print dialog, refer to Print Reports.

10. If you selected 941 Federal Tax Return Report in the Report Type section and voided checks are included, the Void Check Listing report is generated. The default file names are: 

    • RPT: irs941voids.rpt

    • PDF: irs941voids.pdf

    • Excel: irs941voids.xlsx

11. If you selected FICA, Medicare, or Federal Tax Report in the Report Type section, select a Destination for the report file:

    • Select File to create the report in .rpt format. The default file names are:

      • FICA Tax Report: ficatax.rpt

      • Medicare Tax Report: medtax.rpt

      • Federal Tax Report: fedtax.rpt
        You can change the default file name.

    • Select Screen to download the report in .pdf format. The default file names are:

      • FICA Tax Report: ficatax_<#####>.pdf

      • Medicare Tax Report: medtax_<#####>.pdf

      • Federal Tax Report: fedtax_<#####>.pdf

    • Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file names are:

      • FICA Tax Report: ficataxrpt<####_#####>.xlsx

      • Medicare Tax Report: medtaxrpt<####_#####>.xlsx

      • Federal Tax Report: fedtaxrpt<####_#####>.xlsx

        • Select OK.

          • Download the .rpt file from the View Files page.

          • Save the .pdf file.
            For more information about the Print dialog, refer to Print Reports.