Skip to content
logo Knowledgebase

How to print the 941 and Schedule B forms in Sage 100

Created on  | Last modified on 

Summary

How to print the 941 and Schedule B forms in Sage 100 Where do tax liability amounts on Schedule B come from?

Description

941 Form Revisions:

June, 2020: IRS updated 941 Form (rev 4-2020) which will be used for the rest of 2020 (starting with the 2nd quarter filing). The new 941 form takes into account the changes made by the Families First Coronavirus Response Act (FFCRA) and the Coronavirus Aid, Relief, and Economic Security (CARES) Act that added various types of payroll tax relief. For more details, refer to KB article ID 105461, DocLink: My Qualified wages for the Employee Retention Credit and Sick and Family Leave credit are missing on the 941 form.

September, 2020: Updated 941 Form which included the changes for the Employee Social Security Deferral on President Trump's Executive Order with Covid-19.

In June 2021, the 941 Form was again updated by IRS for Covid-19 related to January 2021 through March 2021 payments.

September 2021: 941 Form included changes for reporting 2nd and 3rd quarter 2021 Covid-19 payments.

Cause

Resolution

In order to have access to latest tax forms, you must be using a supported version of Sage 100, refer to KB article ID 31477, DocLink: Sage 100 Supported Versions

**This is the basic process to print the Federal 941 with schedule B for quarterly reporting. Any specific steps related to Covid-19, changes to forms, or other situations will be linked in related resources.

You can print and/or eFile the 941 form from Federal and State Tax Reporting, by doing the following:

  1. Open Payroll, Period End, Federal and State Tax Reporting
  2. Select Federal and Click the Form Name Lookup.
  3. Select the xxxx941/Schedule B/941-V Report (xxxx=tax form year) from the forms listing
    • If the tax year is incorrect in the Form ID Description, a form update is required, please do the following:
      • Select the xxxx 941/Schedule B/941-V Report (xxxx=tax form year)
      • Click Proceed.
      • If the new year form is available, you will now see it when you select Lookup on Form Name.
      • If the new year form is not yet available, Click Automatic Update when prompted upon opening Federal and State Tax Reporting. This updates all new forms from Aatrix.
  4. Verify the correct Quarter and Year are selected
  5. Verify the Company Name, address and Federal Tax ID are correct
    • Note: Company name, address, phone & Federal Tax ID are automatically populated from Company Maintenance, but can be changed.
  6. Click Proceed.
  7. Proceed through steps in wizard, taking note of the popup messages and selecting OK.

To print the 'Schedule B', you must also select the You were a semiweekly schedule depositor for any part of this quarter check box on the Form 941, page 2 and select ok.

**Once 941 Form is displayed, click the right arrow (top left) to go to following pages.

Note: The Federal Tax Liability amounts populated onto the Schedule B come from the last page (Deposit Liability) of the Employers Expense Summary printed during each payroll run.

Important Note: The Employers Expense Summary report can only be printed while Payroll Data Entry is in progress, it is NOT available to print after payroll check register has been updated.

For detailed instructions for Form 941, please contact your tax advisor or visit the IRS website at http://www.irs.gov/pub/irs-pdf/i941.pdf

If you are unable to install Federal and State Tax Reporting updates, refer to KB article ID 18851, DocLink: How to install, activate, update, and uninstall Federal and State Tax Reporting

DocLink: How to setup and payback the Employee Social Security Tax Deferral in Sage 100
DocLink: The 3rd quarter 2021 941 has large fraction of cents that is incorrect if covid earnings are included
DocLink: Unable to Install Aatrix Federal and State Tax Reporting Updates
DocLink: How to print or efile Federal or State tax forms and reports
DocLink: How do I reconcile Payroll tax forms & reports?

Chat with support