Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 29, 2021
Solved

941 Summary Report

  • June 29, 2021
  • 15 replies
  • 64 views

Last quarter I printed a "941 Summary" and this quarter I cannot find where I got it from.  I know it was exported to Excel.  It has Wages, Tips and Other Compensation and breaks it down by payroll category, federal tax withholding, SS and Medicare.  Has Daily Wage Summary, has Taxed Wages by Employee.  Any ideas where I can find this again?

Best answer by BigRedConsulting

@AbbyHCU 

The reports you're after can be found on the QB menu at Employees | Payroll Tax Forms & W-2s | Tax Form Worksheets in Excel - and also at Reports | Employees & Payroll | More Payroll Reports in Excel | Tax Form Worksheets.

15 replies

QuickBooks Team
June 29, 2021

Hi there, AbbyHCU. 

 

Glad to have you here in the Community space. I am here to help you sorted out the payroll reports in QuickBooks Desktop. 

 

Before you prepare your form:

 

Once done, here's how you can prepare your forms:

 

  1. Select Employees, then Payroll Forms & W-2s, then Process Payroll Forms.
  2. Select Quarterly Form 941/Schedule B or Annual Form 940/Sch. A.
    Note: Only semi-weekly depositors are required to file form Schedule B, when any other deposit frequency is selected a Schedule B will not be e-filed and you will likely receive a tax notice.
  3. Select Create Form
  4. Choose the Year or Quarter from the small arrow ▼ then choose your Quarter Ending date.
  5. Select OK.
  6. Complete the interview for your form. Select Next.
    Review the information on your form to confirm it is correct.
    Note: If you need to add or change, data select the field and enter the amount. New data displays in blue and changed data displays in green.
  7. Select Check for Errors to identify and fix any form errors.
  8. Select Save and Close to save your changes and come back later or select Print for Your Records to print your form.

I've also added an article to help learn how QuickBooks populates the lines on form 941: How QuickBooks populates the 941.

 

Please let me know how it goes. I'll be around to help if you have any other questions about your reports. Have a good day ahead. 

BigRedConsulting
Level 15
June 30, 2021

@LeizylM 

It would be better if you answered questions in areas where you know QuickBooks, and after reading the question and understanding it. Your answer clearly does not answer the question.

BigRedConsulting
Level 15
June 30, 2021

@AbbyHCU 

The reports you're after can be found on the QB menu at Employees | Payroll Tax Forms & W-2s | Tax Form Worksheets in Excel - and also at Reports | Employees & Payroll | More Payroll Reports in Excel | Tax Form Worksheets.

April 15, 2024

Hi, I am trying to submit Q4 2023 form 941 right now, but i am getting an error message "you can not file a prior year return. Form 941 si for the current tax year. quick boooks only store one version of the federal 941 tax form." does anyone know how i can go about filing this form?

 

 

FishingForAnswers
Level 4
August 29, 2024
I'm not seeing those optionsl I am using Microsoft.

@TXtea  To save me having to guess what you're seeing, please provide a screenshot of what you do see.