More information

Report Setup Buttons

Report Setup Overview

Payroll Checklists

Payroll FAQs

941 Worksheet

Access this report using Reports>Payroll>Payroll Tax Worksheets>941 Worksheet. It is only available with the Payroll module; it is not available for Payroll Link users.

Use this report to summarize federal tax amounts and tax liability—except for Federal Unemployment Tax. This report helps when completing the Form 941 and the Schedule B (Form 941). The 941 Worksheet is a fixed-format report. You cannot customize the columns in the report; the system has already determined them.

Earning Codes with Contribute to Net Pay Only check box selected, are excluded from the amounts. These Earning Codes were set up to process Employee Reimbursement and Advances through regular payroll processing (Maintain>Payroll>Earning Codes).

Note: Additional Medicare Tax for high income wage earners: When an employee’s wages subject to Medicare exceed $200,000.00 for the calendar year an additional .09% of Medicare tax will be added to the Employee portion and withheld at 2.35%. For those employees who exceed the $200,000.00 threshold, this additional amount is reported separately on the report.

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

  • Current Transaction Dates are required to specify the date range for the data included in the report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.

  • Additional Medicare Reporting in Aatrix:

    The system accommodates the break-out of Additional Medicare Wages and Additional Medicare Withholding needed for 941 reporting by taking the difference between the Employee’s Medicare Withholding and the Employer’s Medicare Tax, recorded in the system for each Pay Date. These values will always be the same unless Additional Medicare Tax has been withheld from the employee because their annual earnings have exceeded $200,000.00. If this is the case the Medicare Withholding will be greater than the Employer’s Medicare Tax. The system then divides the difference by.09% to derive the break-out for Additional Medicare Wages.

      Adjustments:

    • If adjustments are needed to the Additional Medicare Tax or Additional Medicare Wages reported on the 941 this can be accomplished by going to Setup/ Adjust Employee Balances and entering a Medicare tax adjustment for both Employee Amount and Employer Amount. As long as the Employee Amount is larger than the Employer Amount being adjusted the system will generate an Additional Medicare Withholding and an Additional Medicare Wage adjustment based on the formula described above.